-
Problem report
-
Resolution: Fixed
-
Minor
-
None
-
None
-
3.0
-
Sprint 25, Sprint 26, Sprint 27, Sprint 28, Sprint 29
-
1
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.
