<!DOCTYPE html>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=Edge"/>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="Author" content="Zabbix SIA" />
<title>localhost: Host inventory overview</title>
<link rel="icon" href="favicon.ico">
<link rel="apple-touch-icon-precomposed" sizes="76x76" href="assets/img/apple-touch-icon-76x76-precomposed.png">
<link rel="apple-touch-icon-precomposed" sizes="120x120" href="assets/img/apple-touch-icon-120x120-precomposed.png">
<link rel="apple-touch-icon-precomposed" sizes="152x152" href="assets/img/apple-touch-icon-152x152-precomposed.png">
<link rel="apple-touch-icon-precomposed" sizes="180x180" href="assets/img/apple-touch-icon-180x180-precomposed.png">
<link rel="icon" sizes="192x192" href="assets/img/touch-icon-192x192.png">
<meta name="csrf-token" content="8b89bd4755e62fd8"/>
<meta name="msapplication-TileImage" content="assets/img/ms-tile-144x144.png">
<meta name="msapplication-TileColor" content="#d40000">
<meta name="msapplication-config" content="none"/>
<link rel="stylesheet" type="text/css" href="assets/styles/blue-theme.css?1593431348" />
<style type="text/css">.na-bg, .na-bg input[type="radio"]:checked + label, .na-bg:before, .flh-na-bg, .status-na-bg { background-color: #97AAB3 }
.info-bg, .info-bg input[type="radio"]:checked + label, .info-bg:before, .flh-info-bg, .status-info-bg { background-color: #7499FF }
.warning-bg, .warning-bg input[type="radio"]:checked + label, .warning-bg:before, .flh-warning-bg, .status-warning-bg { background-color: #FFC859 }
.average-bg, .average-bg input[type="radio"]:checked + label, .average-bg:before, .flh-average-bg, .status-average-bg { background-color: #FFA059 }
.high-bg, .high-bg input[type="radio"]:checked + label, .high-bg:before, .flh-high-bg, .status-high-bg { background-color: #E97659 }
.disaster-bg, .disaster-bg input[type="radio"]:checked + label, .disaster-bg:before, .flh-disaster-bg, .status-disaster-bg { background-color: #E45959 }
</style><script>var PHP_TZ_OFFSET = -18000,PHP_ZBX_FULL_DATE_TIME = "Y-m-d H:i:s";</script><script src="js/browsers.js"></script>
<script src="jsLoader.php?ver=4.4.10&lang=en_GB&showGuiMessaging=1"></script>
<script src="jsLoader.php?ver=4.4.10&lang=en_GB&files%5B0%5D=servercheck.js"></script>
</head>
<body lang="en">
<output class="msg-global-footer msg-warning" id="msg-global-footer"></output>
<script type="text/javascript">
MMenu.def_label = 'cm'
</script><header><div><div class="top-nav-container" id="mmenu"><a class="header-logo" href="zabbix.php?action=dashboard.view"><div class="logo"></div></a><nav aria-label="Main navigation"><ul class="top-nav"><li id="view"><a onclick="javascript: MMenu.mouseOver('view');" onkeyup="javascript: MMenu.keyUp('view', event);" tabindex="0" role="button" href="javascript:void(0)">Monitoring</a></li><li class="selected" id="cm"><a onclick="javascript: MMenu.mouseOver('cm');" onkeyup="javascript: MMenu.keyUp('cm', event);" tabindex="0" role="button" href="javascript:void(0)">Inventory</a></li><li id="reports"><a onclick="javascript: MMenu.mouseOver('reports');" onkeyup="javascript: MMenu.keyUp('reports', event);" tabindex="0" role="button" href="javascript:void(0)">Reports</a></li><li id="config"><a onclick="javascript: MMenu.mouseOver('config');" onkeyup="javascript: MMenu.keyUp('config', event);" tabindex="0" role="button" href="javascript:void(0)">Configuration</a></li><li id="admin"><a onclick="javascript: MMenu.mouseOver('admin');" onkeyup="javascript: MMenu.keyUp('admin', event);" tabindex="0" role="button" href="javascript:void(0)">Administration</a></li></ul></nav><ul class="top-nav-icons"><li><form method="get" action="zabbix.php" accept-charset="utf-8" role="search"><input type="hidden" name="action" value="search"><input type="text" id="search" name="search" value="" maxlength="255" autocomplete="off" class="search" aria-label="type here to search"><button type="submit" class="btn-search" title="Search"> </button></form></li><li><ul role="navigation" aria-label="User menu"><li style="padding-left:0"><a class="top-nav-support" target="_blank" title="Zabbix Technical Support" href="https://www.zabbix.com/support">Support</a></li><li><a class="top-nav-zbbshare" target="_blank" title="Zabbix Share" href="https://share.zabbix.com/">Share</a></li><li><a class="top-nav-help" target="_blank" title="Help" href="https://www.zabbix.com/documentation/4.4/"> </a></li><li><a class="top-nav-profile" title="Admin (Zabbix Administrator)" href="zabbix.php?action=userprofile.edit"></a></li><li><a class="top-nav-signout" title="Sign out" onclick="ZABBIX.logout()" href="javascript:;"> </a></li></ul></li></ul></div><nav aria-label="Sub navigation" class="top-subnav-container" onmouseover="javascript: MMenu.submenu_mouseOver();" onmouseout="javascript: MMenu.mouseOut();"><ul class="top-subnav" id="sub_view" style="display: none;"><li><a tabindex="0" href="zabbix.php?action=dashboard.view&ddreset=1">Dashboard</a></li><li><a tabindex="0" href="zabbix.php?action=problem.view&ddreset=1">Problems</a></li><li><a tabindex="0" href="overview.php?ddreset=1">Overview</a></li><li><a tabindex="0" href="zabbix.php?action=web.view&ddreset=1">Web</a></li><li><a tabindex="0" href="latest.php?ddreset=1">Latest data</a></li><li><a tabindex="0" href="charts.php?ddreset=1">Graphs</a></li><li><a tabindex="0" href="screens.php?ddreset=1">Screens</a></li><li><a tabindex="0" href="zabbix.php?action=map.view&ddreset=1">Maps</a></li><li><a tabindex="0" href="zabbix.php?action=discovery.view&ddreset=1">Discovery</a></li><li><a tabindex="0" href="srv_status.php?ddreset=1">Services</a></li></ul><ul class="top-subnav" id="sub_cm" style="display: block;"><li><a tabindex="0" class="selected" href="hostinventoriesoverview.php?ddreset=1">Overview</a></li><li><a tabindex="0" href="hostinventories.php?ddreset=1">Hosts</a></li></ul><ul class="top-subnav" id="sub_reports" style="display: none;"><li><a tabindex="0" href="zabbix.php?action=report.status&ddreset=1">System information</a></li><li><a tabindex="0" href="report2.php?ddreset=1">Availability report</a></li><li><a tabindex="0" href="toptriggers.php?ddreset=1">Triggers top 100</a></li><li><a tabindex="0" href="auditlogs.php?ddreset=1">Audit</a></li><li><a tabindex="0" href="auditacts.php?ddreset=1">Action log</a></li><li><a tabindex="0" href="report4.php?ddreset=1">Notifications</a></li></ul><ul class="top-subnav" id="sub_config" style="display: none;"><li><a tabindex="0" href="hostgroups.php?ddreset=1">Host groups</a></li><li><a tabindex="0" href="templates.php?ddreset=1">Templates</a></li><li><a tabindex="0" href="hosts.php?ddreset=1">Hosts</a></li><li><a tabindex="0" href="maintenance.php?ddreset=1">Maintenance</a></li><li><a tabindex="0" href="actionconf.php?ddreset=1">Actions</a></li><li><a tabindex="0" href="correlation.php?ddreset=1">Event correlation</a></li><li><a tabindex="0" href="discoveryconf.php?ddreset=1">Discovery</a></li><li><a tabindex="0" href="services.php?ddreset=1">Services</a></li></ul><ul class="top-subnav" id="sub_admin" style="display: none;"><li><a tabindex="0" href="adm.gui.php?ddreset=1">General</a></li><li><a tabindex="0" href="zabbix.php?action=proxy.list&ddreset=1">Proxies</a></li><li><a tabindex="0" href="zabbix.php?action=authentication.edit&ddreset=1">Authentication</a></li><li><a tabindex="0" href="usergrps.php?ddreset=1">User groups</a></li><li><a tabindex="0" href="zabbix.php?action=user.list&ddreset=1">Users</a></li><li><a tabindex="0" href="zabbix.php?action=mediatype.list&ddreset=1">Media types</a></li><li><a tabindex="0" href="zabbix.php?action=script.list&ddreset=1">Scripts</a></li><li><a tabindex="0" href="queue.php?ddreset=1">Queue</a></li></ul><div class="server-name">localhost</div></nav></div></header><main><output class="msg-bad" role="contentinfo" aria-label="Error message"><div class="msg-details"><ul><li>session_start(): Setting option 'use_cookies' failed [hostinventoriesoverview.php:29 → require_once() → CSession::keyExists() → CSession::open() → session_start() in include/classes/core/CSession.php:145]</li></ul></div><button type="button" class="overlay-close-btn" onclick="jQuery(this).closest('.msg-bad').remove();" title="Close"></button></output><div class="header-title table"><div class="cell"><h1 id="page-title-general">Host inventory overview</h1></div><div class="cell nowrap"><form method="get" action="hostinventoriesoverview.php" accept-charset="utf-8" aria-label="Main filter"><input type="hidden" id="sid" name="sid" value="8b89bd4755e62fd8"><input type="hidden" id="form_refresh" name="form_refresh" value="1"><ul><li><label for="groupid">Group</label><div class="form-input-margin"></div><select name="groupid" onchange="javascript: submit();" autocomplete="off" style="max-width: 300px;"><option value="0" selected="selected">all</option><option value="8">CNS_Intranet</option><option value="13">File Server</option><option value="4">Zabbix servers</option></select></li><li><label for="groupby">Grouping by</label><div class="form-input-margin"></div><select id="groupby" name="groupby" onchange="submit()" autocomplete="off"><option value="" selected="selected">not selected</option><option value="alias">Alias</option><option value="asset_tag">Asset tag</option><option value="chassis">Chassis</option><option value="contact">Contact</option><option value="contract_number">Contract number</option><option value="date_hw_decomm">Date HW decommissioned</option><option value="date_hw_install">Date HW installed</option><option value="date_hw_expiry">Date HW maintenance expires</option><option value="date_hw_purchase">Date HW purchased</option><option value="deployment_status">Deployment status</option><option value="hw_arch">HW architecture</option><option value="hardware">Hardware</option><option value="hardware_full">Hardware (Full details)</option><option value="host_networks">Host networks</option><option value="host_router">Host router</option><option value="host_netmask">Host subnet mask</option><option value="installer_name">Installer name</option><option value="location">Location</option><option value="location_lat">Location latitude</option><option value="location_lon">Location longitude</option><option value="macaddress_a">MAC address A</option><option value="macaddress_b">MAC address B</option><option value="model">Model</option><option value="name">Name</option><option value="notes">Notes</option><option value="oob_ip">OOB IP address</option><option value="oob_router">OOB router</option><option value="oob_netmask">OOB subnet mask</option><option value="os">OS</option><option value="os_full">OS (Full details)</option><option value="os_short">OS (Short)</option><option value="poc_1_cell">Primary POC cell</option><option value="poc_1_email">Primary POC email</option><option value="poc_1_name">Primary POC name</option><option value="poc_1_notes">Primary POC notes</option><option value="poc_1_phone_a">Primary POC phone A</option><option value="poc_1_phone_b">Primary POC phone B</option><option value="poc_1_screen">Primary POC screen name</option><option value="poc_2_cell">Secondary POC cell</option><option value="poc_2_email">Secondary POC email</option><option value="poc_2_name">Secondary POC name</option><option value="poc_2_notes">Secondary POC notes</option><option value="poc_2_phone_a">Secondary POC phone A</option><option value="poc_2_phone_b">Secondary POC phone B</option><option value="poc_2_screen">Secondary POC screen name</option><option value="serialno_a">Serial number A</option><option value="serialno_b">Serial number B</option><option value="site_zip">Site ZIP / postal</option><option value="site_address_a">Site address A</option><option value="site_address_b">Site address B</option><option value="site_address_c">Site address C</option><option value="site_city">Site city</option><option value="site_country">Site country</option><option value="site_notes">Site notes</option><option value="site_rack">Site rack location</option><option value="site_state">Site state / province</option><option value="software">Software</option><option value="software_full">Software (Full details)</option><option value="software_app_a">Software application A</option><option value="software_app_b">Software application B</option><option value="software_app_c">Software application C</option><option value="software_app_d">Software application D</option><option value="software_app_e">Software application E</option><option value="tag">Tag</option><option value="type">Type</option><option value="type_full">Type (Full details)</option><option value="url_a">URL A</option><option value="url_b">URL B</option><option value="url_c">URL C</option><option value="vendor">Vendor</option></select></li></ul></form></div></div><table class="list-table" id="t5f1ed70d91f92425456682"><thead><tr><th><a href="hostinventoriesoverview.php?ddreset=1&sort=inventory_field&sortorder=ASC">Field</a></th><th><a href="hostinventoriesoverview.php?ddreset=1&sort=host_count&sortorder=ASC">Host count<span class="arrow-down"></span></a></th></tr></thead><tbody><tr class="nothing-to-show"><td colspan="2">No data found.</td></tr></tbody></table></main>
<footer role="contentinfo">Zabbix 4.4.10. © 2001–2020, <a class="grey link-alt" target="_blank" href="https://www.zabbix.com/">Zabbix SIA</a></footer><script type="text/javascript">
jQuery(document).ready(function() {
// the chkbxRange.init() method must be called after the inserted post scripts and initializing cookies
cookie.init();
chkbxRange.init();
MMenu.init();
});
</script>
<pre class="debug-output" name="zbx_debug_info"><a name="debug" role="button" href="javascript:void(0)"></a>******************** Script profiler ********************<br>Total time: 0.012199<br>Total SQL time: 0.008326<br>SQL count: 19 (selects: 18 | executes: 10)<br>Peak memory usage: 2M<br>Memory limit: 128M<br><br>1. <b>hostgroup.get</b> [CPageFilter.php:376]<br><br><table><tbody><tr><td>Parameters:<br>Array
(
[output] => Array
(
[0] => groupid
[1] => name
)
[preservekeys] => 1
[real_hosts] => 1
)
</td><td>Result:<br>Array
(
[8] => Array
(
[groupid] => 8
[name] => CNS_Intranet
)
[13] => Array
(
[groupid] => 13
[name] => File Server
)
[4] => Array
(
[groupid] => 4
[name] => Zabbix servers
)
)
</td></tr></tbody></table><br><br>SQL (0.003713): <span class="blue">COMMIT</span><br>hostinventoriesoverview.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<br><br>SQL (0.000197): <span class="green">SELECT NULL FROM users u WHERE u.userid=1 FOR UPDATE</span><br>hostinventoriesoverview.php:29 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::init() → DBselect() in include/classes/user/CProfile.php:37<br><br>SQL (0.000188): <span class="green">SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.menu.cm.last'</span><br>hostinventoriesoverview.php:29 → require_once() → zbx_construct_menu() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167<br><br>SQL (0.000208): <span class="green">SELECT c.* FROM config c</span><br>hostinventoriesoverview.php:29 → require_once() → select_config() → DBselect() in include/profiles.inc.php:33<br><br>SQL (7.8E-5): <span class="green">SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.login.attempt.failed'</span><br>hostinventoriesoverview.php:29 → require_once() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167<br><br>SQL (0.000201): <span class="green">SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.hostinventoriesoverview.php.sort'</span><br>hostinventoriesoverview.php:41 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167<br><br>SQL (0.000192): <span class="green">SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.hostinventoriesoverview.php.sortorder'</span><br>hostinventoriesoverview.php:42 → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167<br><br>SQL (0.000153): <span class="green">SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.cm.groupid'</span><br>hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167<br><br>SQL (0.000136): <span class="green">SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.cm.hostid'</span><br>hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167<br><br>SQL (0.000155): <span class="green">SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.cm.graphid'</span><br>hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_getProfiles() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167<br><br>SQL (7.0E-5): <span class="blue">BEGIN</span><br>hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBstart() → DBexecute() in include/db.inc.php:234<br><br>SQL (7.1E-5): <span class="green">SELECT g.groupid,g.name FROM hstgrp g WHERE EXISTS (SELECT NULL FROM hosts h,hosts_groups hg WHERE hg.hostid=h.hostid AND h.status IN (0,1) AND g.groupid=hg.groupid)</span><br>hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHostGroup->get() → DBselect() in include/classes/api/services/CHostGroup.php:358<br><br>SQL (5.3E-5): <span class="blue">COMMIT</span><br>hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_initGroups() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291<br><br>SQL (0.000131): <span class="green">SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.latest.groupid'</span><br>hostinventoriesoverview.php:65 → CPageFilter->__construct() → CPageFilter->_initGroups() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167<br><br>SQL (0.000202): <span class="green">SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid=1 AND idx='web.paging.lastpage'</span><br>hostinventoriesoverview.php:162 → require_once() → CProfile::update() → CProfile::get() → DBselect() in include/classes/user/CProfile.php:167<br><br>SQL (8.9E-5): <span class="blue">BEGIN</span><br>hostinventoriesoverview.php:162 → require_once() → DBstart() → DBexecute() in include/db.inc.php:234<br><br>SQL (0.00018): <span class="blue">UPDATE profiles SET value_str='hostinventoriesoverview.php', type=3 WHERE userid=1 AND idx='web.menu.cm.last' AND idx2='0'</span><br>hostinventoriesoverview.php:162 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:341<br><br>SQL (0.00018): <span class="blue">UPDATE profiles SET value_str='hostinventoriesoverview.php', type=3 WHERE userid=1 AND idx='web.paging.lastpage' AND idx2='0'</span><br>hostinventoriesoverview.php:162 → require_once() → CProfile::flush() → CProfile::updateDB() → DBexecute() in include/classes/user/CProfile.php:341<br><br>SQL (0.002129): <span class="blue">COMMIT</span><br>hostinventoriesoverview.php:162 → require_once() → DBend() → DBcommit() → DBexecute() in include/db.inc.php:291<br><br><br></pre><div class="btn-debug"><a onclick="javascript: if (!isset('state', this)) { this.state = 'none'; }this.state = (this.state == 'none' ? 'block' : 'none');jQuery(this).text(this.state == 'none' ? "Debug" : "Hide debug").blur();showHideByName('zbx_debug_info', this.state);" href="#debug">Debug</a></div></body></html>