Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-13257

Doesn’t a display the lastest in auditlog.

    Details

    • Team:
      Team B
    • Sprint:
      Sprint 25, Sprint 26, Sprint 27, Sprint 28, Sprint 29
    • Story Points:
      1

      Description

      When "Search/Filter elements" over than an limit, doesn't a display the lastest in Reports -> auditlog.

      Zoom_All
      2017-12-26 09:32:12 Admin   192.168.10.109  User group  Added   0       Group name [hoge]
      2017-12-26 09:31:53 Admin   192.168.10.109  User group  Enabled 0       Debug mode for group name [Disabled]
      ....
      Displaying 1 to 50 of 100+ found
      
      Zoom_1h
      2017-12-26 09:39:26 Admin   192.168.10.109  User    Updated 0       User alias [Admin] Name [Zabbix] Surname [Administrator] profile id [1]
      2017-12-26 09:32:12 Admin   192.168.10.109  User group  Added   0       Group name [hoge]
      2017-12-26 09:31:53 Admin   192.168.10.109  User group  Enabled 0       Debug mode for group name [Disabled]
      ....
      Displaying 39 of 39 found
      

      2017-12-26 09:39:26 ... UNIXTIME(1514248766)

      There is nothing wrong with it clock.

      webui_debug_All
      SQL (0.001353): SELECT a.auditid,a.clock,u.alias,a.ip,a.resourcetype,a.action,a.resourceid,a.resourcename,a.details FROM auditlog a,users u WHERE a.userid=u.userid AND a.clock>'1512455625' AND a.clock<'1514250039' ORDER BY a.clock DESC LIMIT 101 OFFSET 0
      
      webui_debug_1h
      SQL (0.000241): SELECT a.auditid,a.clock,u.alias,a.ip,a.resourcetype,a.action,a.resourceid,a.resourcename,a.details FROM auditlog a,users u WHERE a.userid=u.userid AND a.clock>'1514246407' AND a.clock<'1514250007' ORDER BY a.clock DESC LIMIT 101 OFFSET 0
      
      mysql_query_log_All
                105 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.auditlogs.filter.resourcetype'
                105 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.auditlogs.filter.alias'
                105 Query SELECT a.auditid,a.clock,u.alias,a.ip,a.resourcetype,a.action,a.resourceid,a.resourcename,a.details FROM auditlog a,users u WHERE a.userid=u.userid AND a.clock>'1512455625' AND a.clock<'1514250039' ORDER BY a.clock DESC LIMIT 101 OFFSET 0
                105 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='188'
                105 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='156'
                105 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='155'
                105 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='154'
      
      mysql_query_log_1h
                 99 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.auditlogs.filter.resourcetype'
                 99 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.auditlogs.filter.alias'
                 99 Query SELECT a.auditid,a.clock,u.alias,a.ip,a.resourcetype,a.action,a.resourceid,a.resourcename,a.details FROM auditlog a,users u WHERE a.userid=u.userid AND a.clock>'1514246407' AND a.clock<'1514250007' ORDER BY a.clock DESC LIMIT 101 OFFSET 0
                 99 Query SELECT ad.table_name,ad.field_name,ad.oldvalue,ad.newvalue FROM auditlog_details ad WHERE ad.auditid='188'
                 99 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.lastpage'
                 99 Query SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.page'
      

      thank you.

        Attachments

          Activity

            People

            • Assignee:
              agriscenko Andrejs Griščenko
              Reporter:
              hayato.watanabe Hayato Watanabe
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: