DEBUG! CMD[/usr/bin/svn info /opt/observium]  CMD EXITCODE[0] CMD RUNTIME[0.0092s] CMD EXITDELAY[5ms] STDOUT[ Path: . Working Copy Root Path: /opt/observium URL: https://svn.observium.org/svn/observium/branches/stable Relative URL: ^/observium/branches/stable Repository Root: https://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 14103 Node Kind: directory Schedule: normal Last Changed Author: adama Last Changed Rev: 14097 Last Changed Date: 2025-06-27 11:35:04 +0200 (Fri, 27 Jun 2025) ]  CMD[/usr/bin/svn auth svn.observium.org | awk '/Username:/ {print $2}']  CMD EXITCODE[0] CMD RUNTIME[0.0075s] STDOUT[ bankdelen-6160660 ] DEFINITIONS Time : 0.129769 ms DEFINITIONS Memory: 4.02MB SQL[SELECT * FROM `observium_attribs`] SQL RUNTIME[0.00016117s]  SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00011921s]  SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'] SQL RUNTIME[0.00010586s] DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[9.394E-5s] DB timezone different from php timezone. Syncing.. SQL[SELECT VERSION();] SQL RUNTIME[5.412E-5s]  SQL[SET SESSION time_zone='+00:00';] SQL RUNTIME[0.000139s]  SQL[SELECT * FROM `config`] SQL RUNTIME[6.819E-5s]  CMD[/sbin/fping -v 2>&1]  CMD EXITCODE[0] CMD RUNTIME[0.0025s] STDOUT[ /sbin/fping: Version 5.0 ]  SQL[SELECT EXISTS (SELECT 1 FROM `pollers`)] SQL RUNTIME[7.391E-5s]  ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 25.6.14097 https://www.observium.org   CMD[/opt/observium/scripts/distro]  CMD EXITCODE[0] CMD RUNTIME[0.0233s] STDOUT[ Linux|5.14.0-570.23.1.el9_6.x86_64|amd64|Red Hat Enterprise|9.6|kvm| ]  CMD[/usr/bin/env python --version 2>&1]  CMD EXITCODE[0] CMD RUNTIME[0.0035s] STDOUT[ Python 3.9.21 ]  SQL[SELECT VERSION();] SQL RUNTIME[0.000144s]  CMD[/usr/bin/snmpget --version 2>&1]  CMD EXITCODE[0] CMD RUNTIME[0.0027s] STDOUT[ NET-SNMP version: 5.9.1 ]  CMD[/usr/bin/rrdtool --version | head -n1]  CMD EXITCODE[0] CMD RUNTIME[0.0078s] STDOUT[ RRDtool 1.7.2 Copyright by Tobias Oetiker ]  CMD[/sbin/fping -v 2>&1]  CMD EXITCODE[0] CMD RUNTIME[0.002s] STDOUT[ /sbin/fping: Version 5.0 ]  CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']  CMD EXITCODE[0] CMD RUNTIME[0.0035s] STDOUT[ ]  CMD[/usr/sbin/httpd -v | awk '/Server version:/ {print $3}']  CMD EXITCODE[0] CMD RUNTIME[0.0318s] STDOUT[ Apache/2.4.62 ]  SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00021791s]  SQL[SHOW VARIABLES LIKE 'log_bin'] SQL RUNTIME[0.00041986s]  SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00028896s]  ##### Observium #####   o Version  25.6.14097  o Train  stable  o Released  27th June 2025  o Subscription User  bankdelen-6160660 ##### Software versions #####   o OS  Linux 5.14.0-570.23.1.el9_6.x86_64 [amd64] (Red Hat Enterprise 9.6)  o VM  KVM Virtual Machine  o Apache  2.4.62  o PHP  8.0.30 (OPcache: ENABLED)  o Python  3.9.21  o MariaDB  10.5.27-MariaDB-log (extension: mysqli 8.0.30)  o SNMP  NET-SNMP 5.9.1  o RRDtool  1.7.2  o Fping  5.0 (IPv4 and IPv6)  o Fetch  cURL 7.76.1 (OpenSSL/3.2.2, LibZ 1.2.11, LibIDN 2.3.0) ##### PHP info #####   o Memory Limit  512MB  o Math  NATIVE ##### DB info #####   o DB schema  497  o MariaDB binlog  OFF  o MariaDB mode  NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ##### Charset info #####   o PHP  UTF-8  o MariaDB  utf8 ##### Timezones info #####   o Date  Wednesday, 20-Aug-25 12:19:26 UTC  o PHP  +00:00  o MariaDB  +02:00 There is a newer revision of Observium available! Version 25.8.14180 (20th August 2025) is 83 revisions ahead.  ##### Starting discovery run at 2025-08-20 12:19:26 #####   SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = '559' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00027609s] Return cached 'ups-a-be-wav-01.winnet.local' = '' Found device [559] model 'powertek' exact association for .1.3.6.1.4.1.42610.1.4.4 CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' .1.3.6.1.2.1.1.2.0 .1.3.6.1.2.1.1.3.0]  CMD EXITCODE[0] CMD RUNTIME[0.0248s] STDOUT[ .1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.42610.1.4.4 .1.3.6.1.2.1.1.3.0 = 36:3:09:50.72 ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559'] SQL RUNTIME[9.513E-5s]  SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '559' AND `poller_id` = '0'] SQL RUNTIME[0.00031114s]  SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('550910','discovery.php','533227','0','php ./discovery.php -d -h 559','1755692365','559')] SQL RUNTIME[0.0007689s] ##### ups-a-be-wav-01.winnet.local [559] #####   o OS Type  powertek-pdu  o OS Group  pdu  o SNMP Version  v1  o Last discovery  2025-08-20 12:17:07  o Last duration  2.12 seconds ##### Module Start: os #####   CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' sysDescr.0]  CMD EXITCODE[0] CMD RUNTIME[0.0236s] STDOUT[ NetVision-8 ] SNMP STATUS[TRUE] Store in cache OID: SNMPv2-MIB::sysDescr.0 CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' sysObjectID.0]  CMD EXITCODE[0] CMD RUNTIME[0.0217s] STDOUT[ .1.3.6.1.4.1.42610.1.4.4 ] SNMP STATUS[TRUE] +-------------+--------------------------+ | OID | | +-------------+--------------------------+ | sysDescr | NetVision-8 | | sysObjectID | .1.3.6.1.4.1.42610.1.4.4 | +-------------+--------------------------+  o Detect OS matched (powertek-pdu: Powertek PDU):  +-------------+------------------------+--------------------------+ | OID | Matched definition | | +-------------+------------------------+--------------------------+ | sysObjectID | .1.3.6.1.4.1.42610.1.4 | .1.3.6.1.4.1.42610.1.4.4 | +-------------+------------------------+--------------------------+  o Duration  0.0714s ##### Module Start: mibs #####   CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'SNMPv2-MIB::sysORID']  CMD EXITCODE[0] CMD RUNTIME[0.0158s] 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' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' .1.3.6.1.2.1.1.9.1.2]  CMD EXITCODE[0] CMD RUNTIME[0.0575s] STDOUT[ .1.3.6.1.2.1.1.9.1.2.1 = .1.3.6.1.6.3.1 .1.3.6.1.2.1.1.9.1.2.2 = .1.3.6.1.6.3.16.2.2.1 .1.3.6.1.2.1.1.9.1.2.3 = .1.3.6.1.6.3.11.3.1.1 .1.3.6.1.2.1.1.9.1.2.4 = .1.3.6.1.6.3.15.2.1.1 .1.3.6.1.2.1.1.9.1.2.5 = .1.3.6.1.6.3.10.3.1.1 ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' sysORDescr]  CMD EXITCODE[0] CMD RUNTIME[0.0602s] STDOUT[ sysORDescr.1 = The MIB module for SNMPv2 entities sysORDescr.2 = View-based Access Control Model for SNMP. sysORDescr.3 = The MIB for Message Processing and Dispatching. sysORDescr.4 = The management information definitions for the SNMP User-based Security Model. sysORDescr.5 = The SNMP Management Architecture MIB. ] SNMP STATUS[TRUE]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m OSPFV3-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ospfv3AdminStatus.0]  CMD EXITCODE[2] CMD RUNTIME[0.0263s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: OSPFV3-MIB::ospfv3AdminStatus.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response] Store in cache OID: OSPFV3-MIB::ospfv3AdminStatus.0  o MIBs discovered   SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00025296s]  +--------------------------+--------------------+---------+---------------------+ | Identity | MIB | Source | Status | +--------------------------+--------------------+---------+---------------------+ | .1.3.6.1.6.3.1 | SNMPv2-MIB | sysORID | MIB already defined | | .1.3.6.1.6.3.10.3.1.1 | SNMP-FRAMEWORK-MIB | sysORID | MIB already defined | | .1.3.6.1.4.1.42610.1.4.4 | PWTv1-MIB | Model | MIB already defined | | .1.3.6.1.4.1.42610.1.4.1 | SPS2v1-MIB | Model | MIB already defined | | .1.3.6.1.6.3.16.2.2.1 | - | sysORID | Unknown Identity | | .1.3.6.1.6.3.11.3.1.1 | - | sysORID | Unknown Identity | | .1.3.6.1.6.3.15.2.1.1 | - | sysORID | Unknown Identity | +--------------------------+--------------------+---------+---------------------+ SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'sysORID'] SQL RUNTIME[0.00024915s] JSON DECODE[Not string passed] JSON RAW[ ] SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '559' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[5.794E-5s] Array ( [0] => PWTv1-MIB [1] => SPS2v1-MIB [2] => SNMPv2-MIB [3] => SNMP-FRAMEWORK-MIB [4] => IF-MIB [5] => ADSL-LINE-MIB [6] => EtherLike-MIB [7] => ENTITY-MIB [8] => ENTITY-SENSOR-MIB [9] => UCD-SNMP-MIB [10] => Q-BRIDGE-MIB [11] => IP-MIB [12] => IPV6-MIB [13] => LLDP-MIB [14] => CISCO-CDP-MIB [15] => DISMAN-PING-MIB )  o Duration  0.1705s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_vrf'] SQL RUNTIME[0.00019097s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_ports'] SQL RUNTIME[0.00010395s] ##### Module Start: ports #####   o Caching OIDs  ifDescr SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ifDescr]  CMD EXITCODE[0] CMD RUNTIME[0.0325s] STDOUT[ ] SNMP STATUS[TRUE] ifAlias SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ifAlias]  CMD EXITCODE[0] CMD RUNTIME[0.0362s] STDOUT[ ] SNMP STATUS[TRUE] ifName SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ifName]  CMD EXITCODE[0] CMD RUNTIME[0.0373s] STDOUT[ ] SNMP STATUS[TRUE] ifType SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ifType]  CMD EXITCODE[0] CMD RUNTIME[0.0283s] STDOUT[ ] SNMP STATUS[TRUE] ifOperStatus SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ifOperStatus]  CMD EXITCODE[0] CMD RUNTIME[0.0318s] STDOUT[ ] SNMP STATUS[TRUE]   o Caching DB   SQL[SELECT * FROM `ports` WHERE `device_id` = '559'] SQL RUNTIME[0.00042701s] 0 ports  o Discovering ports    o Duration  0.1746s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_ports-stack'] SQL RUNTIME[0.00018382s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_vlans'] SQL RUNTIME[0.0001049s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_oids'] SQL RUNTIME[9.012E-5s] ##### Module Start: oids #####   SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '559'] SQL RUNTIME[0.00016212s]  SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1'] SQL RUNTIME[5.102E-5s]   o Duration  0.0011s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_ip-addresses'] SQL RUNTIME[9.704E-5s] ##### Module Start: ip-addresses #####   SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'sysORID'] SQL RUNTIME[4.697E-5s] JSON DECODE[Not string passed] JSON RAW[ ]  o IP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ipAdEntIfIndex]  CMD EXITCODE[0] CMD RUNTIME[0.036s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ipAdEntNetMask]  CMD EXITCODE[0] CMD RUNTIME[0.0336s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ipAddressIfIndex]  CMD EXITCODE[0] CMD RUNTIME[0.0318s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ipAddressType]  CMD EXITCODE[0] CMD RUNTIME[0.0322s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ipAddressPrefix]  CMD EXITCODE[0] CMD RUNTIME[0.0314s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ipAddressOrigin]  CMD EXITCODE[0] CMD RUNTIME[0.0314s] STDOUT[ ] SNMP STATUS[TRUE]   o IPV6-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUsb -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ipv6AddrEntry]  CMD EXITCODE[0] CMD RUNTIME[0.029s] STDOUT[ ] SNMP STATUS[TRUE]   o LLDP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUsb -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' lldpLocManAddrTable]  CMD EXITCODE[0] CMD RUNTIME[0.0343s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '559'] SQL RUNTIME[0.00047708s]  SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '559'] SQL RUNTIME[0.00015187s]   o Duration  0.276s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_processors'] SQL RUNTIME[0.00013685s] ##### Module Start: processors #####   o UCD-SNMP-MIB   SQL[SELECT EXISTS (SELECT 1 FROM `processors` WHERE `device_id` = '559' AND `processor_type` NOT IN ('ucd-old', 'ucd-raw'))] SQL RUNTIME[0.00016618s]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ssCpuIdle.0 ssCpuSystem.0 ssCpuUser.0 ssCpuRawIdle.0 ssCpuRawSystem.0]  CMD EXITCODE[2] CMD RUNTIME[0.0484s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: ssCpuRawSystem.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: ssCpuRawIdle.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: ssCpuUser.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: ssCpuSystem.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: ssCpuIdle.0 ] SNMP ERROR[#1000 - Failed response] SNMP ERROR[#1000 - Failed response] SNMP STATUS[FALSE]  SQL[SELECT * FROM `processors` WHERE `device_id` = '559'] SQL RUNTIME[0.00044298s]   o Duration  0.052s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_mempools'] SQL RUNTIME[0.00018191s] ##### Module Start: mempools #####   o UCD-SNMP-MIB   CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' memTotalReal.0 memAvailReal.0 memBuffer.0 memCached.0]  CMD EXITCODE[2] CMD RUNTIME[0.0427s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: memCached.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: memAvailReal.0 Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: memTotalReal.0 ] SNMP ERROR[#1000 - Failed response] SNMP ERROR[#1000 - Failed response] SNMP STATUS[FALSE]  SQL[SELECT * FROM `mempools` WHERE `device_id` = '559'] SQL RUNTIME[0.00043011s]   o Duration  0.0458s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_inventory'] SQL RUNTIME[0.00015497s] ##### Module Start: inventory #####   SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'sysORID'] SQL RUNTIME[4.101E-5s] JSON DECODE[Not string passed] JSON RAW[ ]  o ENTITY-MIB  ENTITY-MIB SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhysicalEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0724s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' entAliasMappingIdentifier]  CMD EXITCODE[0] CMD RUNTIME[0.0298s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '559'] SQL RUNTIME[0.00038099s]   o Duration  0.1068s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_printersupplies'] SQL RUNTIME[0.0001781s] ##### Module Start: printersupplies #####   SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '559'] SQL RUNTIME[0.00012589s]   o Duration  0.0008s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_sensors'] SQL RUNTIME[0.00022292s] ##### Module Start: sensors #####   o PWTv1-MIB   CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m PWTv1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduPwrMonitoringInletNum.0]  CMD EXITCODE[2] CMD RUNTIME[0.0236s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: PWTv1-MIB::pduPwrMonitoringInletNum.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m PWTv1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduPwrMonitoringOutletNumPduA.0]  CMD EXITCODE[2] CMD RUNTIME[0.0268s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: PWTv1-MIB::pduPwrMonitoringOutletNumPduA.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m PWTv1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduPwrMonitoringOutletNumPduB.0]  CMD EXITCODE[2] CMD RUNTIME[0.0261s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: PWTv1-MIB::pduPwrMonitoringOutletNumPduB.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m PWTv1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduPwrMonitoringOutletNumPduC.0]  CMD EXITCODE[2] CMD RUNTIME[0.0281s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: PWTv1-MIB::pduPwrMonitoringOutletNumPduC.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m PWTv1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduPwrMonitoringOutletNumPduD.0]  CMD EXITCODE[2] CMD RUNTIME[0.0247s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: PWTv1-MIB::pduPwrMonitoringOutletNumPduD.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m PWTv1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduPwrMonitoringOutletNumPduE.0]  CMD EXITCODE[2] CMD RUNTIME[0.0224s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: PWTv1-MIB::pduPwrMonitoringOutletNumPduE.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m PWTv1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduPwrMonitoringOutletNumPduF.0]  CMD EXITCODE[2] CMD RUNTIME[0.0256s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: PWTv1-MIB::pduPwrMonitoringOutletNumPduF.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m PWTv1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduPwrMonitoringOutletNumPduG.0]  CMD EXITCODE[2] CMD RUNTIME[0.0211s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: PWTv1-MIB::pduPwrMonitoringOutletNumPduG.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m PWTv1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduPwrMonitoringOutletNumPduH.0]  CMD EXITCODE[2] CMD RUNTIME[0.0242s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: PWTv1-MIB::pduPwrMonitoringOutletNumPduH.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]   o SPS2v1-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m SPS2v1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduDevMonInletTable]  CMD EXITCODE[0] CMD RUNTIME[0.0304s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m SPS2v1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduDevMgmtInletTable]  CMD EXITCODE[0] CMD RUNTIME[0.0328s] STDOUT[ ] SNMP STATUS[TRUE]  CMD[/usr/bin/snmpget -v1 -c *** -Pud -Ir -OQUv -m SPS2v1-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/powertek 'udp':'ups-a-be-wav-01.winnet.local':'161' pduDevMonOutletMasterPortSize.0]  CMD EXITCODE[2] CMD RUNTIME[0.0282s] STDOUT[ ] STDERR[ Error in packet Reason: (noSuchName) There is no such variable name in this MIB. Failed object: SPS2v1-MIB::pduDevMonOutletMasterPortSize.0 ] SNMP STATUS[FALSE] SNMP ERROR[#1000 - Failed response]   o ENTITY-SENSOR-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhySensorValue]  CMD EXITCODE[0] CMD RUNTIME[0.0278s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhySensorType]  CMD EXITCODE[0] CMD RUNTIME[0.0292s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhySensorScale]  CMD EXITCODE[0] CMD RUNTIME[0.0282s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhySensorPrecision]  CMD EXITCODE[0] CMD RUNTIME[0.0318s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhySensorOperStatus]  CMD EXITCODE[0] CMD RUNTIME[0.0283s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhySensorUnitsDisplay]  CMD EXITCODE[0] CMD RUNTIME[0.0331s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhysicalDescr]  CMD EXITCODE[0] CMD RUNTIME[0.0753s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhysicalName]  CMD EXITCODE[0] CMD RUNTIME[0.0728s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhysicalClass]  CMD EXITCODE[0] CMD RUNTIME[0.0803s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhysicalContainedIn]  CMD EXITCODE[0] CMD RUNTIME[0.0864s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'ups-a-be-wav-01.winnet.local':'161' entPhysicalParentRelPos]  CMD EXITCODE[0] CMD RUNTIME[0.0899s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' entAliasMappingIdentifier]  CMD EXITCODE[0] CMD RUNTIME[0.0329s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00037098s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016308s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011802s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[9.918E-5s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[8.488E-5s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011301s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[8.297E-5s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[7.892E-5s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00010896s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011301s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00010705s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00010085s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011706s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011182s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.000108s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00010395s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'attenuation' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00014615s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00013709s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011492s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[9.298E-5s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'concentration' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00013709s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00017905s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00012803s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011802s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.0001111s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.0001049s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00010109s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'distance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00012898s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00013208s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00012088s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.0001061s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'age' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016212s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '559' AND `sensor_class` = 'gauge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00019503s]  SQL[SELECT * FROM `status` WHERE `device_id` = '559' AND `poller_type` = 'snmp' AND `status_deleted` = '0'] SQL RUNTIME[0.00014997s]  SQL[SELECT * FROM `counters` WHERE `device_id` = '559' AND `poller_type` = 'snmp' AND `counter_deleted` = '0'] SQL RUNTIME[0.00020909s]   o Duration  0.9792s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_storage'] SQL RUNTIME[0.00014687s] ##### Module Start: storage #####   o UCD-SNMP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' dskEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0279s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `storage` WHERE `device_id` = '559'] SQL RUNTIME[0.0003829s]   o Duration  0.0305s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_neighbours'] SQL RUNTIME[0.00016713s] ##### Module Start: neighbours #####   SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'sysORID'] SQL RUNTIME[3.815E-5s] JSON DECODE[Not string passed] JSON RAW[ ]  o LLDP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' lldpRemChassisIdSubtype]  CMD EXITCODE[0] CMD RUNTIME[0.0374s] STDOUT[ ] SNMP STATUS[TRUE]   o CISCO-CDP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Irh -OQUs -m CISCO-CDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'ups-a-be-wav-01.winnet.local':'161' cdpCache]  CMD EXITCODE[0] CMD RUNTIME[0.0546s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `neighbours` WHERE `device_id` = '559'] SQL RUNTIME[0.00020003s]   o Duration  0.0985s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_arp-table'] SQL RUNTIME[0.00012708s] ##### Module Start: arp-table #####   SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'sysORID'] SQL RUNTIME[3.29E-5s] JSON DECODE[Not string passed] JSON RAW[ ]  o IP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUsX -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ipNetToPhysicalPhysAddress]  CMD EXITCODE[0] CMD RUNTIME[0.0308s] STDOUT[ ] SNMP STATUS[TRUE] Used IP-MIB::ipNetToPhysicalPhysAddress  o IPV6-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUsX -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' ipv6NetToMediaPhysAddress]  CMD EXITCODE[0] CMD RUNTIME[0.0288s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `ip_mac` WHERE `device_id` = '559'] SQL RUNTIME[0.00018501s]   o Duration  0.0643s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_junose-atm-vp'] SQL RUNTIME[0.00015116s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_bgp-peers'] SQL RUNTIME[0.00013018s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_mac-accounting'] SQL RUNTIME[8.988E-5s] ##### Module Start: mac-accounting #####    o Duration  0.0003s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_sla'] SQL RUNTIME[7.892E-5s] ##### Module Start: sla #####   o DISMAN-PING-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m DISMAN-PING-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' pingCtlEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0276s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `slas` WHERE `device_id` = '559'] SQL RUNTIME[0.00026202s]   o Duration  0.0301s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_lsp'] SQL RUNTIME[0.00013208s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_pseudowires'] SQL RUNTIME[8.392E-5s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_virtual-machines'] SQL RUNTIME[6.986E-5s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_cisco-cbqos'] SQL RUNTIME[6.7E-5s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_ucd-diskio'] SQL RUNTIME[8.702E-5s] ##### Module Start: ucd-diskio #####  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -v1 -c *** -Pud -Ir -OQUs -m UCD-DISKIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-wav-01.winnet.local':'161' diskIOEntry]  CMD EXITCODE[0] CMD RUNTIME[0.026s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '559'] SQL RUNTIME[0.00010419s]   o Duration  0.0287s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_wifi'] SQL RUNTIME[0.00038815s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_p2p-radios'] SQL RUNTIME[0.00011611s]  SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_graphs'] SQL RUNTIME[8.416E-5s] ##### Module Start: graphs #####    o Duration  0.0003s SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '559' AND `attrib_type` = 'discover_raid'] SQL RUNTIME[0.00010204s]  o Modules Disabled  vrf, ports-stack, vlans, junose-atm-vp, bgp-peers, lsp, pseudowires, virtual-machines, cisco-cbqos, wifi, p2p-radios, raid  o Modules Enabled  os, mibs, ports, oids, ip-addresses, processors, mempools, inventory, printersupplies, sensors, storage, neighbours, arp-table,mac-accounting, sla, ucd-diskio, graphs SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '559';] SQL RUNTIME[0.00011396s]  SQL[UPDATE `devices` SET `last_discovered` =NOW(),`type` ='power',`last_discovered_timetaken` ='2.1463',`force_discovery` ='0',`device_state` ='a:5:{s:15:\"poller_mod_perf\";a:22:{s:6:\"system\";d:0.1139;s:2:\"os\";d:0.1347;s:7:\"sensors\";d:0.0008;s:6:\"status\";d:0.0004;s:7:\"counter\";d:0.0005;s:10:\"processors\";d:0.0007;s:8:\"mempools\";d:0.0007;s:7:\"storage\";d:0.0009;s:7:\"ucd-mib\";d:0.1148;s:13:\"ipSystemStats\";d:0.0368;s:5:\"ports\";d:0.2746;s:15:\"printersupplies\";d:0.0007;s:10:\"ucd-diskio\";d:0.0005;s:4:\"ospf\";d:0.0001;s:3:\"sla\";d:0.0007;s:14:\"mac-accounting\";d:0.0009;s:12:\"loadbalancer\";d:0.0002;s:15:\"entity-physical\";d:0.0003;s:9:\"fdb-table\";d:0.0639;s:6:\"graphs\";d:0.0004;s:4:\"oids\";d:0.0008;s:6:\"probes\";d:0.0008;}s:17:\"poller_ports_perf\";a:4:{s:6:\"IF-MIB\";d:0.07247114181518555;s:13:\"EtherLike-MIB\";d:0.0312650203704834;s:12:\"Q-BRIDGE-MIB\";d:0.10426998138427734;s:6:\"IP-MIB\";d:0.06186509132385254;}s:14:\"poller_history\";a:288:{i:1755692334;d:0.884;i:1755692044;d:0.7824;i:1755691732;d:1.7685;i:1755691470;d:0.7462;i:1755691111;d:0.7867;i:1755690811;d:0.8597;i:1755690484;d:0.7667;i:1755690198;d:0.8056;i:1755689895;d:0.7873;i:1755689592;d:0.9165;i:1755689305;d:0.8231;i:1755689008;d:0.8895;i:1755688711;d:0.7838;i:1755688416;d:0.802;i:1755688107;d:0.7782;i:1755687806;d:0.8691;i:1755687504;d:0.8358;i:1755687209;d:0.9231;i:1755686898;d:0.8021;i:1755686602;d:0.8359;i:1755686312;d:0.815;i:1755686016;d:0.8528;i:1755685711;d:0.8087;i:1755685455;d:0.8582;i:1755685156;d:0.7694;i:1755684853;d:0.8494;i:1755684506;d:0.8463;i:1755684209;d:0.7968;i:1755683946;d:0.907;i:1755683665;d:0.8959;i:1755683359;d:0.8438;i:1755683002;d:1.1755;i:1755682719;d:0.8547;i:1755682425;d:0.8352;i:1755682125;d:0.8548;i:1755681820;d:0.8754;i:1755681520;d:0.8175;i:1755681213;d:0.8209;i:1755680929;d:0.8628;i:1755680649;d:0.8143;i:1755680361;d:0.831;i:1755680014;d:0.8054;i:1755679723;d:0.8021;i:1755679445;d:0.7857;i:1755679132;d:0.7711;i:1755678836;d:0.7794;i:1755678535;d:0.772;i:1755678255;d:0.8261;i:1755677939;d:0.7836;i:1755677615;d:0.75;i:1755677336;d:0.7706;i:1755677017;d:0.7788;i:1755676705;d:0.815;i:1755676396;d:0.7803;i:1755676117;d:0.7532;i:1755675837;d:0.8356;i:1755675496;d:0.7838;i:1755675203;d:0.7448;i:1755674908;d:0.9011;i:1755674606;d:0.796;i:1755674299;d:0.7783;i:1755674007;d:0.7892;i:1755673716;d:0.8001;i:1755673424;d:0.7868;i:1755673112;d:0.9723;i:1755672801;d:0.7786;i:1755672539;d:0.8119;i:1755672238;d:0.7813;i:1755671925;d:0.8148;i:1755671599;d:0.816;i:1755671287;d:0.8067;i:1755671020;d:0.7869;i:1755670710;d:0.7456;i:1755670401;d:0.8141;i:1755670106;d:0.7546;i:1755669806;d:0.7733;i:1755669492;d:0.7567;i:1755669209;d:0.7522;i:1755668905;d:0.9103;i:1755668594;d:0.8156;i:1755668281;d:0.7652;i:1755667978;d:0.8221;i:1755667668;d:0.7569;i:1755667402;d:0.8047;i:1755667105;d:0.8304;i:1755666803;d:0.8309;i:1755666493;d:0.873;i:1755666211;d:0.7575;i:1755665880;d:0.7615;i:1755665589;d:0.8396;i:1755665309;d:0.7911;i:1755665061;d:0.8656;i:1755664802;d:1.4293;i:1755664585;d:1.1086;i:1755664151;d:0.796;i:1755663833;d:0.7778;i:1755663552;d:0.7827;i:1755663234;d:0.822;i:1755662892;d:0.7959;i:1755662585;d:0.7767;i:1755662307;d:0.7854;i:1755662054;d:0.7322;i:1755661748;d:0.8868;i:1755661403;d:0.8463;i:1755661086;d:0.7752;i:1755660777;d:0.7559;i:1755660472;d:0.7594;i:1755660199;d:0.7881;i:1755659884;d:0.7487;i:1755659579;d:0.7498;i:1755659284;d:0.7268;i:1755659020;d:0.8745;i:1755658707;d:0.7255;i:1755658431;d:0.766;i:1755658068;d:0.865;i:1755657793;d:0.7134;i:1755657508;d:0.7528;i:1755657197;d:0.7681;i:1755656893;d:0.7584;i:1755656624;d:0.7811;i:1755656307;d:0.7829;i:1755656011;d:0.862;i:1755655691;d:0.7839;i:1755655385;d:0.8546;i:1755655114;d:0.7419;i:1755654791;d:0.7328;i:1755654495;d:0.7669;i:1755654178;d:0.7444;i:1755653895;d:0.8337;i:1755653580;d:0.8439;i:1755653290;d:0.8704;i:1755652984;d:0.783;i:1755652667;d:0.779;i:1755652364;d:0.8236;i:1755652077;d:0.7883;i:1755651787;d:0.7526;i:1755651478;d:0.7074;i:1755651178;d:0.9352;i:1755650887;d:0.7587;i:1755650566;d:0.8012;i:1755650282;d:0.7467;i:1755649983;d:0.7756;i:1755649687;d:0.7525;i:1755649388;d:0.7702;i:1755649088;d:0.7512;i:1755648800;d:0.759;i:1755648500;d:0.7911;i:1755648197;d:0.8474;i:1755647891;d:0.726;i:1755647572;d:0.7516;i:1755647269;d:0.8233;i:1755646978;d:0.7871;i:1755646685;d:0.7355;i:1755646384;d:0.7737;i:1755646087;d:0.7682;i:1755645778;d:0.7643;i:1755645485;d:0.7788;i:1755645180;d:0.755;i:1755644888;d:0.9215;i:1755644602;d:0.7597;i:1755644286;d:0.7508;i:1755644004;d:0.7814;i:1755643686;d:0.7309;i:1755643400;d:0.7309;i:1755643104;d:0.9093;i:1755642776;d:0.815;i:1755642509;d:0.7928;i:1755642254;d:0.8067;i:1755641935;d:0.8165;i:1755641641;d:0.8115;i:1755641288;d:1.7576;i:1755640997;d:0.7819;i:1755640730;d:0.7988;i:1755640456;d:0.7641;i:1755640132;d:0.8035;i:1755639820;d:0.7154;i:1755639483;d:0.7596;i:1755639174;d:0.7783;i:1755638879;d:0.7501;i:1755638563;d:0.7423;i:1755638279;d:0.7398;i:1755637987;d:0.7965;i:1755637685;d:0.7532;i:1755637414;d:0.8155;i:1755637132;d:0.764;i:1755636825;d:0.7408;i:1755636477;d:0.7368;i:1755636195;d:0.7691;i:1755635927;d:0.8243;i:1755635628;d:0.8475;i:1755635319;d:0.8026;i:1755634993;d:0.8266;i:1755634707;d:0.8859;i:1755634411;d:0.7907;i:1755634106;d:1.0395;i:1755633791;d:0.8427;i:1755633484;d:0.8362;i:1755633180;d:0.7495;i:1755632884;d:0.7946;i:1755632615;d:0.7613;i:1755632297;d:0.7535;i:1755632000;d:0.7867;i:1755631685;d:0.8016;i:1755631407;d:0.7729;i:1755631098;d:0.8202;i:1755630818;d:0.8283;i:1755630485;d:0.7468;i:1755630175;d:0.7964;i:1755629871;d:0.8481;i:1755629587;d:0.785;i:1755629293;d:0.7375;i:1755629006;d:0.8033;i:1755628700;d:1.1624;i:1755628388;d:0.752;i:1755628086;d:0.7811;i:1755627791;d:0.7429;i:1755627477;d:0.7524;i:1755627195;d:0.7941;i:1755626885;d:0.8328;i:1755626608;d:0.8425;i:1755626298;d:0.7845;i:1755625987;d:0.7353;i:1755625686;d:0.7581;i:1755625394;d:0.718;i:1755625079;d:0.743;i:1755624793;d:0.7548;i:1755624478;d:0.7862;i:1755624180;d:0.8156;i:1755623892;d:0.7224;i:1755623594;d:0.7608;i:1755623291;d:0.8073;i:1755622986;d:0.7627;i:1755622695;d:0.7816;i:1755622364;d:0.911;i:1755622090;d:0.8068;i:1755621791;d:0.7752;i:1755621497;d:0.8809;i:1755621203;d:0.8253;i:1755620937;d:0.8853;i:1755620633;d:0.8125;i:1755620340;d:0.7668;i:1755620006;d:0.7775;i:1755619704;d:0.8534;i:1755619408;d:0.8884;i:1755619142;d:0.8433;i:1755618839;d:0.7221;i:1755618530;d:0.7459;i:1755618193;d:0.8276;i:1755617899;d:0.8496;i:1755617607;d:0.7974;i:1755617308;d:0.8079;i:1755616987;d:0.7687;i:1755616689;d:0.7585;i:1755616399;d:0.8182;i:1755616131;d:0.7449;i:1755615829;d:0.7441;i:1755615549;d:0.7914;i:1755615199;d:0.7695;i:1755614924;d:0.7997;i:1755614642;d:0.8536;i:1755614338;d:0.9426;i:1755614037;d:0.7931;i:1755613727;d:0.7768;i:1755613417;d:0.849;i:1755613161;d:0.7761;i:1755612879;d:0.8965;i:1755612557;d:0.9012;i:1755612262;d:1.0472;i:1755611944;d:0.7899;i:1755611633;d:0.9469;i:1755611346;d:0.8159;i:1755611014;d:0.7489;i:1755610716;d:0.8369;i:1755610407;d:0.7968;i:1755610097;d:0.9252;i:1755609811;d:0.8314;i:1755609519;d:0.7354;i:1755609228;d:0.7605;i:1755608915;d:0.7671;i:1755608638;d:0.793;i:1755608317;d:0.7635;i:1755608002;d:0.75;i:1755607723;d:0.7697;i:1755607461;d:1.2744;i:1755607114;d:0.8359;i:1755606821;d:0.8598;i:1755606527;d:0.9196;i:1755606248;d:0.8546;}s:17:\"discovery_history\";a:100:{i:1755692366;d:2.1463;i:1755692225;d:2.125;i:1755686019;d:2.0676;i:1755664424;d:2.1366;i:1755642830;d:2.0582;i:1755621223;d:2.0629;i:1755599642;d:2.1631;i:1755578020;d:2.2457;i:1755556435;d:2.1076;i:1755534837;d:2.0271;i:1755513218;d:2.3513;i:1755491642;d:2.1927;i:1755470030;d:2.0352;i:1755448441;d:2.0792;i:1755426821;d:2.2238;i:1755405216;d:2.0955;i:1755383696;d:2.0235;i:1755362022;d:2.5732;i:1755340429;d:2.0249;i:1755318810;d:2.0464;i:1755297220;d:2.0858;i:1755275630;d:2.0101;i:1755254033;d:2.0535;i:1755232434;d:2.22;i:1755210841;d:2.0571;i:1755189233;d:2.1296;i:1755167627;d:2.0543;i:1755146016;d:2.2082;i:1755124424;d:1.9434;i:1755102812;d:2.042;i:1755081229;d:2.1209;i:1755059611;d:2.1418;i:1755038012;d:2.0698;i:1755016431;d:2.0632;i:1754994833;d:2.1754;i:1754973245;d:2.3373;i:1754951621;d:2.1109;i:1754930015;d:2.0663;i:1754908405;d:2.0031;i:1754886817;d:2.0048;i:1754865214;d:1.9873;i:1754843618;d:2.051;i:1754822027;d:2.0763;i:1754800427;d:2.1241;i:1754778814;d:1.9642;i:1754757227;d:2.0658;i:1754735630;d:2.011;i:1754714026;d:2.0344;i:1754692415;d:2.0633;i:1754670825;d:1.9905;i:1754649229;d:2.0336;i:1754627628;d:2.1648;i:1754606025;d:2.1129;i:1754584434;d:2.0431;i:1754562826;d:2.1125;i:1754541230;d:2.0555;i:1754519611;d:2.0499;i:1754498016;d:1.9713;i:1754476427;d:2.0751;i:1754454835;d:2.1886;i:1754433219;d:2.2088;i:1754411634;d:2.0272;i:1754390024;d:2.0098;i:1754368417;d:2.0641;i:1754346973;d:2.0377;i:1754325208;d:3.0873;i:1754303675;d:1.9939;i:1754282020;d:2.4316;i:1754260424;d:2.0126;i:1754238830;d:2.044;i:1754217228;d:2.0517;i:1754195617;d:2.0155;i:1754174022;d:2.015;i:1754152435;d:2.1095;i:1754130796;d:2.335;i:1754109224;d:2.0944;i:1754087622;d:2.0413;i:1754066035;d:2.1925;i:1754044428;d:2.2106;i:1754022811;d:2.1281;i:1754001223;d:2.0219;i:1753979608;d:2.1785;i:1753958043;d:2.1096;i:1753936418;d:2.1445;i:1753914831;d:2.0554;i:1753893228;d:2.1264;i:1753871622;d:2.3131;i:1753850160;d:2.3731;i:1753828434;d:3.0494;i:1753806808;d:2.2048;i:1753785241;d:2.1626;i:1753763624;d:2.4693;i:1753742025;d:2.0738;i:1753720427;d:2.1571;i:1753698818;d:2.0992;i:1753677274;d:2.0067;i:1753655615;d:2.4541;i:1753634019;d:2.1216;i:1753612419;d:2.1112;i:1753590825;d:2.1929;}s:18:\"discovery_mod_perf\";a:17:{s:2:\"os\";d:0.0714;s:4:\"mibs\";d:0.1705;s:5:\"ports\";d:0.1746;s:4:\"oids\";d:0.0011;s:12:\"ip-addresses\";d:0.276;s:10:\"processors\";d:0.052;s:8:\"mempools\";d:0.0458;s:9:\"inventory\";d:0.1068;s:15:\"printersupplies\";d:0.0008;s:7:\"sensors\";d:0.9792;s:7:\"storage\";d:0.0305;s:10:\"neighbours\";d:0.0985;s:9:\"arp-table\";d:0.0643;s:14:\"mac-accounting\";d:0.0003;s:3:\"sla\";d:0.0301;s:10:\"ucd-diskio\";d:0.0287;s:6:\"graphs\";d:0.0003;}}' WHERE `device_id` = '559'] SQL RUNTIME[0.0011189s] ##### ups-a-be-wav-01.winnet.local [559] completed discovery modules at 2025-08-20 12:19:28 #####   o Discovery time  2.1463 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '550910' AND `process_name` = 'discovery.php' AND `device_id` = '559' AND `poller_id` = '0'] SQL RUNTIME[0.00057197s] ##### Finished discovery run at 2025-08-20 12:19:28 #####   SQL[SELECT * FROM `groups` ORDER BY `entity_type`] SQL RUNTIME[0.00021791s]  SQL[SELECT * FROM `groups_assoc`] SQL RUNTIME[7.51E-5s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^DC.*')] SQL RUNTIME[0.00048184s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.0003171s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^(BE|CH|LU|NL)' AND IFNULL(`devices`.`location`, "") NOT REGEXP '(R30|LCL)')] SQL RUNTIME[0.00071979s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00059104s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, '') = 'Unknown' OR `devices`.`location` IS NULL OR IFNULL(`devices`.`location`, "") REGEXP '^$')] SQL RUNTIME[0.00040293s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 5] SQL RUNTIME[0.00011492s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'Juniper' AND(( IFNULL(`devices`.`hardware`, "") REGEXP '(EX4300)' AND IFNULL(`devices`.`version`, "") NOT REGEXP '(21.4R3-S10)') OR( IFNULL(`devices`.`hardware`, "") REGEXP '(QFX5100|QFX5110)' AND IFNULL(`devices`.`version`, "") NOT REGEXP '(21.4R3-S10)') OR( IFNULL(`devices`.`hardware`, "") REGEXP '(QFX5120)' AND IFNULL(`devices`.`version`, "") NOT REGEXP '(23.4R2)')))] SQL RUNTIME[0.000561s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 7] SQL RUNTIME[0.00018191s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'Juniper' AND IFNULL(`devices`.`hostname`, "") NOT REGEXP '(node|\\-vr)' AND( IFNULL(`devices`.`hardware`, "") REGEXP '(SRX5400)' AND IFNULL(`devices`.`version`, "") NOT REGEXP '(21.4R3-S7.9)'))] SQL RUNTIME[0.00037599s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 8] SQL RUNTIME[0.00019622s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'Juniper' AND(( IFNULL(`devices`.`hardware`, "") REGEXP '(ex2300|ex3400)' AND IFNULL(`devices`.`version`, "") NOT REGEXP '(21.4R3-S9|23.4R2-S[2-9])') OR( IFNULL(`devices`.`hardware`, "") REGEXP '(ex2200)' AND IFNULL(`devices`.`version`, "") NOT REGEXP '(12.3R12-S21)')))] SQL RUNTIME[0.00055814s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 126] SQL RUNTIME[0.00012207s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^DC R30.*' AND IFNULL(`devices`.`hostname`, "") NOT REGEXP '(oob|jvr|labo)')] SQL RUNTIME[0.00051284s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 129] SQL RUNTIME[0.00025797s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^DC LCL.*' AND IFNULL(`devices`.`hostname`, "") NOT REGEXP '(oob)')] SQL RUNTIME[0.00031686s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 132] SQL RUNTIME[0.0001049s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`vendor`, '') = 'APC' AND IFNULL(`devices`.`version`, "") NOT REGEXP '^(6\\.9\\.6|7\\.0\\.\\d+|7\\.1\\.\\d+|[12]\\.\\d+\\.\\d+\\.\\d+)$')] SQL RUNTIME[0.00032091s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 134] SQL RUNTIME[8.988E-5s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^DC.*' AND IFNULL(`devices`.`hostname`, "") NOT REGEXP '(oob|labo|jvr)')] SQL RUNTIME[0.00042415s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 138] SQL RUNTIME[0.00032806s]  SQL[SELECT `pool_id`, `devices`.`device_id` AS `device_id` FROM `lb_pools` LEFT JOIN `devices` ON (`lb_pools`.`device_id` = `devices`.`device_id`) WHERE ( `lb_pools`.`pool_name` IS NOT NULL)] SQL RUNTIME[0.00027394s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 4] SQL RUNTIME[0.00023198s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifAlias`, "") REGEXP 'uplink') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00848317s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 124] SQL RUNTIME[0.00107408s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.00021696s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (1,2,3,4,7,8,10,11,14,15,16,17,18,31,32,75,76,77,78,79,80,81,82,122,123,134,135,136,139,140,153,154,155,156,159,160,161,162,163,164,167,168,176,177,178,179,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,216,217,218,219,220,221,228,229,230,231,252,253,254,302,303,344,345,346,348,396,407,417,422,423,437,441,442,443,448,453,454,455,458,490,510,511,512,513,514,515,516,517,526,527,528,529,530,531,532,533) AND IFNULL(`devices`.`type`, '') = 'network' AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up' AND IFNULL(`ports`.`ifType`, '') = 'ethernetCsmacd' AND IFNULL(`ports`.`ifName`, "") REGEXP '(et|xe|ge)') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00471878s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 125] SQL RUNTIME[0.00119686s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`vendor`, '') = 'Juniper' AND IFNULL(`ports`.`ifName`, "") REGEXP 'vcp-.*') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00832105s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 128] SQL RUNTIME[0.00054502s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00024295s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (49,52,57,60,66,67,69,70,72,83,84,85,86,87,88,91,92,94,95,96,97,98,99,100,101,102,103,106,107,108,109,110,111,112,113,114,115,116,117,118,128,129,137,143,144,145,146,147,148,149,150,151,174,183,184,185,232,234,235,236,237,238,241,251,261,262,264,265,266,267,269,270,271,272,273,274,275,276,282,283,284,285,286,287,288,289,290,291,292,293,295,297,298,299,300,301,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,339,340,341,342,343,347,353,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,399,400,401,402,403,404,405,406,408,409,410,411,412,413,414,415,416,418,419,420,421,424,425,426,427,428,429,430,431,432,433,434,435,436,438,452,456,459,460,462,464,465,466,467,468,469,470,473,474,475,476,477,478,489,492,493,494,495,496,497,498,499,500,501,502,503,518,519,520,521,522,523,524,525,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559) AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.01933694s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 131] SQL RUNTIME[0.00628996s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00012589s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (49,52,57,60,66,67,69,70,72,83,84,85,86,87,88,91,92,94,95,96,97,98,99,100,101,102,103,106,107,108,109,110,111,112,113,114,115,116,117,118,128,129,137,143,144,145,146,147,148,149,150,151,174,183,184,185,232,234,235,236,237,238,241,251,261,262,264,265,266,267,269,270,271,272,273,274,275,276,282,283,284,285,286,287,288,289,290,291,292,293,295,297,298,299,300,301,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,339,340,341,342,343,347,353,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,399,400,401,402,403,404,405,406,408,409,410,411,412,413,414,415,416,418,419,420,421,424,425,426,427,428,429,430,431,432,433,434,435,436,438,452,456,459,460,462,464,465,466,467,468,469,470,473,474,475,476,477,478,489,492,493,494,495,496,497,498,499,500,501,502,503,518,519,520,521,522,523,524,525,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559) AND IFNULL(`devices`.`type`, '') = 'network' AND IFNULL(`ports`.`ifAlias`, "") REGEXP '(isp1|isp2)') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.01528382s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 133] SQL RUNTIME[0.00029707s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a01_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00057888s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 91] SQL RUNTIME[0.0001018s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a01_.2' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.000597s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 92] SQL RUNTIME[0.00015116s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a02_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.000664s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 93] SQL RUNTIME[0.00013709s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a02_.2' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00057197s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 94] SQL RUNTIME[9.608E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a03_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00046206s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 95] SQL RUNTIME[0.00010896s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a04_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00065207s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 96] SQL RUNTIME[0.00014901s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a05_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00047588s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 97] SQL RUNTIME[8.512E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a06_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00046206s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 98] SQL RUNTIME[7.296E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a07_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00053287s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 99] SQL RUNTIME[7.701E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a08_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00043416s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 100] SQL RUNTIME[8.488E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a09_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00042605s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 101] SQL RUNTIME[0.00011706s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a10_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00075793s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 102] SQL RUNTIME[0.000144s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a11_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00052404s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 103] SQL RUNTIME[0.00010109s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a12_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00048399s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 104] SQL RUNTIME[9.203E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_a13_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00047708s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 105] SQL RUNTIME[9.394E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_k0_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.0004859s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 106] SQL RUNTIME[8.607E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_k1_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00046206s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 107] SQL RUNTIME[6.986E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_k2_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00042796s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 108] SQL RUNTIME[7.415E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b01_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00044799s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 109] SQL RUNTIME[0.00041103s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b01_.2' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00086617s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 110] SQL RUNTIME[0.00017691s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b02_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00087881s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 111] SQL RUNTIME[0.00017715s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b02_.2' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00079703s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 112] SQL RUNTIME[0.00015593s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b03_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00081897s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 113] SQL RUNTIME[0.00015903s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b04_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00085807s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 114] SQL RUNTIME[0.00012016s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b05_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00053883s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 115] SQL RUNTIME[9.203E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b06_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00051689s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 116] SQL RUNTIME[7.391E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b07_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.000525s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 117] SQL RUNTIME[8.512E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b08_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00090885s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 118] SQL RUNTIME[0.00017023s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b09_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00075698s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 119] SQL RUNTIME[0.00017405s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b10_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00054789s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 120] SQL RUNTIME[0.00011396s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b11_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.0004859s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 121] SQL RUNTIME[8.893E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b12_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00048494s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 122] SQL RUNTIME[7.892E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') = 'current' AND IFNULL(`devices`.`hostname`, "") REGEXP '^pdu_r30_b13_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00044203s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 123] SQL RUNTIME[7.606E-5s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') IN (76,80) AND IFNULL(`sensors`.`sensor_class`, '') = 'dbm' AND( IFNULL(`sensors`.`sensor_descr`, "") REGEXP '^EDFA Interface . RX' OR IFNULL(`sensors`.`sensor_descr`, "") REGEXP '^SFP Interface 200 RXnot')) AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00238609s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 135] SQL RUNTIME[0.00013494s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') IN (79,77) AND IFNULL(`sensors`.`sensor_class`, '') = 'dbm' AND( IFNULL(`sensors`.`sensor_descr`, "") REGEXP '^EDFA Interface 2 RX' OR IFNULL(`sensors`.`sensor_descr`, "") REGEXP '^SFP Interface 200 RXnot')) AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00227594s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 136] SQL RUNTIME[0.00019193s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') IN (78,75) AND IFNULL(`sensors`.`sensor_class`, '') = 'dbm' AND( IFNULL(`sensors`.`sensor_descr`, "") REGEXP '^EDFA Interface . RX' OR IFNULL(`sensors`.`sensor_descr`, "") REGEXP '^SFP Interface 200 RX')) AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00236583s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 137] SQL RUNTIME[0.00013804s]  SQL[SELECT `status_id`, `devices`.`device_id` AS `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`vendor`, '') = 'APC' AND IFNULL(`status`.`status_type`, '') = 'rPDUOutletStatusOutletState' AND IFNULL(`status`.`status_descr`, "") REGEXP 'Outlet \\d+ - Outlet \\d+') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.00840116s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 130] SQL RUNTIME[0.00205016s]  SQL[SELECT * FROM `alert_tests`] SQL RUNTIME[7.892E-5s] Cached 41 alert rules. SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[4.101E-5s]  SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`ignore` = '0' AND( IFNULL(`devices`.`vendor`, '') != 'Moxa'))] SQL RUNTIME[0.00057793s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 1] SQL RUNTIME[0.00058413s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`type`, '') = 'optical' AND IFNULL(`ports`.`ifName`, "") NOT LIKE 'LAN interface%' AND `ports`.`ifName` != 'ETH 2') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.0101099s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 2] SQL RUNTIME[0.00043607s]  SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`ignore` = '0' AND IFNULL(`devices`.`type`, '') != 'power')] SQL RUNTIME[0.000458s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 5] SQL RUNTIME[0.00031614s]  SQL[SELECT `status_id`, `devices`.`device_id` AS `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`ignore` = '0' AND IFNULL(`devices`.`type`, '') != 'power') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.01029897s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 6] SQL RUNTIME[0.00780487s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`ignore` = '0' AND IFNULL(`sensors`.`sensor_class`, '') = 'dbm') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00736904s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 7] SQL RUNTIME[0.0013299s]  SQL[SELECT `bgpPeer_id`, `devices`.`device_id` AS `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hardware`, "") REGEXP 'SRX' AND IFNULL(`devices`.`hostname`, "") NOT REGEXP 'node')] SQL RUNTIME[0.00025296s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 8] SQL RUNTIME[0.00014496s]  SQL[SELECT `bgpPeer_id`, `devices`.`device_id` AS `device_id` FROM `bgpPeers` LEFT JOIN `devices` ON (`bgpPeers`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`hardware`, "") REGEXP 'SRX' AND IFNULL(`devices`.`hostname`, "") NOT REGEXP 'node')] SQL RUNTIME[3.815E-5s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 9] SQL RUNTIME[0.000108s]  SQL[SELECT `status_id`, `devices`.`device_id` AS `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`ignore` = '0') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.01711297s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 10] SQL RUNTIME[0.01184893s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.00011587s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (1,2,3,4,7,8,10,11,14,15,16,17,18,31,32,75,76,77,78,79,80,81,82,122,123,134,135,136,139,140,153,154,155,156,159,160,161,162,163,164,167,168,176,177,178,179,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,216,217,218,219,220,221,228,229,230,231,252,253,254,302,303,344,345,346,348,396,407,417,422,423,437,441,442,443,448,453,454,455,458,490,510,511,512,513,514,515,516,517,526,527,528,529,530,531,532,533) AND IFNULL(`devices`.`type`, '') IN ('firewall','loadbalancer','network') AND IFNULL(`ports`.`ifAlias`, "") NOT REGEXP '(span|mirror)' AND IFNULL(`ports`.`ifType`, '') = 'ethernetCsmacd') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00815606s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 11] SQL RUNTIME[0.00204206s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[7.486E-5s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (1,2,3,4,7,8,10,11,14,15,16,17,18,31,32,75,76,77,78,79,80,81,82,122,123,134,135,136,139,140,153,154,155,156,159,160,161,162,163,164,167,168,176,177,178,179,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,216,217,218,219,220,221,228,229,230,231,252,253,254,302,303,344,345,346,348,396,407,417,422,423,437,441,442,443,448,453,454,455,458,490,510,511,512,513,514,515,516,517,526,527,528,529,530,531,532,533) AND IFNULL(`devices`.`type`, '') IN ('firewall','network') AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up' AND IFNULL(`ports`.`ifType`, '') NOT IN ('loopback','l2vlan','propVirtual','rs232')) AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00737786s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 12] SQL RUNTIME[0.00247192s]  SQL[SELECT `processor_id`, `devices`.`device_id` AS `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`disabled` = '0' AND IFNULL(`processors`.`processor_descr`, "") NOT REGEXP '(Routing.Engine|Average)')] SQL RUNTIME[0.0015831s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 13] SQL RUNTIME[0.00084114s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`sensors`.`sensor_class`, '') IN ('fanspeed','temperature') AND IFNULL(`sensors`.`sensor_descr`, "") NOT REGEXP '^(ge|xe|et)|Routing.Engine|MNG|SFP|13157377') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00301909s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 14] SQL RUNTIME[0.00067711s]  String '0' transformed by action [units] to: '0' SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifName`, "") REGEXP '^(ae|reth)[0-9]+$' AND `ports`.`ifSpeed` != '0' AND IFNULL(`devices`.`type`, '') = 'network') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00816989s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 15] SQL RUNTIME[0.00042009s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`ports`.`ifName`, "") REGEXP '^vcp') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00741696s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 16] SQL RUNTIME[0.00054789s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^DC.(BVB|LCL|R30)' AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up' AND IFNULL(`ports`.`ifType`, '') NOT IN ('loopback','l2vlan','propVirtual','rs232') AND `devices`.`os` = 'ruleset_disabled') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00023985s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 17] SQL RUNTIME[9.298E-5s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^DC.(BVB|LCL|R30)' AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up' AND IFNULL(`ports`.`ifType`, '') NOT IN ('loopback','l2vlan','propVirtual','rs232')) AND `ports`.`deleted` != '1'] SQL RUNTIME[0.01237297s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 18] SQL RUNTIME[0.00380611s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[9.799E-5s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (1,2,3,4,7,8,10,11,14,15,16,17,18,31,32,75,76,77,78,79,80,81,82,122,123,134,135,136,139,140,153,154,155,156,159,160,161,162,163,164,167,168,176,177,178,179,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,216,217,218,219,220,221,228,229,230,231,252,253,254,302,303,344,345,346,348,396,407,417,422,423,437,441,442,443,448,453,454,455,458,490,510,511,512,513,514,515,516,517,526,527,528,529,530,531,532,533) AND IFNULL(`devices`.`type`, '') IN ('firewall','network') AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up' AND IFNULL(`ports`.`ifType`, '') NOT IN ('loopback','l2vlan','propVirtual','rs232','Loopback') AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%span%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%mirror%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00833797s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 19] SQL RUNTIME[0.00236583s]  SQL[SELECT `status_id`, `devices`.`device_id` AS `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`disabled` = '0' AND IFNULL(`devices`.`type`, '') = 'power' AND `status`.`entPhysicalClass` = 'outlet' AND IFNULL(`status`.`status_descr`, "") NOT REGEXP '.*DISABLED$') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.00695109s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 20] SQL RUNTIME[0.00416398s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`disabled` = '0' AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up' AND `ports`.`port_descr_type` = 'transit') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.02286792s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 21] SQL RUNTIME[0.00018406s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`vendor`, '') = 'Socomec' AND IFNULL(`sensors`.`sensor_class`, '') = 'temperature' AND( `sensors`.`sensor_descr` = 'Battery' OR `sensors`.`sensor_descr` = 'Ambient')) AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00222802s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 23] SQL RUNTIME[0.00016999s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`disabled` = '0' AND IFNULL(`sensors`.`sensor_class`, '') = 'temperature' AND IFNULL(`devices`.`vendor`, '') IN ('APC','Socomec') AND( `sensors`.`sensor_descr` = 'Battery' OR `sensors`.`sensor_descr` = 'Ambient')) AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00307298s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 24] SQL RUNTIME[0.00016785s]  SQL[SELECT `status_id`, `devices`.`device_id` AS `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`ignore` = '0' AND IFNULL(`devices`.`type`, '') IN ('environment','management','power') AND IFNULL(`devices`.`vendor`, '') != 'Raritan') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.00582719s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 25] SQL RUNTIME[0.005023s]  SQL[SELECT `status_id`, `devices`.`device_id` AS `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`ignore` = '0' AND IFNULL(`devices`.`type`, '') IN ('environment','management','power') AND IFNULL(`devices`.`vendor`, '') != 'Raritan') AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.00035906s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 26] SQL RUNTIME[0.00510287s]  SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`ignore` = '0' AND IFNULL(`devices`.`type`, '') IN ('environment','management','power') AND IFNULL(`devices`.`vendor`, '') != 'Raritan')] SQL RUNTIME[0.00059199s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 27] SQL RUNTIME[0.00038886s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`device_id`, '') = 1)] SQL RUNTIME[0.00013494s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 28] SQL RUNTIME[7.081E-5s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 124] 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`.`ignore` = '0' AND `ports`.`port_id` IN (1153,1155,1157,1160,1161,1220,1273,2058,2059,2114,2132,2167,2171,2173,2175,2177,2927,2928,2950,2952,2954,2956,9161,9162,9163,9164,9168,9189,9190,9191,9193,9199,9309,9311,9320,9371,9373,9375,9376,9377,9433,9434,9435,9436,9437,9645,9655,9659,9660,9661,9662,10117,10119,10122,10126,10174,10175,10178,10179,10180,10823,10832,10834,10836,10837,10838,10884,10888,10915,11188,11193,11195,11199,11241,11242,11243,11244,11245,11318,11319,11320,11321,11322,11424,11425,11427,11428,11430,11763,11765,11767,11768,11769,11851,11852,11853,11854,11856,16401,16403,16404,16406,16459,16460,16461,16462,16473,16475,16477,16480,16481,16482,16483,16611,16612,16614,16615,16689,16690,16693,16695,16803,16805,16807,16808,16809,16852,16858,16862,16871,16902,16906,16908,16909,16910,17004,17005,17006,17007,17009,17115,17116,17117,17118,17119,18911,19003,19009,21983,21984,21995,21996,22014,22015,22026,22027,22087,22088,22089,22090,22091,22092,22093,22094,22095,22096,22097,22098,22101,22103,22912,22914,22916,22918,23187,23191,23193,23199,23203,23207,23211,23212,23217,23219,23220,23222,23235,23236,23239,23240,23242,23245,23247,23249,23251,23253,23255,23257,23259,23261,23263,23323,23327,23330,23334,23338,23342,23346,23350,23354,23358,23362,23366,23369,23371,23375,23379,23383,23387,23391,23395,23399,24083,24084,24085,24088,24089,24286,24287,24288,24404,24408,24409,24411,24413,24511,24515,24517,24519,24520,24789,24791,24915,24916,24967,24968,25019,25667,25669,25670,25721,25771,25885,25886,25937,25938,26275,26850,26853,27076,27078,27080,27081,27133,27291,27293,27295,27297,27298,27726,27728,27874,27877,27878,28008,28040,28042,28044,28045,28046,30139,30140,30193,32367,32368,32382,32922,32929,32931,33030,33063,33402,33483,33484,33485,33486,33493,33540,33542,33544,33546,33548,33549,33550,33551,34346,34436,34437,34438,34484,34485,34583,34584,34588,34590,34592,34594,34596,34598,34600,34602,34797,34798,34799,34800,34860,34873,34889,35813,35814,35815,35816,35837,35838,35839,35840,35861,35862,35863,35864,36137,36139,36364,36365,36425,36427,36429,36500,36501,36615,36616,36617,36618,37437,37651,37955,37957,37959,37961,38242,38250,38251,38260,38301,38302,38303,38304,38305,38520,38522,38524,38525,38526,38827,38829,38831,38833,39211,39213,39215,39474,39475,39476,39477,39669,39670,39695,39696,39762,39764,39768,39771,39971,39972,39973,39974,40073,40093,40097,40103,40110,40115,40120,40130,40139,40146,40147,40148,40149,40150,40340,40342,40344,40346,40580,40581,40584,40586,40633,40634,40635,40636,40706,40707,40711,40754,40755,40758,40844,40846,40848,40849,40850,40903,40908,40910,40916,40949,40950,40951,40952,40953,41496,41588,41591,41593,41595,41638,41639,41641,41643,41645,41729,41730,41731,41733,41734,41909,41917,41973,41974,42245,42246,42248,42249,42250,42785,42786,42787,42789,42790,42861,42862,42863,42864,42865,42866,42868,42870,42872,42992,42993,42994,43170,43235,43236,43237,43238,43239,44439,44447,44458,44459,44763,47270,47271,47272,47273,47274,47593,47595,47597,48474,48494,48495,48509,49515,49520,49521,49534,49536,49577,49578,49581,49594,49599,49605,49624,49629,49630,49631,49632,49681,49760,49889,49891,49893,51183,51198,51222,51223,51224,51225,51250,51251,51252,51253,51323,51329,51330,51332,51333,51468,51512,51523,51524,51527,51528,51529,51609,51610,51611,51612,51613,51758,51759,52049,52053,52055,52126,52164,52417,52418,52419,52469,52473,52531,52533,52595,52597,52629,52679,52731,52753,52841,52842,53018,53049,53050,53051,53052,53087,53104,53107,53214,53216,53218,53220,53230,53265,53314,53315,53384,53405,53406,53408,53421,53423,53425,53427,53464,53465,53466,53467,53468,53503,53505,53507,53508,53511,53513,53544,53594,53595,53597,53598,53600,53638,53640,53642,53656) AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00215507s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 29] SQL RUNTIME[0.00072408s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 130] SQL RUNTIME[0.00081706s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[5.293E-5s]  SQL[SELECT `status_id`, `devices`.`device_id` AS `device_id` FROM `status` LEFT JOIN `devices` ON (`status`.`device_id` = `devices`.`device_id`) WHERE ( `status`.`status_id` IN (1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2144,2145,2146,2147,2148,2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2161,2162,2163,2164,2165,2166,2167,2198,2199,2200,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2360,2361,2362,2363,2364,2365,2366,2367,2368,2369,2370,2371,2372,2373,2374,2375,2376,2377,2378,2379,2380,2381,2382,2383,2414,2415,2416,2417,2418,2419,2420,2421,2422,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2433,2434,2435,2436,2437,2468,2469,2470,2471,2472,2473,2474,2475,2476,2477,2478,2479,2480,2481,2482,2483,2484,2485,2486,2487,2488,2489,2490,2491,2522,2523,2524,2525,2526,2527,2528,2529,2530,2531,2532,2533,2534,2535,2536,2537,2538,2539,2540,2541,2542,2543,2544,2545,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2846,2847,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2869,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2920,2921,2922,2923,2954,2955,2956,2957,2958,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2973,2974,2975,2976,2977,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3224,3225,3226,3227,3228,3229,3230,3231,3232,3233,3234,3235,3236,3237,3238,3239,3240,3241,3242,3243,3244,3245,3246,3247,3278,3279,3280,3281,3282,3283,3284,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3295,3296,3297,3298,3299,3300,3301,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3348,3349,3350,3351,3352,3353,3354,3355,3386,3387,3388,3389,3390,3391,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3405,3406,3407,3408,3409,3440,3441,3442,3443,3444,3445,3446,3447,3448,3449,3450,3451,3452,3453,3454,3455,3456,3457,3458,3459,3460,3461,3462,3463,3494,3495,3496,3497,3498,3499,3500,3501,3502,3503,3504,3505,3506,3507,3508,3509,3510,3511,3512,3513,3514,3515,3516,3517,3548,3549,3550,3551,3552,3553,3554,3555,3556,3557,3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3656,3657,3658,3659,3660,3661,3662,3663,3664,3665,3666,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3710,3711,3712,3713,3714,3715,3716,3717,3718,3719,3720,3721,3722,3723,3724,3725,3726,3727,3728,3729,3730,3731,3732,3733,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3839,3840,3841,3842,3873,3874,3876,3877,3878,3879,3880,3881,3882,3883,3884,3885,3886,3887,3888,3889,3890,3891,3892,3893,3894,3895,3896,3927,3928,3930,3931,3932,3933,3934,3935,3936,3937,3938,3939,3940,3941,3942,3943,3944,3945,3946,3947,3948,3949,3950,3981,3982,3983,3984,3985,3986,3987,3988,3989,3990,3991,3992,3993,3994,3995,3996,3997,3998,3999,4000,4001,4002,4003,4004,13486,13487,13512,13513,13514,13515,13516,13517,13518,13519,13520,13521,13522,13523,13524,13525,13526,13527,13528,13529,13563,13564,13565,13566,13567,13568,13569,13570,13571,13572,13573,13574,13575,13576,13577,13578,13579,13580,13624,13625,13626,13627,13628,13629,13630,13631,13650,13651,13652,13653,13654,13655,13656,13657,13658,13659,13660,13661,13662,13663,13664,13665,13666,13701,13702,13703,13704,13705,13706,13707,13708,13709,13710,13711,13712,13713,13714,13715,13716,13717,14164,14182,14183,14184,14185,14186,14202,14203,14204,14205,14206,14478,14479,14480,14481,14482,14483,14627,14628,14629,14630,14631,14632,15740,15756,15757,15758,15759,15760,15761,15762,15780,16040,16041,16042,16043,16044,16045,16060,16061,16062,16063,16064,16065,16085,16086,16087,16088,16089,16090,16149,16169,16200,16201,16217,16220,16221,16222,16223,16240,16241,16367,16368,16369,16370,16383,16384,16385,16386,16387,16388,16389,16390,16407,16408,16409,16410,16440,16441,16442,16443,16460,16461,16462,16463,16480,16481,16482,16483,16657,16658,16659,16660,16661,16679,16680,16699,16700,16931,16932,16933,16934,16947,16948,16949,16950,16951,16952,16953,16954,16955,16956,16957,16958,16959,16960,16961,16962,16963,16964,16965,16966,16967,16968,16969,16970,16998,16999,17000,17001,17002,17003,17004,17005,17006,17007,17008,17009,17010,17011,17012,17013,17014,17015,17016,17017,17018,17019,17020,17021,17066,17067,17068,17069,17070,17071,17072,17073,17074,17075,17076,17077,17078,17079,17080,17081,17082,17083,17084,17085,17126,17127,17128,17129,17146,17152,17153,17154,17155,17156,17157,17158,17159,17160,17161,17162,17163,17164,17165,17166,17167,17168,17169,17197,17203,17204,17205,17206,17207,17208,17209,17210,17211,17212,17213,17214,17215,17216,17217,17218,17219,17220,17256,17257,17258,17259,17260,17261,17262,17263,17264,17265,17266,17267,17268,17269,17270,17271,17272,17273,17274,17275,17306,17308,17309,17310,17637,17638,17639,17640,17641,17642,17643,17644,17645,17646,17647,17648,17649,17650,17651,17652,17653,17654,17655,17656,17657,17658,17659,17660,17688,17689,17690,17691,17692,17693,17694,17695,17696,17697,17698,17699,17700,17701,17702,17703,17704,17705,17706,17707,17708,17709,17710,17711,17740,17741,17742,17743,17744,17745,17746,17945,17946,17947,17948,17949,17966,17967,17968,17986,17987,17988,17989,18295,18296,18297,18298,18299,18300,18301,18302,18303,18304,18305,18306,18307,18308,18309,18310,18311,18314,18346,18347,18348,18349,18350,18351,18352,18353,18354,18355,18356,18357,18358,18359,18360,18361,18362,18365,18619,18620,18621,18622,18623,18624,18625,18626,18627,18628,18629,18630,18631,18632,18633,18634,18635,18636,18637,18638,18639,18640,18641,18642,18949,18950,18951,18952,18953,18954,18955,18956,18957,18958,18959,18960,18961,18962,18963,18964,18965,18966,18967,18968,18969,18970,18971,18972,19000,19001,19002,19003,19004,19005,19006,19007,19146,19147,19148,19149,19150,19151,19152,19153,19154,19155,19156,19157,19158,19159,19160,19161,19162,19163,19164,19165,19166,19167,19168,19169,19200,19201,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19216,19217,19218,19219,19220,19221,19222,19223,19334,19335,19336,19337,19338,19339,19340,19341,19342,19343,19344,19345,19346,19347,19348,19349,19350,19351,19352,19353,19354,19355,19356,19357,19388,19389,19390,19391,19392,19393,19394,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19405,19406,19407,19408,19409,19410,19411,19442,19443,19444,19445,19446,19447,19448,19449,19450,19451,19452,19453,19454,19455,19456,19457,19458,19459,19460,19461,19462,19463,19464,19465,19496,19497,19498,19499,19500,19501,19502,19503,19504,19505,19506,19507,19508,19509,19510,19511,19512,19513,19514,19515,19516,19517,19518,19519,19586,19587,19588,19589,19590,19591,19592,19593,19594,19595,19596,19597,19598,19599,19600,19601,19602,19603,19604,19605,19606,19607,19608,19609,20270,20271,20272,20273,20290,20291,20292,20293,20826,20827,20828,20829,20833,20848,20849,20850,20868,20869,20870,20915,20916,20917,20918,20919,20920,20938,20939,20940,20941,20955,20956,20957,20958,20959,20960,20987,20988,20989,20990,21007,21008,21009,21010,21237,21238,21239,21240,21241,21242,21243,21244,21245,21246,21247,21248,21249,21250,21251,21252,21253,21254,21255,21256,21257,21258,21259,21260,21288,21289,21290,21291,21292,21293,21294,21295,21296,21297,21298,21299,21300,21301,21302,21303,21304,21305,21306,21307,21308,21309,21310,21311,21339,21340,21341,21342,21344,21345,21346,21347,21348,21349,21350,21351,21352,21353,21354,21355,21356,21357,21358,21359,21360,21361,21362,21390,21391,21392,21393,21395,21396,21397,21398,21399,21400,21401,21402,21403,21404,21405,21406,21407,21408,21409,21410,21411,21412,21413,21441,21444,21445,21446,21447,21727,21729,21731,21732,21733,21734,21737,21738,21739,21740,21741,21742,21746,21777,21778,21779,21780,21781,21782,21783,21784,21785,21786,21787,21788,21789,21790,21791,21792,21793,21794,21795,21796,21797,21798,21799,21800,21838,21839,21840,21841,21846,21847,21848,21849,21854,21889,21891,21893,21894,21895,21896,21899,21900,21901,21902,21903,21904,21908,21946,21947,21948,21949,21954,21955,21956,21957,21962,21993,21994,21995,21996,21997,21998,21999,22000,22001,22002,22003,22004,22005,22006,22007,22008,22009,22010,22011,22012,22013,22014,22015,22016,22902,22903,22904,22905,22924,22925,22926,22927,22945,22946,22947,22948,23036,23037,23040,23041,23042,23043,23056,23057,23060,23061,23062,23063,23235,23236,23237,23238,23239,23240,23258,23259,23278,23279,23493,23494,23513,23514,23529,23530,23531,23532,23533,23534,23535,24185,24186,24187,24188,24189,24190,24205,24206,24207,24208,24209,24210,24254,24255,24256,24257,24258,24259,24260,24261) AND IFNULL(`status`.`status_descr`, "") REGEXP 'Outlet 1 - Outlet 1' AND `devices`.`device_id` IN (49,52,57,60,66,67,69,70,72,83,84,85,86,87,88,91,92,94,95,96,97,98,99,100,101,102,103,106,107,108,109,110,111,112,113,114,115,116,117,118,128,129,137,143,144,145,146,147,148,149,150,151,174,183,184,185,232,234,235,236,237,238,241,251,261,262,264,265,266,267,269,270,271,272,273,274,275,276,282,283,284,285,286,287,288,289,290,291,292,293,295,297,298,299,300,301,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,339,340,341,342,343,347,353,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,399,400,401,402,403,404,405,406,408,409,410,411,412,413,414,415,416,418,419,420,421,424,425,426,427,428,429,430,431,432,433,434,435,436,438,452,456,459,460,462,464,465,466,467,468,469,470,473,474,475,476,477,478,489,492,493,494,495,496,497,498,499,500,501,502,503,518,519,520,521,522,523,524,525,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559)) AND `status`.`status_deleted` != '1'] SQL RUNTIME[0.00421691s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 31] SQL RUNTIME[0.00022984s]  SQL[SELECT `probe_id`, `devices`.`device_id` AS `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`probes`.`probe_type`, '') = 'check_fping' AND IFNULL(`devices`.`vendor`, '') = 'Palo Alto')] SQL RUNTIME[0.00025105s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 32] SQL RUNTIME[0.00017905s]  SQL[SELECT `storage_id`, `devices`.`device_id` AS `device_id` FROM `storage` LEFT JOIN `devices` ON (`storage`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`type`, '') = 'server') AND `storage`.`storage_deleted` != '1'] SQL RUNTIME[0.00067997s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 33] SQL RUNTIME[0.00017405s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[4.411E-5s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (49,52,57,60,66,67,69,70,72,83,84,85,86,87,88,91,92,94,95,96,97,98,99,100,101,102,103,106,107,108,109,110,111,112,113,114,115,116,117,118,128,129,137,143,144,145,146,147,148,149,150,151,174,183,184,185,232,234,235,236,237,238,241,251,261,262,264,265,266,267,269,270,271,272,273,274,275,276,282,283,284,285,286,287,288,289,290,291,292,293,295,297,298,299,300,301,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,339,340,341,342,343,347,353,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,399,400,401,402,403,404,405,406,408,409,410,411,412,413,414,415,416,418,419,420,421,424,425,426,427,428,429,430,431,432,433,434,435,436,438,452,456,459,460,462,464,465,466,467,468,469,470,473,474,475,476,477,478,489,492,493,494,495,496,497,498,499,500,501,502,503,518,519,520,521,522,523,524,525,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559) AND IFNULL(`devices`.`type`, '') IN ('firewall','network') AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up' AND IFNULL(`ports`.`ifType`, '') NOT IN ('loopback','l2vlan','propVirtual','rs232','Loopback') AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%span%' AND IFNULL(`ports`.`ifAlias`, "") NOT LIKE '%mirror%') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.01961398s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 35] SQL RUNTIME[0.00828195s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[7.915E-5s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN (49,52,57,60,66,67,69,70,72,83,84,85,86,87,88,91,92,94,95,96,97,98,99,100,101,102,103,106,107,108,109,110,111,112,113,114,115,116,117,118,128,129,137,143,144,145,146,147,148,149,150,151,174,183,184,185,232,234,235,236,237,238,241,251,261,262,264,265,266,267,269,270,271,272,273,274,275,276,282,283,284,285,286,287,288,289,290,291,292,293,295,297,298,299,300,301,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,339,340,341,342,343,347,353,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,399,400,401,402,403,404,405,406,408,409,410,411,412,413,414,415,416,418,419,420,421,424,425,426,427,428,429,430,431,432,433,434,435,436,438,452,456,459,460,462,464,465,466,467,468,469,470,473,474,475,476,477,478,489,492,493,494,495,496,497,498,499,500,501,502,503,518,519,520,521,522,523,524,525,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559) AND IFNULL(`devices`.`vendor`, '') = 'Juniper' AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up' AND IFNULL(`ports`.`ifName`, "") REGEXP '^(ge|xe)\\-\\d/\\d/\\d+' AND IFNULL(`ports`.`ifType`, '') = 'Ethernet') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.01796007s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 36] SQL RUNTIME[0.00020695s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`vendor`, '') = 'Palo Alto' AND IFNULL(`ports`.`ifAdminStatus`, '') = 'up' AND IFNULL(`ports`.`ifName`, "") REGEXP '(Ethernet|mgmt)') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00864506s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 37] SQL RUNTIME[0.00055814s]  SQL[SELECT `probe_id`, `devices`.`device_id` AS `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`vendor`, '') = 'Palo Alto' AND IFNULL(`devices`.`device_id`, '') IN (156,153,154,155))] SQL RUNTIME[0.00027084s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 38] SQL RUNTIME[0.00011516s]  SQL[SELECT `sensor_id`, `devices`.`device_id` AS `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`vendor`, '') = 'Juniper' AND IFNULL(`sensors`.`sensor_class`, '') = 'age' AND `sensors`.`sensor_descr` = 'Configuration Rescue Last Changed') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00212789s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 39] SQL RUNTIME[0.00020409s]  SQL[SELECT `oid_entry_id`, `devices`.`device_id` AS `device_id` FROM `oids_entries` LEFT JOIN `devices` ON (`oids_entries`.`device_id` = `devices`.`device_id`) LEFT JOIN `oids` USING (`oid_id`) WHERE ( IFNULL(`devices`.`device_id`, '') = 490)] SQL RUNTIME[0.00016809s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 41] SQL RUNTIME[7.01E-5s]  SQL[SELECT `pool_id`, `devices`.`device_id` AS `device_id` FROM `lb_pools` LEFT JOIN `devices` ON (`lb_pools`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`type`, '') = 'loadbalancer' AND IFNULL(`devices`.`device_id`, '') IN (161,159,160,164,162,163))] SQL RUNTIME[0.00016284s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 42] SQL RUNTIME[9.203E-5s]  SQL[SELECT `virt_id`, `devices`.`device_id` AS `device_id` FROM `lb_virtuals` LEFT JOIN `devices` ON (`lb_virtuals`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`type`, '') = 'loadbalancer')] SQL RUNTIME[0.00020695s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 43] SQL RUNTIME[0.0002501s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') = 140 AND `ports`.`ifName` = 'xe-0/2/0') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.00645399s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 44] SQL RUNTIME[0.00014305s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') = 140 AND `ports`.`ifName` = 'xe-0/2/0') AND `ports`.`deleted` != '1'] SQL RUNTIME[4.411E-5s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 45] SQL RUNTIME[0.00010514s]  SQL[SELECT `probe_id`, `devices`.`device_id` AS `device_id` FROM `probes` LEFT JOIN `devices` ON (`probes`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`vendor`, '') = 'Palo Alto' AND IFNULL(`devices`.`device_id`, '') NOT IN (156,153,154,155,458,346))] SQL RUNTIME[0.00029087s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 46] SQL RUNTIME[0.00020194s]  SQL[SELECT `storage_id`, `devices`.`device_id` AS `device_id` FROM `storage` LEFT JOIN `devices` ON (`storage`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`type`, '') = 'loadbalancer') AND `storage`.`storage_deleted` != '1'] SQL RUNTIME[0.00066209s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 47] SQL RUNTIME[0.00032997s] ##### Update Alert Checkers Table #####  +--------------------------------------+-------------------+-------+---------+ | Alert Checker | Entries: existing | found | changes | +--------------------------------------+-------------------+-------+---------+ | Device Down | 405 | 405 | +0/-0 | | Optical Port Down | 216 | 216 | +0/-0 | | Device has rebooted | 184 | 184 | +0/-0 | | Status warning | 7768 | 7768 | +0/-0 | | Sensor dBm not ok | 1040 | 1040 | +0/-0 | | BGP peer down | 19 | 19 | +0/-0 | | BGP session has restarted | 19 | 19 | +0/-0 | | Status alert | 13537 | 13537 | +0/-0 | | Datacenter Port Traffic warning | 1584 | 1584 | +0/-0 | | Datacenter Port Errors | 2505 | 2505 | +0/-0 | | CPU Usage | 676 | 676 | +0/-0 | | Temperature Alert | 535 | 535 | +0/-0 | | Test aggregate speed | 255 | 255 | +0/-0 | | VCP Port Errors (5 min) | 338 | 338 | +0/-0 | | Test Datacenter Port down | 0 | 0 | +0/-0 | | Test Half-Duplex Port | 2978 | 2978 | +0/-0 | | Datacenter Port Discards | 2487 | 2487 | +0/-0 | | Facility: PDU Port Disabled | 4564 | 4564 | +0/-0 | | Transit Port Traffic warning | 11 | 11 | +0/-0 | | Facility: UPS Temperature | 31 | 31 | +0/-0 | | Facility: UPS Temperature (critical) | 41 | 41 | +0/-0 | | Facility: Status alert | 5775 | 5775 | +0/-0 | | Facility: Status warning | 5775 | 5775 | +0/-0 | | Facility: Device Down | 232 | 232 | +0/-0 | | Device Load Average > 8 | 1 | 1 | +0/-0 | | Uplink port down | 621 | 621 | +0/-0 | | Test pdu outlet descriptions missing | 26 | 26 | +0/-0 | | Remote site ISP down (15m) | 54 | 54 | +0/-0 | | Server disk usage > 90% | 73 | 73 | +0/-0 | | Remote site Port Discards | 8215 | 8215 | +0/-0 | | Test Remote Site Unused Port | 0 | 0 | +0/-0 | | PaloAlto Port Errors | 424 | 424 | +0/-0 | | BGP on PA in datacenter down | 26 | 26 | +0/-0 | | Juniper rescue configuration too old | 88 | 88 | +0/-0 | | Facility: Sensor LCL | 3 | 3 | +0/-0 | | F5 Pool not healthy | 26 | 26 | +0/-0 | | F5 Virtual Server not ok | 216 | 216 | +0/-0 | | Eurofiber R30 Port Traffic Warning | 1 | 1 | +0/-0 | | Eurofiber R30 Port Traffic Alert | 1 | 1 | +0/-0 | | BGP on PA in remote site down | 108 | 108 | +0/-0 | | F5 disk usage > 95% | 248 | 248 | +0/-0 | +--------------------------------------+-------------------+-------+---------+ ./discovery.php: ups-a-be-wav-01.winnet.local - 1 devices discovered in 2.2633 secs SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1755677968'] SQL RUNTIME[0.00019002s] NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.  o Devices Discovered (Total) 1 (1)  o Discovery Time  2.2633 secs  o Definitions  0.12976884841919 secs  o Memory usage  32MB (peak: 34MB)  o MySQL Usage  Cell[8/0.004s] Row[32/0.014s] Rows[247/0.529s] Column[12/0.006s] Update[1/0.002s] Insert[1/0.001s] Delete[2/0.002s]  o RRDTool Usage