History: Configuration of user groups » Dashboard » Configuration of user groups » Configuration of users » Dashboard 
PERSONAL DASHBOARD
    
  Favourite screens
  • List is empty
  Favourite graphs
  • List is empty
  Favourite maps
  • List is empty
  Status of Zabbix
ParameterValueDetails
Zabbix server is runningYes172.30.0.12:10051
Number of hosts (monitored/not monitored/templates)5122 / 1 / 28
Number of items (monitored/disabled/not supported)245238 / 1 / 6
Number of triggers (enabled/disabled)[problem/unknown/ok]8482 / 2  [2 / 0 / 80]
Number of users (online)52
Required server performance, new values per second3.23 -

******************** Script profiler ********************
Total time: 0.189394
Total SQL time: 0.085737
SQL count: 17 (selects: 13 | executes: 4)
Peak memory usage: 11.75M
Memory limit: 128M

1. user->checkAuthentication [class.cwebuser.php:80]
Parameters:
83e974be87f843f3882c622146682f7e
Result:
Array
(
    [userid] => 1
    [alias] => Admin
    [name] => Zabbix
    [surname] => Administrator
    [url] => 
    [autologin] => 1
    [autologout] => 0
    [lang] => en_GB
    [refresh] => 55
    [type] => 3
    [theme] => default
    [attempt_failed] => 0
    [attempt_ip] => 10.242.2.10
    [attempt_clock] => 1378113180
    [rows_per_page] => 50
    [debug_mode] => 1
    [userip] => 192.168.5.246
    [node] => Array
        (
            [name] => - unknown -
            [nodeid] => 0
        )

    [sessionid] => 83e974be87f843f3882c622146682f7e
    [gui_access] => 0
)

SQL (0.000423): SET NAMES utf8
require_once() -> DBconnect() -> DBexecute()

SQL (0.000249): SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid
require_once() -> DBselect()

SQL (0.004353): begin
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.021226): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='83e974be87f843f3882c622146682f7e' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1378277964) OR (u.autologout=0)) AND u.userid BETWEEN 000000000000000 AND 099999999999999
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBselect()

SQL (0.007835): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> check_perm2system() -> DBselect()

SQL (0.002928): UPDATE sessions SET lastaccess=1378277964 WHERE userid=1 AND sessionid='83e974be87f843f3882c622146682f7e'
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBexecute()

SQL (0.012764): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBselect()

SQL (0.000371): SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout,u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip,u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid=1
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect()

SQL (0.000247): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect()

SQL (0.015436): commit
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.010824): SELECT p.* FROM profiles p WHERE p.userid=1 AND p.profileid BETWEEN 000000000000000 AND 099999999999999 ORDER BY p.userid,p.profileid
require_once() -> CProfile::get() -> CProfile::init() -> DBselect()

SQL (0.002826): SELECT COUNT(DISTINCT t.triggerid) AS cnt,t.status,t.value FROM triggers t INNER JOIN functions f ON t.triggerid=f.triggerid INNER JOIN items i ON f.itemid=i.itemid INNER JOIN hosts h ON i.hostid=h.hostid WHERE i.status=0 AND h.status=0 GROUP BY t.status,t.value
make_status_of_zbx() -> get_status() -> DBselect()

SQL (0.001799): SELECT COUNT(*) AS cnt,i.status FROM items i INNER JOIN hosts h ON i.hostid=h.hostid WHERE h.status=0 AND i.status IN ('0','1','3') GROUP BY i.status
make_status_of_zbx() -> get_status() -> DBselect()

SQL (0.000464): SELECT COUNT(*) AS cnt,h.status FROM hosts h WHERE h.status IN (0,1,3 ) GROUP BY h.status
make_status_of_zbx() -> get_status() -> DBselect()

SQL (0.000493): SELECT COUNT(*) AS usr_cnt FROM users u WHERE u.userid BETWEEN 000000000000000 AND 099999999999999
make_status_of_zbx() -> get_status() -> DBselect()

SQL (0.002595): SELECT s.userid,s.status,MAX(s.lastaccess) AS lastaccess FROM sessions s WHERE s.userid BETWEEN 000000000000000 AND 099999999999999 AND s.status=0 GROUP BY s.userid,s.status
make_status_of_zbx() -> get_status() -> DBselect()

SQL (0.000904): SELECT SUM(1.0/i.delay) AS qps FROM items i,hosts h WHERE i.status=0 AND i.hostid=h.hostid AND h.status=0 AND i.delay<>0
make_status_of_zbx() -> get_status() -> DBselect()


  System status
  Host status
Host groupWithout problemsWith problemsTotal
DMZ202
GZB-Drucker808
INTERN9211
Router/Firewall101
  Last 20 issues
HostIssue
Last change 
 
AgeInfoAckActions
ger-brb-srv-005.intern.weistedv.de
Port 25 (SMTP) is donw on ger-brb-srv-005.intern.weistedv.de04 Sep 2013 08:16:1244m 12s No
2
 
2
1 of 2 issues are shown
  Web monitoring

******************** Script profiler ********************
Total time: 0.113452
Total SQL time: 0.030819
SQL count: 27 (selects: 19 | executes: 8)
Peak memory usage: 14.25M
Memory limit: 128M

1. user->checkAuthentication [class.cwebuser.php:80]
Parameters:
83e974be87f843f3882c622146682f7e
Result:
Array
(
    [userid] => 1
    [alias] => Admin
    [name] => Zabbix
    [surname] => Administrator
    [url] => 
    [autologin] => 1
    [autologout] => 0
    [lang] => en_GB
    [refresh] => 55
    [type] => 3
    [theme] => default
    [attempt_failed] => 0
    [attempt_ip] => 10.242.2.10
    [attempt_clock] => 1378113180
    [rows_per_page] => 50
    [debug_mode] => 1
    [userip] => 192.168.5.246
    [node] => Array
        (
            [name] => - unknown -
            [nodeid] => 0
        )

    [sessionid] => 83e974be87f843f3882c622146682f7e
    [gui_access] => 0
)
2. map->get [blocks.inc.php:1260]
Parameters:
Array
(
    [sysmapids] => Array
        (
        )

    [output] => Array
        (
            [0] => sysmapid
            [1] => name
        )

)
Result:
Array
(
)

SQL (0.000377): SET NAMES utf8
require_once() -> DBconnect() -> DBexecute()

SQL (0.000222): SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeid
require_once() -> DBselect()

SQL (0.000324): begin
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.001597): SELECT u.userid,u.autologout,s.lastaccess FROM sessions s,users u WHERE s.sessionid='83e974be87f843f3882c622146682f7e' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1378277962) OR (u.autologout=0)) AND u.userid BETWEEN 000000000000000 AND 099999999999999
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBselect()

SQL (0.000263): SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> check_perm2system() -> DBselect()

SQL (0.000454): UPDATE sessions SET lastaccess=1378277962 WHERE userid=1 AND sessionid='83e974be87f843f3882c622146682f7e'
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBexecute()

SQL (0.000225): SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> DBselect()

SQL (0.000248): SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout,u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip,u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid=1
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect()

SQL (0.000237): SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=1 AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->checkAuthentication() -> CUser->_getUserData() -> DBselect()

SQL (0.017717): commit
require_once() -> CWebUser::checkAuthentication() -> CAPIObject->checkAuthentication() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.000673): SELECT p.* FROM profiles p WHERE p.userid=1 AND p.profileid BETWEEN 000000000000000 AND 099999999999999 ORDER BY p.userid,p.profileid
require_once() -> zbx_construct_menu() -> CProfile::update() -> CProfile::init() -> DBselect()

SQL (0.000429): SELECT c.* FROM config c WHERE c.configid BETWEEN 000000000000000 AND 099999999999999
require_once() -> select_config() -> DBselect()

SQL (0.000647): SELECT uh.title1,uh.url1,uh.title2,uh.url2,uh.title3,uh.url3,uh.title4,uh.url4,uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=1
require_once() -> get_user_history() -> DBselect()

SQL (0.001335): SELECT p.value_id,p.source FROM profiles p WHERE p.userid=1 AND p.idx='web.favorite.graphids' ORDER BY p.profileid
make_graph_menu() -> make_graph_submenu() -> get_favorites() -> DBselect()

SQL (0.000472): SELECT p.value_id,p.source FROM profiles p WHERE p.userid=1 AND p.idx='web.favorite.sysmapids' ORDER BY p.profileid
make_sysmap_menu() -> make_sysmap_submenu() -> get_favorites() -> DBselect()

SQL (0.000279): begin
make_sysmap_menu() -> make_sysmap_submenu() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.000261): commit
make_sysmap_menu() -> make_sysmap_submenu() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.000326): begin
make_sysmap_menu() -> make_sysmap_submenu() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()

SQL (0.000424): SELECT s.sysmapid,s.name FROM sysmaps s WHERE 1=0
make_sysmap_menu() -> make_sysmap_submenu() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CMap->get() -> DBselect()

SQL (0.000242): SELECT su.* FROM sysmap_url su WHERE 1=0
make_sysmap_menu() -> make_sysmap_submenu() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CMap->get() -> DBselect()

SQL (0.000211): commit
make_sysmap_menu() -> make_sysmap_submenu() -> CAPIObject->get() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()

SQL (0.000529): SELECT p.value_id,p.source FROM profiles p WHERE p.userid=1 AND p.idx='web.favorite.screenids' ORDER BY p.profileid
make_screen_menu() -> make_screen_submenu() -> get_favorites() -> DBselect()

SQL (0.001715): SELECT p.value_id,p.source FROM profiles p WHERE p.userid=1 AND p.idx='web.favorite.graphids' ORDER BY p.profileid
make_favorite_graphs() -> get_favorites() -> DBselect()

SQL (0.000474): SELECT p.value_id,p.source FROM profiles p WHERE p.userid=1 AND p.idx='web.favorite.screenids' ORDER BY p.profileid
make_favorite_screens() -> get_favorites() -> DBselect()

SQL (0.0003): SELECT p.value_id,p.source FROM profiles p WHERE p.userid=1 AND p.idx='web.favorite.sysmapids' ORDER BY p.profileid
make_favorite_maps() -> get_favorites() -> DBselect()

SQL (0.000269): SELECT COUNT(d.druleid) AS cnt FROM drules d WHERE d.druleid BETWEEN 000000000000000 AND 099999999999999 AND d.status=0
DBselect()

SQL (0.000569): SELECT uh.title5,uh.url5 FROM user_history uh WHERE uh.userid=1
require_once() -> add_user_history() -> DBselect()