DEBUG! CMD[/usr/bin/svn info /opt/observium]  CMD EXITCODE[0] CMD RUNTIME[0.0113s] 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.0088s] STDOUT[ bankdelen-6160660 ] DEFINITIONS Time : 0.128685 ms DEFINITIONS Memory: 4.02MB SQL[SELECT * FROM `observium_attribs`] SQL RUNTIME[0.0001049s]  SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[8.297E-5s]  SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'] SQL RUNTIME[3.29E-5s] DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);] SQL RUNTIME[5.007E-5s] DB timezone different from php timezone. Syncing.. SQL[SELECT VERSION();] SQL RUNTIME[2.813E-5s]  SQL[SET SESSION time_zone='+00:00';] SQL RUNTIME[2.503E-5s]  SQL[SELECT * FROM `config`] SQL RUNTIME[3.505E-5s]  CMD[/sbin/fping -v 2>&1]  CMD EXITCODE[0] CMD RUNTIME[0.0027s] STDOUT[ /sbin/fping: Version 5.0 ]  SQL[SELECT EXISTS (SELECT 1 FROM `pollers`)] SQL RUNTIME[6.485E-5s]  ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 25.6.14097 https://www.observium.org   CMD[/opt/observium/scripts/distro]  CMD EXITCODE[0] CMD RUNTIME[0.027s] 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.0033s] STDOUT[ Python 3.9.21 ]  SQL[SELECT VERSION();] SQL RUNTIME[0.0007081s]  CMD[/usr/bin/snmpget --version 2>&1]  CMD EXITCODE[0] CMD RUNTIME[0.0035s] 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.0048s] STDOUT[ /sbin/fping: Version 5.0 ]  CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']  CMD EXITCODE[0] CMD RUNTIME[0.0059s] STDOUT[ ]  CMD[/usr/sbin/httpd -v | awk '/Server version:/ {print $3}']  CMD EXITCODE[0] CMD RUNTIME[0.0287s] STDOUT[ Apache/2.4.62 ]  SQL[SELECT @@SESSION.sql_mode;] SQL RUNTIME[0.00024104s]  SQL[SHOW VARIABLES LIKE 'log_bin'] SQL RUNTIME[0.00060105s]  SQL[SHOW VARIABLES LIKE 'character_set_connection'] SQL RUNTIME[0.00047612s]  ##### 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:32:01 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:32:01 #####   SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `device_id` = '174' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME[0.00050092s] Return cached 'ups-a-be-abp-01.winnet.local' = '' CMD[/usr/bin/snmpget -t '5' -v1 -c *** -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-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.0219s] STDOUT[ .1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.8072.3.2.10 .1.3.6.1.2.1.1.3.0 = 133:15:22:00.47 ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '174'] SQL RUNTIME[0.00011802s]  SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '174' AND `poller_id` = '0'] SQL RUNTIME[0.00040793s]  SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('615900','discovery.php','533227','0','php ./discovery.php -d -h 174','1755693120','174')] SQL RUNTIME[0.00064802s] ##### ups-a-be-abp-01.winnet.local [174] #####   o OS Type  netvision-ng  o OS Group  ups  o SNMP Version  v1  o Last discovery  2025-08-20 10:37:14  o Last duration  3.58 seconds ##### Module Start: os #####   CMD[/usr/bin/snmpget -t '5' -v1 -c *** -Pud -Ir -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' sysDescr.0]  CMD EXITCODE[0] CMD RUNTIME[0.0194s] CMD EXITDELAY[5ms] STDOUT[ Linux localhost.localdomain 2.6.37.6-lsp-3.2.5_stm24_0012-spear3xx #38 Fri Oct 21 10:48:19 CST 2016 armv5tejl ] SNMP STATUS[TRUE] Store in cache OID: SNMPv2-MIB::sysDescr.0 CMD[/usr/bin/snmpget -t '5' -v1 -c *** -Pud -Ir -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' sysObjectID.0]  CMD EXITCODE[0] CMD RUNTIME[0.021s] STDOUT[ .1.3.6.1.4.1.8072.3.2.10 ] SNMP STATUS[TRUE] +-------------+---------------------------------------------------------------------------------------------------------------+ | OID | | +-------------+---------------------------------------------------------------------------------------------------------------+ | sysDescr | Linux localhost.localdomain 2.6.37.6-lsp-3.2.5_stm24_0012-spear3xx #38 Fri Oct 21 10:48:19 CST 2016 armv5tejl | | sysObjectID | .1.3.6.1.4.1.8072.3.2.10 | +-------------+---------------------------------------------------------------------------------------------------------------+ CMD[/usr/bin/snmpget -t '5' -v1 -c *** -Pud -Ir -OQUv -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsIdentAgentSoftwareVersion.0]  CMD EXITCODE[0] CMD RUNTIME[0.0223s] STDOUT[ Net Vision 7 v7.40 ] SNMP STATUS[TRUE] Store in cache OID: SOCOMECUPS7-MIB::upsIdentAgentSoftwareVersion.0  o Re-Detect OS matched (netvision-ng: NetVision UPS):  +-------------------------------------------------+--------------------------+---------------------------------------------------------------------------------------------------------------+ | OID | Matched definition | | +-------------------------------------------------+--------------------------+---------------------------------------------------------------------------------------------------------------+ | sysObjectID | .1.3.6.1.4.1.8072.3.2.10 | .1.3.6.1.4.1.8072.3.2.10 | | sysDescr | /^Linux / | Linux localhost.localdomain 2.6.37.6-lsp-3.2.5_stm24_0012-spear3xx #38 Fri Oct 21 10:48:19 CST 2016 armv5tejl | | SOCOMECUPS7-MIB::upsIdentAgentSoftwareVersion.0 | /^Net Vision/ | Net Vision 7 v7.40 | +-------------------------------------------------+--------------------------+---------------------------------------------------------------------------------------------------------------+  o Duration  0.0917s ##### 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.0112s] 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 -t '5' -v1 -c *** -Pud -Ir -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' .1.3.6.1.2.1.1.9.1.2]  CMD EXITCODE[0] CMD RUNTIME[0.0821s] STDOUT[ .1.3.6.1.2.1.1.9.1.2.1 = .1.3.6.1.6.3.11.2.3.1.1 .1.3.6.1.2.1.1.9.1.2.2 = .1.3.6.1.6.3.15.2.1.1 .1.3.6.1.2.1.1.9.1.2.3 = .1.3.6.1.6.3.10.3.1.1 .1.3.6.1.2.1.1.9.1.2.4 = .1.3.6.1.6.3.1 .1.3.6.1.2.1.1.9.1.2.5 = .1.3.6.1.2.1.49 .1.3.6.1.2.1.1.9.1.2.6 = .1.3.6.1.2.1.4 .1.3.6.1.2.1.1.9.1.2.7 = .1.3.6.1.2.1.50 .1.3.6.1.2.1.1.9.1.2.8 = .1.3.6.1.6.3.16.2.2.1 .1.3.6.1.2.1.1.9.1.2.9 = .1.3.6.1.6.3.13.3.1.3 .1.3.6.1.2.1.1.9.1.2.10 = .1.3.6.1.2.1.92 ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' sysORDescr]  CMD EXITCODE[0] CMD RUNTIME[0.083s] STDOUT[ sysORDescr.1 = The MIB for Message Processing and Dispatching. sysORDescr.2 = The MIB for Message Processing and Dispatching. sysORDescr.3 = The SNMP Management Architecture MIB. sysORDescr.4 = The MIB module for SNMPv2 entities sysORDescr.5 = The MIB module for managing TCP implementations sysORDescr.6 = The MIB module for managing IP and ICMP implementations sysORDescr.7 = The MIB module for managing UDP implementations sysORDescr.8 = View-based Access Control Model for SNMP. sysORDescr.9 = The MIB modules for managing SNMP Notification, plus filtering. sysORDescr.10 = The MIB module for logging SNMP Notifications. ] SNMP STATUS[TRUE]  CMD[/usr/bin/snmpget -t '5' -v1 -c *** -Pud -Ir -OQUv -m OSPFV3-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ospfv3AdminStatus.0]  CMD EXITCODE[2] CMD RUNTIME[0.0254s] 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  TCP-MIB UDP-MIB +-------------------------+--------------------+-----------+----------------------------------+ | Identity | MIB | Source | Status | +-------------------------+--------------------+-----------+----------------------------------+ | .1.3.6.1.6.3.1 | SNMPv2-MIB | sysORID | MIB already defined | | .1.3.6.1.2.1.4 | IP-MIB | sysORID | MIB already defined | | .1.3.6.1.2.1.49 | TCP-MIB | sysORID | MIB added | | .1.3.6.1.2.1.50 | UDP-MIB | sysORID | MIB added | | .1.3.6.1.6.3.10.3.1.1 | SNMP-FRAMEWORK-MIB | sysORID | MIB already defined | | | SOCOMECUPS7-MIB | Discovery | MIB defined for os but not found | | .1.3.6.1.6.3.11.2.3.1.1 | - | sysORID | Unknown Identity | | .1.3.6.1.6.3.15.2.1.1 | - | sysORID | Unknown Identity | | .1.3.6.1.6.3.16.2.2.1 | - | sysORID | Unknown Identity | | .1.3.6.1.6.3.13.3.1.3 | - | sysORID | Unknown Identity | | .1.3.6.1.2.1.92 | - | sysORID | Unknown Identity | +-------------------------+--------------------+-----------+----------------------------------+ SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '174' AND `use` = 'mib' AND `disabled` = '1'] SQL RUNTIME[0.0001061s] Array ( [0] => TCP-MIB [1] => UDP-MIB [2] => SOCOMECUPS7-MIB [3] => SOCOMECUPS-MIB [4] => SNMPv2-MIB [5] => SNMP-FRAMEWORK-MIB [6] => IF-MIB [7] => ADSL-LINE-MIB [8] => EtherLike-MIB [9] => ENTITY-MIB [10] => ENTITY-SENSOR-MIB [11] => UCD-SNMP-MIB [12] => HOST-RESOURCES-MIB [13] => Q-BRIDGE-MIB [14] => IP-MIB [15] => IPV6-MIB [16] => LLDP-MIB [17] => CISCO-CDP-MIB [18] => DISMAN-PING-MIB )  o Duration  0.2132s ##### Module Start: ports #####   o Caching OIDs  ifDescr SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ifDescr]  CMD EXITCODE[0] CMD RUNTIME[0.0489s] STDOUT[ ifDescr.1 = lo ifDescr.2 = eth0 ifDescr.3 = sit0 ifDescr.4 = ip6tnl0 ] SNMP STATUS[TRUE] ifAlias SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ifAlias]  CMD EXITCODE[0] CMD RUNTIME[0.0479s] STDOUT[ ifAlias.1 = ifAlias.2 = ifAlias.3 = ifAlias.4 = ] SNMP STATUS[TRUE] ifName SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ifName]  CMD EXITCODE[0] CMD RUNTIME[0.0523s] STDOUT[ ifName.1 = lo ifName.2 = eth0 ifName.3 = sit0 ifName.4 = ip6tnl0 ] SNMP STATUS[TRUE] ifType SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ifType]  CMD EXITCODE[0] CMD RUNTIME[0.0486s] STDOUT[ ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifType.3 = tunnel ifType.4 = tunnel ] SNMP STATUS[TRUE] ifOperStatus SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ifOperStatus]  CMD EXITCODE[0] CMD RUNTIME[0.0451s] STDOUT[ ifOperStatus.1 = up ifOperStatus.2 = up ifOperStatus.3 = down ifOperStatus.4 = down ] SNMP STATUS[TRUE]  Array ( [1] => Array ( [ifDescr] => lo [ifAlias] => [ifName] => lo [ifType] => softwareLoopback [ifOperStatus] => up ) [2] => Array ( [ifDescr] => eth0 [ifAlias] => [ifName] => eth0 [ifType] => ethernetCsmacd [ifOperStatus] => up ) [3] => Array ( [ifDescr] => sit0 [ifAlias] => [ifName] => sit0 [ifType] => tunnel [ifOperStatus] => down ) [4] => Array ( [ifDescr] => ip6tnl0 [ifAlias] => [ifName] => ip6tnl0 [ifType] => tunnel [ifOperStatus] => down ) )  o Caching DB   SQL[SELECT * FROM `ports` WHERE `device_id` = '174'] SQL RUNTIME[0.00049901s] 4 ports  o Discovering ports   ifIndex 1 (ifAdminStatus = , ifOperStatus = up). . ifIndex 2 (ifAdminStatus = , ifOperStatus = up). . ifIndex 3 (ifAdminStatus = , ifOperStatus = down). . ifIndex 4 (ifAdminStatus = , ifOperStatus = down). . +---------+---------+---------+---------+------------------+-------------+---------+ | ifIndex | ifDescr | ifName | ifAlias | ifType | Oper Status | Ignored | +---------+---------+---------+---------+------------------+-------------+---------+ | 1 | lo | lo | ... | softwareLoopback | up | no | | 2 | eth0 | eth0 | ... | ethernetCsmacd | up | no | | 3 | sit0 | sit0 | ... | tunnel | down | no | | 4 | ip6tnl0 | ip6tnl0 | ... | tunnel | down | no | +---------+---------+---------+---------+------------------+-------------+---------+  o Duration  0.2552s ##### Module Start: oids #####   SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '174'] SQL RUNTIME[0.00030398s]  SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1'] SQL RUNTIME[6.795E-5s]   o Duration  0.0016s ##### Module Start: ip-addresses #####   o IP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ipAdEntIfIndex]  CMD EXITCODE[0] CMD RUNTIME[0.0397s] STDOUT[ ipAdEntIfIndex.10.42.60.111 = 2 ipAdEntIfIndex.127.0.0.1 = 1 ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ipAdEntNetMask]  CMD EXITCODE[0] CMD RUNTIME[0.0407s] CMD EXITDELAY[5ms] STDOUT[ ipAdEntNetMask.10.42.60.111 = 255.255.255.0 ipAdEntNetMask.127.0.0.1 = 255.0.0.0 ] SNMP STATUS[TRUE] Added 10.42.60.111 .Added 127.0.0.1 .SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ipAddressIfIndex]  CMD EXITCODE[0] CMD RUNTIME[0.0586s] STDOUT[ ipAddressIfIndex.ipv4."10.42.60.111" = 2 ipAddressIfIndex.ipv4."10.42.60.255" = 2 ipAddressIfIndex.ipv4."127.0.0.1" = 1 ipAddressIfIndex.ipv6."00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01" = 1 ipAddressIfIndex.ipv6."fe:80:00:00:00:00:00:00:02:e0:d8:ff:fe:1e:2f:8b" = 2 ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ipAddressType]  CMD EXITCODE[0] CMD RUNTIME[0.1076s] STDOUT[ ipAddressType.ipv4."10.42.60.111" = unicast ipAddressType.ipv4."10.42.60.255" = broadcast ipAddressType.ipv4."127.0.0.1" = unicast ipAddressType.ipv6."00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01" = unicast ipAddressType.ipv6."fe:80:00:00:00:00:00:00:02:e0:d8:ff:fe:1e:2f:8b" = unicast ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ipAddressPrefix]  CMD EXITCODE[0] CMD RUNTIME[0.0553s] STDOUT[ ipAddressPrefix.ipv4."10.42.60.111" = ipAddressPrefixOrigin.2.ipv4."10.42.60.0".24 ipAddressPrefix.ipv4."10.42.60.255" = ipAddressPrefixOrigin.2.ipv4."10.42.60.0".24 ipAddressPrefix.ipv4."127.0.0.1" = ipAddressPrefixOrigin.1.ipv4."127.0.0.0".8 ipAddressPrefix.ipv6."00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01" = ipAddressPrefixOrigin.1.ipv6."00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01".128 ipAddressPrefix.ipv6."fe:80:00:00:00:00:00:00:02:e0:d8:ff:fe:1e:2f:8b" = ipAddressPrefixOrigin.2.ipv6."fe:80:00:00:00:00:00:00:00:00:00:00:00:00:00:00".64 ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ipAddressOrigin]  CMD EXITCODE[0] CMD RUNTIME[0.0532s] STDOUT[ ipAddressOrigin.ipv4."10.42.60.111" = manual ipAddressOrigin.ipv4."10.42.60.255" = manual ipAddressOrigin.ipv4."127.0.0.1" = manual ipAddressOrigin.ipv6."00:00:00:00:00:00:00:00:00:00:00:00:00:00:00:01" = manual ipAddressOrigin.ipv6."fe:80:00:00:00:00:00:00:02:e0:d8:ff:fe:1e:2f:8b" = linklayer ] SNMP STATUS[TRUE] Added 0000:0000:0000:0000:0000:0000:0000:0001 .Address fe80:0000:0000:0000:02e0:d8ff:fe1e:2f8b/64 marked as invalid by type [link-local]. Address 'fe80:0000:0000:0000:02e0:d8ff:fe1e:2f8b/64' skipped as invalid.  o IPV6-MIB    o LLDP-MIB   SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '174'] SQL RUNTIME[0.00028014s]  SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '174' AND `ifIndex` = '2' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[0.00014997s]  SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '35926'] SQL RUNTIME[0.00017595s]  SQL[SELECT DISTINCT `entity_type` FROM `entity_attribs` WHERE `device_id` = '174'] SQL RUNTIME[6.485E-5s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '35926'] SQL RUNTIME[3.695E-5s]  SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '10.42.60.0/24'] SQL RUNTIME[0.00025916s]  SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '174' AND `ifIndex` = '1' AND `deleted` = '0' LIMIT 1] SQL RUNTIME[0.00012994s]  SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '18281'] SQL RUNTIME[0.00020194s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '18281'] SQL RUNTIME[5.484E-5s]  SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '127.0.0.0/8'] SQL RUNTIME[0.00024819s]  SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '174'] SQL RUNTIME[5.698E-5s]  SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '174'] SQL RUNTIME[0.00019002s]  SQL[SELECT `ipv6_network_id` FROM `ipv6_networks` WHERE `ipv6_network` = '0:0:0:0:0:0:0:1/128'] SQL RUNTIME[0.00012803s]  SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '174'] SQL RUNTIME[5.198E-5s] +---------+---------+-------------+-----------------+---------------------+----------+--------+ | ifIndex | ifDescr | IP: Version | Address | Network | Type | Origin | +---------+---------+-------------+-----------------+---------------------+----------+--------+ | 2 | eth0 | IPv4 | 10.42.60.111/24 | 10.42.60.0/24 | private | | | 1 | lo | IPv4 | 127.0.0.1/8 | 127.0.0.0/8 | loopback | | | 1 | lo | IPv6 | ::1/128 | 0:0:0:0:0:0:0:1/128 | loopback | manual | +---------+---------+-------------+-----------------+---------------------+----------+--------+  o Changes  3 unchanged  o Duration  0.387s ##### Module Start: processors #####   o UCD-SNMP-MIB   SQL[SELECT EXISTS (SELECT 1 FROM `processors` WHERE `device_id` = '174' AND `processor_type` NOT IN ('ucd-old', 'ucd-raw'))] SQL RUNTIME[0.00031304s]  CMD[/usr/bin/snmpget -t '5' -v1 -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ssCpuIdle.0 ssCpuSystem.0 ssCpuUser.0 ssCpuRawIdle.0 ssCpuRawSystem.0]  CMD EXITCODE[0] CMD RUNTIME[0.0224s] STDOUT[ ssCpuIdle.0 = 63 ssCpuSystem.0 = 3 ssCpuUser.0 = 32 ssCpuRawIdle.0 = 714232105 ssCpuRawSystem.0 = 288796342 ] SNMP STATUS[TRUE] 174 -> 0, 0, ucd-old, CPU, 1, 63 SQL[SELECT * FROM `processors` WHERE `device_id` = '174' AND `processor_index` = '0' AND `processor_type` = 'ucd-old'] SQL RUNTIME[0.00030398s]   o HOST-RESOURCES-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' hrProcessorLoad]  CMD EXITCODE[0] CMD RUNTIME[0.0292s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `processors` WHERE `device_id` = '174'] SQL RUNTIME[0.0004468s] 0 -> ucd-old Array ( [ucd-old] => Array ( [0] => 1 ) )  o Changes  1 unchanged  o Duration  0.0585s ##### Module Start: mempools #####   o UCD-SNMP-MIB   CMD[/usr/bin/snmpget -t '5' -v1 -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' memTotalReal.0 memAvailReal.0 memBuffer.0 memCached.0]  CMD EXITCODE[0] CMD RUNTIME[0.028s] STDOUT[ memTotalReal.0 = 123564 memAvailReal.0 = 29588 memBuffer.0 = 824 memCached.0 = 20660 ] SNMP STATUS[TRUE]  CMD[/usr/bin/snmpget -t '5' -v1 -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' versionTag.0 versionCDate.0 versionConfigureOptions.0]  CMD EXITCODE[0] CMD RUNTIME[0.02s] STDOUT[ versionTag.0 = 5.7 versionCDate.0 = Wed Aug 20 14:32:02 2025 versionConfigureOptions.0 = '--prefix=/home/minglu/USHA/nv7/target' '--host=armv5-linux' '--with-logfile=none' '--with-sys-location=Unknown' '--with-sys-contact=support@netvesion.com' '--with-default-snmp-version=1' '--with-persistent-directory=/var/net-snmp' '--disable-embedded-perl' '--with-perl-modules=no' '--disable-perl-cc-checks' '--enable-ipv6' '--with-endianness=little' '--with-mib-modules=netvision7/netvision7 nv6/nv6 rfc1628/rfc1628' '--sysconfdir=/etc' '--with-out-mib-modules=disman/event disman/schedule host' '--mandir=/home/minglu/USHA/nv7/target/usr/man' '--datadir=/usr/share' '--exec_prefix=/home/minglu/USHA/nv7/target/usr' 'CFLAGS=-I/home/minglu/USHA/nv7/app/include' 'LDFLAGS=-L/home/minglu/USHA/nv7/target/usr/lib' 'CPPFLAGS=-I/home/minglu/USHA/nv7/app/include' 'VAL_LIBS=-lobj -lcommon' 'host_alias=armv5-linux' 'CC=armv5-linux-gcc' ] SNMP STATUS[TRUE] 174 -> 0, UCD-SNMP-MIB::, Physical Memory, 1, 126529536, 74231808 SQL[SELECT * FROM `mempools` WHERE `device_id` = '174' AND `mempool_index` = '0' AND `mempool_mib` = 'UCD-SNMP-MIB'] SQL RUNTIME[0.00045109s]   o HOST-RESOURCES-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' hrStorageEntry]  CMD EXITCODE[0] CMD RUNTIME[0.029s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `mempools` WHERE `device_id` = '174'] SQL RUNTIME[0.00022602s] 0 -> UCD-SNMP-MIB Array ( [UCD-SNMP-MIB] => Array ( [0] => 1 ) )  o Changes  1 unchanged  o Duration  0.0846s ##### Module Start: inventory #####   o ENTITY-MIB  ENTITY-MIB SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhysicalEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0809s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' entAliasMappingIdentifier]  CMD EXITCODE[0] CMD RUNTIME[0.0299s] STDOUT[ ] SNMP STATUS[TRUE]   o HOST-RESOURCES-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' hrDeviceEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0307s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' hrProcessorEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0283s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `hrDevice` WHERE `device_id` = '174'] SQL RUNTIME[0.000211s]  SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '174'] SQL RUNTIME[0.00028586s]   o Duration  0.1781s ##### Module Start: printersupplies #####   SQL[SELECT * FROM `printersupplies` WHERE `device_id` = '174'] SQL RUNTIME[0.00032997s]   o Duration  0.0009s ##### Module Start: sensors #####   o SOCOMECUPS7-MIB  upsAmbientTemperature [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsAmbientTemperature']  CMD EXITCODE[0] CMD RUNTIME[0.0136s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.2.7 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsAmbientTemperature' -> '.1.3.6.1.4.1.4555.1.1.7.1.2.7' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsAmbientTemperature]  CMD EXITCODE[0] CMD RUNTIME[0.0268s] STDOUT[ upsAmbientTemperature.0 = 180 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsAmbientTemperature Discover sensor: [class: temperature, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.2.7.0, index: 0, type: SOCOMECUPS7-MIB-upsAmbientTemperature, descr: Ambient, scale: 0.1, limits: (, , , ), CURRENT: 18, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsAmbientTemperature' AND `sensor_index` = '0')] SQL RUNTIME[0.00037408s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsAmbientTemperature' AND `sensor_index` = '0'] SQL RUNTIME[0.00020504s] L+-----------------+-------+-------------+ | Limit Param | Value | Previous | +-----------------+-------+-------------+ | Value | 18 | | | Scale | 0.1 | | | ----- | ----- | ----- | | Auto | TRUE | | | limit_high | 28.8 | 30.4 (AUTO) | | limit_high_warn | -- | -- | | limit_low | 0 | 0 | | limit_low_warn | -- | -- | +-----------------+-------+-------------+ SQL[SELECT * FROM `sensors` WHERE `sensors`.`sensor_id` = '6002'] SQL RUNTIME[0.00014305s]  SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('174','6002','sensor',NOW(),'6','Sensor updated (limits): limit_high -> \"28.8\"')] SQL RUNTIME[0.0026691s]  SQL[UPDATE `sensors` SET `sensor_limit` ='28.8' WHERE `sensor_id` = '6002'] SQL RUNTIME[0.00054502s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '6002'] SQL RUNTIME[0.00014997s] .] upsBatteryTemperature [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsBatteryTemperature']  CMD EXITCODE[0] CMD RUNTIME[0.0113s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.2.6 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsBatteryTemperature' -> '.1.3.6.1.4.1.4555.1.1.7.1.2.6' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsBatteryTemperature]  CMD EXITCODE[0] CMD RUNTIME[0.029s] STDOUT[ upsBatteryTemperature.0 = 0 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsBatteryTemperature Excluded by sensor 'upsBatteryTemperature' value '0' is equals or below min [0]. ] upsBatteryVoltage [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsBatteryVoltage']  CMD EXITCODE[0] CMD RUNTIME[0.0125s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.2.5 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsBatteryVoltage' -> '.1.3.6.1.4.1.4555.1.1.7.1.2.5' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsBatteryVoltage]  CMD EXITCODE[0] CMD RUNTIME[0.028s] STDOUT[ upsBatteryVoltage.0 = 814 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsBatteryVoltage Discover sensor: [class: voltage, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.2.5.0, index: 0, type: SOCOMECUPS7-MIB-upsBatteryVoltage, descr: Battery, scale: 0.1, limits: (, , , ), CURRENT: 81.4, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsBatteryVoltage' AND `sensor_index` = '0')] SQL RUNTIME[0.00053096s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsBatteryVoltage' AND `sensor_index` = '0'] SQL RUNTIME[0.0002532s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '9500'] SQL RUNTIME[0.00029302s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-voltage-netvision-upsBatteryVoltage.0.rrd' ] upsBatteryCurrent [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsBatteryCurrent']  CMD EXITCODE[0] CMD RUNTIME[0.013s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.2.8 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsBatteryCurrent' -> '.1.3.6.1.4.1.4555.1.1.7.1.2.8' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsBatteryCurrent]  CMD EXITCODE[0] CMD RUNTIME[0.0323s] STDOUT[ upsBatteryCurrent.0 = 65535 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsBatteryCurrent Discover sensor: [class: current, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.2.8.0, index: 0, type: SOCOMECUPS7-MIB-upsBatteryCurrent, descr: Battery, scale: 0.1, limits: (, , , ), CURRENT: 6553.5, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsBatteryCurrent' AND `sensor_index` = '0')] SQL RUNTIME[0.00043082s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsBatteryCurrent' AND `sensor_index` = '0'] SQL RUNTIME[0.00046515s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '6003'] SQL RUNTIME[0.00018597s] .] upsOutputKva [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsOutputKva']  CMD EXITCODE[0] CMD RUNTIME[0.0129s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.4.4.1.5 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsOutputKva' -> '.1.3.6.1.4.1.4555.1.1.7.1.4.4.1.5' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputKva]  CMD EXITCODE[0] CMD RUNTIME[0.028s] STDOUT[ upsOutputKva.1 = 65535 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsOutputKva Discover sensor: [class: apower, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.4.4.1.5.1, index: 1, type: SOCOMECUPS7-MIB-upsOutputKva, descr: Output Phase 1, scale: 100, limits: (, , , ), CURRENT: 6553500, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'apower' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsOutputKva' AND `sensor_index` = '1')] SQL RUNTIME[0.00036502s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'apower' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsOutputKva' AND `sensor_index` = '1'] SQL RUNTIME[0.00029302s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '6004'] SQL RUNTIME[0.00014901s] .] upsOutputKw [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsOutputKw']  CMD EXITCODE[0] CMD RUNTIME[0.0124s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.4.4.1.6 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsOutputKw' -> '.1.3.6.1.4.1.4555.1.1.7.1.4.4.1.6' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputKw]  CMD EXITCODE[0] CMD RUNTIME[0.0292s] STDOUT[ upsOutputKw.1 = 65535 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsOutputKw Excluded by sensor 'upsOutputKw' value '65535' in invalid range [65535]. ] upsOutputGlobalkVA [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsOutputGlobalkVA']  CMD EXITCODE[0] CMD RUNTIME[0.0126s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.4.5 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsOutputGlobalkVA' -> '.1.3.6.1.4.1.4555.1.1.7.1.4.5' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputGlobalkVA]  CMD EXITCODE[0] CMD RUNTIME[0.0269s] STDOUT[ upsOutputGlobalkVA.0 = 65533 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsOutputGlobalkVA Discover sensor: [class: apower, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.4.5.0, index: 0, type: SOCOMECUPS7-MIB-upsOutputGlobalkVA, descr: Output Total, scale: 100, limits: (, , , ), CURRENT: 6553300, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'apower' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsOutputGlobalkVA' AND `sensor_index` = '0')] SQL RUNTIME[0.00039601s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'apower' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsOutputGlobalkVA' AND `sensor_index` = '0'] SQL RUNTIME[0.00021505s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '6005'] SQL RUNTIME[0.00023293s] .] upsOutputGlobalkW [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsOutputGlobalkW']  CMD EXITCODE[0] CMD RUNTIME[0.0119s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.4.6 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsOutputGlobalkW' -> '.1.3.6.1.4.1.4555.1.1.7.1.4.6' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputGlobalkW]  CMD EXITCODE[0] CMD RUNTIME[0.028s] STDOUT[ upsOutputGlobalkW.0 = 65535 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsOutputGlobalkW Excluded by sensor 'upsOutputGlobalkW' value '65535' in invalid range [65535]. ] upsOutputLoadRate [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsOutputLoadRate']  CMD EXITCODE[0] CMD RUNTIME[0.0112s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.4.7 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsOutputLoadRate' -> '.1.3.6.1.4.1.4555.1.1.7.1.4.7' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputLoadRate]  CMD EXITCODE[0] CMD RUNTIME[0.0289s] STDOUT[ upsOutputLoadRate.0 = 12 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsOutputLoadRate Discover sensor: [class: load, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.4.7.0, index: 0, type: SOCOMECUPS7-MIB-upsOutputLoadRate, descr: Output Total, scale: 1, limits: (, , , ), CURRENT: 12, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'load' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsOutputLoadRate' AND `sensor_index` = '0')] SQL RUNTIME[0.00045419s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'load' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsOutputLoadRate' AND `sensor_index` = '0'] SQL RUNTIME[0.00028419s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '6006'] SQL RUNTIME[0.00011587s] .] upsBypassFrequency [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::upsBypassFrequency']  CMD EXITCODE[0] CMD RUNTIME[0.0144s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.5.1 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::upsBypassFrequency' -> '.1.3.6.1.4.1.4555.1.1.7.1.5.1' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsBypassFrequency]  CMD EXITCODE[0] CMD RUNTIME[0.0303s] STDOUT[ upsBypassFrequency.0 = 500 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsBypassFrequency Discover sensor: [class: frequency, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.5.1.0, index: 0, type: SOCOMECUPS7-MIB-upsBypassFrequency, descr: Bypass, scale: 0.1, limits: (, , , ), CURRENT: 50, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsBypassFrequency' AND `sensor_index` = '0')] SQL RUNTIME[0.00060105s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS7-MIB-upsBypassFrequency' AND `sensor_index` = '0'] SQL RUNTIME[0.000314s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '6007'] SQL RUNTIME[0.00018191s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-frequency-netvision-upsBypassFrequency.0.rrd' ]  o SOCOMECUPS7-MIB  upsBatteryStatus [SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsBatteryStatus]  CMD EXITCODE[0] CMD RUNTIME[0.0304s] STDOUT[ upsBatteryStatus.0 = batteryCharging ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsBatteryStatus Discover status: [device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.2.1.0, index: 0, type: upsBatteryStatus, descr: Battery Status, CURRENT: batteryCharging, , battery] SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '174' AND `status_mib` = 'SOCOMECUPS7-MIB' AND `status_object` = 'upsBatteryStatus' AND `status_type` = 'upsBatteryStatus' AND `status_index` = '0' AND `poller_type`= 'snmp')] SQL RUNTIME[0.00039196s]  SQL[SELECT * FROM `status` WHERE `device_id` = '174' AND `status_mib` = 'SOCOMECUPS7-MIB' AND `status_object` = 'upsBatteryStatus' AND `status_type` = 'upsBatteryStatus' AND `status_index` = '0' AND `poller_type`= 'snmp'] SQL RUNTIME[0.00022197s] .] upsOutputSource [SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputSource]  CMD EXITCODE[0] CMD RUNTIME[0.0298s] STDOUT[ upsOutputSource.0 = ecoMode ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::upsOutputSource Discover status: [device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.4.1.0, index: 0, type: upsOutputSource, descr: Output Source, CURRENT: ecoMode, , device] SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '174' AND `status_mib` = 'SOCOMECUPS7-MIB' AND `status_object` = 'upsOutputSource' AND `status_type` = 'upsOutputSource' AND `status_index` = '0' AND `poller_type`= 'snmp')] SQL RUNTIME[0.000453s]  SQL[SELECT * FROM `status` WHERE `device_id` = '174' AND `status_mib` = 'SOCOMECUPS7-MIB' AND `status_object` = 'upsOutputSource' AND `status_type` = 'upsOutputSource' AND `status_index` = '0' AND `poller_type`= 'snmp'] SQL RUNTIME[0.00020409s] .] emdStatusIn1Active [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::emdStatusIn1Active']  CMD EXITCODE[0] CMD RUNTIME[0.0155s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.10.3 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::emdStatusIn1Active' -> '.1.3.6.1.4.1.4555.1.1.7.1.10.3' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' emdStatusIn1Active]  CMD EXITCODE[0] CMD RUNTIME[0.032s] STDOUT[ emdStatusIn1Active.0 = disabled ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::emdStatusIn1Active Discover status: [device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.10.3.0, index: 0, type: emdStatus, descr: EMD Input 1, CURRENT: disabled, , device] Skipped by 'exclude' event value: , EMD Input 1 ] emdStatusIn2Active [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS7-MIB::emdStatusIn2Active']  CMD EXITCODE[0] CMD RUNTIME[0.0163s] STDOUT[ .1.3.6.1.4.1.4555.1.1.7.1.10.4 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS7-MIB::emdStatusIn2Active' -> '.1.3.6.1.4.1.4555.1.1.7.1.10.4' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS7-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' emdStatusIn2Active]  CMD EXITCODE[0] CMD RUNTIME[0.0461s] STDOUT[ emdStatusIn2Active.0 = disabled ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS7-MIB::emdStatusIn2Active Discover status: [device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.7.1.10.4.0, index: 0, type: emdStatus, descr: EMD Input 2, CURRENT: disabled, , device] Skipped by 'exclude' event value: , EMD Input 2 ]  o SOCOMECUPS-MIB  upsEstimatedChargeRemaining [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsEstimatedChargeRemaining']  CMD EXITCODE[0] CMD RUNTIME[0.0118s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.2.4 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsEstimatedChargeRemaining' -> '.1.3.6.1.4.1.4555.1.1.1.1.2.4' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsEstimatedChargeRemaining]  CMD EXITCODE[0] CMD RUNTIME[0.0255s] STDOUT[ upsEstimatedChargeRemaining.0 = 100 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsEstimatedChargeRemaining Discover sensor: [class: capacity, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.2.4.0, index: 0, type: SOCOMECUPS-MIB-upsEstimatedChargeRemaining, descr: Battery Charge Remaining, scale: 1, limits: (15, 30, , ), CURRENT: 100, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'capacity' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsEstimatedChargeRemaining' AND `sensor_index` = '0')] SQL RUNTIME[0.00065613s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'capacity' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsEstimatedChargeRemaining' AND `sensor_index` = '0'] SQL RUNTIME[0.00032902s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4439'] SQL RUNTIME[0.00018311s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-capacity-netvision-upsEstimatedChargeRemaining.0.rrd' ] upsEstimatedMinutesRemaining [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsEstimatedMinutesRemaining']  CMD EXITCODE[0] CMD RUNTIME[0.0123s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.2.3 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsEstimatedMinutesRemaining' -> '.1.3.6.1.4.1.4555.1.1.1.1.2.3' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsEstimatedMinutesRemaining]  CMD EXITCODE[0] CMD RUNTIME[0.0311s] STDOUT[ upsEstimatedMinutesRemaining.0 = 65535 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsEstimatedMinutesRemaining Discover sensor: [class: runtime, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.2.3.0, index: 0, type: SOCOMECUPS-MIB-upsEstimatedMinutesRemaining, descr: Battery Runtime Remaining, scale: 1, limits: (5, 8, , ), CURRENT: 65535, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'runtime' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsEstimatedMinutesRemaining' AND `sensor_index` = '0')] SQL RUNTIME[0.00038695s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'runtime' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsEstimatedMinutesRemaining' AND `sensor_index` = '0'] SQL RUNTIME[0.00019097s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4440'] SQL RUNTIME[0.00010705s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-runtime-netvision-upsEstimatedMinutesRemaining.0.rrd' ] upsSecondsOnBattery [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsSecondsOnBattery']  CMD EXITCODE[0] CMD RUNTIME[0.0118s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.2.2 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsSecondsOnBattery' -> '.1.3.6.1.4.1.4555.1.1.1.1.2.2' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsSecondsOnBattery]  CMD EXITCODE[0] CMD RUNTIME[0.0382s] STDOUT[ upsSecondsOnBattery.0 = 0 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsSecondsOnBattery Discover sensor: [class: runtime, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.2.2.0, index: 0, type: SOCOMECUPS-MIB-upsSecondsOnBattery, descr: Runtime On Battery, scale: 0.016666666666667, limits: (, , , ), CURRENT: 0, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'runtime' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsSecondsOnBattery' AND `sensor_index` = '0')] SQL RUNTIME[0.00050712s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'runtime' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsSecondsOnBattery' AND `sensor_index` = '0'] SQL RUNTIME[0.00023603s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4441'] SQL RUNTIME[0.00019908s] .] upsBatteryVoltage [Excluded by valid exist: voltage->SOCOMECUPS7-MIB-upsBatteryVoltage !]upsBatteryTemperature [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsBatteryTemperature']  CMD EXITCODE[0] CMD RUNTIME[0.0114s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.2.6 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsBatteryTemperature' -> '.1.3.6.1.4.1.4555.1.1.1.1.2.6' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsBatteryTemperature]  CMD EXITCODE[0] CMD RUNTIME[0.0284s] STDOUT[ upsBatteryTemperature.0 = 0 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsBatteryTemperature Excluded by sensor 'upsBatteryTemperature' value '0' is equals or below min [0]. ] upsInputFrequency [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsInputFrequency']  CMD EXITCODE[0] CMD RUNTIME[0.0123s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.3.2 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsInputFrequency' -> '.1.3.6.1.4.1.4555.1.1.1.1.3.2' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsInputFrequency]  CMD EXITCODE[0] CMD RUNTIME[0.0287s] STDOUT[ upsInputFrequency.0 = 500 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsInputFrequency Discover sensor: [class: frequency, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.3.2.0, index: 0, type: SOCOMECUPS-MIB-upsInputFrequency, descr: Input, scale: 0.1, limits: (, , , ), CURRENT: 50, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsInputFrequency' AND `sensor_index` = '0')] SQL RUNTIME[0.0006752s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsInputFrequency' AND `sensor_index` = '0'] SQL RUNTIME[0.00030518s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4444'] SQL RUNTIME[0.00015807s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-frequency-netvision-upsInputFrequency.0.rrd' ] upsInputVoltage [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsInputVoltage']  CMD EXITCODE[0] CMD RUNTIME[0.0124s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.3.3.1.2 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsInputVoltage' -> '.1.3.6.1.4.1.4555.1.1.1.1.3.3.1.2' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsInputVoltage]  CMD EXITCODE[0] CMD RUNTIME[0.0304s] STDOUT[ upsInputVoltage.1 = 2370 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsInputVoltage Discover sensor: [class: voltage, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.3.3.1.2.1, index: 1, type: SOCOMECUPS-MIB-upsInputVoltage, descr: Input Phase 1, scale: 0.1, limits: (, , , ), CURRENT: 237, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsInputVoltage' AND `sensor_index` = '1')] SQL RUNTIME[0.00047779s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsInputVoltage' AND `sensor_index` = '1'] SQL RUNTIME[0.00026393s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4445'] SQL RUNTIME[0.00037289s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-voltage-netvision-upsInputVoltage.1.rrd' ] upsInputCurrent [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsInputCurrent']  CMD EXITCODE[0] CMD RUNTIME[0.0128s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.3.3.1.3 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsInputCurrent' -> '.1.3.6.1.4.1.4555.1.1.1.1.3.3.1.3' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsInputCurrent]  CMD EXITCODE[0] CMD RUNTIME[0.028s] STDOUT[ upsInputCurrent.1 = 655350 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsInputCurrent Discover sensor: [class: current, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.3.3.1.3.1, index: 1, type: SOCOMECUPS-MIB-upsInputCurrent, descr: Input Phase 1, scale: 0.1, limits: (, , , ), CURRENT: 65535, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsInputCurrent' AND `sensor_index` = '1')] SQL RUNTIME[0.00034404s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsInputCurrent' AND `sensor_index` = '1'] SQL RUNTIME[0.00042605s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4446'] SQL RUNTIME[0.00015998s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-current-netvision-upsInputCurrent.1.rrd' ] upsOutputFrequency [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsOutputFrequency']  CMD EXITCODE[0] CMD RUNTIME[0.0121s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.4.2 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsOutputFrequency' -> '.1.3.6.1.4.1.4555.1.1.1.1.4.2' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputFrequency]  CMD EXITCODE[0] CMD RUNTIME[0.0282s] STDOUT[ upsOutputFrequency.0 = 500 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsOutputFrequency Discover sensor: [class: frequency, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.4.2.0, index: 0, type: SOCOMECUPS-MIB-upsOutputFrequency, descr: Output, scale: 0.1, limits: (, , , ), CURRENT: 50, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsOutputFrequency' AND `sensor_index` = '0')] SQL RUNTIME[0.00043297s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsOutputFrequency' AND `sensor_index` = '0'] SQL RUNTIME[0.0002141s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4447'] SQL RUNTIME[0.00022101s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-frequency-netvision-upsOutputFrequency.0.rrd' ] upsOutputVoltage [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsOutputVoltage']  CMD EXITCODE[0] CMD RUNTIME[0.011s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.4.4.1.2 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsOutputVoltage' -> '.1.3.6.1.4.1.4555.1.1.1.1.4.4.1.2' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputVoltage]  CMD EXITCODE[0] CMD RUNTIME[0.0297s] STDOUT[ upsOutputVoltage.1 = 2370 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsOutputVoltage Discover sensor: [class: voltage, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.4.4.1.2.1, index: 1, type: SOCOMECUPS-MIB-upsOutputVoltage, descr: Output Phase 1, scale: 0.1, limits: (, , , ), CURRENT: 237, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsOutputVoltage' AND `sensor_index` = '1')] SQL RUNTIME[0.00070286s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsOutputVoltage' AND `sensor_index` = '1'] SQL RUNTIME[0.00034285s] L+-----------------+--------+--------------+ | Limit Param | Value | Previous | +-----------------+--------+--------------+ | Value | 237 | | | Scale | 0.1 | | | ----- | ----- | ----- | | Auto | TRUE | | | limit_high | 272.55 | 246.1 (AUTO) | | limit_high_warn | -- | -- | | limit_low | 201.45 | 181.9 (AUTO) | | limit_low_warn | -- | -- | +-----------------+--------+--------------+ SQL[SELECT * FROM `sensors` WHERE `sensors`.`sensor_id` = '4448'] SQL RUNTIME[0.00032115s]  SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('174','4448','sensor',NOW(),'6','Sensor updated (limits): limit_high -> \"272.55\", limit_low -> \"201.45\"')] SQL RUNTIME[0.00204515s]  SQL[UPDATE `sensors` SET `sensor_limit` ='272.55',`sensor_limit_low` ='201.45' WHERE `sensor_id` = '4448'] SQL RUNTIME[0.00076795s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4448'] SQL RUNTIME[0.00027084s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-voltage-netvision-upsOutputVoltage.1.rrd' ] upsOutputCurrent [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsOutputCurrent']  CMD EXITCODE[0] CMD RUNTIME[0.0129s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.4.4.1.3 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsOutputCurrent' -> '.1.3.6.1.4.1.4555.1.1.1.1.4.4.1.3' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputCurrent]  CMD EXITCODE[0] CMD RUNTIME[0.0291s] STDOUT[ upsOutputCurrent.1 = 65535 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsOutputCurrent Discover sensor: [class: current, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.4.4.1.3.1, index: 1, type: SOCOMECUPS-MIB-upsOutputCurrent, descr: Output Phase 1, scale: 0.1, limits: (, , , ), CURRENT: 6553.5, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsOutputCurrent' AND `sensor_index` = '1')] SQL RUNTIME[0.00046992s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsOutputCurrent' AND `sensor_index` = '1'] SQL RUNTIME[0.00019789s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4449'] SQL RUNTIME[0.00011396s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-current-netvision-upsOutputCurrent.1.rrd' ] upsOutputPercentLoad [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsOutputPercentLoad']  CMD EXITCODE[0] CMD RUNTIME[0.0126s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.4.4.1.4 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsOutputPercentLoad' -> '.1.3.6.1.4.1.4555.1.1.1.1.4.4.1.4' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsOutputPercentLoad]  CMD EXITCODE[0] CMD RUNTIME[0.0296s] STDOUT[ upsOutputPercentLoad.1 = 12 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsOutputPercentLoad Discover sensor: [class: load, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.4.4.1.4.1, index: 1, type: SOCOMECUPS-MIB-upsOutputPercentLoad, descr: Output Phase 1, scale: 1, limits: (, , , ), CURRENT: 12, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'load' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsOutputPercentLoad' AND `sensor_index` = '1')] SQL RUNTIME[0.00031304s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'load' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsOutputPercentLoad' AND `sensor_index` = '1'] SQL RUNTIME[0.00019288s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4450'] SQL RUNTIME[0.00010085s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-capacity-netvision-upsOutputPercentLoad.1.rrd' ] upsOutputKva [Excluded by valid exist: apower->SOCOMECUPS7-MIB-upsOutputKva !]upsBypassFrequency [Excluded by valid exist: frequency->SOCOMECUPS7-MIB-upsBypassFrequency !]upsBypassVoltage [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsBypassVoltage']  CMD EXITCODE[0] CMD RUNTIME[0.0131s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.5.3.1.2 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsBypassVoltage' -> '.1.3.6.1.4.1.4555.1.1.1.1.5.3.1.2' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsBypassVoltage]  CMD EXITCODE[0] CMD RUNTIME[0.0273s] STDOUT[ upsBypassVoltage.1 = 2380 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsBypassVoltage Discover sensor: [class: voltage, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.5.3.1.2.1, index: 1, type: SOCOMECUPS-MIB-upsBypassVoltage, descr: Bypass Phase 1, scale: 0.1, limits: (, , , ), CURRENT: 238, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsBypassVoltage' AND `sensor_index` = '1')] SQL RUNTIME[0.00049901s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsBypassVoltage' AND `sensor_index` = '1'] SQL RUNTIME[0.00024509s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4453'] SQL RUNTIME[0.00013304s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-voltage-netvision-_.1.rrd' ] upsBypassCurrent [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::upsBypassCurrent']  CMD EXITCODE[0] CMD RUNTIME[0.0116s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.5.3.1.3 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::upsBypassCurrent' -> '.1.3.6.1.4.1.4555.1.1.1.1.5.3.1.3' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' upsBypassCurrent]  CMD EXITCODE[0] CMD RUNTIME[0.0289s] STDOUT[ upsBypassCurrent.1 = 65535 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::upsBypassCurrent Discover sensor: [class: current, device: ups-a-be-abp-01.winnet.local, oid: .1.3.6.1.4.1.4555.1.1.1.1.5.3.1.3.1, index: 1, type: SOCOMECUPS-MIB-upsBypassCurrent, descr: Bypass Phase 1, scale: 0.1, limits: (, , , ), CURRENT: 6553.5, , SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsBypassCurrent' AND `sensor_index` = '1')] SQL RUNTIME[0.00036907s]  SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '174' AND `sensor_type` = 'SOCOMECUPS-MIB-upsBypassCurrent' AND `sensor_index` = '1'] SQL RUNTIME[0.00032496s]  SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '4454'] SQL RUNTIME[0.00017118s] .RRD old file not found: '/opt/observium/rrd/ups-a-be-abp-01.winnet.local/sensor-current-netvision-upsBypassCurrent.1.rrd' ] emdSatatusTemperature [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::emdSatatusTemperature']  CMD EXITCODE[0] CMD RUNTIME[0.0126s] CMD EXITDELAY[5ms] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.11.1 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::emdSatatusTemperature' -> '.1.3.6.1.4.1.4555.1.1.1.1.11.1' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' emdSatatusTemperature]  CMD EXITCODE[0] CMD RUNTIME[0.0275s] STDOUT[ emdSatatusTemperature.0 = 0 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::emdSatatusTemperature Excluded by sensor 'emdSatatusTemperature' value '0' is equals or below min [0]. ] emdSatatusHumidity [ CMD[/usr/bin/snmptranslate -On -Pud -Ir -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'SOCOMECUPS-MIB::emdSatatusHumidity']  CMD EXITCODE[0] CMD RUNTIME[0.0146s] STDOUT[ .1.3.6.1.4.1.4555.1.1.1.1.11.2 ] SNMP TRANSLATE (CMD): 'SOCOMECUPS-MIB::emdSatatusHumidity' -> '.1.3.6.1.4.1.4555.1.1.1.1.11.2' SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Irh -OQUsb -m SOCOMECUPS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/socomec 'udp':'ups-a-be-abp-01.winnet.local':'161' emdSatatusHumidity]  CMD EXITCODE[0] CMD RUNTIME[0.0295s] STDOUT[ emdSatatusHumidity.0 = 0 ] SNMP STATUS[TRUE] Store in cache Table OID: SOCOMECUPS-MIB::emdSatatusHumidity Excluded by sensor 'emdSatatusHumidity' value '0' is equals or below min [0]. ]  o SOCOMECUPS-MIB  upsBatteryStatus [Excluded by valid exist: SOCOMECUPS7-MIB->upsBatteryStatus !]upsOutputSource [Excluded by valid exist: SOCOMECUPS7-MIB->upsOutputSource !]  o ENTITY-SENSOR-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhySensorValue]  CMD EXITCODE[0] CMD RUNTIME[0.0253s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhySensorType]  CMD EXITCODE[0] CMD RUNTIME[0.0375s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhySensorScale]  CMD EXITCODE[0] CMD RUNTIME[0.0291s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhySensorPrecision]  CMD EXITCODE[0] CMD RUNTIME[0.0306s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhySensorOperStatus]  CMD EXITCODE[0] CMD RUNTIME[0.0295s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhySensorUnitsDisplay]  CMD EXITCODE[0] CMD RUNTIME[0.0306s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhysicalDescr]  CMD EXITCODE[0] CMD RUNTIME[0.0711s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhysicalName]  CMD EXITCODE[0] CMD RUNTIME[0.0812s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhysicalClass]  CMD EXITCODE[0] CMD RUNTIME[0.0776s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhysicalContainedIn]  CMD EXITCODE[0] CMD RUNTIME[0.0711s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' entPhysicalParentRelPos]  CMD EXITCODE[0] CMD RUNTIME[0.0968s] STDOUT[ ] SNMP STATUS[TRUE] SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m ENTITY-MIB:IF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' entAliasMappingIdentifier]  CMD EXITCODE[0] CMD RUNTIME[0.0277s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00054288s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021696s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021791s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00021005s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.000211s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00035787s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00032997s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020695s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016093s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011897s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00015211s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00043893s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00015283s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00012112s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00020099s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00069404s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'attenuation' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00012302s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00012517s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[9.084E-5s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.000108s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'concentration' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[8.893E-5s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00014782s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00015998s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011516s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011396s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[8.202E-5s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[8.416E-5s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'distance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00024986s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00017285s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00012302s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00016904s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'age' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00015497s]  SQL[SELECT * FROM `sensors` WHERE `device_id` = '174' AND `sensor_class` = 'gauge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0'] SQL RUNTIME[0.00011301s]  SQL[SELECT * FROM `status` WHERE `device_id` = '174' AND `poller_type` = 'snmp' AND `status_deleted` = '0'] SQL RUNTIME[0.00011897s]  SQL[SELECT * FROM `counters` WHERE `device_id` = '174' AND `poller_type` = 'snmp' AND `counter_deleted` = '0'] SQL RUNTIME[0.00010896s]   o Duration  1.9952s ##### Module Start: storage #####   o UCD-SNMP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m UCD-SNMP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' dskEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0286s] STDOUT[ ] SNMP STATUS[TRUE]   o HOST-RESOURCES-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' hrStorageEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0303s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `storage` WHERE `device_id` = '174'] SQL RUNTIME[0.00037718s]   o Duration  0.0639s ##### Module Start: neighbours #####   o LLDP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m LLDP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' lldpRemChassisIdSubtype]  CMD EXITCODE[0] CMD RUNTIME[0.033s] STDOUT[ ] SNMP STATUS[TRUE]   o CISCO-CDP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -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-abp-01.winnet.local':'161' cdpCache]  CMD EXITCODE[0] CMD RUNTIME[0.0656s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `neighbours` WHERE `device_id` = '174'] SQL RUNTIME[0.00042009s]   o Duration  0.1045s ##### Module Start: arp-table #####   o IP-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUsX -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ipNetToPhysicalPhysAddress]  CMD EXITCODE[0] CMD RUNTIME[0.0337s] STDOUT[ ] SNMP STATUS[TRUE] Used IP-MIB::ipNetToPhysicalPhysAddress  o IPV6-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUsX -m IPV6-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' ipv6NetToMediaPhysAddress]  CMD EXITCODE[0] CMD RUNTIME[0.0341s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `ip_mac` WHERE `device_id` = '174'] SQL RUNTIME[0.00026107s]   o Duration  0.0726s ##### Module Start: mac-accounting #####    o Duration  0.0003s ##### Module Start: sla #####   o DISMAN-PING-MIB  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m DISMAN-PING-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' pingCtlEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0309s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `slas` WHERE `device_id` = '174'] SQL RUNTIME[0.00038505s]   o Duration  0.0336s ##### Module Start: ucd-diskio #####  SNMP v1 does not support bulk. CMD[/usr/bin/snmpwalk -t '5' -v1 -c *** -Pud -Ir -OQUs -m UCD-DISKIO-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ups-a-be-abp-01.winnet.local':'161' diskIOEntry]  CMD EXITCODE[0] CMD RUNTIME[0.0295s] STDOUT[ ] SNMP STATUS[TRUE]  SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '174'] SQL RUNTIME[0.00029612s]   o Duration  0.0319s ##### Module Start: graphs #####    o Duration  0.0003s  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` = '174';] SQL RUNTIME[0.00015211s]  SQL[UPDATE `devices` SET `last_discovered` =NOW(),`type` ='power',`last_discovered_timetaken` ='3.5769',`force_discovery` ='0',`device_state` ='a:9:{s:2:\"la\";a:3:{s:4:\"1min\";d:4.18;s:4:\"5min\";d:4.55;s:5:\"15min\";d:4.63;}s:8:\"ucd_load\";d:4.55;s:15:\"poller_mod_perf\";a:22:{s:6:\"system\";d:0.0882;s:2:\"os\";d:0.0703;s:7:\"sensors\";d:0.095;s:6:\"status\";d:0.0421;s:7:\"counter\";d:0.0006;s:10:\"processors\";d:0.0246;s:8:\"mempools\";d:0.0258;s:7:\"storage\";d:0.001;s:7:\"ucd-mib\";d:0.2446;s:13:\"ipSystemStats\";d:0.4262;s:5:\"ports\";d:1.006;s:15:\"printersupplies\";d:0.0004;s:10:\"ucd-diskio\";d:0.0002;s:4:\"ospf\";d:0.0001;s:3:\"sla\";d:0.0004;s:14:\"mac-accounting\";d:0.0005;s:12:\"loadbalancer\";d:0.0002;s:15:\"entity-physical\";d:0.0004;s:9:\"fdb-table\";d:0.0622;s:6:\"graphs\";d:0.0544;s:4:\"oids\";d:0.0008;s:6:\"probes\";d:0.0009;}s:10:\"ucd_ss_cpu\";a:8:{s:12:\"ssCpuRawIdle\";a:1:{s:4:\"perc\";d:61.39275101788437;}s:12:\"ssCpuRawUser\";a:1:{s:4:\"perc\";d:13.521118030005038;}s:12:\"ssCpuRawNice\";a:1:{s:4:\"perc\";d:0.003956276386945173;}s:14:\"ssCpuRawSystem\";a:1:{s:4:\"perc\";d:24.824584163417857;}s:17:\"ssCpuRawInterrupt\";a:1:{s:4:\"perc\";d:0;}s:15:\"ssCpuRawSoftIRQ\";a:1:{s:4:\"perc\";d:0.2575904263464981;}s:14:\"ssCpuRawKernel\";a:1:{s:4:\"perc\";d:0;}s:12:\"ssCpuRawWait\";a:1:{s:4:\"perc\";d:8.595929140565286E-8;}}s:7:\"ucd_mem\";a:8:{s:10:\"swap_total\";s:1:\"0\";s:10:\"swap_avail\";s:1:\"0\";s:9:\"mem_total\";s:6:\"123564\";s:9:\"mem_avail\";s:5:\"30036\";s:10:\"mem_shared\";N;s:10:\"mem_buffer\";s:3:\"824\";s:10:\"mem_cached\";s:5:\"20660\";s:8:\"mem_used\";i:72044;}s:17:\"poller_ports_perf\";a:4:{s:6:\"IF-MIB\";d:0.7875969409942627;s:13:\"EtherLike-MIB\";d:0.027740955352783203;s:12:\"Q-BRIDGE-MIB\";d:0.10286998748779297;s:6:\"IP-MIB\";d:0.06956100463867188;}s:14:\"poller_history\";a:288:{i:1755692699;d:2.209;i:1755692584;d:2.1955;i:1755692305;d:7.3882;i:1755692010;d:2.25;i:1755691700;d:2.3322;i:1755691439;d:12.3317;i:1755691081;d:2.3687;i:1755690657;d:2.1276;i:1755690453;d:2.2924;i:1755690165;d:2.2487;i:1755689862;d:2.2485;i:1755689561;d:2.2213;i:1755689272;d:7.3212;i:1755688979;d:2.2687;i:1755688677;d:2.3945;i:1755688384;d:2.4001;i:1755688074;d:2.2993;i:1755687773;d:2.3378;i:1755687472;d:2.2649;i:1755687178;d:2.3668;i:1755686869;d:2.2261;i:1755686570;d:2.3292;i:1755686280;d:2.4036;i:1755685982;d:2.2967;i:1755685680;d:2.2965;i:1755685420;d:2.2073;i:1755685128;d:2.3038;i:1755684824;d:2.2824;i:1755684475;d:2.3134;i:1755684176;d:2.343;i:1755683913;d:2.4896;i:1755683633;d:2.2726;i:1755683327;d:2.3487;i:1755682971;d:2.3289;i:1755682688;d:2.3628;i:1755682180;d:2.2935;i:1755682093;d:2.3396;i:1755681788;d:2.2853;i:1755681488;d:2.3187;i:1755681174;d:2.3163;i:1755680755;d:17.4274;i:1755680610;d:2.2425;i:1755680326;d:2.2689;i:1755679980;d:2.337;i:1755679687;d:2.3863;i:1755679415;d:7.4794;i:1755679101;d:2.505;i:1755678806;d:2.3591;i:1755678503;d:2.3948;i:1755678226;d:2.3317;i:1755677909;d:2.238;i:1755677582;d:2.305;i:1755677305;d:2.353;i:1755676990;d:2.2862;i:1755676668;d:2.3308;i:1755676363;d:2.333;i:1755676086;d:2.2953;i:1755675807;d:2.3082;i:1755675464;d:2.2268;i:1755675171;d:2.4202;i:1755674881;d:2.3793;i:1755674575;d:2.3356;i:1755674256;d:2.2624;i:1755673974;d:2.2959;i:1755673679;d:2.3125;i:1755673281;d:2.1814;i:1755673085;d:2.253;i:1755672770;d:2.5714;i:1755672508;d:2.287;i:1755672206;d:2.3514;i:1755671763;d:7.2691;i:1755671563;d:2.2332;i:1755671258;d:2.2401;i:1755670990;d:2.2546;i:1755670679;d:2.338;i:1755670365;d:7.3511;i:1755670078;d:2.3852;i:1755669774;d:2.2202;i:1755669461;d:2.2592;i:1755669179;d:2.3508;i:1755668876;d:2.3626;i:1755668557;d:2.2704;i:1755668104;d:2.2501;i:1755667947;d:2.3164;i:1755667636;d:2.2234;i:1755667372;d:2.1938;i:1755667076;d:2.4244;i:1755666768;d:8.0208;i:1755666464;d:2.3009;i:1755666182;d:2.359;i:1755665849;d:2.322;i:1755665557;d:2.3157;i:1755665278;d:2.2189;i:1755665028;d:2.2269;i:1755664768;d:2.2746;i:1755664553;d:2.3272;i:1755664122;d:2.2567;i:1755663795;d:2.2789;i:1755663524;d:2.2857;i:1755663201;d:2.3181;i:1755662860;d:2.2467;i:1755662556;d:2.2734;i:1755662279;d:2.4387;i:1755662024;d:2.1939;i:1755661715;d:2.3604;i:1755661371;d:2.3042;i:1755661056;d:2.2038;i:1755660744;d:2.2528;i:1755660438;d:2.249;i:1755660168;d:2.3331;i:1755659853;d:2.2294;i:1755659546;d:2.2786;i:1755659254;d:2.2896;i:1755658991;d:2.3262;i:1755658675;d:2.1944;i:1755658400;d:2.2624;i:1755658037;d:2.2981;i:1755657764;d:2.2315;i:1755657481;d:2.1884;i:1755657168;d:2.3295;i:1755656864;d:2.2515;i:1755656596;d:2.2818;i:1755656141;d:2.2489;i:1755655848;d:2.2955;i:1755655656;d:2.3983;i:1755655351;d:2.3495;i:1755655086;d:2.2003;i:1755654758;d:7.2912;i:1755654465;d:7.2367;i:1755654144;d:2.3512;i:1755653867;d:2.3398;i:1755653550;d:2.2474;i:1755653259;d:2.3558;i:1755652953;d:2.2522;i:1755652639;d:2.3312;i:1755652330;d:2.2358;i:1755652050;d:2.3166;i:1755651756;d:2.251;i:1755651450;d:2.2123;i:1755651148;d:2.2362;i:1755650857;d:2.3703;i:1755650534;d:2.2119;i:1755650246;d:2.2295;i:1755649954;d:2.2013;i:1755649661;d:2.1988;i:1755649357;d:2.2105;i:1755649060;d:2.2617;i:1755648769;d:2.345;i:1755648470;d:2.2654;i:1755648166;d:2.1827;i:1755647861;d:2.2823;i:1755647540;d:2.2113;i:1755647240;d:2.2549;i:1755646948;d:2.1725;i:1755646655;d:2.1789;i:1755646353;d:2.2802;i:1755646050;d:2.3154;i:1755645737;d:2.2424;i:1755645331;d:2.2166;i:1755645152;d:2.3174;i:1755644849;d:2.2473;i:1755644571;d:2.4131;i:1755644253;d:2.6261;i:1755643970;d:7.3929;i:1755643651;d:2.1534;i:1755643368;d:2.4472;i:1755643071;d:2.2418;i:1755642757;d:2.3417;i:1755642481;d:2.1493;i:1755642224;d:2.3502;i:1755641905;d:2.2429;i:1755641609;d:2.2979;i:1755641256;d:2.3454;i:1755640961;d:2.2028;i:1755640701;d:2.258;i:1755640427;d:2.1959;i:1755640105;d:2.2733;i:1755639787;d:2.3227;i:1755639455;d:2.366;i:1755639144;d:2.2194;i:1755638841;d:2.2114;i:1755638534;d:2.1765;i:1755638246;d:2.3401;i:1755637953;d:2.1719;i:1755637654;d:2.294;i:1755637386;d:2.4503;i:1755637099;d:2.3583;i:1755636796;d:2.2797;i:1755636443;d:2.3455;i:1755636161;d:2.2536;i:1755635895;d:2.2428;i:1755635594;d:2.2138;i:1755635280;d:2.1596;i:1755634965;d:2.3274;i:1755634677;d:2.4021;i:1755634379;d:2.344;i:1755634073;d:2.4051;i:1755633758;d:2.5632;i:1755633450;d:2.1963;i:1755633150;d:2.1777;i:1755632852;d:2.31;i:1755632589;d:2.2345;i:1755632272;d:2.276;i:1755631970;d:2.3661;i:1755631655;d:2.3539;i:1755631372;d:2.3626;i:1755631066;d:2.2478;i:1755630786;d:2.3419;i:1755630455;d:2.1748;i:1755630132;d:2.1801;i:1755629839;d:2.273;i:1755629553;d:2.2194;i:1755629256;d:2.2135;i:1755628970;d:2.254;i:1755628667;d:2.7119;i:1755628357;d:2.3539;i:1755628050;d:2.3685;i:1755627762;d:2.5103;i:1755627445;d:2.4503;i:1755627163;d:2.3369;i:1755626852;d:2.3958;i:1755626576;d:2.499;i:1755626269;d:2.1725;i:1755625952;d:2.3008;i:1755625656;d:2.2501;i:1755625360;d:2.2939;i:1755625051;d:2.1748;i:1755624761;d:2.234;i:1755624441;d:2.3821;i:1755624150;d:2.2653;i:1755623863;d:2.2949;i:1755623562;d:2.1945;i:1755623260;d:2.2734;i:1755622957;d:2.395;i:1755622666;d:2.2614;i:1755622336;d:2.2303;i:1755622062;d:2.3027;i:1755621753;d:2.2892;i:1755621449;d:2.2592;i:1755621035;d:2.2467;i:1755620889;d:2.3227;i:1755620588;d:2.1703;i:1755620307;d:2.4114;i:1755619975;d:2.9726;i:1755619661;d:7.908;i:1755619377;d:2.7675;i:1755619110;d:2.7734;i:1755618812;d:2.2718;i:1755618497;d:2.2039;i:1755618162;d:2.4414;i:1755617862;d:2.2002;i:1755617574;d:2.3001;i:1755617275;d:2.2218;i:1755616957;d:2.3595;i:1755616652;d:2.319;i:1755616369;d:2.4211;i:1755616099;d:2.3044;i:1755615798;d:2.3168;i:1755615517;d:2.207;i:1755615160;d:2.4164;i:1755614760;d:2.2498;i:1755614607;d:2.2973;i:1755614313;d:2.2463;i:1755614008;d:2.3081;i:1755613698;d:2.4795;i:1755613385;d:7.5996;i:1755613127;d:2.3789;i:1755612639;d:2.3666;i:1755612511;d:2.2962;i:1755612223;d:2.3836;i:1755611902;d:2.314;i:1755611604;d:2.4112;i:1755611307;d:17.4662;i:1755610980;d:2.6443;i:1755610681;d:2.3683;i:1755610367;d:2.6722;i:1755610062;d:2.2978;i:1755609781;d:2.3472;i:1755609475;d:2.3207;i:1755609195;d:2.3892;i:1755608886;d:2.4715;i:1755608609;d:2.3919;i:1755608289;d:2.2606;i:1755607972;d:2.5177;i:1755607517;d:2.2495;i:1755607415;d:3.074;i:1755607082;d:2.2582;i:1755606786;d:2.3029;}s:17:\"discovery_history\";a:100:{i:1755693121;d:3.5769;i:1755686230;d:3.5772;i:1755664663;d:3.4193;i:1755643018;d:3.721;i:1755621424;d:3.3403;i:1755599838;d:3.4845;i:1755578267;d:3.3928;i:1755556674;d:4.1578;i:1755535070;d:3.8863;i:1755513553;d:4.0411;i:1755491916;d:4.9011;i:1755470246;d:3.9611;i:1755448608;d:3.7019;i:1755427103;d:3.4485;i:1755405456;d:3.982;i:1755383850;d:3.7729;i:1755362221;d:3.66;i:1755340688;d:3.3983;i:1755319069;d:4.1357;i:1755297465;d:4.1485;i:1755275856;d:3.7298;i:1755254245;d:3.7731;i:1755232639;d:3.4141;i:1755211043;d:3.6368;i:1755189424;d:3.3974;i:1755167820;d:3.3183;i:1755146231;d:3.2521;i:1755124611;d:3.4062;i:1755103031;d:3.3825;i:1755082041;d:3.6332;i:1755059857;d:8.5344;i:1755038233;d:3.6106;i:1755016638;d:3.4546;i:1754995064;d:3.6663;i:1754973458;d:3.5795;i:1754951836;d:3.6467;i:1754930241;d:3.522;i:1754908639;d:3.6301;i:1754887054;d:3.4746;i:1754865424;d:3.6441;i:1754843854;d:3.4968;i:1754822266;d:3.8012;i:1754800662;d:3.8684;i:1754779022;d:3.6367;i:1754757433;d:3.4539;i:1754735834;d:3.4852;i:1754714247;d:3.4136;i:1754692609;d:3.511;i:1754671014;d:3.2898;i:1754649398;d:3.2312;i:1754627822;d:3.3516;i:1754606829;d:3.3673;i:1754584651;d:8.8284;i:1754563035;d:3.5639;i:1754541436;d:3.5017;i:1754519819;d:3.3852;i:1754498237;d:3.4842;i:1754476640;d:3.5342;i:1754455054;d:3.5493;i:1754433468;d:3.8215;i:1754411843;d:3.8794;i:1754390212;d:3.3733;i:1754368623;d:3.2559;i:1754347034;d:3.3213;i:1754325437;d:3.7077;i:1754303846;d:3.6225;i:1754282246;d:3.4598;i:1754260645;d:3.5307;i:1754239040;d:3.5737;i:1754217452;d:3.5345;i:1754195831;d:3.7609;i:1754174253;d:3.4961;i:1754152627;d:3.8306;i:1754131039;d:3.6665;i:1754109424;d:3.442;i:1754087837;d:3.4696;i:1754066241;d:3.555;i:1754044631;d:3.5553;i:1754023036;d:3.6166;i:1754001431;d:3.5691;i:1753979850;d:3.5756;i:1753958252;d:3.9327;i:1753936669;d:3.5426;i:1753915034;d:3.8851;i:1753893442;d:3.5159;i:1753871814;d:3.5718;i:1753850379;d:3.7039;i:1753828677;d:5.0514;i:1753807032;d:3.7895;i:1753785453;d:3.6837;i:1753763865;d:3.9456;i:1753742247;d:3.4953;i:1753720657;d:3.5948;i:1753699049;d:3.5639;i:1753677439;d:3.5684;i:1753655843;d:3.6695;i:1753634227;d:3.478;i:1753612646;d:3.4241;i:1753591063;d:3.8153;i:1753569426;d:3.5375;}s:18:\"discovery_mod_perf\";a:17:{s:2:\"os\";d:0.0917;s:4:\"mibs\";d:0.2132;s:5:\"ports\";d:0.2552;s:4:\"oids\";d:0.0016;s:12:\"ip-addresses\";d:0.387;s:10:\"processors\";d:0.0585;s:8:\"mempools\";d:0.0846;s:9:\"inventory\";d:0.1781;s:15:\"printersupplies\";d:0.0009;s:7:\"sensors\";d:1.9952;s:7:\"storage\";d:0.0639;s:10:\"neighbours\";d:0.1045;s:9:\"arp-table\";d:0.0726;s:14:\"mac-accounting\";d:0.0003;s:3:\"sla\";d:0.0336;s:10:\"ucd-diskio\";d:0.0319;s:6:\"graphs\";d:0.0003;}}' WHERE `device_id` = '174'] SQL RUNTIME[0.00105s] ##### ups-a-be-abp-01.winnet.local [174] completed discovery modules at 2025-08-20 12:32:04 #####   o Discovery time  3.5769 seconds SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '615900' AND `process_name` = 'discovery.php' AND `device_id` = '174' AND `poller_id` = '0'] SQL RUNTIME[0.00064397s] ##### Finished discovery run at 2025-08-20 12:32:04 #####   SQL[SELECT * FROM `groups` ORDER BY `entity_type`] SQL RUNTIME[0.00024605s]  SQL[SELECT * FROM `groups_assoc`] SQL RUNTIME[6.7E-5s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^DC.*')] SQL RUNTIME[0.00036597s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.00028396s]  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.00040817s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.0004189s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, '') = 'Unknown' OR `devices`.`location` IS NULL OR IFNULL(`devices`.`location`, "") REGEXP '^$')] SQL RUNTIME[0.00035501s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 5] SQL RUNTIME[0.00011802s]  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.00036311s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 7] SQL RUNTIME[0.000144s]  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.00042605s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 8] SQL RUNTIME[9.584E-5s]  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.00035095s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 126] SQL RUNTIME[8.297E-5s]  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.00035095s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 129] SQL RUNTIME[0.00017214s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^DC LCL.*' AND IFNULL(`devices`.`hostname`, "") NOT REGEXP '(oob)')] SQL RUNTIME[0.00033188s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 132] SQL RUNTIME[0.00014114s]  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.00031304s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 134] SQL RUNTIME[0.0001142s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, "") REGEXP '^DC.*' AND IFNULL(`devices`.`hostname`, "") NOT REGEXP '(oob|labo|jvr)')] SQL RUNTIME[0.00037384s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 138] SQL RUNTIME[0.00022388s]  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.00016904s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 4] SQL RUNTIME[0.0001688s]  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.00806308s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 124] SQL RUNTIME[0.00078392s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.00018716s]  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.00448179s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 125] SQL RUNTIME[0.00118399s]  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.00738502s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 128] SQL RUNTIME[0.00050211s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00025606s]  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.02072001s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 131] SQL RUNTIME[0.00686002s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[0.00010705s]  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.01933503s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 133] SQL RUNTIME[0.00028706s]  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.00075102s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 91] SQL RUNTIME[0.00012803s]  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.00050807s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 92] SQL RUNTIME[0.00012112s]  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.00064087s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 93] SQL RUNTIME[0.00011683s]  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.00066805s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 94] SQL RUNTIME[0.0002501s]  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.00053s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 95] SQL RUNTIME[0.00010014s]  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.00047088s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 96] SQL RUNTIME[8.106E-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_a05_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00061417s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 97] SQL RUNTIME[0.00010991s]  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.00057292s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 98] SQL RUNTIME[9.298E-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.00059104s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 99] SQL RUNTIME[0.00015092s]  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.00052786s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 100] SQL RUNTIME[0.0001061s]  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.00069785s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 101] 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_a10_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00076413s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 102] 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 ( 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.00067306s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 103] SQL RUNTIME[0.00013399s]  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.00052691s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 104] SQL RUNTIME[0.00011992s]  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.00052595s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 105] SQL RUNTIME[9.084E-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.00043702s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 106] SQL RUNTIME[8.297E-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.00078297s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 107] SQL RUNTIME[0.00026107s]  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.00069714s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 108] SQL RUNTIME[0.00018215s]  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.00078702s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 109] SQL RUNTIME[0.00012398s]  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.00071716s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 110] SQL RUNTIME[8.988E-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_b02_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00062108s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 111] SQL RUNTIME[8.416E-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_b02_.2' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00052786s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 112] SQL RUNTIME[7.796E-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_b03_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00045609s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 113] SQL RUNTIME[8.392E-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_b04_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00041199s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 114] SQL RUNTIME[5.603E-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_b05_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.000561s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 115] SQL RUNTIME[7.105E-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.00053716s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 116] SQL RUNTIME[9.012E-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.00064087s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 117] SQL RUNTIME[9.418E-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.00054407s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 118] SQL RUNTIME[8.798E-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_b09_.1' AND `devices`.`status` = '1') AND `sensors`.`sensor_deleted` != '1'] SQL RUNTIME[0.00061679s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 119] SQL RUNTIME[0.00011086s]  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.00068402s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 120] SQL RUNTIME[0.000103s]  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.00054502s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 121] SQL RUNTIME[0.0001049s]  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.00072813s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 122] SQL RUNTIME[0.00017118s]  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.00078702s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 123] SQL RUNTIME[0.00014591s]  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.00351691s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 135] SQL RUNTIME[0.00015402s]  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.00269508s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 136] SQL RUNTIME[0.00012517s]  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.00222397s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 137] SQL RUNTIME[0.00012398s]  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.00694609s]  SQL[SELECT * FROM `group_table` WHERE `group_id` = 130] SQL RUNTIME[0.001966s]  SQL[SELECT * FROM `alert_tests`] SQL RUNTIME[9.894E-5s] Cached 41 alert rules. SQL[SELECT * FROM `alert_assoc`] SQL RUNTIME[5.007E-5s]  SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`ignore` = '0' AND( IFNULL(`devices`.`vendor`, '') != 'Moxa'))] SQL RUNTIME[0.000525s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 1] SQL RUNTIME[0.00056005s]  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.00981021s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 2] SQL RUNTIME[0.00035s]  SQL[SELECT `device_id` FROM `devices` WHERE ( `devices`.`ignore` = '0' AND IFNULL(`devices`.`type`, '') != 'power')] SQL RUNTIME[0.00045991s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 5] SQL RUNTIME[0.00033092s]  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.00993395s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 6] SQL RUNTIME[0.007447s]  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.00644493s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 7] SQL RUNTIME[0.00130105s]  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.00035095s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 8] SQL RUNTIME[0.00017309s]  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[6.104E-5s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 9] SQL RUNTIME[0.00024199s]  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.01714492s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 10] SQL RUNTIME[0.01268601s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[0.00011802s]  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.00780201s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 11] SQL RUNTIME[0.001827s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[7.2E-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.00695515s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 12] SQL RUNTIME[0.00266504s]  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.00149107s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 13] SQL RUNTIME[0.00088s]  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.0030961s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 14] SQL RUNTIME[0.000741s]  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.00935316s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 15] SQL RUNTIME[0.00044394s]  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.00738311s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 16] SQL RUNTIME[0.00047302s]  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.000278s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 17] SQL RUNTIME[9.894E-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.01133084s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 18] SQL RUNTIME[0.00296783s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 1] SQL RUNTIME[4.792E-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.00820184s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 19] SQL RUNTIME[0.0025599s]  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.00695205s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 20] SQL RUNTIME[0.00492191s]  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.02466106s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 21] SQL RUNTIME[0.00024319s]  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.00223589s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 23] SQL RUNTIME[0.00019479s]  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.00306511s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 24] SQL RUNTIME[0.00018501s]  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.00576401s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 25] SQL RUNTIME[0.00546598s]  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.00051689s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 26] SQL RUNTIME[0.00766516s]  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.00071788s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 27] SQL RUNTIME[0.00042605s]  SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`device_id`, '') = 1)] SQL RUNTIME[0.00020599s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 28] SQL RUNTIME[0.00010419s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 124] SQL RUNTIME[0.00038099s]  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.00255203s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 29] SQL RUNTIME[0.0008049s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 130] SQL RUNTIME[0.0011301s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[9.608E-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.00387192s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 31] SQL RUNTIME[0.00030088s]  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.00032902s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 32] SQL RUNTIME[0.00020099s]  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.00072098s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 33] SQL RUNTIME[0.00022912s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[5.293E-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.02054787s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 35] SQL RUNTIME[0.00747204s]  SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE `group_id` = 2] SQL RUNTIME[8.297E-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.01628304s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 36] SQL RUNTIME[0.00014901s]  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.00845695s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 37] SQL RUNTIME[0.00059104s]  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.0003438s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 38] SQL RUNTIME[0.00013995s]  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.00220895s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 39] SQL RUNTIME[0.00023007s]  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.00018501s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 41] SQL RUNTIME[8.988E-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.00018501s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 42] SQL RUNTIME[0.00010085s]  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.00026011s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 43] SQL RUNTIME[0.00033402s]  SQL[SELECT `port_id`, `devices`.`device_id` AS `device_id` FROM `ports` LEFT JOIN `devices` ON (`ports`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`device_id`, '') = 140 AND `ports`.`ifName` = 'xe-0/2/0') AND `ports`.`deleted` != '1'] SQL RUNTIME[0.005934s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 44] SQL RUNTIME[0.00012803s]  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[2.503E-5s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 45] SQL RUNTIME[8.488E-5s]  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.00027704s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 46] SQL RUNTIME[0.00020313s]  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.00064707s]  SQL[SELECT `alert_table_id`, `entity_id`, `device_id` FROM `alert_table` WHERE `alert_test_id` = 47] SQL RUNTIME[0.00035095s] ##### 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-abp-01.winnet.local - 1 devices discovered in 3.7003 secs SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1755678725'] SQL RUNTIME[0.00027204s] 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  3.7003 secs  o Definitions  0.12868499755859 secs  o Memory usage  32MB (peak: 34MB)  o MySQL Usage  Cell[34/0.028s] Row[27/0.017s] Rows[271/0.548s] Column[13/0.007s] Update[3/0.004s] Insert[3/0.007s] Delete[1/0.001s]  o RRDTool Usage