DEBUG!

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

CMD EXITCODE[0]
CMD RUNTIME[0.014s]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/branches/stable
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 11451
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 11450
Last Changed Date: 2021-07-01 04:06:28 -0700 (Thu, 01 Jul 2021)

]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00055289s]

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

SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']
SQL RUNTIME[0.00020099s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0021s]
CMD EXITDELAY[10ms]
STDOUT[
-07:00
]

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

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00038886s]

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

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


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.0166s]
STDOUT[
Linux|3.10.0-1160.15.2.el7.x86_64|amd64|CentOS|7|kvm|
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0034s]
STDOUT[
Python 2.7.5
]

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

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

CMD EXITCODE[0]
CMD RUNTIME[0.0052s]
STDOUT[
NET-SNMP version: 5.7.2
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0059s]
STDOUT[
RRDtool 1.7.1  Copyright by Tobias Oetiker <tobi@oetiker.ch>
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0028s]
STDOUT[
/usr/sbin/fping: Version 3.10
/usr/sbin/fping: comments to david@schweikert.ch
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0026s]
STDOUT[

]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0268s]
STDOUT[
Apache/2.4.6
]

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

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

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

 o OS                   Linux 3.10.0-1160.15.2.el7.x86_64 [amd64] (CentOS 7)
 o Apache               2.4.6
 o PHP                  7.2.34 (OPcache: ENABLED)
 o Python               2.7.5
 o MariaDB              10.4.13-MariaDB-log (extension: mysqli 5.0.12-dev)
 o SNMP                 NET-SNMP 5.7.2
 o RRDtool              1.7.1
 o Fping                3.10 (IPv4 and IPv6)

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

 o PHP                  128MB

#####  MariaDB mode  #####

 o MariaDB              NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

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

 o PHP                  UTF-8
 o MariaDB              utf8

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

 o Date                 Friday, 02-Jul-21 17:51:52 UTC
 o PHP                  +00:00
 o MariaDB              +00:00


SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';]
SQL RUNTIME[0.00033617s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';]
SQL RUNTIME[0.00023103s]
#####  Starting discovery run at 2021-07-02 17:51:52  #####


SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'sb-hny-dsw-01.example.com' AND `status` = '1' AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC]
SQL RUNTIME[0.00080490s]

CMD[/usr/bin/snmpget -t '5' -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'sb-hny-dsw-01.example.com':'161' sysObjectID.0 sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0486s]
STDOUT[
sysObjectID.0 = enterprises.46242
sysUpTime.0 = 38:4:58:05.00
]
SNMP STATUS[TRUE]

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

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

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('17995','discovery.php','10884','0','php ./discovery.php -d -m sensors -h sb-hny-dsw-01.example.com','1625248312','47')]
SQL RUNTIME[0.00445008s]
#####  sb-hny-dsw-01.example.com [47]  #####

 o OS Type              netonix-switch
 o SNMP Version         v2c
 o Last discovery       2021-07-02 17:43:21
 o Last duration        0.89 seconds

#####  Module Start: sensors  #####

JSON DECODE[Not string passed]

SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '47' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00039792s]
 o NETONIX-SWITCH-MIB   totalPowerConsumption [
CMD[/usr/bin/snmpbulkwalk -t '5' -v2c -c *** -Pud -Ih -OQUsb -m NETONIX-SWITCH-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/netonix 'udp':'sb-hny-dsw-01.example.com':'161' totalPowerConsumption]

CMD EXITCODE[0]
CMD RUNTIME[0.0474s]
STDOUT[
totalPowerConsumption.0 = 202
]
SNMP STATUS[TRUE]
Store in cache Table OID: NETONIX-SWITCH-MIB::totalPowerConsumption
Discover sensor: [class: power, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.6.0.0, index: 0, type: NETONIX-SWITCH-MIB-totalPowerConsumption, descr: Total Power Consumption, scale: 0.1, limits: (, , , ), CURRENT: 20.2, ,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-totalPowerConsumption' AND `sensor_index` = '0')]
SQL RUNTIME[0.00066018s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-totalPowerConsumption' AND `sensor_index` = '0']
SQL RUNTIME[0.00047016s]
LCurrent sensor value: "20.2", scale: "0.1"
  limit_high: "37.65" -> "30.3"
  limit_high_warn: "" -> ""
  limit_low: "" -> ""
  limit_low_warn: "" -> ""


SQL[UPDATE `sensors` set `sensor_limit` ='30.3' WHERE `sensor_id` = '116']
SQL RUNTIME[0.00466895s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '116' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00040102s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '116' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00028920s]
.] dcdcInputCurrent [
CMD[/usr/bin/snmpbulkwalk -t '5' -v2c -c *** -Pud -Ih -OQUsb -m NETONIX-SWITCH-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/netonix 'udp':'sb-hny-dsw-01.example.com':'161' dcdcInputCurrent]

CMD EXITCODE[0]
CMD RUNTIME[0.0481s]
STDOUT[
dcdcInputCurrent.0 = 0
]
SNMP STATUS[TRUE]
Store in cache Table OID: NETONIX-SWITCH-MIB::dcdcInputCurrent
Excluded by current value (0) is equals or below min (0).
] dcdcEfficiency [
CMD[/usr/bin/snmpbulkwalk -t '5' -v2c -c *** -Pud -Ih -OQUsb -m NETONIX-SWITCH-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/netonix 'udp':'sb-hny-dsw-01.example.com':'161' dcdcEfficiency]

CMD EXITCODE[0]
CMD RUNTIME[0.0846s]
STDOUT[
dcdcEfficiency = 0
]
SNMP STATUS[TRUE]
Warning. SNMP line 'dcdcEfficiency = 0' not have index part
] fanSpeed [
CMD[/usr/bin/snmpbulkwalk -t '5' -v2c -c *** -Pud -Ih -OQUsb -m NETONIX-SWITCH-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/netonix 'udp':'sb-hny-dsw-01.example.com':'161' fanTable]

CMD EXITCODE[0]
CMD RUNTIME[0.3106s]
STDOUT[
fanIndex.1 = 1
fanSpeed.1 = 8850
]
SNMP STATUS[TRUE]
Store in cache Table OID: NETONIX-SWITCH-MIB::fanTable
Discover sensor: [class: fanspeed, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.2.1.2.1, index: 1, type: NETONIX-SWITCH-MIB-fanSpeed, descr: Fan, scale: 1, limits: (, , , ), CURRENT: 8850, ,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'fanspeed' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-fanSpeed' AND `sensor_index` = '1')]
SQL RUNTIME[0.00069594s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'fanspeed' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-fanSpeed' AND `sensor_index` = '1']
SQL RUNTIME[0.00055599s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '117' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00029278s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '117' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00025892s]
.] temp [
CMD[/usr/bin/snmpbulkwalk -t '5' -v2c -c *** -Pud -Ih -OQUsb -m NETONIX-SWITCH-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/netonix 'udp':'sb-hny-dsw-01.example.com':'161' tempTable]

CMD EXITCODE[0]
CMD RUNTIME[0.0482s]
CMD EXITDELAY[10ms]
STDOUT[
tempIndex.1 = 1
tempIndex.2 = 2
tempIndex.3 = 3
tempDescription.1 = "Board Temp"
tempDescription.2 = "CPU Temp"
tempDescription.3 = "PHY Temp"
temp.1 = 55
temp.2 = 67
temp.3 = 66
]
SNMP STATUS[TRUE]
Store in cache Table OID: NETONIX-SWITCH-MIB::tempTable
Discover sensor: [class: temperature, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.3.1.3.1, index: 1, type: NETONIX-SWITCH-MIB-temp, descr: Board Temp, scale: 1, limits: (, , , ), CURRENT: 55, ,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-temp' AND `sensor_index` = '1')]
SQL RUNTIME[0.00070405s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-temp' AND `sensor_index` = '1']
SQL RUNTIME[0.00046611s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '118' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00028682s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '118' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00027704s]
.Discover sensor: [class: temperature, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.3.1.3.2, index: 2, type: NETONIX-SWITCH-MIB-temp, descr: CPU Temp, scale: 1, limits: (, , , ), CURRENT: 67, ,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-temp' AND `sensor_index` = '2')]
SQL RUNTIME[0.00037408s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-temp' AND `sensor_index` = '2']
SQL RUNTIME[0.00042009s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '119' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00028992s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '119' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00026417s]
.Discover sensor: [class: temperature, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.3.1.3.3, index: 3, type: NETONIX-SWITCH-MIB-temp, descr: PHY Temp, scale: 1, limits: (, , , ), CURRENT: 66, ,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-temp' AND `sensor_index` = '3')]
SQL RUNTIME[0.00043297s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-temp' AND `sensor_index` = '3']
SQL RUNTIME[0.00040388s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '120' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00033998s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '120' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00027490s]
.] voltage [
CMD[/usr/bin/snmpbulkwalk -t '5' -v2c -c *** -Pud -Ih -OQUsb -m NETONIX-SWITCH-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/netonix 'udp':'sb-hny-dsw-01.example.com':'161' voltageTable]

CMD EXITCODE[0]
CMD RUNTIME[0.0503s]
STDOUT[
voltageIndex.1 = 1
voltageIndex.2 = 2
voltageIndex.3 = 3
voltageDescription.1 = "Board 48V"
voltageDescription.2 = "Board 24V"
voltageDescription.3 = "Board 3V"
voltage.1 = 4850
voltage.2 = 2440
voltage.3 = 330
]
SNMP STATUS[TRUE]
Store in cache Table OID: NETONIX-SWITCH-MIB::voltageTable
Discover sensor: [class: voltage, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.4.1.3.1, index: 1, type: NETONIX-SWITCH-MIB-voltage, descr: Board 48V, scale: 0.01, limits: (, , , ), CURRENT: 48.5, ,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-voltage' AND `sensor_index` = '1')]
SQL RUNTIME[0.00072193s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-voltage' AND `sensor_index` = '1']
SQL RUNTIME[0.00046897s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '121' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00028515s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '121' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00039601s]
.Discover sensor: [class: voltage, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.4.1.3.2, index: 2, type: NETONIX-SWITCH-MIB-voltage, descr: Board 24V, scale: 0.01, limits: (, , , ), CURRENT: 24.4, ,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-voltage' AND `sensor_index` = '2')]
SQL RUNTIME[0.00037599s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-voltage' AND `sensor_index` = '2']
SQL RUNTIME[0.00046301s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '122' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00048900s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '122' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00030804s]
.Discover sensor: [class: voltage, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.4.1.3.3, index: 3, type: NETONIX-SWITCH-MIB-voltage, descr: Board 3V, scale: 0.01, limits: (, , , ), CURRENT: 3.3, ,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-voltage' AND `sensor_index` = '3')]
SQL RUNTIME[0.00034904s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '47' AND `sensor_type` = 'NETONIX-SWITCH-MIB-voltage' AND `sensor_index` = '3']
SQL RUNTIME[0.00044298s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '123' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00026107s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '123' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00024605s]
.]
 o NETONIX-SWITCH-MIB
CMD[/usr/bin/snmpbulkwalk -t '5' -v2c -c *** -Pud -OQUs -m POWER-ETHERNET-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'sb-hny-dsw-01.example.com':'161' pethMainPseTable]

CMD EXITCODE[0]
CMD RUNTIME[0.1298s]
STDOUT[
pethMainPseOperStatus.1 = off
pethMainPseOperStatus.2 = off
pethMainPseOperStatus.3 = off
pethMainPseOperStatus.4 = off
pethMainPseOperStatus.5 = off
pethMainPseOperStatus.6 = off
pethMainPseOperStatus.7 = off
pethMainPseOperStatus.8 = on
pethMainPseOperStatus.9 = on
pethMainPseOperStatus.10 = off
pethMainPseOperStatus.11 = off
pethMainPseOperStatus.12 = on
pethMainPseOperStatus.13 = off
pethMainPseOperStatus.14 = off
pethMainPseConsumptionPower.1 = 0
pethMainPseConsumptionPower.2 = 0
pethMainPseConsumptionPower.3 = 0
pethMainPseConsumptionPower.4 = 0
pethMainPseConsumptionPower.5 = 0
pethMainPseConsumptionPower.6 = 0
pethMainPseConsumptionPower.7 = 0
pethMainPseConsumptionPower.8 = 6
pethMainPseConsumptionPower.9 = 3
pethMainPseConsumptionPower.10 = 0
pethMainPseConsumptionPower.11 = 0
pethMainPseConsumptionPower.12 = 0
pethMainPseConsumptionPower.13 = 0
pethMainPseConsumptionPower.14 = 0
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '5' -v2c -c *** -Pud -OQUs -m NETONIX-SWITCH-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/netonix 'udp':'sb-hny-dsw-01.example.com':'161' poeStatusTable]

CMD EXITCODE[0]
CMD RUNTIME[0.0876s]
STDOUT[
poeStatus.1 = Off
poeStatus.2 = Off
poeStatus.3 = Off
poeStatus.4 = Off
poeStatus.5 = Off
poeStatus.6 = Off
poeStatus.7 = Off
poeStatus.8 = 24V
poeStatus.9 = 24V
poeStatus.10 = Off
poeStatus.11 = Off
poeStatus.12 = 24V
poeStatus.13 = Off
poeStatus.14 = Off
]
SNMP STATUS[TRUE]

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '1' LIMIT 1]
SQL RUNTIME[0.00075102s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '708']
SQL RUNTIME[0.00031304s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '47']
SQL RUNTIME[0.00051498s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '47']
SQL RUNTIME[0.00031686s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.1, index: pethMainPseOperStatus.1, type: power-ethernet-mib-pse-state, descr: Port 1 PoE Status, CURRENT: 2, 1, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.1' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00034904s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.1' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00041103s]
.Skipped by 'exclude' event value: , Port 1 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '2' LIMIT 1]
SQL RUNTIME[0.00041604s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '709']
SQL RUNTIME[0.00026894s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.2, index: pethMainPseOperStatus.2, type: power-ethernet-mib-pse-state, descr: Port 2 PoE Status, CURRENT: 2, 2, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.2' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00030684s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.2' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00034714s]
.Skipped by 'exclude' event value: , Port 2 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '3' LIMIT 1]
SQL RUNTIME[0.00037098s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '710']
SQL RUNTIME[0.00026393s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.3, index: pethMainPseOperStatus.3, type: power-ethernet-mib-pse-state, descr: Port 3 PoE Status, CURRENT: 2, 3, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.3' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00029588s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.3' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00034690s]
.Skipped by 'exclude' event value: , Port 3 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '4' LIMIT 1]
SQL RUNTIME[0.00039387s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '711']
SQL RUNTIME[0.00026202s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.4, index: pethMainPseOperStatus.4, type: power-ethernet-mib-pse-state, descr: Port 4 PoE Status, CURRENT: 2, 4, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.4' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00030017s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.4' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00036502s]
.Skipped by 'exclude' event value: , Port 4 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '5' LIMIT 1]
SQL RUNTIME[0.00049591s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '712']
SQL RUNTIME[0.00026202s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.5, index: pethMainPseOperStatus.5, type: power-ethernet-mib-pse-state, descr: Port 5 PoE Status, CURRENT: 2, 5, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.5' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00029397s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.5' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00033712s]
.Skipped by 'exclude' event value: , Port 5 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '6' LIMIT 1]
SQL RUNTIME[0.00042892s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '713']
SQL RUNTIME[0.00025892s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.6, index: pethMainPseOperStatus.6, type: power-ethernet-mib-pse-state, descr: Port 6 PoE Status, CURRENT: 2, 6, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.6' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00028801s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.6' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00053310s]
.Skipped by 'exclude' event value: , Port 6 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '7' LIMIT 1]
SQL RUNTIME[0.00037098s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '714']
SQL RUNTIME[0.00025296s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.7, index: pethMainPseOperStatus.7, type: power-ethernet-mib-pse-state, descr: Port 7 PoE Status, CURRENT: 2, 7, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.7' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00035691s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.7' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00034404s]
.Skipped by 'exclude' event value: , Port 7 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '8' LIMIT 1]
SQL RUNTIME[0.00037098s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '715']
SQL RUNTIME[0.00028181s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.8, index: pethMainPseOperStatus.8, type: power-ethernet-mib-pse-state, descr: Port 8 PoE Status, CURRENT: 1, 8, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.8' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00038505s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.8' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00032783s]
.Discover sensor: [class: power, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.4.8, index: pethMainPseConsumptionPower.8, type: power-ethernet-mib, descr: Port 8 PoE Power, scale: 1, limits: (, , , ), CURRENT: 6, 8,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '47' AND `sensor_type` = 'power-ethernet-mib' AND `sensor_index` = 'pethMainPseConsumptionPower.8')]
SQL RUNTIME[0.00063300s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '47' AND `sensor_type` = 'power-ethernet-mib' AND `sensor_index` = 'pethMainPseConsumptionPower.8']
SQL RUNTIME[0.00042892s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '196' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00041819s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '196' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00025678s]
.Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.5.1.2.8, index: poeStatus.8, type: netonix-poeStatus, descr: Port 8 PoE, CURRENT: 1, 8, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'netonix-poeStatus' AND `status_index` = 'poeStatus.8' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00034595s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'netonix-poeStatus' AND `status_index` = 'poeStatus.8' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00046992s]
.
SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '9' LIMIT 1]
SQL RUNTIME[0.00037217s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '716']
SQL RUNTIME[0.00025392s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.9, index: pethMainPseOperStatus.9, type: power-ethernet-mib-pse-state, descr: Port 9 PoE Status, CURRENT: 1, 9, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.9' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00028491s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.9' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00033402s]
.Discover sensor: [class: power, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.4.9, index: pethMainPseConsumptionPower.9, type: power-ethernet-mib, descr: Port 9 PoE Power, scale: 1, limits: (, , , ), CURRENT: 3, 9,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '47' AND `sensor_type` = 'power-ethernet-mib' AND `sensor_index` = 'pethMainPseConsumptionPower.9')]
SQL RUNTIME[0.00090194s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '47' AND `sensor_type` = 'power-ethernet-mib' AND `sensor_index` = 'pethMainPseConsumptionPower.9']
SQL RUNTIME[0.00049710s]
LCurrent sensor value: "3", scale: "1"
  limit_high: "15" -> "4.5"
  limit_high_warn: "" -> ""
  limit_low: "" -> ""
  limit_low_warn: "" -> ""


SQL[UPDATE `sensors` set `sensor_limit` ='4.5' WHERE `sensor_id` = '114']
SQL RUNTIME[0.00473094s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '114' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00050497s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '114' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00028205s]
.Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.5.1.2.9, index: poeStatus.9, type: netonix-poeStatus, descr: Port 9 PoE, CURRENT: 1, 9, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'netonix-poeStatus' AND `status_index` = 'poeStatus.9' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00046086s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'netonix-poeStatus' AND `status_index` = 'poeStatus.9' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00036788s]
.
SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '10' LIMIT 1]
SQL RUNTIME[0.00047898s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '717']
SQL RUNTIME[0.00026798s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.10, index: pethMainPseOperStatus.10, type: power-ethernet-mib-pse-state, descr: Port 10 PoE Status, CURRENT: 2, 10, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.10' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00032806s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.10' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00034595s]
.Skipped by 'exclude' event value: , Port 10 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '11' LIMIT 1]
SQL RUNTIME[0.00046611s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '718']
SQL RUNTIME[0.00042200s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.11, index: pethMainPseOperStatus.11, type: power-ethernet-mib-pse-state, descr: Port 11 PoE Status, CURRENT: 2, 11, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.11' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00029707s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.11' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00033593s]
.Skipped by 'exclude' event value: , Port 11 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '12' LIMIT 1]
SQL RUNTIME[0.00046897s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '719']
SQL RUNTIME[0.00025797s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.12, index: pethMainPseOperStatus.12, type: power-ethernet-mib-pse-state, descr: Port 12 PoE Status, CURRENT: 1, 12, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.12' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00029898s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.12' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00042200s]
.Discover sensor: [class: power, device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.4.12, index: pethMainPseConsumptionPower.12, type: power-ethernet-mib, descr: Port 12 PoE Power, scale: 1, limits: (, , , ), CURRENT: 0, 12,

SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'power' AND `device_id` = '47' AND `sensor_type` = 'power-ethernet-mib' AND `sensor_index` = 'pethMainPseConsumptionPower.12')]
SQL RUNTIME[0.00034404s]

SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'power' AND `device_id` = '47' AND `sensor_type` = 'power-ethernet-mib' AND `sensor_index` = 'pethMainPseConsumptionPower.12']
SQL RUNTIME[0.00037289s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '115' AND `attrib_type` = 'sensor_addition']
SQL RUNTIME[0.00025392s]

SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '115' AND `attrib_type` = 'oid_scale_si']
SQL RUNTIME[0.00037193s]
.Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.4.1.46242.5.1.2.12, index: poeStatus.12, type: netonix-poeStatus, descr: Port 12 PoE, CURRENT: 1, 12, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'netonix-poeStatus' AND `status_index` = 'poeStatus.12' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00043511s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'netonix-poeStatus' AND `status_index` = 'poeStatus.12' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00034404s]
.
SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '13' LIMIT 1]
SQL RUNTIME[0.00037599s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '720']
SQL RUNTIME[0.00027514s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.13, index: pethMainPseOperStatus.13, type: power-ethernet-mib-pse-state, descr: Port 13 PoE Status, CURRENT: 2, 13, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.13' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00028801s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.13' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00035596s]
.Skipped by 'exclude' event value: , Port 13 PoE

SQL[SELECT * FROM `ports` WHERE `device_id` = '47' AND `ifIndex` = '14' LIMIT 1]
SQL RUNTIME[0.00035405s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '721']
SQL RUNTIME[0.00024295s]
Discover status: [device: sb-hny-dsw-01.example.com, oid: .1.3.6.1.2.1.105.1.3.1.1.3.14, index: pethMainPseOperStatus.14, type: power-ethernet-mib-pse-state, descr: Port 14 PoE Status, CURRENT: 2, 14, ]

SQL[SELECT EXISTS (SELECT 1 FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.14' AND `poller_type`= 'snmp')]
SQL RUNTIME[0.00026989s]

SQL[SELECT * FROM `status` WHERE `device_id` = '47' AND `status_type` = 'power-ethernet-mib-pse-state' AND `status_index` = 'pethMainPseOperStatus.14' AND `poller_type`= 'snmp']
SQL RUNTIME[0.00040388s]
.Skipped by 'exclude' event value: , Port 14 PoE

 o ENTITY-SENSOR-MIB
CMD[/usr/bin/snmpbulkwalk -t '5' -v2c -c *** -Pud -OQUs -m ENTITY-MIB:ENTITY-SENSOR-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'sb-hny-dsw-01.example.com':'161' entPhySensorValue]

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


 o Duration             0.9932s


SQL[SELECT `device_state` FROM `devices` WHERE `device_id` = '47';]
SQL RUNTIME[0.00049496s]

SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.9986',`force_discovery` ='0',`device_state` ='a:9:{s:2:\"la\";a:3:{s:4:\"1min\";d:0.2;s:4:\"5min\";d:0.22;s:5:\"15min\";d:0.19;}s:8:\"ucd_load\";d:0.22;s:15:\"poller_mod_perf\";a:28:{s:6:\"system\";d:0.6554;s:2:\"os\";d:0.0563;s:7:\"sensors\";d:0.6362;s:6:\"status\";d:0.3642;s:7:\"counter\";d:0.003;s:10:\"processors\";d:0.2651;s:8:\"mempools\";d:0.1774;s:7:\"storage\";d:0.3579;s:8:\"netstats\";d:0.8577;s:7:\"ucd-mib\";d:0.2463;s:13:\"ipSystemStats\";d:0.2606;s:5:\"ports\";d:3.2423;s:9:\"bgp-peers\";d:0.2429;s:15:\"printersupplies\";d:0.0026;s:10:\"ucd-diskio\";d:0.0076;s:4:\"wifi\";d:0.0023;s:10:\"p2p-radios\";d:0.0007;s:4:\"ospf\";d:0.0002;s:3:\"sla\";d:0.0034;s:11:\"pseudowires\";d:0.0007;s:14:\"mac-accounting\";d:0.0007;s:12:\"loadbalancer\";d:0.0003;s:15:\"entity-physical\";d:0.0001;s:12:\"applications\";d:0.0014;s:9:\"fdb-table\";d:0.305;s:6:\"graphs\";d:0.363;s:4:\"oids\";d:0.001;s:6:\"probes\";d:0.0013;}s:10:\"ucd_ss_cpu\";a:8:{s:12:\"ssCpuRawUser\";a:1:{s:4:\"perc\";d:10.828070478109451;}s:12:\"ssCpuRawNice\";a:1:{s:4:\"perc\";i:0;}s:14:\"ssCpuRawSystem\";a:1:{s:4:\"perc\";d:5.28639759239402;}s:12:\"ssCpuRawIdle\";a:1:{s:4:\"perc\";d:78.5991343371025;}s:17:\"ssCpuRawInterrupt\";a:1:{s:4:\"perc\";d:0.09605473415911628;}s:15:\"ssCpuRawSoftIRQ\";a:1:{s:4:\"perc\";d:0.015400259757340716;}s:14:\"ssCpuRawKernel\";a:1:{s:4:\"perc\";d:5.174942598477563;}s:12:\"ssCpuRawWait\";a:1:{s:4:\"perc\";i:0;}}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:\"126348\";s:9:\"mem_avail\";s:5:\"64004\";s:10:\"mem_shared\";s:1:\"0\";s:10:\"mem_buffer\";s:4:\"4456\";s:10:\"mem_cached\";s:5:\"24260\";s:8:\"mem_used\";i:33628;}s:17:\"poller_ports_perf\";a:1:{s:4:\"vlan\";d:0.4812028408050537;}s:14:\"poller_history\";a:288:{i:1625248265;d:8.3897;i:1625247973;d:10.2282;i:1625247668;d:8.2756;i:1625247377;d:10.9018;i:1625247081;d:10.5862;i:1625247066;d:8.783;i:1625246762;d:12.0181;i:1625246465;d:11.4286;i:1625246165;d:10.4207;i:1625245868;d:10.8329;i:1625245564;d:10.5276;i:1625245276;d:9.7978;i:1625244964;d:9.617;i:1625244673;d:11.8104;i:1625244366;d:8.8745;i:1625244068;d:10.1647;i:1625243764;d:10.8874;i:1625243455;d:13.1646;i:1625243176;d:15.0324;i:1625242856;d:7.3829;i:1625242572;d:16.751;i:1625242283;d:9.6894;i:1625241972;d:10.3591;i:1625241677;d:9.4118;i:1625241366;d:7.0545;i:1625241070;d:11.633;i:1625240766;d:10.5096;i:1625240470;d:11.3461;i:1625240167;d:10.1486;i:1625239865;d:11.5254;i:1625239564;d:10.9638;i:1625239273;d:10.8975;i:1625238966;d:8.9985;i:1625238664;d:11.0665;i:1625238366;d:12.0959;i:1625238068;d:12.0967;i:1625237766;d:10.4292;i:1625235369;d:9.9649;i:1625235076;d:9.6398;i:1625234768;d:10.7539;i:1625234465;d:11.7018;i:1625234166;d:11.4616;i:1625233866;d:13.3783;i:1625233567;d:12.2121;i:1625233264;d:11.4674;i:1625232970;d:12.36;i:1625232662;d:10.2448;i:1625232364;d:10.9304;i:1625232063;d:10.6285;i:1625231765;d:11.5609;i:1625231464;d:10.9781;i:1625231163;d:10.6102;i:1625230867;d:10.9959;i:1625230568;d:10.8783;i:1625230262;d:10.0178;i:1625229961;d:11.3356;i:1625229667;d:11.4391;i:1625229360;d:9.2346;i:1625229069;d:11.5749;i:1625228760;d:10.9092;i:1625228466;d:12.4639;i:1625228163;d:11.0455;i:1625227864;d:11.0419;i:1625227563;d:11.3214;i:1625227266;d:11.6604;i:1625226970;d:10.3702;i:1625226660;d:8.1158;i:1625226362;d:11.4843;i:1625226069;d:10.8878;i:1625225756;d:7.7659;i:1625225468;d:11.7684;i:1625225161;d:10.2014;i:1625224872;d:10.6641;i:1625224558;d:6.375;i:1625224266;d:11.2286;i:1625223965;d:10.8943;i:1625223661;d:11.0521;i:1625223362;d:12.201;i:1625223062;d:9.9239;i:1625222765;d:11.9184;i:1625222462;d:11.6548;i:1625222162;d:9.873;i:1625221862;d:11.6102;i:1625221566;d:10.9433;i:1625221266;d:10.8231;i:1625220967;d:11.9109;i:1625220664;d:9.7929;i:1625220365;d:10.637;i:1625220063;d:10.8632;i:1625219768;d:11.2087;i:1625219460;d:8.7512;i:1625219163;d:12.0342;i:1625218862;d:12.1691;i:1625218570;d:10.9128;i:1625218279;d:9.1593;i:1625217952;d:6.1179;i:1625217669;d:15.791;i:1625217361;d:8.6138;i:1625217067;d:11.8684;i:1625216763;d:9.4884;i:1625216464;d:10.4438;i:1625216165;d:10.8845;i:1625215880;d:9.8153;i:1625215547;d:5.7365;i:1625215268;d:16.7895;i:1625214975;d:9.9855;i:1625214661;d:7.242;i:1625214363;d:11.8475;i:1625214071;d:10.7558;i:1625213767;d:8.7908;i:1625213468;d:11.1487;i:1625213171;d:10.4168;i:1625212869;d:10.1989;i:1625212569;d:10.1529;i:1625212272;d:10.6769;i:1625211974;d:9.9376;i:1625211664;d:8.7056;i:1625211371;d:14.8666;i:1625211069;d:10.2153;i:1625210770;d:9.9316;i:1625210467;d:9.3468;i:1625210175;d:10.6683;i:1625209874;d:9.8447;i:1625209574;d:10.0664;i:1625209272;d:9.3201;i:1625208976;d:10.486;i:1625208678;d:9.7568;i:1625208377;d:9.0761;i:1625208073;d:9.6334;i:1625207783;d:10.4412;i:1625207476;d:10.0648;i:1625207177;d:9.985;i:1625206872;d:8.6666;i:1625206577;d:10.2957;i:1625206272;d:8.3827;i:1625205972;d:10.0836;i:1625205678;d:9.9613;i:1625205377;d:9.1116;i:1625205093;d:9.3279;i:1625204753;d:5.1551;i:1625204484;d:19.5721;i:1625204178;d:6.1359;i:1625203885;d:14.7171;i:1625203583;d:10.0709;i:1625203291;d:13.9807;i:1625202985;d:8.6453;i:1625202692;d:9.9225;i:1625202379;d:6.5283;i:1625202077;d:15.166;i:1625201779;d:14.1856;i:1625201487;d:14.466;i:1625201190;d:9.232;i:1625200891;d:8.8781;i:1625200566;d:4.8261;i:1625200285;d:18.847;i:1625199982;d:10.2365;i:1625199684;d:9.5973;i:1625199384;d:9.9006;i:1625199080;d:8.5975;i:1625198749;d:9.9427;i:1625198495;d:24.8434;i:1625198196;d:9.0611;i:1625197893;d:9.309;i:1625197567;d:5.1688;i:1625197292;d:18.4525;i:1625196988;d:8.5376;i:1625196678;d:10.9015;i:1625196378;d:10.2282;i:1625196070;d:7.6903;i:1625195787;d:15.5082;i:1625195473;d:8.3844;i:1625195181;d:10.5984;i:1625194883;d:8.8465;i:1625194583;d:10.4536;i:1625194284;d:9.2888;i:1625193990;d:9.556;i:1625193688;d:8.9287;i:1625193385;d:9.7515;i:1625193082;d:10.1241;i:1625192772;d:9.0315;i:1625192481;d:13.7427;i:1625192174;d:7.947;i:1625191882;d:14.1181;i:1625191578;d:10.5341;i:1625191284;d:10.199;i:1625190981;d:9.8102;i:1625190676;d:10.439;i:1625190373;d:9.5824;i:1625190074;d:10.992;i:1625189777;d:10.3002;i:1625189479;d:10.4888;i:1625189181;d:8.1729;i:1625188882;d:10.6376;i:1625188572;d:8.7252;i:1625188265;d:11.8767;i:1625187979;d:15.1335;i:1625187681;d:9.9565;i:1625187382;d:8.8198;i:1625187069;d:7.2142;i:1625186775;d:13.7318;i:1625186484;d:14.4388;i:1625186165;d:7.815;i:1625185882;d:14.7492;i:1625185558;d:6.4401;i:1625185272;d:14.8454;i:1625184977;d:9.4329;i:1625184659;d:5.0316;i:1625184369;d:14.9927;i:1625184069;d:11.619;i:1625183782;d:14.2023;i:1625183481;d:8.2586;i:1625183135;d:4.6783;i:1625182871;d:20.771;i:1625182572;d:11.2603;i:1625182275;d:9.7192;i:1625181965;d:9.0485;i:1625181667;d:10.3388;i:1625181366;d:10.5285;i:1625181067;d:10.4515;i:1625180765;d:10.9909;i:1625180473;d:12.6011;i:1625180175;d:10.8348;i:1625179868;d:9.6537;i:1625179575;d:10.3291;i:1625179270;d:8.3798;i:1625178973;d:11.5048;i:1625178662;d:10.1578;i:1625178378;d:14.7733;i:1625178068;d:8.1781;i:1625177785;d:12.7333;i:1625177463;d:5.5163;i:1625177170;d:15.6149;i:1625176872;d:9.7021;i:1625176575;d:9.993;i:1625176274;d:9.1726;i:1625175966;d:8.4235;i:1625175670;d:13.8187;i:1625175378;d:9.6853;i:1625175075;d:8.003;i:1625174770;d:8.1439;i:1625173582;d:11.0145;i:1625172683;d:9.874;i:1625172366;d:7.0963;i:1625172066;d:11.4465;i:1625171769;d:10.085;i:1625171481;d:11.9133;i:1625171170;d:9.7977;i:1625170882;d:13.6236;i:1625170573;d:11.1294;i:1625168480;d:10.4247;i:1625168167;d:11.9943;i:1625167868;d:11.528;i:1625167570;d:9.366;i:1625167276;d:10.2845;i:1625166979;d:10.1834;i:1625166672;d:8.2971;i:1625166374;d:10.6335;i:1625166070;d:8.7379;i:1625165766;d:11.8171;i:1625165482;d:14.5992;i:1625165167;d:8.4875;i:1625164859;d:11.8229;i:1625164584;d:16.1101;i:1625164274;d:8.7587;i:1625163978;d:11.4517;i:1625163685;d:8.8095;i:1625163379;d:10.7694;i:1625163065;d:5.7399;i:1625162478;d:15.6986;i:1625162174;d:10.0899;i:1625161874;d:9.7087;i:1625161580;d:9.8548;i:1625161273;d:9.505;i:1625160967;d:9.5381;i:1625160667;d:10.7897;i:1625160376;d:11.4128;i:1625160070;d:8.184;i:1625159772;d:11.3496;i:1625159469;d:10.8484;i:1625159171;d:11.7382;i:1625158873;d:10.1577;i:1625158573;d:11.3523;i:1625158257;d:8.3416;i:1625157961;d:9.7344;i:1625157656;d:9.0567;i:1625157364;d:10.0628;i:1625157081;d:9.4101;i:1625156756;d:6.1201;}s:17:\"discovery_history\";a:100:{i:1625248312;d:0.9986;i:1625247800;d:0.8915;i:1625246855;d:1.1523;i:1625246641;d:5.6013;i:1625246554;d:5.4804;i:1625246507;d:5.5241;i:1625233019;d:5.5328;i:1625211386;d:7.3147;i:1625190609;d:5.5525;i:1625168180;d:10.2901;i:1625146522;d:5.9385;i:1625125402;d:5.4383;i:1625103446;d:10.3968;i:1625081726;d:5.5021;i:1625060378;d:5.5262;i:1625038554;d:8.1814;i:1625017195;d:6.2661;i:1624995359;d:7.8856;i:1624973896;d:5.5097;i:1624952187;d:7.8716;i:1624930608;d:6.3014;i:1624909021;d:5.4839;i:1624887333;d:6.901;i:1624867009;d:5.564;i:1624844196;d:11.9648;i:1624823900;d:5.4316;i:1624800965;d:13.544;i:1624780903;d:5.6215;i:1624757768;d:14.1286;i:1624736134;d:5.7904;i:1624714649;d:5.7102;i:1624692947;d:6.0492;i:1624671334;d:5.8943;i:1624650887;d:5.5342;i:1624628219;d:10.5688;i:1624606496;d:6.0931;i:1624584933;d:5.8713;i:1624563454;d:5.5294;i:1624541801;d:5.4533;i:1624520903;d:5.6902;i:1624498584;d:13.8419;i:1624478264;d:5.57;i:1624455371;d:11.7438;i:1624433802;d:5.4801;i:1624412233;d:5.7162;i:1624390589;d:7.2107;i:1624369004;d:5.687;i:1624347294;d:5.5897;i:1624325829;d:5.4867;i:1624304269;d:5.5852;i:1624282534;d:6.7026;i:1624261702;d:5.4609;i:1624241037;d:10.3749;i:1624217761;d:15.1748;i:1624196220;d:5.4616;i:1624174496;d:6.9842;i:1624153970;d:5.3709;i:1624131333;d:11.0512;i:1624109847;d:5.6838;i:1624088152;d:7.3511;i:1624067662;d:5.396;i:1624045208;d:10.6537;i:1624023421;d:8.1504;i:1624001685;d:5.6403;i:1623980375;d:5.5091;i:1623960639;d:7.8765;i:1623936900;d:15.9445;i:1623917069;d:5.8193;i:1623893774;d:23.2384;i:1623872319;d:5.4545;i:1623850624;d:7.1289;i:1623828894;d:5.613;i:1623807500;d:5.5603;i:1623785848;d:5.5357;i:1623766042;d:5.5659;i:1623742502;d:17.5994;i:1623722341;d:5.6052;i:1623699436;d:12.3668;i:1623679684;d:5.4048;i:1623656098;d:16.1222;i:1623634704;d:5.487;i:1623613033;d:7.1642;i:1623591292;d:5.5288;i:1623570571;d:5.3811;i:1623548244;d:10.7745;i:1623526682;d:5.58;i:1623505053;d:5.6974;i:1623483293;d:5.4017;i:1623461849;d:5.428;i:1623440227;d:6.903;i:1623418653;d:5.2752;i:1623397699;d:5.3041;i:1623375477;d:10.344;i:1623353821;d:6.8669;i:1623332248;d:5.3218;i:1623311071;d:5.384;i:1623290043;d:10.5694;i:1623267554;d:10.5293;i:1623245827;d:7.1738;i:1623224620;d:5.4322;}s:18:\"discovery_mod_perf\";a:1:{s:7:\"sensors\";d:0.9932;}}' WHERE `device_id` = '47']
SQL RUNTIME[0.00505114s]
#####  sb-hny-dsw-01.example.com [47] completed discovery modules at 2021-07-02 17:51:53  #####

 o Discovery time       0.9986 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '17995' AND `process_name` = 'discovery.php' AND `device_id` = '47' AND `poller_id` = '0']
SQL RUNTIME[0.00479984s]
#####  Finished discovery run at 2021-07-02 17:51:53  #####

./discovery.php: sb-hny-dsw-01.example.com - 1 devices discovered in 1.135 secs

SQL[SELECT * FROM `observium_processes` WHERE `poller_id` = '0' AND `process_start` < '1625233912']
SQL RUNTIME[0.00040102s]
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.135 secs
 o Memory usage         6MB (peak: 6MB)
 o MySQL Usage          Cell[33/0.017s] Row[69/0.033s] Rows[56/0.024s] Column[1/0s] Update[3/0.015s] Insert[1/0.005s] Delete[1/0.005s]
 o RRDTool Usage