Availability report

Host	Name	Problems	Ok	Graph
No data found.

Displaying 0 of 0 found

******************** Script profiler ********************
Total time: 0.301147
Total SQL time: 0.284102
SQL count: 27 (selects: 20 | executes: 16)
Peak memory usage: 2M
Memory limit: 128M

1. hostgroup.get [report2.php:229]

Parameters:
Array ( [output] => Array ( [0] => name ) [with_triggers] => 1 [preservekeys] => 1 [monitored_hosts] => 1 )

Result:
Array ( )

2. host.get [report2.php:400]

Parameters:
Array ( [output] => Array ( [0] => name ) [groupids] => [monitored_hosts] => 1 [with_triggers] => 1 [preservekeys] => 1 )

Result:
Array ( )

3. trigger.get [report2.php:420]

Parameters:
Array ( [output] => Array ( [0] => triggerid [1] => description [2] => expression [3] => value ) [selectHosts] => Array ( [0] => name ) [expandDescription] => 1 [monitored] => 1 [groupids] => [hostids] => [limit] => 1001 )

Result:
Array ( )

SQL (0.000368): SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
report2.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBselect() in include/classes/db/DB.php:107

SQL (0.000461): UPDATE ids SET nextid=2277938 WHERE table_name='auditlog' AND field_name='auditid'
report2.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DB::reserveIds() → DBexecute() in include/classes/db/DB.php:121

SQL (0.00031): INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('2','1776049466','216.73.216.101','3','0','','2277938')
report2.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CUser->login() → CApiService->addAuditDetails() → CAudit::addDetails() → DB::insert() → DBexecute() in include/classes/db/DB.php:467

SQL (0.007535): COMMIT
report2.php:22 → require_once() → ZBase->run() → ZBase->authenticateUser() → CWebUser::checkAuthentication() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000771): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.menu.reports.last'
report2.php:30 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000321): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.login.attempt.failed'
report2.php:30 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000861): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.avail_report.mode'
report2.php:49 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000671): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.avail_report.0.groupid'
report2.php:103 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000565): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.avail_report.0.hostid'
report2.php:106 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000592): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.avail_report.filter.from'
report2.php:202 → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000438): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.avail_report.filter.to'
report2.php:202 → getTimeSelectorPeriod() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000615): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.avail_report.filter.active'
report2.php:203 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.000166): BEGIN
report2.php:229 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000168): SELECT usrgrpid FROM users_groups WHERE userid='2'
report2.php:229 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → getUserGroupsByUserId() → DBselect() in include/perm.inc.php:283

SQL (0.00149): SELECT g.groupid,g.name FROM hstgrp g WHERE EXISTS (SELECT NULL FROM rights r WHERE g.groupid=r.id AND r.groupid=8 GROUP BY r.id HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND EXISTS (SELECT NULL FROM hosts h,items i,functions f,triggers t,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status=0 AND hg.hostid=i.hostid AND i.itemid=f.itemid AND f.triggerid=t.triggerid AND t.flags IN (0,4) AND g.groupid=hg.groupid)
report2.php:229 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:315

SQL (0.00019): COMMIT
report2.php:229 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000151): BEGIN
report2.php:400 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.00188): SELECT h.hostid,h.name FROM hosts h WHERE h.flags IN (0,4) AND EXISTS (SELECT NULL FROM hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=8 WHERE h.hostid=hgg.hostid GROUP BY hgg.hostid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND h.status=0 AND EXISTS (SELECT NULL FROM items i,functions f,triggers t WHERE h.hostid=i.hostid AND i.itemid=f.itemid AND f.triggerid=t.triggerid AND t.flags IN (0,4))
report2.php:400 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → DBselect() in include/classes/api/services/CHost.php:439

SQL (0.000139): COMMIT
report2.php:400 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000128): BEGIN
report2.php:420 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.255354): SELECT t.triggerid,t.description,t.expression,t.value FROM triggers t 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=8 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) LIMIT 1001
report2.php:420 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->get() → CApiService->customFetch() → DBselect() in include/classes/api/CApiService.php:1068

SQL (0.000774): COMMIT
report2.php:420 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291

SQL (0.000512): SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=2 AND idx='web.paging.lastpage'
report2.php:459 → getPagingLine() → getPageNumber() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:164

SQL (0.00022): BEGIN
report2.php:504 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234

SQL (0.000354): UPDATE profiles SET value_str='report2.php', type=3 WHERE userid=2 AND idx='web.menu.reports.last' AND idx2='0'
report2.php:504 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338

SQL (0.000173): UPDATE profiles SET value_str='report2.php', type=3 WHERE userid=2 AND idx='web.paging.lastpage' AND idx2='0'
report2.php:504 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:338

SQL (0.008895): COMMIT
report2.php:504 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291