# ./discovery.php -h 63 -d DEBUG! CMD[/usr/bin/svn info /opt/observium] CMD EXITCODE[0] CMD RUNTIME[0.0132s] STDOUT[ Path: . Working Copy Root Path: /opt/observium URL: http://svn.observium.org/svn/observium/branches/stable Relative URL: ^/observium/branches/stable Repository Root: http://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 9672 Node Kind: directory Schedule: normal Last Changed Author: adama Last Changed Rev: 9661 Last Changed Date: 2019-01-06 19:01:40 +0100 (Sun, 06 Jan 2019) ] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';] SQL RUNTIME[0.00031900s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00016785s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';] SQL RUNTIME[0.00026608s] SQL[SELECT * FROM `config`] SQL RUNTIME[0.00021791s] CMD[/bin/hostname -f] CMD EXITCODE[0] CMD RUNTIME[0.0024s] STDOUT[ nmon1.redacted.com ] ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 19.1.9661 http://www.observium.org CMD[/opt/observium/scripts/distro] CMD EXITCODE[0] CMD RUNTIME[0.0495s] STDOUT[ Linux|3.16.0-4-amd64|amd64|Debian|8.11|kvm| ] CMD[/usr/bin/env python --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0024s] STDOUT[ Python 2.7.9 ] SQL[SELECT version();] SQL RUNTIME[0.00029898s] CMD[/usr/bin/snmpget --version 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0027s] STDOUT[ NET-SNMP version: 5.7.2.1 ] CMD[/usr/bin/rrdtool --version | head -n1] CMD EXITCODE[0] CMD RUNTIME[0.0062s] STDOUT[ RRDtool 1.4.8 Copyright 1997-2013 by Tobias Oetiker ] CMD[/usr/bin/fping -v 2>&1] CMD EXITCODE[0] CMD RUNTIME[0.0025s] CMD EXITDELAY[10ms] STDOUT[ /usr/bin/fping: Version 3.10 /usr/bin/fping: comments to david@schweikert.ch ] CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'] CMD EXITCODE[0] CMD RUNTIME[0.2394s] STDOUT[ Apache/2.4.10 ] CMD[date "+%:z"] CMD EXITCODE[0] CMD RUNTIME[0.0019s] STDOUT[ +01:00 ] SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[0.00046897s] SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00013614s] SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00063705s] ##### Software versions ##### o OS Linux 3.16.0-4-amd64 [amd64] (Debian 8.11) o Apache 2.4.10 o PHP 5.6.39-0+deb8u1 (OPcache: ENABLED) o Python 2.7.9 o MySQL 5.5.62-0+deb8u1-log (extension: mysqli 5.5.62) o SNMP NET-SNMP 5.7.2.1 o RRDtool 1.4.8 o Fping 3.10 (IPv4 and IPv6) ##### Memory Limit ##### o PHP Unlimited ##### MySQL mode ##### o MySQL ##### Charset info ##### o PHP UTF-8 o MySQL utf8 ##### Timezones info ##### o Date Thursday, 17-Jan-19 13:02:21 CET o PHP +01:00 o MySQL +01:00 SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';] SQL RUNTIME[0.00028801s] SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';] SQL RUNTIME[0.00015783s] ##### Starting discovery run at 2019-01-17 13:02:21 ##### SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = '63' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00031996s] CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' sysObjectID.0 sysUpTime.0] CMD EXITCODE[0] CMD RUNTIME[0.0073s] STDOUT[ sysObjectID.0 = ccitt.9.43.6.1.4.1 sysUpTime.0 = 0:0:29:34.06 ] SNMP STATUS[TRUE] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '63'] SQL RUNTIME[0.00042582s] SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '63'] SQL RUNTIME[0.00026703s] SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('29184','discovery.php','28514','0','php ./discovery.php -h 63 -d','1547726541','63')] SQL RUNTIME[0.00391507s] ##### quido-cra.mng.redacted.com [63] ##### o OS Type papouch o SNMP Version v1 o Last discovery 2019-01-17 12:33:11 o Last duration 5.68 seconds ##### Module Start: os ##### CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' sysDescr.0] CMD EXITCODE[0] CMD RUNTIME[0.0074s] STDOUT[ Quidos SNMP ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' sysObjectID.0] CMD EXITCODE[0] CMD RUNTIME[0.0066s] STDOUT[ .0.9.43.6.1.4.1 ] SNMP STATUS[TRUE] +-------------+-----------------+ | OID | | +-------------+-----------------+ | sysDescr | Quidos SNMP | | sysObjectID | .0.9.43.6.1.4.1 | +-------------+-----------------+ CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUv -m SP2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/eltek 'udp':'quido-cra.mng.redacted.com':'161' powerSystemStatus.0] CMD EXITCODE[2] CMD RUNTIME[0.0157s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: SP2-MIB::powerSystemStatus.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUv -m HIK-DEVICE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/hikvision 'udp':'quido-cra.mng.redacted.com':'161' deviceType.0] CMD EXITCODE[2] CMD RUNTIME[0.0059s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: HIK-DEVICE-MIB::deviceType.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUv -m WOWZA-STREAMING-ENGINE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/wowza 'udp':'quido-cra.mng.redacted.com':'161' serverCounterGetVersion.1] CMD EXITCODE[2] CMD RUNTIME[0.0099s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: WOWZA-STREAMING-ENGINE-MIB::serverCounterGetVersion.1 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUv -m BETTER-NETWORKS-ETHERNETBOX-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/messpc 'udp':'quido-cra.mng.redacted.com':'161' version.0] CMD EXITCODE[2] CMD RUNTIME[0.0106s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: BETTER-NETWORKS-ETHERNETBOX-MIB::version.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUv -m Printer-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' prtGeneralServicePerson.1] CMD EXITCODE[2] CMD RUNTIME[0.0196s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: Printer-MIB::prtGeneralServicePerson.1 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUv -m NSCRTV-ROOT -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/nscrtv 'udp':'quido-cra.mng.redacted.com':'161' commonDeviceVendorInfo.1] CMD EXITCODE[2] CMD RUNTIME[0.0074s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: NSCRTV-ROOT::commonDeviceVendorInfo.1 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] Including /opt/observium/includes/discovery/os/papouch.inc.php o Detect OS matched (papouch: Papouch Probe): +------+--------------------+--+ | OID | Matched definition | | +------+--------------------+--+ | file | | | +------+--------------------+--+ o sysORID table CMD[/usr/bin/snmptranslate -On -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'SNMPv2-MIB::sysORID'] CMD EXITCODE[0] CMD RUNTIME[0.0055s] STDOUT[ .1.3.6.1.2.1.1.9.1.2 ] SNMP TRANSLATE (CMD): 'SNMPv2-MIB::sysORID' -> '.1.3.6.1.2.1.1.9.1.2' CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' .1.3.6.1.2.1.1.9.1.2] CMD EXITCODE[0] CMD RUNTIME[0.0081s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' sysORDescr] CMD EXITCODE[0] CMD RUNTIME[0.0077s] STDOUT[ ] SNMP STATUS[TRUE] SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '63' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00039411s] o Duration 0.2641s ##### Module Start: ports ##### o Caching OIDs ifDescr CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ifDescr] CMD EXITCODE[0] CMD RUNTIME[0.0091s] STDOUT[ ifDescr.1 = Network ] SNMP STATUS[TRUE] ifAlias CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ifAlias] CMD EXITCODE[0] CMD RUNTIME[0.0085s] STDOUT[ ] SNMP STATUS[TRUE] ifName CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ifName] CMD EXITCODE[0] CMD RUNTIME[0.0083s] STDOUT[ ] SNMP STATUS[TRUE] ifType CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ifType] CMD EXITCODE[0] CMD RUNTIME[0.0082s] STDOUT[ ifType.1 = ethernetCsmacd ] SNMP STATUS[TRUE] ifOperStatus CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ifOperStatus] CMD EXITCODE[0] CMD RUNTIME[0.0088s] STDOUT[ ifOperStatus.1 = up ] SNMP STATUS[TRUE] SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '63' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00043702s] SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '63'] SQL RUNTIME[0.00031805s] SQL[SELECT * FROM `observium_attribs`] SQL RUNTIME[0.00028992s] /opt/observium/includes/discovery/ports.inc.php:42 array( [1] => array( [ifDescr] => string(7) "Network" [ifType] => string(14) "ethernetCsmacd" [ifOperStatus] => string(2) "up" ) ) o Caching DB SQL[SELECT * FROM `ports` WHERE `device_id` = '63'] SQL RUNTIME[0.00039601s] 1 ports o Discovering ports . +---------+---------+--------+---------+----------------+-------------+---------+ | ifIndex | ifDescr | ifName | ifAlias | ifType | Oper Status | Ignored | +---------+---------+--------+---------+----------------+-------------+---------+ | 1 | Network | | ... | ethernetCsmacd | up | no | +---------+---------+--------+---------+----------------+-------------+---------+ o Duration 0.0707s ##### Module Start: ports-stack ##### SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '63'] SQL RUNTIME[0.00027204s] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ifStackStatus] CMD EXITCODE[0] CMD RUNTIME[0.0096s] STDOUT[ ] SNMP STATUS[TRUE] o Duration 0.0127s ##### Module Start: vlans ##### SQL[SELECT * FROM `vlans` WHERE `device_id` = '63';] SQL RUNTIME[0.00038218s] SQL[SELECT * FROM `ports_vlans` WHERE `device_id` = '63';] SQL RUNTIME[0.00026703s] o Q-BRIDGE-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' dot1qVlanStaticName] CMD EXITCODE[0] CMD RUNTIME[0.0185s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' dot1qVlanStaticRowStatus] CMD EXITCODE[0] CMD RUNTIME[0.0183s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -Ih -OQUsx -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' dot1qVlanStaticEgressPorts] CMD EXITCODE[0] CMD RUNTIME[0.0183s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' dot1dBasePortIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.0098s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m Q-BRIDGE-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' dot1qPvid] CMD EXITCODE[0] CMD RUNTIME[0.019s] STDOUT[ ] SNMP STATUS[TRUE] o Duration 0.0985s ##### Module Start: oids ##### > $sql /opt/observium/includes/discovery/oids.inc.php:21 string(84) "SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = ?" SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '63'] SQL RUNTIME[0.00042415s] SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1'] SQL RUNTIME[0.00026417s] o Duration 0.0024s ##### Module Start: ip-addresses ##### o IP-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipAdEntIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.0127s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipAdEntNetMask] CMD EXITCODE[0] CMD RUNTIME[0.0119s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipAddressIfIndex] CMD EXITCODE[0] CMD RUNTIME[0.0121s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipAddressType] CMD EXITCODE[0] CMD RUNTIME[0.0116s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipAddressPrefix] CMD EXITCODE[0] CMD RUNTIME[0.0115s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipAddressOrigin] CMD EXITCODE[0] CMD RUNTIME[0.011s] STDOUT[ ] SNMP STATUS[TRUE] o IPV6-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUsb -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipv6AddrEntry] CMD EXITCODE[0] CMD RUNTIME[0.0088s] STDOUT[ ] SNMP STATUS[TRUE] SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '63'] SQL RUNTIME[0.00045419s] SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '63'] SQL RUNTIME[0.00029302s] o Duration 0.0999s ##### Module Start: processors ##### o UCD-SNMP-MIB SQL[SELECT COUNT(*) FROM `processors` WHERE `device_id` = '63' AND `processor_type` != 'ucd-old'] SQL RUNTIME[0.00030589s] CMD[/usr/bin/snmpget -v1 -c *** -Pu -OvQ -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ssCpuIdle.0] CMD EXITCODE[2] CMD RUNTIME[0.0081s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: UCD-SNMP-MIB::ssCpuIdle.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' hrDevice] CMD EXITCODE[0] CMD RUNTIME[0.01s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' hrProcessorLoad] CMD EXITCODE[0] CMD RUNTIME[0.0094s] STDOUT[ ] SNMP STATUS[TRUE] SQL[SELECT * FROM `processors` WHERE `device_id` = '63'] SQL RUNTIME[0.00042200s] o Duration 0.0376s ##### Module Start: mempools ##### o UCD-SNMP-MIB CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' memTotalReal.0 memAvailReal.0 memBuffer.0 memCached.0] CMD EXITCODE[2] CMD RUNTIME[0.0096s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: memTotalReal.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: memAvailReal.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: memBuffer.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: memCached.0 ] SNMP ERROR[#1000 - Failed response] SNMP ERROR[#1000 - Failed response] SNMP STATUS[FALSE] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' hrStorageEntry] CMD EXITCODE[0] CMD RUNTIME[0.0114s] STDOUT[ ] SNMP STATUS[TRUE] SQL[SELECT * FROM `mempools` WHERE `device_id` = '63'] SQL RUNTIME[0.00049806s] o Duration 0.0294s ##### Module Start: inventory ##### o ENTITY-MIB ENTITY-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'quido-cra.mng.redacted.com':'161' entPhysicalEntry] CMD EXITCODE[0] CMD RUNTIME[0.0503s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entAliasMappingIdentifier] CMD EXITCODE[0] CMD RUNTIME[0.0108s] STDOUT[ ] SNMP STATUS[TRUE] o HOST-RESOURCES-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' hrDeviceEntry] CMD EXITCODE[0] CMD RUNTIME[0.0125s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' hrProcessorEntry] CMD EXITCODE[0] CMD RUNTIME[0.01s] STDOUT[ ] SNMP STATUS[TRUE] SQL[SELECT * FROM `hrDevice` WHERE `device_id` = '63'] SQL RUNTIME[0.00047994s] SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '63'] SQL RUNTIME[0.00033808s] o Duration 0.0961s ##### Module Start: printersupplies ##### SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '63'] SQL RUNTIME[0.00029492s] o Duration 0.0017s ##### Module Start: sensors ##### o Papouch-SMI Papouch-SMI ***************************************************** CMD[/usr/bin/snmpget -v1 -c *** -Pu -Oqv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' 1.3.6.1.4.1.18248.1.1.3.0] CMD EXITCODE[2] CMD RUNTIME[0.0208s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: SNMPv2-SMI::enterprises.18248.1.1.3.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] CMD[/usr/bin/snmpget -v1 -c *** -Pu -Oqv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' 1.3.6.1.4.1.18248.16.1.1.0] CMD EXITCODE[0] CMD RUNTIME[0.024s] STDOUT[ 192 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v1 -c *** -Pu -Oqv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' 1.3.6.1.4.1.18248.16.1.1.0] CMD EXITCODE[0] CMD RUNTIME[0.0211s] STDOUT[ 192 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v1 -c *** -Pu -Oqv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' 1.3.6.1.4.1.18248.16.1.1.0] CMD EXITCODE[0] CMD RUNTIME[0.0215s] STDOUT[ 192 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v1 -c *** -Pu -Oqv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' 1.3.6.1.4.1.18248.20.1.3.1.1.2.1] CMD EXITCODE[2] CMD RUNTIME[0.0214s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: SNMPv2-SMI::enterprises.18248.20.1.3.1.1.2.1 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] Discover sensor: [class: Array, device: t, oid: Array, index: .1.3.6.1.4.1.18248.16.1.1.0, type: 1, descr: papouch-th2e, scale: 1, limits: (, , , ), CURRENT: 0.1, , SQL[SELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = AND `device_id` = 't' AND `sensor_type` = '1' AND `sensor_index` = '.1.3.6.1.4.1.18248.16.1.1.0'] SQL RUNTIME[0.00021696s] ERROR[Error in query: (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `device_id` = 't' AND `sensor_type` = '1' AND `sensor_index` = '.1.3.6.1.4.1' at line 2) 1064] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = AND `device_id` = 't' AND `sensor_type` = '1' AND `sensor_index` = '.1.3.6.1.4.1.18248.16.1.1.0'] SQL RUNTIME[0.00016999s] ERROR[Error in query: (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `device_id` = 't' AND `sensor_type` = '1' AND `sensor_index` = '.1.3.6.1.4.1' at line 1) 1064] SQL[UPDATE `sensors` set `sensor_oid` ='63','0','quido-cra.mng.redacted.com','','raH5I7tsa0pJ','','','','','','','v1','161','','','','22','','udp','','','.0.9.43.6.1.4.1','Quidos SNMP','','','','','Mahlerovy sady 1, Prague, CZ','papouch','1','0','','','0','1523','1547724769','0','2019-01-17 12:58:12','2019-01-17 12:33:11','2019-01-17 12:58:12','0.51','5.68','Quido','environment','','','a:4:{s:15:\"poller_mod_perf\";a:27:{s:6:\"system\";d:0.048899999999999999;s:2:\"os\";d:0.0011000000000000001;s:7:\"sensors\";d:0.001;s:6:\"status\";d:0.00050000000000000001;s:10:\"processors\";d:0.00089999999999999998;s:8:\"mempools\";d:0.00080000000000000004;s:7:\"storage\";d:0.00089999999999999998;s:8:\"netstats\";d:0.1046;s:6:\"hr-mib\";d:0.016400000000000001;s:7:\"ucd-mib\";d:0.022499999999999999;s:13:\"ipSystemStats\";d:0.014800000000000001;s:5:\"ports\";d:0.15310000000000001;s:9:\"bgp-peers\";d:0.016;s:15:\"printersupplies\";d:0.0011000000000000001;s:10:\"ucd-diskio\";d:0.00059999999999999995;s:4:\"wifi\";d:0.00050000000000000001;s:10:\"p2p-radios\";d:0.0015;s:4:\"ospf\";d:0.019099999999999999;s:3:\"sla\";d:0.0016000000000000001;s:11:\"pseudowires\";d:0.0012999999999999999;s:14:\"mac-accounting\";d:0.0014;s:12:\"loadbalancer\";d:0.001;s:15:\"entity-physical\";d:0.00050000000000000001;s:12:\"applications\";d:0.00069999999999999999;s:9:\"fdb-table\";d:0.038300000000000001;s:6:\"graphs\";d:0.001;s:4:\"oids\";d:0.00080000000000000004;}s:17:\"poller_ports_perf\";a:1:{s:4:\"vlan\";d:0.053015947341918945;}s:14:\"poller_history\";a:288:{i:1547726291;d:0.51380000000000003;i:1547726006;d:0.49109999999999998;i:1547725690;d:0.57730000000000004;i:1547725412;d:0.4733;i:1547725202;d:1.0254000000000001;i:1547725201;d:0.85360000000000003;i:1547724496;d:0.51919999999999999;i:1547724183;d:0.48459999999999998;i:1547723902;d:2.6111;i:1547723585;d:2.1425999999999998;i:1547723356;d:0.52090000000000003;i:1547723348;d:0.59389999999999998;i:1547722692;d:0.55330000000000001;i:1547722386;d:0.49690000000000001;i:1547722128;d:0.4803;i:1547721775;d:0.47010000000000002;i:1547721561;d:4.1247999999999996;i:1547720895;d:0.50539999999999996;i:1547720633;d:0.48049999999999998;i:1547720299;d:0.47510000000000002;i:1547719982;d:0.55900000000000005;i:1547719746;d:1.4046000000000001;i:1547719731;d:7.8771000000000004;i:1547719044;d:0.47539999999999999;i:1547718790;d:4.4569000000000001;i:1547718492;d:0.48699999999999999;i:1547718195;d:0.48159999999999997;i:1547717942;d:0.47320000000000001;i:1547717803;d:0.52690000000000003;i:1547717291;d:0.4955;i:1547716992;d:0.47860000000000003;i:1547716693;d:0.43149999999999999;i:1547716388;d:0.48859999999999998;i:1547716108;d:0.49580000000000002;i:1547715922;d:0.50929999999999997;i:1547715459;d:0.44769999999999999;i:1547715187;d:1.6493;i:1547714882;d:0.4667;i:1547714585;d:0.4738;i:1547714358;d:0.4854;i:1547714298;d:0.55410000000000004;i:1547713688;d:0.55859999999999999;i:1547713391;d:0.55500000000000005;i:1547713093;d:0.47899999999999998;i:1547712807;d:0.50929999999999997;i:1547712618;d:0.65049999999999997;i:1547711867;d:0.4894;i:1547711590;d:2.121;i:1547711292;d:0.48259999999999997;i:1547710982;d:0.48280000000000001;i:1547710699;d:0.48049999999999998;i:1547710510;d:0.5595;i:1547710090;d:0.48880000000000001;i:1547709788;d:0.495;i:1547709495;d:0.53000000000000003;i:1547709183;d:0.48149999999999998;i:1547708890;d:0.50019999999999998;i:1547708699;d:0.50470000000000004;i:1547708293;d:0.47070000000000001;i:1547708007;d:0.4985;i:1547707683;d:0.52190000000000003;i:1547707391;d:0.46939999999999998;i:1547707087;d:0.46400000000000002;i:1547706903;d:0.50770000000000004;i:1547706447;d:0.84830000000000005;i:1547706180;d:3.5836999999999999;i:1547705888;d:0.80710000000000004;i:1547705586;d:0.47920000000000001;i:1547705320;d:0.50749999999999995;i:1547705207;d:0.53800000000000003;i:1547704688;d:0.47649999999999998;i:1547704397;d:0.4662;i:1547704091;d:0.49840000000000001;i:1547703793;d:0.47689999999999999;i:1547703529;d:0.48070000000000002;i:1547703409;d:0.79430000000000001;i:1547702896;d:0.47760000000000002;i:1547702589;d:0.64890000000000003;i:1547702291;d:0.50139999999999996;i:1547701990;d:0.48749999999999999;i:1547701698;d:0.48070000000000002;i:1547701518;d:0.50629999999999997;i:1547701086;d:0.46660000000000001;i:1547700789;d:0.52370000000000005;i:1547700495;d:0.49880000000000002;i:1547700176;d:0.57240000000000002;i:1547699932;d:1.5276000000000001;i:1547699867;d:0.60860000000000003;i:1547699292;d:0.46460000000000001;i:1547698986;d:0.45660000000000001;i:1547698712;d:0.83409999999999995;i:1547698396;d:0.53129999999999999;i:1547698190;d:0.52159999999999995;i:1547697491;d:0.48199999999999998;i:1547697195;d:0.52500000000000002;i:1547696897;d:0.52969999999999995;i:1547696595;d:0.53910000000000002;i:1547696306;d:0.48430000000000001;i:1547696099;d:0.47899999999999998;i:1547695696;d:0.73350000000000004;i:1547695392;d:0.48480000000000001;i:1547695097;d:0.4884;i:1547694800;d:0.48139999999999999;i:1547694501;d:0.4945;i:1547694311;d:0.54559999999999997;i:1547693902;d:0.48820000000000002;i:1547693591;d:0.49349999999999999;i:1547693262;d:0.45469999999999999;i:1547692987;d:3.0518000000000001;i:1547692695;d:0.48859999999999998;i:1547692501;d:0.47789999999999999;i:1547692094;d:0.4793;i:1547691783;d:0.47799999999999998;i:1547691486;d:0.49340000000000001;i:1547691186;d:0.50029999999999997;i:1547690931;d:0.47410000000000002;i:1547690808;d:0.52759999999999996;i:1547690288;d:0.47910000000000003;i:1547689988;d:0.51090000000000002;i:1547689687;d:0.47149999999999997;i:1547689391;d:0.50309999999999999;i:1547689152;d:0.47070000000000001;i:1547689105;d:0.52810000000000001;i:1547688489;d:0.45660000000000001;i:1547688204;d:0.48089999999999999;i:1547687880;d:0.50270000000000004;i:1547687578;d:0.61480000000000001;i:1547687332;d:0.47239999999999999;i:1547687261;d:0.81340000000000001;i:1547686693;d:0.50419999999999998;i:1547686389;d:0.51339999999999997;i:1547686163;d:0.53239999999999998;i:1547685806;d:0.7399;i:1547685489;d:0.50670000000000004;i:1547685264;d:0.48620000000000002;i:1547684906;d:1.6234999999999999;i:1547684590;d:0.4677;i:1547684281;d:0.45929999999999999;i:1547684097;d:4.1445999999999996;i:1547684067;d:1.8813;i:1547683098;d:0.47770000000000001;i:1547682795;d:0.46839999999999998;i:1547682489;d:0.47960000000000003;i:1547682186;d:0.4667;i:1547681893;d:0.51229999999999998;i:1547681708;d:3.7690999999999999;i:1547681274;d:0.495;i:1547680984;d:0.4763;i:1547680689;d:0.48920000000000002;i:1547680387;d:0.4985;i:1547680091;d:0.51449999999999996;i:1547679906;d:0.53090000000000004;i:1547679484;d:0.47810000000000002;i:1547679188;d:0.50660000000000005;i:1547678907;d:0.48509999999999998;i:1547678571;d:0.48949999999999999;i:1547678298;d:0.48959999999999998;i:1547678105;d:1.0361;i:1547677687;d:0.60270000000000001;i:1547677393;d:0.47360000000000002;i:1547677061;d:0.50880000000000003;i:1547676788;d:2.4500000000000002;i:1547676532;d:0.4713;i:1547676464;d:0.52259999999999995;i:1547675888;d:0.46629999999999999;i:1547675593;d:0.54630000000000001;i:1547675290;d:0.47189999999999999;i:1547674990;d:0.4738;i:1547674690;d:0.51649999999999996;i:1547674496;d:0.47320000000000001;i:1547674060;d:0.4955;i:1547673788;d:2.6974999999999998;i:1547673488;d:0.48259999999999997;i:1547673165;d:0.47110000000000002;i:1547672898;d:2.6713;i:1547672711;d:0.61709999999999998;i:1547672311;d:0.59889999999999999;i:1547671998;d:0.48199999999999998;i:1547671636;d:0.58999999999999997;i:1547671401;d:5.1257999999999999;i:1547671092;d:0.46200000000000002;i:1547670905;d:0.5343;i:1547670490;d:0.52239999999999998;i:1547670194;d:0.4829;i:1547669903;d:0.47399999999999998;i:1547669584;d:0.4864;i:1547669320;d:0.78420000000000001;i:1547669178;d:0.60219999999999996;i:1547668691;d:0.48499999999999999;i:1547668397;d:0.51500000000000001;i:1547668069;d:0.49049999999999999;i:1547667796;d:1.4896;i:1547667509;d:0.47610000000000002;i:1547667322;d:0.49009999999999998;i:1547666887;d:0.48299999999999998;i:1547666577;d:0.53790000000000004;i:1547666285;d:0.46989999999999998;i:1547665982;d:0.4854;i:1547665692;d:0.51629999999999998;i:1547665506;d:0.4929;i:1547665090;d:0.46239999999999998;i:1547664795;d:0.47560000000000002;i:1547664478;d:1.1696;i:1547664199;d:2.2566000000000002;i:1547663892;d:0.48060000000000003;i:1547663701;d:0.48459999999999998;i:1547663292;d:0.48609999999999998;i:1547662985;d:0.49830000000000002;i:1547662703;d:0.4506;i:1547662397;d:0.47770000000000001;i:1547662126;d:0.46060000000000001;i:1547661995;d:0.57499999999999996;i:1547661485;d:0.48930000000000001;i:1547661197;d:0.47349999999999998;i:1547660881;d:0.48139999999999999;i:1547660601;d:0.47160000000000002;i:1547660284;d:0.46820000000000001;i:1547660099;d:0.45219999999999999;i:1547659663;d:0.47739999999999999;i:1547659386;d:2.0865;i:1547659078;d:0.57469999999999999;i:1547658786;d:1.5152000000000001;i:1547658505;d:1.8311999999999999;i:1547658304;d:0.49080000000000001;i:1547657898;d:0.48209999999999997;i:1547657594;d:0.5232;i:1547657258;d:0.46920000000000001;i:1547656986;d:1.9703999999999999;i:1547656709;d:0.49270000000000003;i:1547656533;d:0.49149999999999999;i:1547656110;d:0.47949999999999998;i:1547655793;d:0.50890000000000002;i:1547655500;d:0.48699999999999999;i:1547655251;d:0.61550000000000005;i:1547655097;d:1.6795;i:1547654300;d:1.1225000000000001;i:1547653986;d:0.5484;i:1547653694;d:0.50729999999999997;i:1547653397;d:0.48110000000000003;i:1547653101;d:0.60309999999999997;i:1547652917;d:0.50739999999999996;i:1547652491;d:0.4834;i:1547652200;d:0.8871;i:1547651897;d:0.4718;i:1547651596;d:0.48010000000000003;i:1547651305;d:0.46439999999999998;i:1547651114;d:0.55530000000000002;i:1547650688;d:0.55069999999999997;i:1547650405;d:0.74150000000000005;i:1547650061;d:0.9446;i:1547649806;d:2.3555000000000001;i:1547649505;d:0.48859999999999998;i:1547649319;d:0.73429999999999995;i:1547648891;d:0.73899999999999999;i:1547648591;d:0.50209999999999999;i:1547648294;d:0.49120000000000003;i:1547647982;d:0.50739999999999996;i:1547647764;d:0.72030000000000005;i:1547647065;d:0.47720000000000001;i:1547646800;d:1.9738;i:1547646496;d:0.48709999999999998;i:1547646190;d:0.46310000000000001;i:1547645909;d:0.50380000000000003;i:1547645723;d:0.51229999999999998;i:1547645306;d:0.48259999999999997;i:1547644981;d:0.49780000000000002;i:1547644708;d:0.54239999999999999;i:1547644371;d:0.52010000000000001;i:1547644087;d:0.95330000000000004;i:1547643911;d:0.50700000000000001;i:1547643504;d:0.49049999999999999;i:1547643189;d:0.48780000000000001;i:1547642904;d:0.45889999999999997;i:1547642585;d:0.46039999999999998;i:1547642288;d:0.48499999999999999;i:1547642109;d:0.53110000000000002;i:1547641683;d:0.47639999999999999;i:1547641384;d:1.0446;i:1547641096;d:0.52610000000000001;i:1547640702;d:0.47020000000000001;i:1547640553;d:11.785500000000001;i:1547640538;d:2.2383000000000002;i:1547639900;d:0.56020000000000003;i:1547639593;d:0.503;i:1547639299;d:0.503;i:1547638991;d:0.4713;i:1547638688;d:0.49430000000000002;i:1547638507;d:0.56979999999999997;}s:17:\"discovery_history\";a:100:{i:1547724786;d:5.6779999999999999;i:1547717998;d:1.5356000000000001;i:1547716731;d:1.8197000000000001;i:1547716718;d:3.0108999999999999;i:1547681714;d:1.9261999999999999;i:1547638523;d:2.4910999999999999;i:1547595277;d:2.9460999999999999;i:1547552050;d:1.6869000000000001;i:1547508843;d:1.5679000000000001;i:1547465694;d:1.5562;i:1547422459;d:1.8247;i:1547379282;d:1.6434;i:1547336077;d:1.6432;i:1547292883;d:1.6903999999999999;i:1547249661;d:1.5845;i:1547206464;d:1.7410000000000001;i:1547163242;d:1.7822;i:1547120094;d:1.6015999999999999;i:1547076858;d:1.8637999999999999;i:1547033661;d:1.8226;i:1546990477;d:1.6713;i:1546947297;d:1.6882999999999999;i:1546904045;d:1.7612000000000001;i:1546860872;d:1.575;i:1546817701;d:1.712;i:1546774494;d:1.7262999999999999;i:1546731297;d:1.8229;i:1546688085;d:1.6673;i:1546644898;d:1.706;i:1546601666;d:1.796;i:1546558508;d:1.6308;i:1546515293;d:1.8476999999999999;i:1546472081;d:1.9773000000000001;i:1546428865;d:2.2406999999999999;i:1546385653;d:1.6385000000000001;i:1546342466;d:1.6166;i:1546299306;d:1.6697;i:1546256071;d:1.7726999999999999;i:1546212845;d:1.8172999999999999;i:1546169703;d:1.6900999999999999;i:1546126508;d:1.9441999999999999;i:1546083286;d:1.9943;i:1546040089;d:1.6738;i:1545996873;d:1.8584000000000001;i:1545953653;d:1.7326999999999999;i:1545910572;d:1.6841999999999999;i:1545867281;d:4.8512000000000004;i:1545824095;d:1.7643;i:1545780870;d:1.8486;i:1545737701;d:1.7529999999999999;i:1545694509;d:1.9089;i:1545651286;d:1.7375;i:1545608056;d:1.7052;i:1545564872;d:1.6409;i:1545521707;d:1.7039;i:1545478474;d:1.7891999999999999;i:1545435333;d:1.6681999999999999;i:1545392066;d:2.8993000000000002;i:1545348982;d:1.6936;i:1545305663;d:4.5568;i:1545262478;d:1.7058;i:1545219314;d:1.5931;i:1545176050;d:2.2850000000000001;i:1545132859;d:1.6327;i:1545089679;d:1.5888;i:1545046470;d:1.7427999999999999;i:1545003269;d:1.6612;i:1544960107;d:1.6404000000000001;i:1544916837;d:1.7887;i:1544873694;d:1.4349000000000001;i:1544830570;d:2.2703000000000002;i:1544787278;d:1.7486999999999999;i:1544744097;d:1.5553999999999999;i:1544700991;d:2.0714999999999999;i:1544657760;d:8.9773999999999994;i:1544614479;d:1.6008;i:1544592964;d:1.9733000000000001;i:1544571263;d:1.8262;i:1544549675;d:1.5477000000000001;i:1544528053;d:1.6975;i:1544506457;d:1.6063000000000001;i:1544484875;d:1.6798;i:1544463569;d:1.9028;i:1544441711;d:15.3949;i:1544420112;d:2.552;i:1544398506;d:2.1139999999999999;i:1544376898;d:1.681;i:1544355285;d:1.7784;i:1544333696;d:2.4659;i:1544312089;d:1.7561;i:1544290467;d:2.2504;i:1544268868;d:1.619;i:1544247262;d:1.6747000000000001;i:1544225699;d:1.6449;i:1544204165;d:1.5659000000000001;i:1544182473;d:3.3624999999999998;i:1544160878;d:1.8923000000000001;i:1544139278;d:1.6105;i:1544117682;d:1.6865000000000001;i:1544096084;d:1.7092000000000001;}}','','','','',`sensor_descr` ='papouch-th2e',`sensor_multiplier` ='1',`sensor_deleted` ='0',`sensor_mib` ='',`sensor_object` ='' WHERE `sensor_id` = ''] SQL RUNTIME[0.00019503s] ERROR[Error in query: (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0','quido-cra.mng.redacted.com','','raH5I7tsa0pJ','','','','','','','v1','161','','',' at line 1) 1064] U SQL[SELECT * FROM `devices` WHERE `device_id` = 'temperature'] SQL RUNTIME[0.00039506s] SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('0',NULL,'sensor',NOW(),'6','Sensor updated: Array 1 .1.3.6.1.4.1.18248.16.1.1.0 papouch-th2e')] SQL RUNTIME[0.00228000s] CMD[/usr/bin/snmpget -v1 -c *** -Pu -Oqv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' 1.3.6.1.4.1.18248.16.1.1.0] CMD EXITCODE[0] CMD RUNTIME[0.0202s] STDOUT[ 192 ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpget -v1 -c *** -Pu -Oqv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' 1.3.6.1.4.1.18248.20.1.3.1.1.1.3] CMD EXITCODE[2] CMD RUNTIME[0.0202s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: SNMPv2-SMI::enterprises.18248.20.1.3.1.1.1.3 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] Discover sensor: [class: Array, device: t, oid: Array, index: .1.3.6.1.4.1.18248.20.1.2.1.1.2.3, type: 3, descr: papouch-th2e, scale: 1, limits: (, , , ), CURRENT: 0.1, , SQL[SELECT COUNT(`sensor_id`) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = AND `device_id` = 't' AND `sensor_type` = '3' AND `sensor_index` = '.1.3.6.1.4.1.18248.20.1.2.1.1.2.3'] SQL RUNTIME[0.00033402s] ERROR[Error in query: (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `device_id` = 't' AND `sensor_type` = '3' AND `sensor_index` = '.1.3.6.1.4.1' at line 2) 1064] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = AND `device_id` = 't' AND `sensor_type` = '3' AND `sensor_index` = '.1.3.6.1.4.1.18248.20.1.2.1.1.2.3'] SQL RUNTIME[0.00029993s] ERROR[Error in query: (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `device_id` = 't' AND `sensor_type` = '3' AND `sensor_index` = '.1.3.6.1.4.1' at line 1) 1064] SQL[UPDATE `sensors` set `sensor_oid` ='63','0','quido-cra.mng.redacted.com','','raH5I7tsa0pJ','','','','','','','v1','161','','','','22','','udp','','','.0.9.43.6.1.4.1','Quidos SNMP','','','','','Mahlerovy sady 1, Prague, CZ','papouch','1','0','','','0','1523','1547724769','0','2019-01-17 12:58:12','2019-01-17 12:33:11','2019-01-17 12:58:12','0.51','5.68','Quido','environment','','','a:4:{s:15:\"poller_mod_perf\";a:27:{s:6:\"system\";d:0.048899999999999999;s:2:\"os\";d:0.0011000000000000001;s:7:\"sensors\";d:0.001;s:6:\"status\";d:0.00050000000000000001;s:10:\"processors\";d:0.00089999999999999998;s:8:\"mempools\";d:0.00080000000000000004;s:7:\"storage\";d:0.00089999999999999998;s:8:\"netstats\";d:0.1046;s:6:\"hr-mib\";d:0.016400000000000001;s:7:\"ucd-mib\";d:0.022499999999999999;s:13:\"ipSystemStats\";d:0.014800000000000001;s:5:\"ports\";d:0.15310000000000001;s:9:\"bgp-peers\";d:0.016;s:15:\"printersupplies\";d:0.0011000000000000001;s:10:\"ucd-diskio\";d:0.00059999999999999995;s:4:\"wifi\";d:0.00050000000000000001;s:10:\"p2p-radios\";d:0.0015;s:4:\"ospf\";d:0.019099999999999999;s:3:\"sla\";d:0.0016000000000000001;s:11:\"pseudowires\";d:0.0012999999999999999;s:14:\"mac-accounting\";d:0.0014;s:12:\"loadbalancer\";d:0.001;s:15:\"entity-physical\";d:0.00050000000000000001;s:12:\"applications\";d:0.00069999999999999999;s:9:\"fdb-table\";d:0.038300000000000001;s:6:\"graphs\";d:0.001;s:4:\"oids\";d:0.00080000000000000004;}s:17:\"poller_ports_perf\";a:1:{s:4:\"vlan\";d:0.053015947341918945;}s:14:\"poller_history\";a:288:{i:1547726291;d:0.51380000000000003;i:1547726006;d:0.49109999999999998;i:1547725690;d:0.57730000000000004;i:1547725412;d:0.4733;i:1547725202;d:1.0254000000000001;i:1547725201;d:0.85360000000000003;i:1547724496;d:0.51919999999999999;i:1547724183;d:0.48459999999999998;i:1547723902;d:2.6111;i:1547723585;d:2.1425999999999998;i:1547723356;d:0.52090000000000003;i:1547723348;d:0.59389999999999998;i:1547722692;d:0.55330000000000001;i:1547722386;d:0.49690000000000001;i:1547722128;d:0.4803;i:1547721775;d:0.47010000000000002;i:1547721561;d:4.1247999999999996;i:1547720895;d:0.50539999999999996;i:1547720633;d:0.48049999999999998;i:1547720299;d:0.47510000000000002;i:1547719982;d:0.55900000000000005;i:1547719746;d:1.4046000000000001;i:1547719731;d:7.8771000000000004;i:1547719044;d:0.47539999999999999;i:1547718790;d:4.4569000000000001;i:1547718492;d:0.48699999999999999;i:1547718195;d:0.48159999999999997;i:1547717942;d:0.47320000000000001;i:1547717803;d:0.52690000000000003;i:1547717291;d:0.4955;i:1547716992;d:0.47860000000000003;i:1547716693;d:0.43149999999999999;i:1547716388;d:0.48859999999999998;i:1547716108;d:0.49580000000000002;i:1547715922;d:0.50929999999999997;i:1547715459;d:0.44769999999999999;i:1547715187;d:1.6493;i:1547714882;d:0.4667;i:1547714585;d:0.4738;i:1547714358;d:0.4854;i:1547714298;d:0.55410000000000004;i:1547713688;d:0.55859999999999999;i:1547713391;d:0.55500000000000005;i:1547713093;d:0.47899999999999998;i:1547712807;d:0.50929999999999997;i:1547712618;d:0.65049999999999997;i:1547711867;d:0.4894;i:1547711590;d:2.121;i:1547711292;d:0.48259999999999997;i:1547710982;d:0.48280000000000001;i:1547710699;d:0.48049999999999998;i:1547710510;d:0.5595;i:1547710090;d:0.48880000000000001;i:1547709788;d:0.495;i:1547709495;d:0.53000000000000003;i:1547709183;d:0.48149999999999998;i:1547708890;d:0.50019999999999998;i:1547708699;d:0.50470000000000004;i:1547708293;d:0.47070000000000001;i:1547708007;d:0.4985;i:1547707683;d:0.52190000000000003;i:1547707391;d:0.46939999999999998;i:1547707087;d:0.46400000000000002;i:1547706903;d:0.50770000000000004;i:1547706447;d:0.84830000000000005;i:1547706180;d:3.5836999999999999;i:1547705888;d:0.80710000000000004;i:1547705586;d:0.47920000000000001;i:1547705320;d:0.50749999999999995;i:1547705207;d:0.53800000000000003;i:1547704688;d:0.47649999999999998;i:1547704397;d:0.4662;i:1547704091;d:0.49840000000000001;i:1547703793;d:0.47689999999999999;i:1547703529;d:0.48070000000000002;i:1547703409;d:0.79430000000000001;i:1547702896;d:0.47760000000000002;i:1547702589;d:0.64890000000000003;i:1547702291;d:0.50139999999999996;i:1547701990;d:0.48749999999999999;i:1547701698;d:0.48070000000000002;i:1547701518;d:0.50629999999999997;i:1547701086;d:0.46660000000000001;i:1547700789;d:0.52370000000000005;i:1547700495;d:0.49880000000000002;i:1547700176;d:0.57240000000000002;i:1547699932;d:1.5276000000000001;i:1547699867;d:0.60860000000000003;i:1547699292;d:0.46460000000000001;i:1547698986;d:0.45660000000000001;i:1547698712;d:0.83409999999999995;i:1547698396;d:0.53129999999999999;i:1547698190;d:0.52159999999999995;i:1547697491;d:0.48199999999999998;i:1547697195;d:0.52500000000000002;i:1547696897;d:0.52969999999999995;i:1547696595;d:0.53910000000000002;i:1547696306;d:0.48430000000000001;i:1547696099;d:0.47899999999999998;i:1547695696;d:0.73350000000000004;i:1547695392;d:0.48480000000000001;i:1547695097;d:0.4884;i:1547694800;d:0.48139999999999999;i:1547694501;d:0.4945;i:1547694311;d:0.54559999999999997;i:1547693902;d:0.48820000000000002;i:1547693591;d:0.49349999999999999;i:1547693262;d:0.45469999999999999;i:1547692987;d:3.0518000000000001;i:1547692695;d:0.48859999999999998;i:1547692501;d:0.47789999999999999;i:1547692094;d:0.4793;i:1547691783;d:0.47799999999999998;i:1547691486;d:0.49340000000000001;i:1547691186;d:0.50029999999999997;i:1547690931;d:0.47410000000000002;i:1547690808;d:0.52759999999999996;i:1547690288;d:0.47910000000000003;i:1547689988;d:0.51090000000000002;i:1547689687;d:0.47149999999999997;i:1547689391;d:0.50309999999999999;i:1547689152;d:0.47070000000000001;i:1547689105;d:0.52810000000000001;i:1547688489;d:0.45660000000000001;i:1547688204;d:0.48089999999999999;i:1547687880;d:0.50270000000000004;i:1547687578;d:0.61480000000000001;i:1547687332;d:0.47239999999999999;i:1547687261;d:0.81340000000000001;i:1547686693;d:0.50419999999999998;i:1547686389;d:0.51339999999999997;i:1547686163;d:0.53239999999999998;i:1547685806;d:0.7399;i:1547685489;d:0.50670000000000004;i:1547685264;d:0.48620000000000002;i:1547684906;d:1.6234999999999999;i:1547684590;d:0.4677;i:1547684281;d:0.45929999999999999;i:1547684097;d:4.1445999999999996;i:1547684067;d:1.8813;i:1547683098;d:0.47770000000000001;i:1547682795;d:0.46839999999999998;i:1547682489;d:0.47960000000000003;i:1547682186;d:0.4667;i:1547681893;d:0.51229999999999998;i:1547681708;d:3.7690999999999999;i:1547681274;d:0.495;i:1547680984;d:0.4763;i:1547680689;d:0.48920000000000002;i:1547680387;d:0.4985;i:1547680091;d:0.51449999999999996;i:1547679906;d:0.53090000000000004;i:1547679484;d:0.47810000000000002;i:1547679188;d:0.50660000000000005;i:1547678907;d:0.48509999999999998;i:1547678571;d:0.48949999999999999;i:1547678298;d:0.48959999999999998;i:1547678105;d:1.0361;i:1547677687;d:0.60270000000000001;i:1547677393;d:0.47360000000000002;i:1547677061;d:0.50880000000000003;i:1547676788;d:2.4500000000000002;i:1547676532;d:0.4713;i:1547676464;d:0.52259999999999995;i:1547675888;d:0.46629999999999999;i:1547675593;d:0.54630000000000001;i:1547675290;d:0.47189999999999999;i:1547674990;d:0.4738;i:1547674690;d:0.51649999999999996;i:1547674496;d:0.47320000000000001;i:1547674060;d:0.4955;i:1547673788;d:2.6974999999999998;i:1547673488;d:0.48259999999999997;i:1547673165;d:0.47110000000000002;i:1547672898;d:2.6713;i:1547672711;d:0.61709999999999998;i:1547672311;d:0.59889999999999999;i:1547671998;d:0.48199999999999998;i:1547671636;d:0.58999999999999997;i:1547671401;d:5.1257999999999999;i:1547671092;d:0.46200000000000002;i:1547670905;d:0.5343;i:1547670490;d:0.52239999999999998;i:1547670194;d:0.4829;i:1547669903;d:0.47399999999999998;i:1547669584;d:0.4864;i:1547669320;d:0.78420000000000001;i:1547669178;d:0.60219999999999996;i:1547668691;d:0.48499999999999999;i:1547668397;d:0.51500000000000001;i:1547668069;d:0.49049999999999999;i:1547667796;d:1.4896;i:1547667509;d:0.47610000000000002;i:1547667322;d:0.49009999999999998;i:1547666887;d:0.48299999999999998;i:1547666577;d:0.53790000000000004;i:1547666285;d:0.46989999999999998;i:1547665982;d:0.4854;i:1547665692;d:0.51629999999999998;i:1547665506;d:0.4929;i:1547665090;d:0.46239999999999998;i:1547664795;d:0.47560000000000002;i:1547664478;d:1.1696;i:1547664199;d:2.2566000000000002;i:1547663892;d:0.48060000000000003;i:1547663701;d:0.48459999999999998;i:1547663292;d:0.48609999999999998;i:1547662985;d:0.49830000000000002;i:1547662703;d:0.4506;i:1547662397;d:0.47770000000000001;i:1547662126;d:0.46060000000000001;i:1547661995;d:0.57499999999999996;i:1547661485;d:0.48930000000000001;i:1547661197;d:0.47349999999999998;i:1547660881;d:0.48139999999999999;i:1547660601;d:0.47160000000000002;i:1547660284;d:0.46820000000000001;i:1547660099;d:0.45219999999999999;i:1547659663;d:0.47739999999999999;i:1547659386;d:2.0865;i:1547659078;d:0.57469999999999999;i:1547658786;d:1.5152000000000001;i:1547658505;d:1.8311999999999999;i:1547658304;d:0.49080000000000001;i:1547657898;d:0.48209999999999997;i:1547657594;d:0.5232;i:1547657258;d:0.46920000000000001;i:1547656986;d:1.9703999999999999;i:1547656709;d:0.49270000000000003;i:1547656533;d:0.49149999999999999;i:1547656110;d:0.47949999999999998;i:1547655793;d:0.50890000000000002;i:1547655500;d:0.48699999999999999;i:1547655251;d:0.61550000000000005;i:1547655097;d:1.6795;i:1547654300;d:1.1225000000000001;i:1547653986;d:0.5484;i:1547653694;d:0.50729999999999997;i:1547653397;d:0.48110000000000003;i:1547653101;d:0.60309999999999997;i:1547652917;d:0.50739999999999996;i:1547652491;d:0.4834;i:1547652200;d:0.8871;i:1547651897;d:0.4718;i:1547651596;d:0.48010000000000003;i:1547651305;d:0.46439999999999998;i:1547651114;d:0.55530000000000002;i:1547650688;d:0.55069999999999997;i:1547650405;d:0.74150000000000005;i:1547650061;d:0.9446;i:1547649806;d:2.3555000000000001;i:1547649505;d:0.48859999999999998;i:1547649319;d:0.73429999999999995;i:1547648891;d:0.73899999999999999;i:1547648591;d:0.50209999999999999;i:1547648294;d:0.49120000000000003;i:1547647982;d:0.50739999999999996;i:1547647764;d:0.72030000000000005;i:1547647065;d:0.47720000000000001;i:1547646800;d:1.9738;i:1547646496;d:0.48709999999999998;i:1547646190;d:0.46310000000000001;i:1547645909;d:0.50380000000000003;i:1547645723;d:0.51229999999999998;i:1547645306;d:0.48259999999999997;i:1547644981;d:0.49780000000000002;i:1547644708;d:0.54239999999999999;i:1547644371;d:0.52010000000000001;i:1547644087;d:0.95330000000000004;i:1547643911;d:0.50700000000000001;i:1547643504;d:0.49049999999999999;i:1547643189;d:0.48780000000000001;i:1547642904;d:0.45889999999999997;i:1547642585;d:0.46039999999999998;i:1547642288;d:0.48499999999999999;i:1547642109;d:0.53110000000000002;i:1547641683;d:0.47639999999999999;i:1547641384;d:1.0446;i:1547641096;d:0.52610000000000001;i:1547640702;d:0.47020000000000001;i:1547640553;d:11.785500000000001;i:1547640538;d:2.2383000000000002;i:1547639900;d:0.56020000000000003;i:1547639593;d:0.503;i:1547639299;d:0.503;i:1547638991;d:0.4713;i:1547638688;d:0.49430000000000002;i:1547638507;d:0.56979999999999997;}s:17:\"discovery_history\";a:100:{i:1547724786;d:5.6779999999999999;i:1547717998;d:1.5356000000000001;i:1547716731;d:1.8197000000000001;i:1547716718;d:3.0108999999999999;i:1547681714;d:1.9261999999999999;i:1547638523;d:2.4910999999999999;i:1547595277;d:2.9460999999999999;i:1547552050;d:1.6869000000000001;i:1547508843;d:1.5679000000000001;i:1547465694;d:1.5562;i:1547422459;d:1.8247;i:1547379282;d:1.6434;i:1547336077;d:1.6432;i:1547292883;d:1.6903999999999999;i:1547249661;d:1.5845;i:1547206464;d:1.7410000000000001;i:1547163242;d:1.7822;i:1547120094;d:1.6015999999999999;i:1547076858;d:1.8637999999999999;i:1547033661;d:1.8226;i:1546990477;d:1.6713;i:1546947297;d:1.6882999999999999;i:1546904045;d:1.7612000000000001;i:1546860872;d:1.575;i:1546817701;d:1.712;i:1546774494;d:1.7262999999999999;i:1546731297;d:1.8229;i:1546688085;d:1.6673;i:1546644898;d:1.706;i:1546601666;d:1.796;i:1546558508;d:1.6308;i:1546515293;d:1.8476999999999999;i:1546472081;d:1.9773000000000001;i:1546428865;d:2.2406999999999999;i:1546385653;d:1.6385000000000001;i:1546342466;d:1.6166;i:1546299306;d:1.6697;i:1546256071;d:1.7726999999999999;i:1546212845;d:1.8172999999999999;i:1546169703;d:1.6900999999999999;i:1546126508;d:1.9441999999999999;i:1546083286;d:1.9943;i:1546040089;d:1.6738;i:1545996873;d:1.8584000000000001;i:1545953653;d:1.7326999999999999;i:1545910572;d:1.6841999999999999;i:1545867281;d:4.8512000000000004;i:1545824095;d:1.7643;i:1545780870;d:1.8486;i:1545737701;d:1.7529999999999999;i:1545694509;d:1.9089;i:1545651286;d:1.7375;i:1545608056;d:1.7052;i:1545564872;d:1.6409;i:1545521707;d:1.7039;i:1545478474;d:1.7891999999999999;i:1545435333;d:1.6681999999999999;i:1545392066;d:2.8993000000000002;i:1545348982;d:1.6936;i:1545305663;d:4.5568;i:1545262478;d:1.7058;i:1545219314;d:1.5931;i:1545176050;d:2.2850000000000001;i:1545132859;d:1.6327;i:1545089679;d:1.5888;i:1545046470;d:1.7427999999999999;i:1545003269;d:1.6612;i:1544960107;d:1.6404000000000001;i:1544916837;d:1.7887;i:1544873694;d:1.4349000000000001;i:1544830570;d:2.2703000000000002;i:1544787278;d:1.7486999999999999;i:1544744097;d:1.5553999999999999;i:1544700991;d:2.0714999999999999;i:1544657760;d:8.9773999999999994;i:1544614479;d:1.6008;i:1544592964;d:1.9733000000000001;i:1544571263;d:1.8262;i:1544549675;d:1.5477000000000001;i:1544528053;d:1.6975;i:1544506457;d:1.6063000000000001;i:1544484875;d:1.6798;i:1544463569;d:1.9028;i:1544441711;d:15.3949;i:1544420112;d:2.552;i:1544398506;d:2.1139999999999999;i:1544376898;d:1.681;i:1544355285;d:1.7784;i:1544333696;d:2.4659;i:1544312089;d:1.7561;i:1544290467;d:2.2504;i:1544268868;d:1.619;i:1544247262;d:1.6747000000000001;i:1544225699;d:1.6449;i:1544204165;d:1.5659000000000001;i:1544182473;d:3.3624999999999998;i:1544160878;d:1.8923000000000001;i:1544139278;d:1.6105;i:1544117682;d:1.6865000000000001;i:1544096084;d:1.7092000000000001;}}','','','','',`sensor_descr` ='papouch-th2e',`sensor_multiplier` ='1',`sensor_deleted` ='0',`sensor_mib` ='',`sensor_object` ='' WHERE `sensor_id` = ''] SQL RUNTIME[0.00016093s] ERROR[Error in query: (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0','quido-cra.mng.redacted.com','','raH5I7tsa0pJ','','','','','','','v1','161','','',' at line 1) 1064] U SQL[SELECT * FROM `devices` WHERE `device_id` = 'temperature'] SQL RUNTIME[0.00042796s] SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('0',NULL,'sensor',NOW(),'6','Sensor updated: Array 3 .1.3.6.1.4.1.18248.20.1.2.1.1.2.3 papouch-th2e')] SQL RUNTIME[0.00214386s] CMD[/usr/bin/snmpget -v1 -c *** -Pu -Oqv -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' 1.3.6.1.4.1.18248.20.1.2.1.1.2.1] CMD EXITCODE[2] CMD RUNTIME[0.0199s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: SNMPv2-SMI::enterprises.18248.20.1.2.1.1.2.1 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] o ENTITY-SENSOR-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entPhySensorValue] CMD EXITCODE[0] CMD RUNTIME[0.0086s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entPhySensorType] CMD EXITCODE[0] CMD RUNTIME[0.0087s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entPhySensorScale] CMD EXITCODE[0] CMD RUNTIME[0.0087s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entPhySensorPrecision] CMD EXITCODE[0] CMD RUNTIME[0.0088s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entPhySensorOperStatus] CMD EXITCODE[0] CMD RUNTIME[0.0092s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'quido-cra.mng.redacted.com':'161' entPhysicalDescr] CMD EXITCODE[0] CMD RUNTIME[0.0498s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'quido-cra.mng.redacted.com':'161' entPhysicalName] CMD EXITCODE[0] CMD RUNTIME[0.0518s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'quido-cra.mng.redacted.com':'161' entPhysicalClass] CMD EXITCODE[0] CMD RUNTIME[0.0481s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'quido-cra.mng.redacted.com':'161' entPhysicalContainedIn] CMD EXITCODE[0] CMD RUNTIME[0.0483s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'quido-cra.mng.redacted.com':'161' entPhysicalParentRelPos] CMD EXITCODE[0] CMD RUNTIME[0.0509s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entAliasMappingIdentifier] CMD EXITCODE[0] CMD RUNTIME[0.0115s] STDOUT[ ] SNMP STATUS[TRUE] o TMESNMP2-MIB int_temperature [ CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -Ih -OQUsb -m TMESNMP2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/papouch 'udp':'quido-cra.mng.redacted.com':'161' int_temperature] CMD EXITCODE[0] CMD RUNTIME[0.0079s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -Ih -OQUsb -m TMESNMP2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/papouch 'udp':'quido-cra.mng.redacted.com':'161' device_name] CMD EXITCODE[0] CMD RUNTIME[0.0077s] STDOUT[ ] SNMP STATUS[TRUE] ] o the_v01-MIB inChValue [ CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -Ih -OQUsb -m the_v01-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/papouch 'udp':'quido-cra.mng.redacted.com':'161' inChValue] CMD EXITCODE[0] CMD RUNTIME[0.0104s] STDOUT[ End of MIB ] SNMP STATUS[FALSE] SNMP ERROR[#999 - Unknown] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -Ih -OQUsb -m the_v01-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/papouch 'udp':'quido-cra.mng.redacted.com':'161' inChUnits] CMD EXITCODE[0] CMD RUNTIME[0.0089s] STDOUT[ End of MIB ] SNMP STATUS[FALSE] SNMP ERROR[#999 - Unknown] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -Ih -OQUsb -m the_v01-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/papouch 'udp':'quido-cra.mng.redacted.com':'161' limitLo] CMD EXITCODE[0] CMD RUNTIME[0.0091s] STDOUT[ End of MIB ] SNMP STATUS[FALSE] SNMP ERROR[#999 - Unknown] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -Ih -OQUsb -m the_v01-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/papouch 'udp':'quido-cra.mng.redacted.com':'161' limitHy] CMD EXITCODE[0] CMD RUNTIME[0.0093s] STDOUT[ End of MIB ] SNMP STATUS[FALSE] SNMP ERROR[#999 - Unknown] ] o papago_temp_V02-MIB inChValue [ CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -Ih -OQUsb -m papago_temp_V02-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/papouch 'udp':'quido-cra.mng.redacted.com':'161' channelTable] CMD EXITCODE[0] CMD RUNTIME[0.0087s] STDOUT[ End of MIB ] SNMP STATUS[FALSE] SNMP ERROR[#999 - Unknown] Store in cache Table OID: papago_temp_V02-MIB::channelTable ] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00053692s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00035787s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00037098s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00031614s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00029397s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00030994s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00030804s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'charge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00031209s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00034690s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'energy' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00028896s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00028300s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024199s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00023198s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00026894s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022602s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024199s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024581s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00025892s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022388s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00025201s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00025392s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022602s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024796s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022388s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00019884s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021100s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00028491s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00022888s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020099s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021601s] SQL[SELECT * FROM `sensors` WHERE `device_id` = '63' AND `sensor_class` = 'counter' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024700s] SQL[SELECT * FROM `status` WHERE `device_id` = '63' AND `poller_type` = 'snmp' AND `status_deleted` = '0'] SQL RUNTIME[0.00021601s] o Duration 0.6555s ##### Module Start: storage ##### o UCD-SNMP-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' dskEntry] CMD EXITCODE[0] CMD RUNTIME[0.0088s] STDOUT[ ] SNMP STATUS[TRUE] o HOST-RESOURCES-MIB SQL[SELECT * FROM `storage` WHERE `device_id` = '63'] SQL RUNTIME[0.00035214s] o Duration 0.015s ##### Module Start: neighbours ##### o LLDP-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' lldpRemChassisIdSubtype] CMD EXITCODE[0] CMD RUNTIME[0.0169s] STDOUT[ ] SNMP STATUS[TRUE] o CISCO-CDP-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m CISCO-CDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'quido-cra.mng.redacted.com':'161' cdpCache] CMD EXITCODE[0] CMD RUNTIME[0.0284s] STDOUT[ ] SNMP STATUS[TRUE] o OSPF-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m OSPF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ospfNbrRtrId] CMD EXITCODE[0] CMD RUNTIME[0.0117s] STDOUT[ ] SNMP STATUS[TRUE] SQL[SELECT * FROM `neighbours` WHERE `device_id` = '63'] SQL RUNTIME[0.00049710s] o Duration 0.0685s ##### Module Start: arp-table ##### SQL[SELECT port_id, ifIndex FROM ports WHERE device_id = '63' GROUP BY port_id] SQL RUNTIME[0.00042915s] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OXqs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipNetToPhysicalPhysAddress] CMD EXITCODE[0] CMD RUNTIME[0.0114s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OXqs -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipv6NetToMediaPhysAddress] CMD EXITCODE[0] CMD RUNTIME[0.0085s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OXqs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' ipNetToMediaPhysAddress] CMD EXITCODE[0] CMD RUNTIME[0.0111s] STDOUT[ ] SNMP STATUS[TRUE] SQL[SELECT mac_id, mac_address, ip_address, ip_version, ifIndex FROM ip_mac AS M LEFT JOIN ports AS I ON M.port_id = I.port_id WHERE I.device_id = '63'] SQL RUNTIME[0.00055885s] o Duration 0.0403s ##### Module Start: junose-atm-vp ##### o Duration 0.0009s ##### Module Start: bgp-peers ##### CMD[/usr/bin/snmpget -v1 -c *** -Pu -OQUv -m BGP4-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' bgpLocalAs.0] CMD EXITCODE[2] CMD RUNTIME[0.0076s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: BGP4-MIB::bgpLocalAs.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] No BGP on host SQL[SELECT * FROM `bgpPeers` WHERE `device_id` = '63'] SQL RUNTIME[0.00052810s] o Duration 0.0141s ##### Module Start: mac-accounting ##### o Duration 0.0005s ##### Module Start: cisco-vrf ##### o Duration 0.001s ##### Module Start: cisco-cef ##### Cisco CEF Switching Path: CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m CISCO-CEF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'quido-cra.mng.redacted.com':'161' cefSwitchingPath] CMD EXITCODE[0] CMD RUNTIME[0.0262s] STDOUT[ ] SNMP STATUS[TRUE] Caching OIDs: entPhysicalDescr CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entPhysicalDescr] CMD EXITCODE[0] CMD RUNTIME[0.0097s] STDOUT[ ] SNMP STATUS[TRUE] entPhysicalName CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entPhysicalName] CMD EXITCODE[0] CMD RUNTIME[0.0093s] STDOUT[ ] SNMP STATUS[TRUE] entPhysicalModelName CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m ENTITY-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' entPhysicalModelName] CMD EXITCODE[0] CMD RUNTIME[0.0089s] STDOUT[ ] SNMP STATUS[TRUE] o Duration 0.0635s ##### Module Start: sla ##### o DISMAN-PING-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m DISMAN-PING-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pingCtlEntry] CMD EXITCODE[0] CMD RUNTIME[0.0112s] STDOUT[ ] SNMP STATUS[TRUE] SQL[SELECT * FROM `slas` WHERE `device_id` = '63'] SQL RUNTIME[0.00046897s] o Duration 0.0167s ##### Module Start: lsp ##### o Duration 0.0002s ##### Module Start: pseudowires ##### SQL[SELECT * FROM `pseudowires` WHERE `device_id` = '63'] SQL RUNTIME[0.00027084s] o PW-STD-MIB CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwID] CMD EXITCODE[0] CMD RUNTIME[0.0118s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwRowStatus] CMD EXITCODE[0] CMD RUNTIME[0.0111s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwName] CMD EXITCODE[0] CMD RUNTIME[0.0117s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwType] CMD EXITCODE[0] CMD RUNTIME[0.0117s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwDescr] CMD EXITCODE[0] CMD RUNTIME[0.0109s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwPsnType] CMD EXITCODE[0] CMD RUNTIME[0.011s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwPeerAddrType] CMD EXITCODE[0] CMD RUNTIME[0.0115s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwPeerAddr] CMD EXITCODE[0] CMD RUNTIME[0.0115s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwOutboundLabel] CMD EXITCODE[0] CMD RUNTIME[0.0119s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwInboundLabel] CMD EXITCODE[0] CMD RUNTIME[0.0107s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwRemoteIfString] CMD EXITCODE[0] CMD RUNTIME[0.0111s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-MPLS-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwMplsLocalLdpID] CMD EXITCODE[0] CMD RUNTIME[0.0132s] STDOUT[ ] SNMP STATUS[TRUE] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m PW-MPLS-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' pwMplsPeerLdpID] CMD EXITCODE[0] CMD RUNTIME[0.0127s] STDOUT[ ] SNMP STATUS[TRUE] o Duration 0.1821s ##### Module Start: virtual-machines ##### o Duration 0.0018s ##### Module Start: cisco-cbqos ##### SQL[SELECT * FROM `ports_cbqos` WHERE `device_id` = '63'] SQL RUNTIME[0.00165701s] CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m CISCO-CLASS-BASED-QOS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'quido-cra.mng.redacted.com':'161' cbQosIfType] CMD EXITCODE[0] CMD RUNTIME[0.0438s] STDOUT[ ] SNMP STATUS[TRUE] QoS not configured. o Duration 0.0491s ##### Module Start: ucd-diskio ##### CMD[/usr/bin/snmpwalk -v1 -c *** -Pu -OQUs -m UCD-DISKIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'quido-cra.mng.redacted.com':'161' diskIOEntry] CMD EXITCODE[0] CMD RUNTIME[0.0085s] STDOUT[ ] SNMP STATUS[TRUE] SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '63'] SQL RUNTIME[0.00038004s] o Duration 0.0123s ##### Module Start: wifi ##### SQL[SELECT * FROM `wifi_radios` WHERE `device_id` = '63'] SQL RUNTIME[0.00019097s] SQL[SELECT * FROM `wifi_wlans` WHERE `device_id` = '63'] SQL RUNTIME[0.00016809s] SQL[SELECT * FROM `wifi_aps` WHERE `device_id` = '63'] SQL RUNTIME[0.00014901s] o Duration 0.0026s ##### Module Start: p2p-radios ##### o Duration 0.0002s ##### Module Start: graphs ##### o Duration 0.0008s Module [ services ] disabled globally. Module [ raid ] disabled globally. SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '63';] SQL RUNTIME[0.00025797s] SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='environment',`last_discovered_timetaken` ='1.8571',`force_discovery` ='0',`device_state` ='a:4:{s:15:\"poller_mod_perf\";a:27:{s:6:\"system\";d:0.048899999999999999;s:2:\"os\";d:0.0011000000000000001;s:7:\"sensors\";d:0.001;s:6:\"status\";d:0.00050000000000000001;s:10:\"processors\";d:0.00089999999999999998;s:8:\"mempools\";d:0.00080000000000000004;s:7:\"storage\";d:0.00089999999999999998;s:8:\"netstats\";d:0.1046;s:6:\"hr-mib\";d:0.016400000000000001;s:7:\"ucd-mib\";d:0.022499999999999999;s:13:\"ipSystemStats\";d:0.014800000000000001;s:5:\"ports\";d:0.15310000000000001;s:9:\"bgp-peers\";d:0.016;s:15:\"printersupplies\";d:0.0011000000000000001;s:10:\"ucd-diskio\";d:0.00059999999999999995;s:4:\"wifi\";d:0.00050000000000000001;s:10:\"p2p-radios\";d:0.0015;s:4:\"ospf\";d:0.019099999999999999;s:3:\"sla\";d:0.0016000000000000001;s:11:\"pseudowires\";d:0.0012999999999999999;s:14:\"mac-accounting\";d:0.0014;s:12:\"loadbalancer\";d:0.001;s:15:\"entity-physical\";d:0.00050000000000000001;s:12:\"applications\";d:0.00069999999999999999;s:9:\"fdb-table\";d:0.038300000000000001;s:6:\"graphs\";d:0.001;s:4:\"oids\";d:0.00080000000000000004;}s:17:\"poller_ports_perf\";a:1:{s:4:\"vlan\";d:0.053015947341918945;}s:14:\"poller_history\";a:288:{i:1547726291;d:0.51380000000000003;i:1547726006;d:0.49109999999999998;i:1547725690;d:0.57730000000000004;i:1547725412;d:0.4733;i:1547725202;d:1.0254000000000001;i:1547725201;d:0.85360000000000003;i:1547724496;d:0.51919999999999999;i:1547724183;d:0.48459999999999998;i:1547723902;d:2.6111;i:1547723585;d:2.1425999999999998;i:1547723356;d:0.52090000000000003;i:1547723348;d:0.59389999999999998;i:1547722692;d:0.55330000000000001;i:1547722386;d:0.49690000000000001;i:1547722128;d:0.4803;i:1547721775;d:0.47010000000000002;i:1547721561;d:4.1247999999999996;i:1547720895;d:0.50539999999999996;i:1547720633;d:0.48049999999999998;i:1547720299;d:0.47510000000000002;i:1547719982;d:0.55900000000000005;i:1547719746;d:1.4046000000000001;i:1547719731;d:7.8771000000000004;i:1547719044;d:0.47539999999999999;i:1547718790;d:4.4569000000000001;i:1547718492;d:0.48699999999999999;i:1547718195;d:0.48159999999999997;i:1547717942;d:0.47320000000000001;i:1547717803;d:0.52690000000000003;i:1547717291;d:0.4955;i:1547716992;d:0.47860000000000003;i:1547716693;d:0.43149999999999999;i:1547716388;d:0.48859999999999998;i:1547716108;d:0.49580000000000002;i:1547715922;d:0.50929999999999997;i:1547715459;d:0.44769999999999999;i:1547715187;d:1.6493;i:1547714882;d:0.4667;i:1547714585;d:0.4738;i:1547714358;d:0.4854;i:1547714298;d:0.55410000000000004;i:1547713688;d:0.55859999999999999;i:1547713391;d:0.55500000000000005;i:1547713093;d:0.47899999999999998;i:1547712807;d:0.50929999999999997;i:1547712618;d:0.65049999999999997;i:1547711867;d:0.4894;i:1547711590;d:2.121;i:1547711292;d:0.48259999999999997;i:1547710982;d:0.48280000000000001;i:1547710699;d:0.48049999999999998;i:1547710510;d:0.5595;i:1547710090;d:0.48880000000000001;i:1547709788;d:0.495;i:1547709495;d:0.53000000000000003;i:1547709183;d:0.48149999999999998;i:1547708890;d:0.50019999999999998;i:1547708699;d:0.50470000000000004;i:1547708293;d:0.47070000000000001;i:1547708007;d:0.4985;i:1547707683;d:0.52190000000000003;i:1547707391;d:0.46939999999999998;i:1547707087;d:0.46400000000000002;i:1547706903;d:0.50770000000000004;i:1547706447;d:0.84830000000000005;i:1547706180;d:3.5836999999999999;i:1547705888;d:0.80710000000000004;i:1547705586;d:0.47920000000000001;i:1547705320;d:0.50749999999999995;i:1547705207;d:0.53800000000000003;i:1547704688;d:0.47649999999999998;i:1547704397;d:0.4662;i:1547704091;d:0.49840000000000001;i:1547703793;d:0.47689999999999999;i:1547703529;d:0.48070000000000002;i:1547703409;d:0.79430000000000001;i:1547702896;d:0.47760000000000002;i:1547702589;d:0.64890000000000003;i:1547702291;d:0.50139999999999996;i:1547701990;d:0.48749999999999999;i:1547701698;d:0.48070000000000002;i:1547701518;d:0.50629999999999997;i:1547701086;d:0.46660000000000001;i:1547700789;d:0.52370000000000005;i:1547700495;d:0.49880000000000002;i:1547700176;d:0.57240000000000002;i:1547699932;d:1.5276000000000001;i:1547699867;d:0.60860000000000003;i:1547699292;d:0.46460000000000001;i:1547698986;d:0.45660000000000001;i:1547698712;d:0.83409999999999995;i:1547698396;d:0.53129999999999999;i:1547698190;d:0.52159999999999995;i:1547697491;d:0.48199999999999998;i:1547697195;d:0.52500000000000002;i:1547696897;d:0.52969999999999995;i:1547696595;d:0.53910000000000002;i:1547696306;d:0.48430000000000001;i:1547696099;d:0.47899999999999998;i:1547695696;d:0.73350000000000004;i:1547695392;d:0.48480000000000001;i:1547695097;d:0.4884;i:1547694800;d:0.48139999999999999;i:1547694501;d:0.4945;i:1547694311;d:0.54559999999999997;i:1547693902;d:0.48820000000000002;i:1547693591;d:0.49349999999999999;i:1547693262;d:0.45469999999999999;i:1547692987;d:3.0518000000000001;i:1547692695;d:0.48859999999999998;i:1547692501;d:0.47789999999999999;i:1547692094;d:0.4793;i:1547691783;d:0.47799999999999998;i:1547691486;d:0.49340000000000001;i:1547691186;d:0.50029999999999997;i:1547690931;d:0.47410000000000002;i:1547690808;d:0.52759999999999996;i:1547690288;d:0.47910000000000003;i:1547689988;d:0.51090000000000002;i:1547689687;d:0.47149999999999997;i:1547689391;d:0.50309999999999999;i:1547689152;d:0.47070000000000001;i:1547689105;d:0.52810000000000001;i:1547688489;d:0.45660000000000001;i:1547688204;d:0.48089999999999999;i:1547687880;d:0.50270000000000004;i:1547687578;d:0.61480000000000001;i:1547687332;d:0.47239999999999999;i:1547687261;d:0.81340000000000001;i:1547686693;d:0.50419999999999998;i:1547686389;d:0.51339999999999997;i:1547686163;d:0.53239999999999998;i:1547685806;d:0.7399;i:1547685489;d:0.50670000000000004;i:1547685264;d:0.48620000000000002;i:1547684906;d:1.6234999999999999;i:1547684590;d:0.4677;i:1547684281;d:0.45929999999999999;i:1547684097;d:4.1445999999999996;i:1547684067;d:1.8813;i:1547683098;d:0.47770000000000001;i:1547682795;d:0.46839999999999998;i:1547682489;d:0.47960000000000003;i:1547682186;d:0.4667;i:1547681893;d:0.51229999999999998;i:1547681708;d:3.7690999999999999;i:1547681274;d:0.495;i:1547680984;d:0.4763;i:1547680689;d:0.48920000000000002;i:1547680387;d:0.4985;i:1547680091;d:0.51449999999999996;i:1547679906;d:0.53090000000000004;i:1547679484;d:0.47810000000000002;i:1547679188;d:0.50660000000000005;i:1547678907;d:0.48509999999999998;i:1547678571;d:0.48949999999999999;i:1547678298;d:0.48959999999999998;i:1547678105;d:1.0361;i:1547677687;d:0.60270000000000001;i:1547677393;d:0.47360000000000002;i:1547677061;d:0.50880000000000003;i:1547676788;d:2.4500000000000002;i:1547676532;d:0.4713;i:1547676464;d:0.52259999999999995;i:1547675888;d:0.46629999999999999;i:1547675593;d:0.54630000000000001;i:1547675290;d:0.47189999999999999;i:1547674990;d:0.4738;i:1547674690;d:0.51649999999999996;i:1547674496;d:0.47320000000000001;i:1547674060;d:0.4955;i:1547673788;d:2.6974999999999998;i:1547673488;d:0.48259999999999997;i:1547673165;d:0.47110000000000002;i:1547672898;d:2.6713;i:1547672711;d:0.61709999999999998;i:1547672311;d:0.59889999999999999;i:1547671998;d:0.48199999999999998;i:1547671636;d:0.58999999999999997;i:1547671401;d:5.1257999999999999;i:1547671092;d:0.46200000000000002;i:1547670905;d:0.5343;i:1547670490;d:0.52239999999999998;i:1547670194;d:0.4829;i:1547669903;d:0.47399999999999998;i:1547669584;d:0.4864;i:1547669320;d:0.78420000000000001;i:1547669178;d:0.60219999999999996;i:1547668691;d:0.48499999999999999;i:1547668397;d:0.51500000000000001;i:1547668069;d:0.49049999999999999;i:1547667796;d:1.4896;i:1547667509;d:0.47610000000000002;i:1547667322;d:0.49009999999999998;i:1547666887;d:0.48299999999999998;i:1547666577;d:0.53790000000000004;i:1547666285;d:0.46989999999999998;i:1547665982;d:0.4854;i:1547665692;d:0.51629999999999998;i:1547665506;d:0.4929;i:1547665090;d:0.46239999999999998;i:1547664795;d:0.47560000000000002;i:1547664478;d:1.1696;i:1547664199;d:2.2566000000000002;i:1547663892;d:0.48060000000000003;i:1547663701;d:0.48459999999999998;i:1547663292;d:0.48609999999999998;i:1547662985;d:0.49830000000000002;i:1547662703;d:0.4506;i:1547662397;d:0.47770000000000001;i:1547662126;d:0.46060000000000001;i:1547661995;d:0.57499999999999996;i:1547661485;d:0.48930000000000001;i:1547661197;d:0.47349999999999998;i:1547660881;d:0.48139999999999999;i:1547660601;d:0.47160000000000002;i:1547660284;d:0.46820000000000001;i:1547660099;d:0.45219999999999999;i:1547659663;d:0.47739999999999999;i:1547659386;d:2.0865;i:1547659078;d:0.57469999999999999;i:1547658786;d:1.5152000000000001;i:1547658505;d:1.8311999999999999;i:1547658304;d:0.49080000000000001;i:1547657898;d:0.48209999999999997;i:1547657594;d:0.5232;i:1547657258;d:0.46920000000000001;i:1547656986;d:1.9703999999999999;i:1547656709;d:0.49270000000000003;i:1547656533;d:0.49149999999999999;i:1547656110;d:0.47949999999999998;i:1547655793;d:0.50890000000000002;i:1547655500;d:0.48699999999999999;i:1547655251;d:0.61550000000000005;i:1547655097;d:1.6795;i:1547654300;d:1.1225000000000001;i:1547653986;d:0.5484;i:1547653694;d:0.50729999999999997;i:1547653397;d:0.48110000000000003;i:1547653101;d:0.60309999999999997;i:1547652917;d:0.50739999999999996;i:1547652491;d:0.4834;i:1547652200;d:0.8871;i:1547651897;d:0.4718;i:1547651596;d:0.48010000000000003;i:1547651305;d:0.46439999999999998;i:1547651114;d:0.55530000000000002;i:1547650688;d:0.55069999999999997;i:1547650405;d:0.74150000000000005;i:1547650061;d:0.9446;i:1547649806;d:2.3555000000000001;i:1547649505;d:0.48859999999999998;i:1547649319;d:0.73429999999999995;i:1547648891;d:0.73899999999999999;i:1547648591;d:0.50209999999999999;i:1547648294;d:0.49120000000000003;i:1547647982;d:0.50739999999999996;i:1547647764;d:0.72030000000000005;i:1547647065;d:0.47720000000000001;i:1547646800;d:1.9738;i:1547646496;d:0.48709999999999998;i:1547646190;d:0.46310000000000001;i:1547645909;d:0.50380000000000003;i:1547645723;d:0.51229999999999998;i:1547645306;d:0.48259999999999997;i:1547644981;d:0.49780000000000002;i:1547644708;d:0.54239999999999999;i:1547644371;d:0.52010000000000001;i:1547644087;d:0.95330000000000004;i:1547643911;d:0.50700000000000001;i:1547643504;d:0.49049999999999999;i:1547643189;d:0.48780000000000001;i:1547642904;d:0.45889999999999997;i:1547642585;d:0.46039999999999998;i:1547642288;d:0.48499999999999999;i:1547642109;d:0.53110000000000002;i:1547641683;d:0.47639999999999999;i:1547641384;d:1.0446;i:1547641096;d:0.52610000000000001;i:1547640702;d:0.47020000000000001;i:1547640553;d:11.785500000000001;i:1547640538;d:2.2383000000000002;i:1547639900;d:0.56020000000000003;i:1547639593;d:0.503;i:1547639299;d:0.503;i:1547638991;d:0.4713;i:1547638688;d:0.49430000000000002;i:1547638507;d:0.56979999999999997;}s:17:\"discovery_history\";a:100:{i:1547726542;d:1.8571;i:1547724786;d:5.6779999999999999;i:1547717998;d:1.5356000000000001;i:1547716731;d:1.8197000000000001;i:1547716718;d:3.0108999999999999;i:1547681714;d:1.9261999999999999;i:1547638523;d:2.4910999999999999;i:1547595277;d:2.9460999999999999;i:1547552050;d:1.6869000000000001;i:1547508843;d:1.5679000000000001;i:1547465694;d:1.5562;i:1547422459;d:1.8247;i:1547379282;d:1.6434;i:1547336077;d:1.6432;i:1547292883;d:1.6903999999999999;i:1547249661;d:1.5845;i:1547206464;d:1.7410000000000001;i:1547163242;d:1.7822;i:1547120094;d:1.6015999999999999;i:1547076858;d:1.8637999999999999;i:1547033661;d:1.8226;i:1546990477;d:1.6713;i:1546947297;d:1.6882999999999999;i:1546904045;d:1.7612000000000001;i:1546860872;d:1.575;i:1546817701;d:1.712;i:1546774494;d:1.7262999999999999;i:1546731297;d:1.8229;i:1546688085;d:1.6673;i:1546644898;d:1.706;i:1546601666;d:1.796;i:1546558508;d:1.6308;i:1546515293;d:1.8476999999999999;i:1546472081;d:1.9773000000000001;i:1546428865;d:2.2406999999999999;i:1546385653;d:1.6385000000000001;i:1546342466;d:1.6166;i:1546299306;d:1.6697;i:1546256071;d:1.7726999999999999;i:1546212845;d:1.8172999999999999;i:1546169703;d:1.6900999999999999;i:1546126508;d:1.9441999999999999;i:1546083286;d:1.9943;i:1546040089;d:1.6738;i:1545996873;d:1.8584000000000001;i:1545953653;d:1.7326999999999999;i:1545910572;d:1.6841999999999999;i:1545867281;d:4.8512000000000004;i:1545824095;d:1.7643;i:1545780870;d:1.8486;i:1545737701;d:1.7529999999999999;i:1545694509;d:1.9089;i:1545651286;d:1.7375;i:1545608056;d:1.7052;i:1545564872;d:1.6409;i:1545521707;d:1.7039;i:1545478474;d:1.7891999999999999;i:1545435333;d:1.6681999999999999;i:1545392066;d:2.8993000000000002;i:1545348982;d:1.6936;i:1545305663;d:4.5568;i:1545262478;d:1.7058;i:1545219314;d:1.5931;i:1545176050;d:2.2850000000000001;i:1545132859;d:1.6327;i:1545089679;d:1.5888;i:1545046470;d:1.7427999999999999;i:1545003269;d:1.6612;i:1544960107;d:1.6404000000000001;i:1544916837;d:1.7887;i:1544873694;d:1.4349000000000001;i:1544830570;d:2.2703000000000002;i:1544787278;d:1.7486999999999999;i:1544744097;d:1.5553999999999999;i:1544700991;d:2.0714999999999999;i:1544657760;d:8.9773999999999994;i:1544614479;d:1.6008;i:1544592964;d:1.9733000000000001;i:1544571263;d:1.8262;i:1544549675;d:1.5477000000000001;i:1544528053;d:1.6975;i:1544506457;d:1.6063000000000001;i:1544484875;d:1.6798;i:1544463569;d:1.9028;i:1544441711;d:15.3949;i:1544420112;d:2.552;i:1544398506;d:2.1139999999999999;i:1544376898;d:1.681;i:1544355285;d:1.7784;i:1544333696;d:2.4659;i:1544312089;d:1.7561;i:1544290467;d:2.2504;i:1544268868;d:1.619;i:1544247262;d:1.6747000000000001;i:1544225699;d:1.6449;i:1544204165;d:1.5659000000000001;i:1544182473;d:3.3624999999999998;i:1544160878;d:1.8923000000000001;i:1544139278;d:1.6105;i:1544117682;d:1.6865000000000001;}}' WHERE `device_id` = '63'] SQL RUNTIME[0.00944304s] ##### quido-cra.mng.redacted.com [63] completed discovery modules at 2019-01-17 13:02:23 ##### o Discovery time 1.8571 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '29184' AND `process_name` = 'discovery.php' AND `device_id` = '63'] SQL RUNTIME[0.00991702s] SQL[SELECT * FROM `groups` ORDER BY `entity_type`] SQL RUNTIME[0.00079107s] SQL[SELECT * FROM `groups_assoc`] SQL RUNTIME[0.00034595s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`type` = 'network' AND IFNULL(`devices`.`hostname`, "") LIKE '%-c%')] SQL RUNTIME[0.00040793s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '1'] SQL RUNTIME[0.00028801s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`type` = 'network' AND IFNULL(`devices`.`hostname`, "") LIKE '%acc%')] SQL RUNTIME[0.00032401s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '2'] SQL RUNTIME[0.00025105s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`type` = 'network' AND IFNULL(`devices`.`hostname`, "") LIKE '%agr%')] SQL RUNTIME[0.00030804s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '3'] SQL RUNTIME[0.00026894s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`type` = 'network' AND IFNULL(`devices`.`hostname`, "") LIKE 'r%')] SQL RUNTIME[0.00031710s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '4'] SQL RUNTIME[0.00026584s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`type` = 'network' AND IFNULL(`devices`.`hostname`, "") LIKE '%test%')] SQL RUNTIME[0.00027299s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '40'] SQL RUNTIME[0.00022292s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`type` = 'server' AND IFNULL(`devices`.`hostname`, "") LIKE 'vhs%')] SQL RUNTIME[0.00030303s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '48'] SQL RUNTIME[0.00022006s] SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`type` = 'server' AND IFNULL(`devices`.`hostname`, "") LIKE '%ipmi%')] SQL RUNTIME[0.00026107s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '49'] SQL RUNTIME[0.00017619s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Qcz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00771093s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '8'] SQL RUNTIME[0.00036502s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Ecz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00540519s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '10'] SQL RUNTIME[0.00045395s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Tcz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00565910s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '11'] SQL RUNTIME[0.00033402s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hcz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00559020s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '12'] SQL RUNTIME[0.00105405s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hsk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00552702s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '13'] SQL RUNTIME[0.00044584s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Qsk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00530410s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '15'] SQL RUNTIME[0.00022101s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Esk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00538206s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '18'] SQL RUNTIME[0.00023103s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Ccz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00524306s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '19'] SQL RUNTIME[0.00054502s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Csk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00565696s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '20'] SQL RUNTIME[0.00028801s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hcz%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%{%/FE%}%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00553107s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '21'] SQL RUNTIME[0.00044107s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hcz%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%{%/MU%}%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00556684s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '22'] SQL RUNTIME[0.00025511s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hcz%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%{%/PC%}%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00535297s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '23'] SQL RUNTIME[0.00044680s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hsk%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%{%/MU%}%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00532603s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '24'] SQL RUNTIME[0.00035191s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hsk%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%{%/PC%}%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00511909s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '25'] SQL RUNTIME[0.00029492s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'propVirtual' AND IFNULL(`ports`.`ifDescr`, "") LIKE 'hannel%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Pcz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00437093s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '26'] SQL RUNTIME[0.00032496s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'propVirtual' AND IFNULL(`ports`.`ifDescr`, "") LIKE 'hannel%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Psk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00459099s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '27'] SQL RUNTIME[0.00030994s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Rcz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00580311s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '29'] SQL RUNTIME[0.00031090s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Rsk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00557709s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '30'] SQL RUNTIME[0.00035501s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Icz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00519085s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '31'] SQL RUNTIME[0.00027800s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Isk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00510907s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '32'] SQL RUNTIME[0.00024509s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Scz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00518799s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '33'] SQL RUNTIME[0.00053310s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Ssk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00519896s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '34'] SQL RUNTIME[0.00038600s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Lcz%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00518107s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '37'] SQL RUNTIME[0.00032520s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Lsk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00548697s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '38'] SQL RUNTIME[0.00020909s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hcz%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%[10G]%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00517011s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '41'] SQL RUNTIME[0.00065398s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hcz%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%[100G]%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00515914s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '42'] SQL RUNTIME[0.00032091s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hcz%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%[1G]%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00530815s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '44'] SQL RUNTIME[0.00043321s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hsk%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%[100G]%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00534916s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '45'] SQL RUNTIME[0.00025988s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hsk%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%[10G]%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00503898s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '46'] SQL RUNTIME[0.00038600s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Hsk%' AND IFNULL(`ports`.`ifAlias`, "") LIKE '%[1G]%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00521684s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '47'] SQL RUNTIME[0.00036001s] SQL[SELECT `port_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`type` = 'network' AND `ports`.`ifType` = 'ethernetCsmacd' AND IFNULL(`ports`.`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ports`.`ifAlias`, "") LIKE 'Tsk%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00540519s] SQL[SELECT * FROM `group_table` WHERE `group_id` = '50'] SQL RUNTIME[0.00035810s] SQL[SELECT * FROM `alert_tests` WHERE 1] SQL RUNTIME[0.00030613s] Cached 21 alert rules. SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[0.00024509s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `ifType` = 'ethernetCsmacd' AND IFNULL(`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ifAlias`, "") LIKE 'S%'))) AND `deleted` != '1'] SQL RUNTIME[0.00445700s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '2'] SQL RUNTIME[0.00108504s] SQL[SELECT `storage_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `storage` LEFT JOIN `devices` ON (`storage`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'server') AND ( 1))) AND `storage_deleted` != '1'] SQL RUNTIME[0.00084305s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '3'] SQL RUNTIME[0.00066185s] SQL[SELECT `bgpPeer_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1)))] SQL RUNTIME[0.00125813s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '4'] SQL RUNTIME[0.00544500s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `ifType` = 'ethernetCsmacd' AND IFNULL(`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ifAlias`, "") LIKE 'H%'))) AND `deleted` != '1'] SQL RUNTIME[0.00621319s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '5'] SQL RUNTIME[0.00185204s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `ifType` = 'ethernetCsmacd' AND IFNULL(`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ifAlias`, "") LIKE 'T%'))) AND `deleted` != '1'] SQL RUNTIME[0.00478292s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '6'] SQL RUNTIME[0.00052619s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `ifType` = 'ethernetCsmacd' AND IFNULL(`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ifAlias`, "") LIKE 'C%'))) AND `deleted` != '1'] SQL RUNTIME[0.00464296s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '7'] SQL RUNTIME[0.00081396s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `ifType` = 'ethernetCsmacd' AND IFNULL(`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ifAlias`, "") LIKE 'H%')) OR (( 1) AND ( 1))) AND `deleted` != '1'] SQL RUNTIME[0.00773501s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '8'] SQL RUNTIME[0.01048803s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `ifType` = 'ethernetCsmacd' AND IFNULL(`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ifAlias`, "") LIKE 'H%'))) AND `deleted` != '1'] SQL RUNTIME[0.00684404s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '9'] SQL RUNTIME[0.00183201s] SQL[SELECT `processor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1)))] SQL RUNTIME[0.00107288s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '10'] SQL RUNTIME[0.00287414s] SQL[SELECT `mempool_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1))) AND `mempool_deleted` != '1'] SQL RUNTIME[0.00087500s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '11'] SQL RUNTIME[0.00073504s] SQL[SELECT `device_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `devices` WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1)))] SQL RUNTIME[0.00044084s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '12'] SQL RUNTIME[0.00071502s] SQL[SELECT `sensor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `sensor_class` = 'fanspeed'))) AND `sensor_deleted` != '1'] SQL RUNTIME[0.00095391s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '13'] SQL RUNTIME[0.00084996s] SQL[SELECT `sensor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND IFNULL(`sensor_descr`, "") LIKE '%Transceiver%' AND `sensor_class` = 'temperature'))) AND `sensor_deleted` != '1'] SQL RUNTIME[0.02188587s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '14'] SQL RUNTIME[0.00338387s] SQL[SELECT `sensor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND IFNULL(`sensor_descr`, "") LIKE 'odule%' AND `sensor_class` = 'temperature'))) AND `sensor_deleted` != '1'] SQL RUNTIME[0.02205610s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '15'] SQL RUNTIME[0.00489211s] SQL[SELECT `sensor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND IFNULL(`sensor_descr`, "") LIKE '%xbar%' AND `sensor_class` = 'temperature'))) AND `sensor_deleted` != '1'] SQL RUNTIME[0.01943016s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '16'] SQL RUNTIME[0.00097799s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND IFNULL(`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ifAlias`, "") LIKE 'h%'))) AND `deleted` != '1'] SQL RUNTIME[0.00968289s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '17'] SQL RUNTIME[0.00036907s] SQL[SELECT `port_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND `ifType` = 'ethernetCsmacd' AND IFNULL(`ifDescr`, "") LIKE '%Ether%' AND IFNULL(`ifAlias`, "") LIKE 'Q%'))) AND `deleted` != '1'] SQL RUNTIME[0.00438499s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '18'] SQL RUNTIME[0.00042295s] SQL[SELECT `sensor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND IFNULL(`sensor_descr`, "") LIKE '%Transceiver%' AND `sensor_class` = 'dbm'))) AND `sensor_deleted` != '1'] SQL RUNTIME[0.01421905s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '19'] SQL RUNTIME[0.00626612s] SQL[SELECT `sensor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND IFNULL(`sensor_descr`, "") LIKE '%Transceiver%' AND `sensor_class` = 'voltage'))) AND `sensor_deleted` != '1'] SQL RUNTIME[0.01385188s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '20'] SQL RUNTIME[0.00344777s] SQL[SELECT `sensor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1 AND `devices`.`type` = 'network') AND ( 1 AND IFNULL(`sensor_descr`, "") LIKE '%Transceiver%' AND `sensor_class` = 'power'))) AND `sensor_deleted` != '1'] SQL RUNTIME[0.00042915s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '21'] SQL RUNTIME[0.00026512s] SQL[SELECT `sensor_id` AS `entity_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE `devices`.`ignore` = '0' AND `devices`.`disabled` = '0' AND ( (( 1) AND ( 1 AND `sensor_class` = 'power' AND IFNULL(`sensor_descr`, "") LIKE '%supply%'))) AND `sensor_deleted` != '1'] SQL RUNTIME[0.00033188s] SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '22'] SQL RUNTIME[0.00023794s] ##### Finished discovery run at 2019-01-17 13:02:24 ##### ./discovery.php: quido-cra.mng.redacted.com - 1 devices discovered in 2.750 secs SQL[SELECT * FROM `observium_processes` WHERE `process_start` < '1547712141'] SQL RUNTIME[0.00028992s] NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output. o Devices Discovered 1 o Discovery Time 2.750 secs o Memory usage 10.75MB (peak: 20.5MB) o MySQL Usage Cell[6/0.004s] Row[7/0.005s] Rows[187/0.513s] Column[0/0s] Update[3/0.013s] Insert[3/0.01s] Delete[2/0.011s] o RRDTool Usage