DEBUG!

CMD[/usr/bin/svn info /opt/observium]

CMD EXITCODE[0]
CMD RUNTIME[0.0161s]
CMD EXITDELAY[5ms]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: https://svn.observium.org/svn/observium/trunk
Relative URL: ^/observium/trunk
Repository Root: https://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 12944
Node Kind: directory
Schedule: normal
Last Changed Author: mike
Last Changed Rev: 12944
Last Changed Date: 2023-08-18 11:58:04 +0200 (Fri, 18 Aug 2023)

]
DEFINITIONS Time  : 0.145963 ms

DEFINITIONS Memory: 15.3MB


SQL[SELECT * FROM `observium_attribs`]
SQL RUNTIME[0.00035501s]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00018406s]

SQL[SET SESSION `sql_mode` = 'NO_ENGINE_SUBSTITUTION']
SQL RUNTIME[0.00013304s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ONLY_FULL_GROUP_BY, NO_ZERO_DATE, NO_ZERO_IN_DATE, ERROR_FOR_DIVISION_BY_ZERO

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00016904s]

SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00029802s]

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0033s]
STDOUT[
vm-observium
]

SQL[SELECT EXISTS (SELECT 1 FROM `pollers`)]
SQL RUNTIME[0.00034189s]

  ___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |
 \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|
                          Observium Professional 23.8.12944
                                  https://www.observium.org


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0227s]
STDOUT[
Linux|5.15.0-78-generic|amd64|Ubuntu|20.04|vmware|
]

CMD[/usr/bin/env python --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0033s]
STDOUT[
Python 3.8.10
]

SQL[SELECT version();]
SQL RUNTIME[0.00024199s]

CMD[/usr/bin/snmpget --version 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0045s]
STDOUT[
NET-SNMP version: 5.8
]

CMD[/usr/bin/rrdtool --version | head -n1]

CMD EXITCODE[0]
CMD RUNTIME[0.0106s]
STDOUT[
RRDtool 1.7.2  Copyright by Tobias Oetiker
]

CMD[/usr/bin/fping -v 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0025s]
STDOUT[
/usr/bin/fping: Version 4.2
/usr/bin/fping: comments to david@schweikert.ch
]

CMD[/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}']

CMD EXITCODE[0]
CMD RUNTIME[0.0462s]
STDOUT[
Apache/2.4.41
]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00024390s]

SQL[SHOW VARIABLES LIKE 'log_bin']
SQL RUNTIME[0.20749497s]

SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.00191808s]

#####  Software versions  #####

 o OS                   Linux 5.15.0-78-generic [amd64] (Ubuntu 20.04)
 o Apache               2.4.41
 o PHP                  7.4.3-4ubuntu2.19 (OPcache: DISABLED)
 o Python               3.8.10
 o MySQL                8.0.34-0ubuntu0.20.04.1 (extension: mysqli 7.4.3-4ubuntu2.19)
 o SNMP                 NET-SNMP 5.8
 o RRDtool              1.7.2
 o Fping                4.2 (IPv4 and IPv6)
 o Fetch                cURL 7.68.0 (OpenSSL/1.1.1f, LibZ 1.2.11, LibIDN 2.2.0)

#####  Memory Limit  #####

 o PHP                  Unlimited

#####  DB info  #####

 o DB schema            485
 o MySQL binlog         ON
 o MySQL mode           NO_ENGINE_SUBSTITUTION

#####  Charset info  #####

 o PHP                  UTF-8
 o MySQL                utf8mb3

#####  Timezones info  #####

 o Date                 Monday, 21-Aug-23 13:44:19 CEST
 o PHP                  +02:00
 o MySQL                +02:00

HTTP 'curl' library used.

SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'http_rate_https://www.observium.org')]
SQL RUNTIME[0.00031710s]

SQL[UPDATE `observium_attribs` set `attrib_value` ='{\"2023-08-21\":5}' WHERE `attrib_type` = 'http_rate_https://www.observium.org']
SQL RUNTIME[0.00234103s]

REQUEST[https://www.observium.org/versions.php]
REQUEST STATUS[TRUE]
REQUEST RUNTIME[0.1408s]
RESPONSE CODE[200 OK]
TRUE
Response [12912] valid: [stable->revision] regex [^\d+$]
Array
(
    [stable] => Array
        (
            [version] => 23.8.12912
            [revision] => 12912
            [date] => 2023-08-02
        )

    [current] => Array
        (
            [version] => 23.8.12946
            [revision] => 12946
            [date] => 2023-08-18
        )

    [ce] => Array
        (
            [version] => 22.12
            [revision] => 12447
            [date] => 2022-12-30
        )

)


SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latst_ver')]
SQL RUNTIME[0.00050902s]

SQL[UPDATE `observium_attribs` set `attrib_value` ='23.8.12946' WHERE `attrib_type` = 'latest_ver']
SQL RUNTIME[0.00028419s]

SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev')]
SQL RUNTIME[0.00024009s]

SQL[UPDATE `observium_attribs` set `attrib_value` ='12946' WHERE `attrib_type` ='latest_rev']
SQL RUNTIME[0.00022507s]

SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date')]
SQL RUNTIME[0.00020790s]

SQL[UPDATE `observium_attribs` set `attrib_value` ='2023-08-18' WHERE `attrib_type` = 'latest_rev_date']
SQL RUNTIME[0.00020790s]

SQL[SELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck')]
SQL RUNTIME[0.00020003s]

SQL[UPDATE `observium_attribs` set `attrib_value` ='1692618259' WHERE `attrib_type` = 'last_versioncheck']
SQL RUNTIME[0.00173497s]
There is a newer revision of Observium available!
Version 23.8.12946 (21st August 2023) is 2 revisions ahead.

#####  Starting discovery run at 2023-08-21 13:44:19  #####


SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE '172.21.199.100' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00060701s]
Found device [329] model 'inveo' exact association for .1.3.6.1.4.1.42814.12

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'172.21.199.100':'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.0318s]
STDOUT[
.1.3.6.1.2.1.1.2.0 = .1.3.6.1.4.1.42814.12
.1.3.6.1.2.1.1.3.0 = 0:7:58:50.93
]
SNMP STATUS[TRUE]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329']
SQL RUNTIME[0.00057006s]

SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '329' AND `poller_id` = '0']
SQL RUNTIME[0.00031495s]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('2762046                                       ','discovery.php','2761990','0','php ./discovery.php -d -h 172.21.199.100','1692618259','329')]
SQL RUNTIME[0.00192094s]
#####  172.21.199.100 [329]  #####

 o OS Type              inveo-sensor
 o OS Group             enterprise_tree_snmpv2
 o SNMP Version         v2c
 o Last discovery       2023-08-21 12:57:26
 o Last duration        1.06 seconds

#####  Module Start: os  #####

Device-specific no-bulk option.

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'172.21.199.100':'161' sysDescr.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0289s]
STDOUT[
HERO-WS 1.28
]
SNMP STATUS[TRUE]
Store in cache OID: SNMPv2-MIB::sysDescr.0
Device-specific no-bulk option.

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUvn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'172.21.199.100':'161' sysObjectID.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0299s]
STDOUT[
.1.3.6.1.4.1.42814.12
]
SNMP STATUS[TRUE]
+-------------+-----------------------+
| OID         |                       |
+-------------+-----------------------+
| sysDescr    | HERO-WS 1.28          |
| sysObjectID | .1.3.6.1.4.1.42814.12 |
+-------------+-----------------------+

 o Detect OS matched (inveo-sensor: Inveo Sensor):
+-------------+--------------------+-----------------------+
| OID         | Matched definition |                       |
+-------------+--------------------+-----------------------+
| sysObjectID | .1.3.6.1.4.1.42814 | .1.3.6.1.4.1.42814.12 |
+-------------+--------------------+-----------------------+


 o Duration             0.1246s

#####  Module Start: mibs  #####


CMD[/usr/bin/snmptranslate -On -Pu -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'SNMPv2-MIB::sysORID']

CMD EXITCODE[0]
CMD RUNTIME[0.0162s]
STDOUT[
.1.3.6.1.2.1.1.9.1.2
]
SNMP TRANSLATE (CMD): 'SNMPv2-MIB::sysORID' -> '.1.3.6.1.2.1.1.9.1.2'

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -OQUsn -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'172.21.199.100':'161' .1.3.6.1.2.1.1.9.1.2]

CMD EXITCODE[0]
CMD RUNTIME[0.1128s]
STDOUT[
.1.3.6.1.2.1.1.9.1.2 = No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'172.21.199.100':'161' sysORDescr]

CMD EXITCODE[0]
CMD RUNTIME[0.1158s]
STDOUT[
sysORDescr = No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m OSPF-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'172.21.199.100':'161' ospfAdminStat.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0276s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
Store in cache OID: OSPF-MIB::ospfAdminStat.0

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m OSPFV3-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'172.21.199.100':'161' ospfv3AdminStatus.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0323s]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
Store in cache OID: OSPFV3-MIB::ospfv3AdminStatus.0

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUv -m Hero -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/inveo 'udp':'172.21.199.100':'161' busFail.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0281s]
STDOUT[
ok
]
SNMP STATUS[TRUE]
Store in cache OID: Hero::busFail.0
+-----------------+--------------------+--------------+
| OID             | Matched definition | Value        |
+-----------------+--------------------+--------------+
| device os       | inveo-sensor       | inveo-sensor |
| Hero::busFail.0 | /.+/               | ok           |
+-----------------+--------------------+--------------+

 o MIBs discovered      <empty>
SQL[DELETE FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id`= '329' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00050902s]

+-----------------------+------+--------+---------------------+
| Identity              | MIB  | Source | Status              |
+-----------------------+------+--------+---------------------+
| .1.3.6.1.4.1.42814.12 | Hero | Model  | MIB already defined |
+-----------------------+------+--------+---------------------+


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00035787s]
JSON DECODE[Not string passed]
JSON RAW[


]

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '329' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00027418s]
Array
(
    [0] => Hero
    [1] => ENTITY-MIB
    [2] => SNMPv2-MIB
    [3] => IF-MIB
    [4] => IP-MIB
)


 o Duration             0.3587s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_vrf']
SQL RUNTIME[0.00025010s]
#####  Module Start: vrf  #####


SQL[SELECT COUNT(*) FROM `vrfs` WHERE `device_id` = '329' AND 1]
SQL RUNTIME[0.00028205s]

SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '329' AND `ifVrf` IS NOT NULL AND 1]
SQL RUNTIME[0.00035787s]

 o Duration             0.0028s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_ports']
SQL RUNTIME[0.00028086s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_ports-stack']
SQL RUNTIME[0.00025105s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_vlans']
SQL RUNTIME[0.00023890s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_oids']
SQL RUNTIME[0.00025392s]
#####  Module Start: oids  #####


SQL[SELECT * FROM `oids_entries` LEFT JOIN `oids` USING(`oid_id`) WHERE `device_id` = '329']
SQL RUNTIME[0.00032616s]

SQL[SELECT * FROM `oids` WHERE `oid_autodiscover` = '1']
SQL RUNTIME[0.00027013s]

 o Duration             0.0019s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_ip-addresses']
SQL RUNTIME[0.00028706s]
#####  Module Start: ip-addresses  #####


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'sysORID']
SQL RUNTIME[0.00027394s]
JSON DECODE[Not string passed]
JSON RAW[


]
 o IP-MIB
CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'172.21.199.100':'161' ipAdEntIfIndex]

CMD EXITCODE[0]
CMD RUNTIME[0.1s]
STDOUT[
ipAdEntIfIndex = No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -OQUs -m IP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'172.21.199.100':'161' ipAddressIfIndex]

CMD EXITCODE[0]
CMD RUNTIME[0.1002s]
STDOUT[
ipAddressIfIndex = No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]


SQL[SELECT * FROM `ipv4_addresses` WHERE `device_id` = '329']
SQL RUNTIME[0.00066400s]

SQL[SELECT * FROM `ipv6_addresses` WHERE `device_id` = '329']
SQL RUNTIME[0.00053906s]

 o Duration             0.2121s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_processors']
SQL RUNTIME[0.00038910s]
#####  Module Start: processors  #####


SQL[SELECT * FROM `processors` WHERE `device_id` = '329']
SQL RUNTIME[0.00030303s]

 o Duration             0.0027s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_mempools']
SQL RUNTIME[0.00030017s]
#####  Module Start: mempools  #####


SQL[SELECT * FROM `mempools` WHERE `device_id` = '329']
SQL RUNTIME[0.00028801s]

 o Duration             0.0021s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_inventory']
SQL RUNTIME[0.00026107s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_printersupplies']
SQL RUNTIME[0.00025201s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_sensors']
SQL RUNTIME[0.00026488s]
#####  Module Start: sensors  #####

 o Hero                 sensorValInt [
CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -Ih -OQUsb -m Hero -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/inveo 'udp':'172.21.199.100':'161' sensorEntry]

CMD EXITCODE[1]
CMD RUNTIME[0.1942s]
STDOUT[
sensorId.0 = 0
sensorId.1 = 1
sensorId.2 = 2
sensorId.3 = 3
sensorExist.0 = yes
sensorExist.1 = yes
sensorExist.2 = no
sensorExist.3 = no
sensorType.0 = temperature
sensorType.1 = humidity
sensorType.1 = humidity
sensorType.2 = none
sensorType.3 = none
sensorName.0 = "Temp"
sensorName.1 = "Hum"
sensorName.2 = "CH 3"
sensorName.3 = "CH 4"
sensorValString.0 = "23.4"
sensorValString.1 = "43.8"
sensorValString.2 = "00 "
]
STDERR[
Error: OID not increasing: sensorType.1
 >= sensorType.1
]
SNMP STATUS[FALSE]
SNMP ERROR[#993 - OID not increasing]

SQL[SELECT * FROM `devices` WHERE `devices`.`device_id` = '329']
SQL RUNTIME[0.00064993s]
Store in cache Table OID: Hero::sensorEntry
map_class found: temperature - temperature
TRUE
TRUE
Excluded by sensor 'sensorValInt' value '' is not numeric.
map_class found: humidity - humidity
TRUE
TRUE
Excluded by sensor 'sensorValInt' value '' is not numeric.
Value from oid_class (none) does not match any configured values in map_class!
Value from oid_class (none) does not match any configured values in map_class!
]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'temperature' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00047016s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'humidity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00033498s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'fanspeed' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030994s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'dewpoint' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00031710s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'airflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00034595s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'voltage' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00031614s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'current' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030804s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'power' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029993s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'apower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029206s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'rpower' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00032187s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'crestfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029206s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'powerfactor' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029397s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'impedance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00031495s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'resistance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00033307s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'frequency' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030184s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'dbm' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030708s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'attenuation' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030303s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'snr' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029898s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'dust' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00034809s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'concentration' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029707s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'sound' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00028300s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'capacity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029182s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'load' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030303s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'runtime' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00028110s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'volume' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029302s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'waterflow' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00027895s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'pressure' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030494s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'velocity' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00029302s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'distance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00027704s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'illuminance' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00027299s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'wavelength' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00028300s]

SQL[SELECT * FROM `sensors` WHERE `device_id` = '329' AND `sensor_class` = 'gauge' AND `poller_type` = 'snmp' AND `sensor_deleted` = '0']
SQL RUNTIME[0.00030112s]

SQL[SELECT * FROM `status` WHERE `device_id` = '329' AND `poller_type` = 'snmp' AND `status_deleted` = '0']
SQL RUNTIME[0.00028992s]

SQL[SELECT * FROM `counters` WHERE `device_id` = '329' AND `poller_type` = 'snmp' AND `counter_deleted` = '0']
SQL RUNTIME[0.00030708s]


 o Duration             0.232s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_storage']
SQL RUNTIME[0.00025988s]
#####  Module Start: storage  #####


SQL[SELECT * FROM `storage` WHERE `device_id` = '329']
SQL RUNTIME[0.00025415s]

 o Duration             0.0013s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_neighbours']
SQL RUNTIME[0.00024009s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_arp-table']
SQL RUNTIME[0.00023103s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_junose-atm-vp']
SQL RUNTIME[0.00022888s]
#####  Module Start: junose-atm-vp  #####


 o Duration             0.0002s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_bgp-peers']
SQL RUNTIME[0.00022888s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_mac-accounting']
SQL RUNTIME[0.00022697s]
#####  Module Start: mac-accounting  #####


 o Duration             0.0003s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_sla']
SQL RUNTIME[0.00022602s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_lsp']
SQL RUNTIME[0.00022483s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_pseudowires']
SQL RUNTIME[0.00025296s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_virtual-machines']
SQL RUNTIME[0.00024009s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_cisco-cbqos']
SQL RUNTIME[0.00022602s]
#####  Module Start: cisco-cbqos  #####


SQL[SELECT * FROM `ports_cbqos` WHERE `device_id` = '329']
SQL RUNTIME[0.00025702s]

CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pud -OQUs -m CISCO-CLASS-BASED-QOS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'172.21.199.100':'161' cbQosIfType]

CMD EXITCODE[0]
CMD RUNTIME[0.1806s]
STDOUT[
cbQosIfType = No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
QoS not configured.

 o Duration             0.1844s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_ucd-diskio']
SQL RUNTIME[0.00055885s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_wifi']
SQL RUNTIME[0.00026798s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_p2p-radios']
SQL RUNTIME[0.00025487s]
#####  Module Start: p2p-radios  #####


 o Duration             0.0002s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_graphs']
SQL RUNTIME[0.00025511s]
#####  Module Start: graphs  #####


 o Duration             0.0004s


SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '329' AND `attrib_type` = 'discover_raid']
SQL RUNTIME[0.00025582s]
 o Modules Disabled     ports, ports-stack, vlans, inventory, printersupplies, neighbours, arp-table, bgp-peers, sla, lsp, pseudowires,
                        virtual-machines,ucd-diskio, wifi, raid
 o Modules Enabled      os, mibs, vrf, oids, ip-addresses, processors, mempools, sensors, storage, junose-atm-vp, mac-accounting, cisco-cbqos,
                        p2p-radios,graphs

SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '329';]
SQL RUNTIME[0.00025201s]

SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='environment',`last_discovered_timetaken` ='1.1569',`force_discovery` ='0',`device_state` ='a:4:{s:15:\"poller_mod_perf\";a:18:{s:6:\"system\";d:0.1251;s:2:\"os\";d:0.2222;s:7:\"sensors\";d:0.0014;s:6:\"status\";d:0.0005;s:7:\"counter\";d:0.0004;s:10:\"processors\";d:0.0017;s:8:\"mempools\";d:0.0008;s:7:\"storage\";d:0.0019;s:7:\"ucd-mib\";d:0.0005;s:13:\"ipSystemStats\";d:0.1111;s:10:\"ucd-diskio\";d:0.0006;s:10:\"p2p-radios\";d:0.0007;s:14:\"mac-accounting\";d:0.0013;s:12:\"loadbalancer\";d:0.0003;s:15:\"entity-physical\";d:0.0002;s:6:\"graphs\";d:0.0004;s:4:\"oids\";d:0.0007;s:6:\"probes\";d:0.0005;}s:14:\"poller_history\";a:65:{i:1692618128;d:0.5396;i:1692617828;d:1.5374;i:1692617533;d:0.5601;i:1692617238;d:1.1499;i:1692616924;d:0.5427;i:1692616620;d:0.5424;i:1692616328;d:2.4963;i:1692616031;d:0.6052;i:1692                                       615735;d:0.5413;i:1692615431;d:0.9603;i:1692615139;d:0.6795;i:1692614837;d:0.510                                     2;i:1692614536;d:0.6529;i:1692614239;d:0.6297;i:1692613939;d:0.5217;i:1692613632;d:1.5176;i:1692613331;d:0.6442;i:1692613029;d:0.6224;i:1692612730;d:0.5358;i:16                                       92612434;d:1.5162;i:1692612129;d:0.6159;i:1692611823;d:0.8059;i:1692611535;d:0.6011;i:1692611237;d:0.5605;i:1692610922;d:0.6514;i:1692610632;d:1.5346;i:16926103                                       34;d:0.7599;i:1692610029;d:0.5041;i:1692609724;d:0.6287;i:1692609426;d:0.6627;i:                                     1692609125;d:0.5493;i:1692608827;d:0.5853;i:1692608533;d:0.5433;i:1692608226;d:0.6052;i:1692607928;d:0.5693;i:1692607635;d:0.7888;i:1692607328;d:0.5674;i:169260                                       7031;d:0.6417;i:1692606729;d:0.7434;i:1692606427;d:0.5128;i:1692606130;d:0.5776;                                       i:1692605829;d:0.5229;i:1692605529;d:0.5805;i:1692605230;d:1.5248;i:1692604943;d:0.732;i:1692604634;d:0.5631;i:1692604330;d:0.5762;i:1692604027;d:0.5712;i:16926                                       03728;d:0.6004;i:1692603429;d:0.5561;i:1692603134;d:0.5336;i:1692602833;d:0.5553;i:1692602537;d:0.5895;i:1692602244;d:0.6112;i:1692601943;d:0.5695;i:1692601650;                                       d:0.6478;i:1692601337;d:0.5012;i:1692601034;d:0.5254;i:1692600735;d:1.5461;i:169                                       2600434;d:0.6183;i:1692600126;d:0.6541;i:1692599833;d:0.609;i:1692599534;d:0.569;i:1692599227;d:0.5844;i:1692598932;d:1.1477;}s:17:\"discovery_history\";a:3:{i:                                       1692618259;d:1.1569;i:1692615445;d:1.0557;i:1692598802;d:1.1531;}s:18:\"discovery_mod_perf\";a:14:{s:2:\"os\";d:0.1246;s:4:\"mibs\";d:0.3587;s:3:\"vrf\";d:0.0028;s:4:\"oids\";d:0.0019;s:12:\"ip-addresses\";d:0.2121;s:10:\"processors\";d:0.0027;s:8:\"mempools\";d:0.0021;s:7:\"sensors\";d:0.232;s:7:\"storage\";d:0.0013;s:13:\"junose-atm-vp\";d:0.0002;s:14:\"mac-accounting\";d:0.0003;s:11:\"cisco-cbqos\";d:0.1844;s:10:\"p2p-radios\";d:0.0002;s:6:\"graphs\";d:0.0004;}}' WHERE `device_id` = '329']
SQL RUNTIME[0.00244212s]
#####  172.21.199.100 [329] completed discovery modules at 2023-08-21 13:44:20  #####

 o Discovery time       1.1569 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '2762046' AND `process_name` = 'discovery.php' AND `device_id` = '329' AND `poller_id` = '0']
SQL RUNTIME[0.00173593s]
#####  Finished discovery run at 2023-08-21 13:44:20  #####


SQL[SELECT * FROM `groups` ORDER BY `entity_type`]
SQL RUNTIME[0.00045013s]

SQL[SELECT * FROM `groups_assoc`]
SQL RUNTIME[0.00036001s]

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, '') = 'SRV M6+1')]
SQL RUNTIME[0.00119996s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '1']
SQL RUNTIME[0.00054407s]
Group                             'SRV M6+1': 58 existing, 58 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`os`, '') IN ('airos-af','airos','edgemax','edgeos','ubnt-edgepower','ubnt-ltu','unifi-switch','unifi','ubnt-sunmax'))]
SQL RUNTIME[0.00064898s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '2']
SQL RUNTIME[0.00044298s]
Group                             'Ubiquiti': 72 existing, 72 new entries (+0/-0).

SQL[SELECT DISTINCT `device_id` FROM `ipv4_addresses` LEFT JOIN `ports` USING (`device_id`, `port_id`) WHERE 1 AND (`ipv4_address` LIKE '%172.20.33.%') AND (`ports`.`deleted` != "1" OR `ports`.`deleted` IS NULL)]
SQL RUNTIME[0.00148392s]

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`device_id`, '') IN ('78','79','80','81','82','84','138','139','145','175','183','176','196','202                                       ','206','207','103','279','280','208','85','83','322'))]
SQL RUNTIME[0.00051308s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '3']
SQL RUNTIME[0.00035000s]
Group                                 'CCTV': 23 existing, 23 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, '') IN ('MBK','MBK Majstrówka'))]
SQL RUNTIME[0.00105691s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '4']
SQL RUNTIME[0.00032187s]
Group                                  'MBK': 9 existing, 9 new entries (+0/-0).

SQL[SELECT DISTINCT `device_id` FROM `ipv4_addresses` LEFT JOIN `ports` USING (`device_id`, `port_id`) WHERE 1 AND (`ipv4_address` LIKE '%172.21.109.%') AND (`ports`.`deleted` != "1" OR `ports`.`deleted` IS NULL)]
SQL RUNTIME[0.00130010s]

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`location`, '') = 'Hotel' OR IFNULL(`devices`.`device_id`, '') IN ('69','70','71','72','73','74',                                       '75','76','77','100','95','330','331'))]
SQL RUNTIME[0.00133181s]

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '5']
SQL RUNTIME[0.00034094s]
Group                                'Hotel': 15 existing, 15 new entries (+0/-0).

SQL[SELECT * FROM `alert_tests` WHERE 1]
SQL RUNTIME[0.00041509s]
Cached 22 alert rules.

SQL[SELECT * FROM `alert_assoc`]
SQL RUNTIME[0.00022006s]

SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`type`, '') IN ('communication','environment','firewall','hypervisor','loadbalancer','network','optical','power','printer','radio','security','blade','server','storage','video','voip','wireless','workstation'))]
SQL RUNTIME[0.00318694s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '1']
SQL RUNTIME[0.00968599s]
Alert Checker                'ALL CPU Alert': 1148 existing, 1148 new entries (+0/-0).

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( IF NULL(`devices`.`type`, '') IN ('communication','environment','firewall','hypervisor','loadbalancer','management','network','optical','power','printer','radio','                                       security','blade','server','storage','video','voip','wireless','workstation')) AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00165701s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '2']
SQL RUNTIME[0.00196004s]
Alert Checker                      'ALL RAM': 221 existing, 221 new entries (+0/-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(`devices`.`type`, '') IN ('firewall','network','wireless')) AND `ports`.`deleted` != '1']
SQL RUNTIME[0.01422310s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '3']
SQL RUNTIME[0.04960394s]
Alert Checker  'NETWORK Traffic exceeds 80%': 6623 existing, 6623 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`hostname`, "") LIKE '%')]
SQL RUNTIME[0.00091815s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '5']
SQL RUNTIME[0.01085305s]
Alert Checker              'ALL Device down': 279 existing, 279 new entries (+0/-0).

SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `sensors`.`sensor_class` = 'temperature') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00731897s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '6']
SQL RUNTIME[0.00894880s]
Alert Checker 'ALL Temperature is higher then 75 degrees': 1138 existing, 1138 new entries (+0/-0).

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 IFNULL(`devices`.`device_id`, '') != '150') AND `storage`.`storage_deleted` != '1']
SQL RUNTIME[0.00144696s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '7']
SQL RUNTIME[0.00072908s]
Alert Checker          'VM 10%free storage': 45 existing, 45 new entries (+0/-0).

SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`type`, '') = 'hypervisor' AND `processors`.`processor_descr` = 'Average')]
SQL RUNTIME[0.00199199s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '8']
SQL RUNTIME[0.00046992s]
Alert Checker               'ESXI CPU Alert': 13 existing, 13 new entries (+0/-0).

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( IF NULL(`devices`.`type`, '') = 'hypervisor') AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00113201s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '9']
SQL RUNTIME[0.00043297s]
Alert Checker                     'ESXI RAM': 14 existing, 14 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`type`, '') = 'hypervisor')]
SQL RUNTIME[0.00063992s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '10']
SQL RUNTIME[0.00041485s]
Alert Checker             'ESXI Device down': 14 existing, 14 new entries (+0/-0).

SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( IFNULL(`devices`.`type`, '') = 'server' AND `processors`.`processor_descr` = 'Average')]
SQL RUNTIME[0.00191498s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '11']
SQL RUNTIME[0.00049305s]
Alert Checker                 'VM CPU Alert': 21 existing, 21 new entries (+0/-0).

SQL[SELECT `mempool_id`, `devices`.`device_id` as `device_id` FROM `mempools` LEFT JOIN `devices` ON (`mempools`.`device_id` = `devices`.`device_id`) WHERE ( IF NULL(`devices`.`type`, '') = 'server') AND `mempools`.`mempool_deleted` != '1']
SQL RUNTIME[0.00138593s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '12']
SQL RUNTIME[0.00061893s]
Alert Checker                       'VM RAM': 43 existing, 43 new entries (+0/-0).

SQL[SELECT `device_id` FROM `devices` WHERE ( IFNULL(`devices`.`type`, '') = 'server')]
SQL RUNTIME[0.00067616s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '13']
SQL RUNTIME[0.00048494s]
Alert Checker               'VM Device down': 21 existing, 21 new entries (+0/-0).

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`.`type`, '') = 'power' AND( IFNULL(`status`.`status_type`, '') = 'ups-mib-battery-state' OR IFNULL(`status`.`status_type`, '') = 'upsEBatteryStatus')) AND `status`.`status_deleted` != '1']
SQL RUNTIME[0.00262809s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '14']
SQL RUNTIME[0.00051093s]
Alert Checker          'UPS battery failure': 21 existing, 21 new entries (+0/-0).

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`.`type`, '') = 'power' AND IFNULL(`sensors`.`sensor_class`, '') = 'capacity') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00661206s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '16']
SQL RUNTIME[0.00049686s]
Alert Checker 'UPS Battery Charge Remaining': 21 existing, 21 new entries (+0/-0).

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`.`type`, '') = 'power' AND IFNULL(`sensors`.`sensor_class`, '') = 'voltage' AND( `sensors`.`sensor_descr` = 'Input Phase 1' OR `sensors`.`sensor_descr` = 'Input' OR `sensors`.`sensor_descr` = 'Input Phase 2' OR `sensors`.`sensor_descr` = 'Input Phase 3')) AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00782895s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '17']
SQL RUNTIME[0.00045919s]
Alert Checker                 'UPS No input': 23 existing, 23 new entries (+0/-0).

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`.`type`, '') = 'power' AND IFNULL(`devices`.`device_id`, '') NOT IN ('186','187','211') AND IFNULL(`sensors`.`sensor_class`, '') = 'runtime' AND `sensors`.`sensor_descr` != 'Battery Runtime') AND `sensors`.`sensor_deleted` != '1'                                       ]
SQL RUNTIME[0.00710702s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '18']
SQL RUNTIME[0.00045419s]
Alert Checker                  'UPS Runtime': 18 existing, 18 new entries (+0/-0).

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`, '') = '211' AND IFNULL(`sensors`.`sensor_class`, '') = 'runtime' AND `sensors`.`sensor_descr` != 'Battery Runtime') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00717306s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '19']
SQL RUNTIME[0.00035191s]
Alert Checker  'UPS Runtime (only ups m6+1)': 1 existing, 1 new entries (+0/-0).

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`.`type`, '') = 'power' AND IFNULL(`devices`.`device_id`, '') IN ('186','187') AND IFNULL(`sensors`.`sensor_class`, '') = 'runtime' AND `sensors`.`sensor_descr` != 'Battery Runtime') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00721288s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '20']
SQL RUNTIME[0.00036883s]
Alert Checker              'UPS Runtime MBK': 2 existing, 2 new entries (+0/-0).

SQL[SELECT DISTINCT `entity_id` FROM `group_table` WHERE 1 AND `group_id` = '4']
SQL RUNTIME[0.00040388s]

SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `devices`.`device_id` IN ('96','177','178','185','186','187','276','277','321') AND IFNULL(`devices`.`type`, '') = 'environment') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00060678s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '21']
SQL RUNTIME[0.00032997s]
Alert Checker       'SENSOR Temperature MBK': 0 existing, 0 new entries (+0/-0).

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 ('186','187') AND IFNULL(`sensors`.`sensor_class`, '') = 'voltage' AND( `sensors`.`sensor_descr` = 'Input Phase 1' OR `sensors`.`sensor_descr` = 'Input' OR `sensors`.`sensor_descr` = 'Input Phase 2' OR `sensors`.`sensor_descr` = 'Input Phase 3')) AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00770283s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '22']
SQL RUNTIME[0.00039315s]
Alert Checker             'UPS No input MBK': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `sensor_id`, `devices`.`device_id` as `device_id` FROM `sensors` LEFT JOIN `devices` ON (`sensors`.`device_id` = `devices`.`device_id`) WHERE ( `sensors`.`sensor_descr` = 'Circuit 2 Evap. Temperature') AND `sensors`.`sensor_deleted` != '1']
SQL RUNTIME[0.00679994s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '23']
SQL RUNTIME[0.00037408s]
Alert Checker  'SENSOR Temperature SRV M6+1': 2 existing, 2 new entries (+0/-0).

SQL[SELECT `processor_id`, `devices`.`device_id` as `device_id` FROM `processors` LEFT JOIN `devices` ON (`processors`.`device_id` = `devices`.`device_id`) WHERE ( `processors`.`processor_descr` = 'Average' AND IFNULL(`devices`.`type`, '') = 'management')]
SQL RUNTIME[0.00194716s]

SQL[SELECT * FROM `alert_table` WHERE `alert_test_id` = '24']
SQL RUNTIME[0.00042415s]
Alert Checker            'CPU Average util ': 12 existing, 12 new entries (+0/-0).
./discovery.php: 172.21.199.100 - 1 devices discovered in 1.676 secs

SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1692603859']
SQL RUNTIME[0.00027609s]
NOTE, $config['snmp']['hide_auth'] is set to TRUE, snmp community and snmp v3 auth hidden from debug output.
 o Devices Discovered   1
 o Discovery Time       1.676 secs
 o Definitions          0.1459629535675 secs
 o Memory usage         42MB (peak: 44.02MB)
 o MySQL Usage          Cell[13/0.015s] Row[30/0.028s] Rows[112/0.527s] Column[9/0.012s] Update[6/0.011s] Insert[1/0.003s] Delete[2/0.004s]
 o RRDTool Usage

SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('329','329','device',NOW(),'7','WARNING! snmpbulkwalk ended prematurely due to an error [OID not increasing] on MIB::Oid [Hero::sensorEntry]. Try to use -Cc option for snmpbulkwalk command.')]
SQL RUNTIME[0.00221705s]