SNMP STATUS[TRUE] ifName CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' ifName] CMD EXITCODE[0] CMD RUNTIME[0.0694s] STDOUT[ ifName.1 = lo0 ifName.2 = gei0 ifName.3 = gei1 ifName.4 = gei2 ifName.5 = gei3 ifName.6 = lagg0 ifName.7 = lagg1 ] SNMP STATUS[TRUE] ifType CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' ifType] CMD EXITCODE[0] CMD RUNTIME[0.0685s] STDOUT[ ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.5 = ethernetCsmacd ifType.6 = ethernetCsmacd ifType.7 = ethernetCsmacd ] SNMP STATUS[TRUE] ifOperStatus CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' ifOperStatus] CMD EXITCODE[0] CMD RUNTIME[0.0675s] STDOUT[ ifOperStatus.1 = up ifOperStatus.2 = up ifOperStatus.3 = up ifOperStatus.4 = down ifOperStatus.5 = down ifOperStatus.6 = down ifOperStatus.7 = down ] SNMP STATUS[TRUE] Array ( [1] => Array ( [ifDescr] => lo0 [ifAlias] => [ifName] => lo0 [ifType] => softwareLoopback [ifOperStatus] => up ) [2] => Array ( [ifDescr] => gei0 [ifAlias] => [ifName] => gei0 [ifType] => ethernetCsmacd [ifOperStatus] => up ) [3] => Array ( [ifDescr] => gei1 [ifAlias] => [ifName] => gei1 [ifType] => ethernetCsmacd [ifOperStatus] => up ) [4] => Array ( [ifDescr] => gei2 [ifAlias] => [ifName] => gei2 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [5] => Array ( [ifDescr] => gei3 [ifAlias] => [ifName] => gei3 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [6] => Array ( [ifDescr] => lagg0 [ifAlias] => [ifName] => lagg0 [ifType] => ethernetCsmacd [ifOperStatus] => down ) [7] => Array ( [ifDescr] => lagg1 [ifAlias] => [ifName] => lagg1 [ifType] => ethernetCsmacd [ifOperStatus] => down ) ) o Caching DB SQL[SELECT * FROM `ports` WHERE `device_id` = '1401'] SQL RUNTIME[0.00097704s] 7 ports o Discovering ports ifIndex 1 (ifAdminStatus = , ifOperStatus = up). . ifIndex 2 (ifAdminStatus = , ifOperStatus = up). . ifIndex 3 (ifAdminStatus = , ifOperStatus = up). . ifIndex 4 (ifAdminStatus = , ifOperStatus = down). . ifIndex 5 (ifAdminStatus = , ifOperStatus = down). . ifIndex 6 (ifAdminStatus = , ifOperStatus = down). . ifIndex 7 (ifAdminStatus = , ifOperStatus = down). . +---------+---------+--------+---------+------------------+-------------+---------+ | ifIndex | ifDescr | ifName | ifAlias | ifType | Oper Status | Ignored | +---------+---------+--------+---------+------------------+-------------+---------+ | 1 | lo0 | lo0 | ... | softwareLoopback | up | no | | 2 | gei0 | gei0 | ... | ethernetCsmacd | up | no | | 3 | gei1 | gei1 | ... | ethernetCsmacd | up | no | | 4 | gei2 | gei2 | ... | ethernetCsmacd | down | no | | 5 | gei3 | gei3 | ... | ethernetCsmacd | down | no | | 6 | lagg0 | lagg0 | ... | ethernetCsmacd | down | no | | 7 | lagg1 | lagg1 | ... | ethernetCsmacd | down | no | +---------+---------+--------+---------+------------------+-------------+---------+ o Duration 0.3731s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_ports-stack'] SQL RUNTIME[0.00036287s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_vlans'] SQL RUNTIME[0.00032401s] ##### Module Start: vlans ##### SQL[SELECT * FROM `vlans` WHERE `device_id` = '1401'] SQL RUNTIME[0.00033998s] SQL[SELECT * FROM `ports_vlans` WHERE `device_id` = '1401'] SQL RUNTIME[0.00104904s] o Q-BRIDGE-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' dot1qVlanStaticName] CMD EXITCODE[0] CMD RUNTIME[0.1328s] STDOUT[ dot1qVlanStaticName = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o Duration 0.1601s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_oids'] SQL RUNTIME[0.00068092s] ##### Module Start: oids ##### SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '1401'] SQL RUNTIME[0.00057411s] SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1'] SQL RUNTIME[0.00054598s] o Duration 0.0209s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_ip-addresses'] SQL RUNTIME[0.00057507s] ##### Module Start: ip-addresses ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00055408s] JSON DECODE[Not string passed] JSON RAW[ ] o IP-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' ipAdEntIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.0739s] STDOUT[ ipAdEntIfIndex.127.0.0.1 = 1 ipAdEntIfIndex.172.30.30.172 = 2 ipAdEntIfIndex.192.168.10.2 = 2 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' ipAdEntNetMask] CMD EXITCODE[0] CMD RUNTIME[0.0749s] STDOUT[ ipAdEntNetMask.127.0.0.1 = 255.255.255.255 ipAdEntNetMask.172.30.30.172 = 255.255.255.0 ipAdEntNetMask.192.168.10.2 = 255.255.255.252 ] SNMP STATUS[TRUE] Added 127.0.0.1 .Added 172.30.30.172 .Added 192.168.10.2 . CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' ipAddressIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.1142s] STDOUT[ ipAddressIfIndex = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o IPV6-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUsb -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' ipv6AddrEntry] CMD EXITCODE[0] CMD RUNTIME[0.1114s] STDOUT[ ipv6AddrEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o LLDP-MIB SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '1401'] SQL RUNTIME[0.00048399s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '1401' AND `ifIndex` = '1' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[0.00043201s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '555106'] SQL RUNTIME[0.00067091s] SQL[SELECT DISTINCT `entity_type` FROM `entity_attribs` WHERE `device_id` = '1401'] SQL RUNTIME[0.00048399s] SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '127.0.0.1/32'] SQL RUNTIME[0.00108385s] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '1401' AND `ifIndex` = '2' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[0.00043201s] SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '555107'] SQL RUNTIME[0.0006609s] SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '172.30.30.0/24'] SQL RUNTIME[0.00123405s] SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '192.168.10.0/30'] SQL RUNTIME[0.00125694s] SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '1401'] SQL RUNTIME[0.00049901s] SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '1401'] SQL RUNTIME[0.00043893s] +---------+---------+-------------+------------------+-----------------+----------+--------+ | ifIndex | ifDescr | IP: Version | Address | Network | Type | Origin | +---------+---------+-------------+------------------+-----------------+----------+--------+ | 1 | lo0 | IPv4 | 127.0.0.1/32 | 127.0.0.1/32 | loopback | | | 2 | gei0 | IPv4 | 172.30.30.172/24 | 172.30.30.0/24 | private | | | 2 | gei0 | IPv4 | 192.168.10.2/30 | 192.168.10.0/30 | private | | +---------+---------+-------------+------------------+-----------------+----------+--------+ o Changes 3 unchanged o Duration 0.5242s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_processors'] SQL RUNTIME[0.00033998s] ##### Module Start: processors ##### o UCD-SNMP-MIB SQL[SELECT EXISTS (SELECT 1 FROM `processors` WHERE `device_id` = '1401' AND `processor_type` NOT IN ('ucd-old', 'ucd-raw'))] SQL RUNTIME[0.00048399s] CMD[/usr/bin/snmpget -v2c -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' ssCpuIdle.0 ssCpuSystem.0 ssCpuUser.0 ssCpuRawIdle.0 ssCpuRawSystem.0] CMD EXITCODE[0] CMD RUNTIME[0.068s] STDOUT[ ssCpuIdle.0 = No Such Object available on this agent at this OID ssCpuSystem.0 = No Such Object available on this agent at this OID ssCpuUser.0 = No Such Object available on this agent at this OID ssCpuRawIdle.0 = No Such Object available on this agent at this OID ssCpuRawSystem.0 = No Such Object available on this agent at this OID ] SNMP ERROR[#1000 - Failed response] SNMP STATUS[FALSE] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' hrProcessorLoad] CMD EXITCODE[0] CMD RUNTIME[0.11s] STDOUT[ hrProcessorLoad = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `processors` WHERE `device_id` = '1401'] SQL RUNTIME[0.00039506s] o Duration 0.2338s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_mempools'] SQL RUNTIME[0.00039697s] ##### Module Start: mempools ##### o UCD-SNMP-MIB CMD[/usr/bin/snmpget -v2c -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' memTotalReal.0 memAvailReal.0 memBuffer.0 memCached.0] CMD EXITCODE[0] CMD RUNTIME[0.0672s] STDOUT[ memTotalReal.0 = No Such Object available on this agent at this OID memAvailReal.0 = No Such Object available on this agent at this OID memBuffer.0 = No Such Object available on this agent at this OID memCached.0 = No Such Object available on this agent at this OID ] SNMP ERROR[#1000 - Failed response] SNMP STATUS[FALSE] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' hrStorageEntry] CMD EXITCODE[0] CMD RUNTIME[0.1136s] STDOUT[ hrStorageEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `mempools` WHERE `device_id` = '1401'] SQL RUNTIME[0.00043511s] o Duration 0.2005s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_inventory'] SQL RUNTIME[0.0004251s] ##### Module Start: inventory ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00039291s] JSON DECODE[Not string passed] JSON RAW[ ] o ENTITY-MIB ENTITY-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'202.151.24.109':'1611' entPhysicalEntry] CMD EXITCODE[0] CMD RUNTIME[1.1954s] STDOUT[ entPhysicalEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' hrDeviceEntry] CMD EXITCODE[0] CMD RUNTIME[0.1119s] STDOUT[ hrDeviceEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' hrProcessorEntry] CMD EXITCODE[0] CMD RUNTIME[0.1103s] STDOUT[ hrProcessorEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `hrDevice` WHERE `device_id` = '1401'] SQL RUNTIME[0.00068498s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'poll_unix-agent'] SQL RUNTIME[0.0004108s] SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '1401'] SQL RUNTIME[0.00047803s] o Duration 1.4756s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_printersupplies'] SQL RUNTIME[0.00039697s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_sensors'] SQL RUNTIME[0.00039601s] ##### Module Start: sensors ##### o ENTITY-SENSOR-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' entPhySensorValue] CMD EXITCODE[0] CMD RUNTIME[0.1082s] STDOUT[ entPhySensorValue = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.0004971s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00054312s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00043917s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00052619s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00045395s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00040889s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00042295s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00054502s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.0004549s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00043297s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00043392s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00043488s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.0004921s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00048304s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'capacitance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00042295s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00044084s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00043201s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'attenuation' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00044394s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00044799s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00046301s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00050497s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'concentration' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00044394s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00043607s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00052285s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00044084s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.000458s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00051689s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00050497s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'distance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00052691s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00061679s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00049591s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00054502s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'age' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00047398s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '1401' AND `sensor_class` = 'gauge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00045514s] SQL[SELECT * FROM `status` WHERE `device_id` = '1401' AND `poller_type` = 'snmp' AND `status_deleted` = '0'] SQL RUNTIME[0.00042796s] SQL[SELECT * FROM `counters` WHERE `device_id` = '1401' AND `poller_type` = 'snmp' AND `counter_deleted` = '0'] SQL RUNTIME[0.00058198s] o Duration 0.481s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_storage'] SQL RUNTIME[0.00041199s] ##### Module Start: storage ##### o UCD-SNMP-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' dskEntry] CMD EXITCODE[0] CMD RUNTIME[0.1074s] STDOUT[ dskEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' hrStorageEntry] CMD EXITCODE[0] CMD RUNTIME[0.12s] STDOUT[ hrStorageEntry = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `storage` WHERE `device_id` = '1401'] SQL RUNTIME[0.00046015s] o Duration 0.2457s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_neighbours'] SQL RUNTIME[0.00037909s] ##### Module Start: neighbours ##### SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00041008s] JSON DECODE[Not string passed] JSON RAW[ ] o LLDP-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' lldpRemChassisIdSubtype] CMD EXITCODE[0] CMD RUNTIME[0.1257s] STDOUT[ lldpRemChassisIdSubtype = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o CISCO-CDP-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Irh -OQUs -m CISCO-CDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'202.151.24.109':'1611' cdpCache] CMD EXITCODE[0] CMD RUNTIME[0.1835s] STDOUT[ cdpCache = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] SQL[SELECT * FROM `neighbours` WHERE `device_id` = '1401'] SQL RUNTIME[0.00044107s] o Duration 0.339s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_arp-table'] SQL RUNTIME[0.00040698s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_junose-atm-vp'] SQL RUNTIME[0.00043201s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_bgp-peers'] SQL RUNTIME[0.00044203s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_mac-accounting'] SQL RUNTIME[0.00041723s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_sla'] SQL RUNTIME[0.00037694s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_lsp'] SQL RUNTIME[0.00041199s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_pseudowires'] SQL RUNTIME[0.00043297s] ##### Module Start: pseudowires ##### SQL[SELECT * FROM `pseudowires` WHERE `device_id` = '1401'] SQL RUNTIME[0.00046706s] o PW-STD-MIB CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ir -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'202.151.24.109':'1611' pwID] CMD EXITCODE[0] CMD RUNTIME[0.1217s] STDOUT[ pwID = No Such Object available on this agent at this OID ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o Duration 0.1382s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_virtual-machines'] SQL RUNTIME[0.00045395s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_cisco-cbqos'] SQL RUNTIME[0.00041699s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_ucd-diskio'] SQL RUNTIME[0.00043511s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_wifi'] SQL RUNTIME[0.00036502s] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_p2p-radios'] SQL RUNTIME[0.00045204s] ##### Module Start: p2p-radios ##### o Duration 0.0002s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_graphs'] SQL RUNTIME[0.00041294s] ##### Module Start: graphs ##### o Duration 0.0056s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '1401' AND `attrib_type` = 'discover_raid'] SQL RUNTIME[0.00057793s] o Modules Disabled vrf, ports-stack, printersupplies, arp-table, junose-atm-vp, bgp-peers, mac-accounting, sla, lsp, virtual-machines, cisco-cbqos,ucd-diskio, wifi, raid o Modules Enabled os, mibs, ports, vlans, oids, ip-addresses, processors, mempools, inventory, sensors, storage, neighbours, pseudowires, p2p-radios,graphs SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '1401';] SQL RUNTIME[0.00044179s] SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='unknown',`last_discovered_timetaken` ='8.0473',`force_discovery` ='0',`device_state` ='a:5:{s:15:\"poller_mod_perf\";a:25:{s:6:\"system\";d:0.5076;s:2:\"os\";d:0.2347;s:12:\"applications\";d:0.0014;s:4:\"ipmi\";d:0.0052;s:7:\"sensors\";d:0.0015;s:6:\"status\";d:0.0009;s:7:\"counter\";d:0.001;s:10:\"processors\";d:0.0018;s:8:\"mempools\";d:0.0017;s:7:\"storage\";d:0.002;s:8:\"netstats\";d:0.7315;s:7:\"ucd-mib\";d:0.1175;s:13:\"ipSystemStats\";d:0.1272;s:5:\"ports\";d:1.9488;s:9:\"bgp-peers\";d:0.0015;s:10:\"ucd-diskio\";d:0.0012;s:10:\"p2p-radios\";d:0.0013;s:4:\"ospf\";d:0.0003;s:3:\"sla\";d:0.002;s:11:\"pseudowires\";d:0.0021;s:14:\"mac-accounting\";d:0.002;s:15:\"entity-physical\";d:0.0005;s:6:\"graphs\";d:0.1522;s:4:\"oids\";d:0.0018;s:6:\"probes\";d:0.0022;}s:17:\"poller_ports_perf\";a:4:{s:6:\"IF-MIB\";d:1.2894859313964844;s:13:\"EtherLike-MIB\";d:0.11557912826538086;s:12:\"Q-BRIDGE-MIB\";d:0.37690305709838867;s:6:\"IP-MIB\";d:0.11930704116821289;}s:14:\"poller_history\";a:261:{i:1760482669;d:4.0351;i:1760482366;d:4.0038;i:1760482065;d:4.0068;i:1760481765;d:4.0067;i:1760481468;d:4.0223;i:1760481166;d:4.0246;i:1760480866;d:3.992;i:1760480566;d:3.9609;i:1760480260;d:4.0829;i:1760479970;d:4.0048;i:1760479668;d:3.9538;i:1760479368;d:3.9646;i:1760479070;d:4.0042;i:1760478772;d:3.983;i:1760478468;d:4.0084;i:1760478165;d:4.0698;i:1760477867;d:4.0196;i:1760477565;d:3.9974;i:1760477261;d:4.07;i:1760476970;d:4.0195;i:1760476668;d:3.9525;i:1760476368;d:4.4478;i:1760476069;d:3.9737;i:1760475767;d:4.0318;i:1760475465;d:3.9857;i:1760475166;d:3.9751;i:1760474867;d:3.9699;i:1760474566;d:4.0063;i:1760474267;d:3.9932;i:1760473967;d:3.993;i:1760473668;d:3.9476;i:1760473367;d:3.9358;i:1760473067;d:3.9398;i:1760472767;d:4.2119;i:1760472466;d:4.4926;i:1760472164;d:4.1362;i:1760471867;d:4.2828;i:1760471564;d:4.1149;i:1760471266;d:3.9574;i:1760470968;d:4.4829;i:1760470668;d:3.9696;i:1760470368;d:4.1285;i:1760470065;d:4.015;i:1760469767;d:4.0017;i:1760469466;d:4.0382;i:1760469166;d:4.0963;i:1760468863;d:3.9951;i:1760468568;d:3.9525;i:1760468265;d:3.94;i:1760467964;d:3.982;i:1760467664;d:4.0303;i:1760467365;d:4.9759;i:1760467066;d:3.9895;i:1760466766;d:3.9331;i:1760466466;d:3.9625;i:1760466168;d:3.9549;i:1760465866;d:3.9682;i:1760465568;d:4.011;i:1760465267;d:4.0031;i:1760464967;d:4.0146;i:1760464665;d:3.9814;i:1760464367;d:3.9464;i:1760464065;d:4.0264;i:1760463766;d:4.0413;i:1760463477;d:3.8854;i:1760463165;d:3.9343;i:1760462866;d:3.9917;i:1760462567;d:4.8008;i:1760462267;d:3.9271;i:1760461966;d:4.0166;i:1760461668;d:4.1066;i:1760461366;d:3.9532;i:1760461067;d:4.1174;i:1760460766;d:3.9963;i:1760460466;d:4.0002;i:1760460165;d:3.957;i:1760459867;d:4.0356;i:1760459568;d:3.9587;i:1760459264;d:3.9802;i:1760458967;d:3.99;i:1760458668;d:5.0468;i:1760458371;d:4.0455;i:1760458071;d:4.0607;i:1760457767;d:4.0458;i:1760457462;d:4.0069;i:1760457163;d:3.9572;i:1760456867;d:5.0091;i:1760456567;d:4.0615;i:1760456269;d:4.0496;i:1760455968;d:4.0806;i:1760455667;d:4.9597;i:1760455364;d:5.0405;i:1760455067;d:4.0016;i:1760454769;d:4.0299;i:1760454465;d:4.1281;i:1760454165;d:3.9888;i:1760453863;d:3.9456;i:1760453566;d:3.9596;i:1760453267;d:4.0262;i:1760452964;d:3.9555;i:1760452666;d:4.0178;i:1760452365;d:3.9526;i:1760452065;d:4.1808;i:1760451767;d:3.9998;i:1760451467;d:3.952;i:1760451167;d:3.9554;i:1760450868;d:3.9769;i:1760450567;d:3.9814;i:1760450268;d:3.9918;i:1760449964;d:3.9734;i:1760449672;d:3.946;i:1760449368;d:3.9641;i:1760449067;d:4.0057;i:1760448760;d:4.0136;i:1760448466;d:3.9843;i:1760448166;d:3.9656;i:1760447873;d:4.1347;i:1760447566;d:3.9896;i:1760447277;d:4.033;i:1760446968;d:3.8245;i:1760446673;d:4.0818;i:1760446369;d:4.0581;i:1760446072;d:3.9574;i:1760445770;d:3.9923;i:1760445466;d:3.9659;i:1760445171;d:3.9627;i:1760444868;d:4.0574;i:1760444573;d:4.0183;i:1760444277;d:4.0267;i:1760443964;d:3.998;i:1760443671;d:3.9655;i:1760443369;d:3.9831;i:1760443071;d:3.9751;i:1760442773;d:3.9397;i:1760442472;d:3.9433;i:1760442169;d:3.9967;i:1760441873;d:3.9661;i:1760441573;d:3.9559;i:1760441269;d:4.0256;i:1760440968;d:4.0256;i:1760440669;d:3.9341;i:1760440370;d:4.0133;i:1760440069;d:4.0041;i:1760439776;d:4.0012;i:1760439468;d:3.9868;i:1760439168;d:4.0225;i:1760438872;d:4.0698;i:1760438567;d:4.0145;i:1760438273;d:4.1015;i:1760437973;d:3.9877;i:1760437672;d:4.0336;i:1760437370;d:4.0754;i:1760437072;d:4.0206;i:1760436772;d:4.0208;i:1760436471;d:4.1818;i:1760436172;d:4.4448;i:1760435872;d:4.1822;i:1760435571;d:4.5292;i:1760435270;d:4.1743;i:1760434972;d:4.2112;i:1760434370;d:4.351;i:1760434069;d:5.0268;i:1760433771;d:4.6438;i:1760433475;d:7.0176;i:1760433169;d:6.5925;i:1760432866;d:4.0876;i:1760432572;d:4.8126;i:1760432274;d:4.0804;i:1760431969;d:4.4603;i:1760431675;d:4.1047;i:1760431369;d:4.1497;i:1760431072;d:4.0737;i:1760430768;d:5.7423;i:1760430470;d:15.477;i:1760430172;d:4.4936;i:1760429870;d:4.1816;i:1760429571;d:4.1418;i:1760429271;d:5.6442;i:1760428969;d:4.125;i:1760428672;d:4.6821;i:1760428375;d:4.0206;i:1760428070;d:5.7304;i:1760427768;d:4.0581;i:1760427467;d:4.3717;i:1760427171;d:4.0339;i:1760426871;d:4.0441;i:1760426571;d:4.8094;i:1760426273;d:4.3062;i:1760425968;d:4.1696;i:1760425672;d:5.6282;i:1760425367;d:3.9799;i:1760425072;d:4.9846;i:1760424769;d:4.2856;i:1760424469;d:5.1191;i:1760424167;d:4.7053;i:1760423867;d:4.0625;i:1760423572;d:6.8233;i:1760423268;d:4.9976;i:1760422968;d:4.1002;i:1760422667;d:4.0577;i:1760422367;d:4.0983;i:1760422066;d:4.1061;i:1760421772;d:4.191;i:1760421467;d:4.1883;i:1760421173;d:4.006;i:1760420871;d:4.0415;i:1760420567;d:3.9579;i:1760420262;d:4.185;i:1760419968;d:7.4544;i:1760419665;d:4.0161;i:1760419368;d:4.1211;i:1760419062;d:4.074;i:1760418766;d:4.0289;i:1760418474;d:4.178;i:1760418169;d:4.1181;i:1760417869;d:4.1187;i:1760417569;d:4.0209;i:1760417268;d:4.0025;i:1760416967;d:4.0234;i:1760416676;d:4.2594;i:1760416370;d:4.0897;i:1760416068;d:4.0343;i:1760415769;d:4.1647;i:1760415470;d:3.9597;i:1760415170;d:4.1817;i:1760414874;d:4.0471;i:1760414568;d:4.0854;i:1760414267;d:4.2608;i:1760413968;d:5.018;i:1760413673;d:4.0543;i:1760413362;d:4.2935;i:1760413072;d:4.1024;i:1760412764;d:4.1336;i:1760412468;d:4.1309;i:1760412169;d:4.1837;i:1760411867;d:4.1535;i:1760411567;d:4.1127;i:1760411271;d:4.0633;i:1760410966;d:4.0134;i:1760410667;d:4.0689;i:1760410368;d:4.0301;i:1760410069;d:4.0852;i:1760409769;d:4.0594;i:1760409469;d:4.1631;i:1760409164;d:4.0528;i:1760408868;d:4.0459;i:1760408569;d:4.026;i:1760408264;d:3.9791;i:1760407970;d:4.1521;i:1760407670;d:4.4068;i:1760407366;d:4.1182;i:1760407066;d:4.0967;i:1760406769;d:4.1784;i:1760406467;d:4.4209;i:1760406171;d:3.9928;i:1760405869;d:4.0724;i:1760405569;d:4.064;i:1760405267;d:3.9694;i:1760404968;d:3.9786;i:1760404669;d:4.0672;i:1760404368;d:4.5754;}s:17:\"discovery_history\";a:5:{i:1760482814;d:8.0473;i:1760468873;d:5.1795;i:1760447312;d:5.0836;i:1760425790;d:16.1343;i:1760404201;d:5.6594;}s:18:\"discovery_mod_perf\";a:16:{s:2:\"os\";d:0.0025;s:4:\"mibs\";d:2.7499;s:5:\"ports\";d:0.3731;s:5:\"vlans\";d:0.1601;s:11:\"ports_vlans\";N;s:4:\"oids\";d:0.0209;s:12:\"ip-addresses\";d:0.5242;s:10:\"processors\";d:0.2338;s:8:\"mempools\";d:0.2005;s:9:\"inventory\";d:1.4756;s:7:\"sensors\";d:0.481;s:7:\"storage\";d:0.2457;s:10:\"neighbours\";d:0.339;s:11:\"pseudowires\";d:0.1382;s:10:\"p2p-radios\";d:0.0002;s:6:\"graphs\";d:0.0056;}}' WHERE `device_id` = '1401'] SQL RUNTIME[0.00146985s] ##### 202.151.24.109 [1401] completed discovery modules at 2025-10-14 23:00:22 ##### o Discovery time 8.0473 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '3322563' AND `process_name` = 'discovery.php' AND `device_id` = '1401' AND `poller_id` = '0'] SQL RUNTIME[0.002285s] ##### Finished discovery run at 2025-10-14 23:00:22 ##### SQL[SELECT * FROM `groups` ORDER BY `entity_type`] SQL RUNTIME[0.00048709s] SQL[SELECT * FROM `groups_assoc`] SQL RUNTIME[0.00032997s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`os`, '') = 'routeros' OR IFNULL(`devices`.`os`, '') = 'linux')] SQL RUNTIME[0.00154805s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.00128508s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`sysname`, "") REGEXP '.*csw.*')] SQL RUNTIME[0.00260496s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00057793s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`sysname`, "") REGEXP '.*ert.*')] SQL RUNTIME[0.0018599s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 3] SQL RUNTIME[0.00036502s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") REGEXP '^([a-zA-Z\\d-]*?){1}((cer|ert)\\d\\.vostro\\.network)')] SQL RUNTIME[0.00161695s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 4] SQL RUNTIME[0.00066185s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") REGEXP 'dsprodobs-superwifi')] SQL RUNTIME[0.00128007s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 5] SQL RUNTIME[0.00033808s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 7] SQL RUNTIME[0.00039601s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") NOT REGEXP '^([a-zA-Z\\d-]*?){1}((cer|ert)\\d\\.vostro\\.network)' AND IFNULL(`devices`.`os`, '') = 'routeros' AND `devices`.`device_id` NOT IN (155,233,250,251,252,253,254,257,258,510,1327) AND IFNULL(`devices`.`device_id`, '') != 1321 AND IFNULL(`devices`.`device_id`, '') != 1369 AND IFNULL(`devices`.`device_id`, '') != 1370)] SQL RUNTIME[0.00261998s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 6] SQL RUNTIME[0.00107193s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`device_id`, '') = 233 OR IFNULL(`devices`.`device_id`, '') = 258 OR IFNULL(`devices`.`device_id`, '') = 257 OR IFNULL(`devices`.`device_id`, '') = 250 OR IFNULL(`devices`.`device_id`, '') = 251 OR IFNULL(`devices`.`device_id`, '') = 252 OR IFNULL(`devices`.`device_id`, '') = 253 OR IFNULL(`devices`.`device_id`, '') = 155 OR IFNULL(`devices`.`device_id`, '') = 255 OR IFNULL(`devices`.`device_id`, '') = 510 OR IFNULL(`devices`.`device_id`, '') = 254 OR IFNULL(`devices`.`device_id`, '') = 1327 OR IFNULL(`devices`.`device_id`, '') = 1327)] SQL RUNTIME[0.00486183s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 7] SQL RUNTIME[0.00060511s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, '') IN ('Iglu Brisbane City, 65 Mary Street, Brisbane City, QLD','Iglu Brisbane Kelvin Grove, 62 Blamey Street, Kelvin Grove, QLD','Iglu Central Park, 6 Central Park Ave, Chippendale, NSW','Iglu Central, 1 Regent St, Chippendale, NSW','Iglu Chatswood, 73 Albert Avenue, Chatswood, NSW','Iglu Flagstaff Gardens, 7 Batman Street, West Melbourne, VIC','Iglu Mascot, 8 John St, Mascot, NSW','Iglu Melbourne Central, 167 Little Lonsdale St, Melbourne, VIC','Iglu Melbourne City, 229 Franklin Street, Melbourne, VIC','Iglu Redfern, 66 Regent St, Redfern, NSW','Iglu South Yarra, 8 Claremont St, South Yarra, VIC','Iglu Sydney Broadway, 9 Kensington Street, Chippendale, NSW','Iglu Sydney Summer Hill, 74 Carlton Crescent, Summer Hill, NSW','Iglu Waterloo, 49 Botany Rd, Waterloo, NSW'))] SQL RUNTIME[0.00223184s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 8] SQL RUNTIME[0.00050497s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`device_id`, '') IN (1311,1092,1312))] SQL RUNTIME[0.00131083s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 9] SQL RUNTIME[0.00050902s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`os`, '') = 'linux' AND IFNULL(`devices`.`device_id`, '') NOT IN (516,517,518,1196))] SQL RUNTIME[0.00123215s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 10] SQL RUNTIME[0.00056911s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`device_id`, '') IN (1358,1359,1360,1347,1354,1355,1356,1357))] SQL RUNTIME[0.0012939s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 11] SQL RUNTIME[0.00041389s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") REGEXP '.*slsc.*')] SQL RUNTIME[0.00159478s] SQL[SELECT * FROM `group_table` WHERE `group_id` = 12] SQL RUNTIME[0.00043797s] SQL[SELECT * FROM `alert_tests`] SQL RUNTIME[0.00040793s] Cached 13 alert rules. SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.000283s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.00085402s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00043392s] SQL[SELECT `device_id` FROM `devices` WHERE (( `devices`.`device_id` IN (1,2,3,4,5,6,7,8,16,33,34,35,36,37,40,42,49,52,55,56,59,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,132,133,134,135,136,137,138,139,141,142,143,144,145,146,147,148,149,150,152,153,154,155,156,158,159,160,162,163,164,165,166,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,184,185,186,188,189,190,191,192,193,194,195,196,197,198,199,200,203,204,205,206,207,208,209,210,211,212,214,215,216,217,218,219,221,222,223,224,225,226,227,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,285,302,303,304,308,328,329,397,435,504,505,507,508,509,510,511,513,514,515,516,517,518,520,521,522,523,524,525,528,529,530,531,532,533,534,535,537,538,539,540,541,542,544,545,546,547,548,549,551,553,554,555,556,557,559,562,563,564,565,566,567,568,569,570,571,573,574,575,576,577,578,579,580,581,749,763,784,786,821,890,1089,1094,1188,1196,1227,1228,1239,1242,1310,1313,1314,1315,1317,1321,1327,1328,1345,1348,1350,1361,1363,1368,1387,1388,1391,1392,1393,1394,1395,1399,1400) OR `devices`.`device_id` IN (53,312,327,403,412,416,422,436,449,462,468,471,616,621,639,674,698,708,717,723,750,755,822,874,891,894,908,918,963,968,975,976,1029,1043,1060,1068,1184,1198,1215,1220,1225,1229,1237,1241,1245,1249,1254,1275,1304,1371)))] SQL RUNTIME[0.00242186s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 1] SQL RUNTIME[0.00172782s] SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`type`, '') = 'network')] SQL RUNTIME[0.00954509s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 3] SQL RUNTIME[0.01632905s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` IN (2,1)] SQL RUNTIME[0.00105s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` NOT IN (1,2,3,4,5,6,7,8,16,33,34,35,36,37,40,42,49,52,55,56,59,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,132,133,134,135,136,137,138,139,141,142,143,144,145,146,147,148,149,150,152,153,154,155,156,158,159,160,162,163,164,165,166,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,184,185,186,188,189,190,191,192,193,194,195,196,197,198,199,200,203,204,205,206,207,208,209,210,211,212,214,215,216,217,218,219,221,222,223,224,225,226,227,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,285,302,303,304,308,328,329,397,435,504,505,507,508,509,510,511,513,514,515,516,517,518,520,521,522,523,524,525,528,529,530,531,532,533,534,535,537,538,539,540,541,542,544,545,546,547,548,549,551,553,554,555,556,557,559,562,563,564,565,566,567,568,569,570,571,573,574,575,576,577,578,579,580,581,749,763,784,786,821,890,1089,1094,1188,1196,1227,1228,1239,1242,1310,1313,1314,1315,1317,1321,1327,1328,1345,1348,1350,1361,1363,1368,1387,1388,1391,1392,1393,1394,1395,1399,1400,53,312,327,403,412,416,422,436,449,462,468,471,616,621,639,674,698,708,717,723,750,755,822,874,891,894,908,918,963,968,975,976,1029,1043,1060,1068,1184,1198,1215,1220,1225,1229,1237,1241,1245,1249,1254,1275,1304,1371))] SQL RUNTIME[0.00195909s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 4] SQL RUNTIME[0.00298595s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.00086188s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00044394s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (1,2,3,4,5,6,7,8,16,33,34,35,36,37,40,42,49,52,55,56,59,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,132,133,134,135,136,137,138,139,141,142,143,144,145,146,147,148,149,150,152,153,154,155,156,158,159,160,162,163,164,165,166,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,184,185,186,188,189,190,191,192,193,194,195,196,197,198,199,200,203,204,205,206,207,208,209,210,211,212,214,215,216,217,218,219,221,222,223,224,225,226,227,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,285,302,303,304,308,328,329,397,435,504,505,507,508,509,510,511,513,514,515,516,517,518,520,521,522,523,524,525,528,529,530,531,532,533,534,535,537,538,539,540,541,542,544,545,546,547,548,549,551,553,554,555,556,557,559,562,563,564,565,566,567,568,569,570,571,573,574,575,576,577,578,579,580,581,749,763,784,786,821,890,1089,1094,1188,1196,1227,1228,1239,1242,1310,1313,1314,1315,1317,1321,1327,1328,1345,1348,1350,1361,1363,1368,1387,1388,1391,1392,1393,1394,1395,1399,1400) OR `devices`.`device_id` IN (53,312,327,403,412,416,422,436,449,462,468,471,616,621,639,674,698,708,717,723,750,755,822,874,891,894,908,918,963,968,975,976,1029,1043,1060,1068,1184,1198,1215,1220,1225,1229,1237,1241,1245,1249,1254,1275,1304,1371))] SQL RUNTIME[0.00279713s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 8] SQL RUNTIME[0.00160599s] SQL[SELECT `oid_entry_id`, `devices`.`device_id` as `device_id` FROM `oids_entries` LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) LEFT JOIN `oids` USING (`oid_id`) WHERE ( `devices`.`hardware` = 'CCR2004-1G-12S+2XS' AND `oids`.`oid` = '1.3.6.1.4.1.9.9.150.1.1.1.0')] SQL RUNTIME[0.00120187s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 9] SQL RUNTIME[0.00059199s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` IN (1,3)] SQL RUNTIME[0.00104284s] SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (1,2,3,4,5,6,7,8,16,33,34,35,36,37,40,42,49,52,55,56,59,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,132,133,134,135,136,137,138,139,141,142,143,144,145,146,147,148,149,150,152,153,154,155,156,158,159,160,162,163,164,165,166,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,184,185,186,188,189,190,191,192,193,194,195,196,197,198,199,200,203,204,205,206,207,208,209,210,211,212,214,215,216,217,218,219,221,222,223,224,225,226,227,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,285,302,303,304,308,328,329,397,435,504,505,507,508,509,510,511,513,514,515,516,517,518,520,521,522,523,524,525,528,529,530,531,532,533,534,535,537,538,539,540,541,542,544,545,546,547,548,549,551,553,554,555,556,557,559,562,563,564,565,566,567,568,569,570,571,573,574,575,576,577,578,579,580,581,749,763,784,786,821,890,1089,1094,1188,1196,1227,1228,1239,1242,1310,1313,1314,1315,1317,1321,1327,1328,1345,1348,1350,1361,1363,1368,1387,1388,1391,1392,1393,1394,1395,1399,1400) AND IFNULL(`devices`.`os`, '') = 'routeros') AND `mempools`.`mempool_deleted` != '1'] SQL RUNTIME[0.00531602s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 10] SQL RUNTIME[0.00146985s] SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`os`, '') = 'junos') AND `mempools`.`mempool_deleted` != '1'] SQL RUNTIME[0.00594497s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 11] SQL RUNTIME[0.00153518s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 3] SQL RUNTIME[0.00036478s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (68,69,70,132,133,134,135,136,137,138,275,511))] SQL RUNTIME[0.00042701s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 12] SQL RUNTIME[0.00043583s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 9] SQL RUNTIME[0.00061607s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`device_id` IN (1092,1311,1312))] SQL RUNTIME[0.00042701s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 13] SQL RUNTIME[0.00040913s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 6] SQL RUNTIME[0.00067496s] SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`os`, '') = 'routeros' AND `devices`.`device_id` IN (49,52,55,56,59,64,65,139,141,142,143,144,145,146,147,148,149,150,152,153,154,156,158,159,160,162,163,164,165,166,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,184,185,186,188,189,190,191,192,193,194,195,196,197,198,199,200,203,204,205,206,207,208,209,210,211,212,214,215,216,217,218,219,221,222,223,224,225,226,227,229,230,231,232,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,256,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,278,279,280,285,303,304,308,328,329,435,508,513,514,515,524,551,568,569,571,749,1188,1227,1228,1313,1315,1317,1328,1348,1361,1363,1368,1387,1393,1394) AND IFNULL(`devices`.`version`, '') = 6.49)] SQL RUNTIME[0.00238299s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 15] SQL RUNTIME[0.0011282s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.00101495s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (1,2,3,4,5,6,7,8,16,33,34,35,36,37,40,42,49,52,55,56,59,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,132,133,134,135,136,137,138,139,141,142,143,144,145,146,147,148,149,150,152,153,154,155,156,158,159,160,162,163,164,165,166,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,184,185,186,188,189,190,191,192,193,194,195,196,197,198,199,200,203,204,205,206,207,208,209,210,211,212,214,215,216,217,218,219,221,222,223,224,225,226,227,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,285,302,303,304,308,328,329,397,435,504,505,507,508,509,510,511,513,514,515,516,517,518,520,521,522,523,524,525,528,529,530,531,532,533,534,535,537,538,539,540,541,542,544,545,546,547,548,549,551,553,554,555,556,557,559,562,563,564,565,566,567,568,569,570,571,573,574,575,576,577,578,579,580,581,749,763,784,786,821,890,1089,1094,1188,1196,1227,1228,1239,1242,1310,1313,1314,1315,1317,1321,1327,1328,1345,1348,1350,1361,1363,1368,1387,1388,1391,1392,1393,1394,1395,1399,1400)) AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00946188s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 16] SQL RUNTIME[0.0145061s] SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00046492s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (53,312,327,403,412,416,422,436,449,462,468,471,616,621,639,674,698,708,717,723,750,755,822,874,891,894,908,918,963,968,975,976,1029,1043,1060,1068,1184,1198,1215,1220,1225,1229,1237,1241,1245,1249,1254,1275,1304,1371)) AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00470209s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 17] SQL RUNTIME[0.00810099s] SQL[SELECT `storage_id`, `devices`.`device_id` as `device_id` FROM `storage` LEFT JOIN `devices` ON (`storage`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`ignore` != '1') AND `storage`.`storage_deleted` != '1'] SQL RUNTIME[0.0038259s] SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 18] SQL RUNTIME[0.00460505s] ##### Update Alert Checkers Table ##### +--------------------------------+-------------------+-------+---------+ | Alert Checker | Entries: existing | found | changes | +--------------------------------+-------------------+-------+---------+ | Device Rebooted | 384 | 384 | +0/-0 | | High CPU Utilization | 5571 | 5571 | +0/-0 | | P2 - Device Offline | 896 | 896 | +0/-0 | | P1 - Device Offline | 384 | 384 | +0/-0 | | Hotspot over 1000 on CCR2004 | 76 | 76 | +0/-0 | | Memory Leak (MikroTik) | 277 | 277 | +0/-0 | | Memory Leak (JunOS) | 358 | 358 | +0/-0 | | P1 Major - Device Offline | 12 | 12 | +0/-0 | | P1 - VSZ Offline | 3 | 3 | +0/-0 | | Exosphere - 180+ Day Uptime | 127 | 127 | +0/-0 | | Router Port Errors | 4864 | 4864 | +0/-0 | | Port usage over threshold | 2567 | 2567 | +0/-0 | | Disk Space Low | 1359 | 1359 | +0/-0 | +--------------------------------+-------------------+-------+---------+ ./discovery.php: 202.151.24.109 - 1 devices discovered in 8.7191 secs SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1760468423'] SQL RUNTIME[0.00054908s] NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output. o Devices Discovered (Total) 1 (1) o Discovery Time 8.7191 secs o Definitions 0.31224989891052 secs o Memory usage 16MB (peak: 16MB) o MySQL Usage Cell[12/0.117s] Row[34/0.333s] Rows[111/1.287s] Column[14/0.137s] Update[1/0.011s] Insert[1/0.012s] Delete[2/0.021s] o RRDTool Usage