-
Incident report
-
Resolution: Won't fix
-
Blocker
-
None
-
2.2.6
The report is generated for a user with access to 3 hosts.
******************** Script profiler ******************** Total time: 138.053884 Total SQL time: 138.026369 SQL count: 121 (selects: 90 | executes: 31) Peak memory usage: 14.25M Memory limit: 756M
SQL (137.668251): SELECT DISTINCT t.triggerid,t.description,t.expression,t.value,h.name AS hostname,h.host,h.hostid FROM triggers t,functions f,items i,hosts h WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid='62' WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN ('0','4') AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND h.hostid=i.hostid report2.php:407 ? CAPIObject->get() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBselect() in /zabbix/include/classes/api/CZBXAPI.php:1048