Ad Widget

Collapse

Num of users is wrong in Zabbix 1.5.3

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cristhiano
    Member
    • Nov 2007
    • 48

    #1

    Num of users is wrong in Zabbix 1.5.3

    If users dont correct logout, Dashboard table is wrong in number of users.

    This SQL is correct to file:include/blocks.inc.php - line 378

    SELECT distinct (u.userid), max (s.lastaccess), u.autologout FROM users u LEFT JOIN sessions s ON s.userid=u.userid group by u.userid,u.autologout;
  • Aly
    ZABBIX developer
    • May 2007
    • 1126

    #2
    Thank You. Fixed.
    Zabbix | ex GUI developer

    Comment

    • cristhiano
      Member
      • Nov 2007
      • 48

      #3
      Originally posted by Aly
      Thank You. Fixed.
      And, the counter of trigger is wrong too.

      This is the SQL correct to include/config.inc.php line 1103:

      $sql = 'SELECT COUNT(DISTINCT t.triggerid) as cnt '.

      Comment

      • Aly
        ZABBIX developer
        • May 2007
        • 1126

        #4
        Accepted.
        Zabbix | ex GUI developer

        Comment

        Working...