LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.41ms] SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.31ms] SQL[[1;33mselect version() [0;33m[][0m 0.32ms] =========================================== Component | Version --------- | ------- LibreNMS | 23.5.0 (2023-05-19T11:32:19-04:00) DB Schema | 2023_05_12_071412_devices_expand_timetaken_doubles (251) PHP | 8.1.11 Python | 3.9.10 Database | MariaDB 10.5.16-MariaDB RRDTool | 1.7.2 SNMP | 5.9.1 =========================================== DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.1.250.132' ORDER BY `device_id` ASC [0;33m[][0m 0.69ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[661][0m 0.37ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[661][0m 0.32ms] Attempting to initialize OS: linux Attempting to initialize Group OS: unix OS initialized: LibreNMS\OS\Shared\Unix Hostname: 10.1.250.132 Device ID: 661 OS: linux (unix) [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '10.1.250.132' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.185/0.195/0.209 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = NET-SNMP-MIB::netSnmpAgentOIDs.10 SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.185,0.209,0.195,3,3,0,"{\"poller_name\":\"librenms.indypl.org\"}",661,"2023-06-22 07:41:47"][0m 0.31ms] SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.195,661][0m 0.25ms] SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[661][0m 0.34ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m] .*.*.0 = 167563 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 1676 HOST-RESOURCES-MIB::hrSystemUptime.0 = 518002 Uptime seconds: 5180 Uptime: 1 hour 26 minutes 20 seconds SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[5180,661][0m 0.26ms] >> Runtime for poller module 'core': 0.0593 seconds with 119328 bytes >> [0;36mSNMP[0m: [2/0.06s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module core #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[46][0m 0.26ms] Location: Unknown Hardware: Generic x86 64-bit OS Version: 6.1.34 OS Features: Serial: >> Runtime for poller module 'os': 0.0027 seconds with 122288 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[661][0m 0.24ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[661][0m 0.21ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[661,1687347707][0m 0.24ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.66,2613][0m 0.15ms] 1 day : 99.66% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[661,1686829307][0m 0.23ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.951,2614][0m 0.15ms] 1 week : 99.951% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[661,1684842107][0m 0.22ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.989,2615][0m 0.16ms] 1 month : 99.989% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[661,1655898107][0m 0.22ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.999,2616][0m 0.14ms] 1 year : 99.999% >> Runtime for poller module 'availability': 0.0050 seconds with 25480 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.02s] #### Unload poller module availability #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[661][0m 0.27ms] array ( ) >> Runtime for poller module 'ipmi': 0.0007 seconds with 2528 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module ipmi #### Modules status: Global+ OS Device #### Load poller module sensors #### SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[661][0m 0.27ms] >> Runtime for poller module 'sensors': 0.0005 seconds with 280 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: linux Attempting to initialize Group OS: unix OS initialized: LibreNMS\OS\Shared\Unix SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[661][0m 0.25ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.3.3.1.2.196608'[0m] .*.*.*608 = 1 array ( '.1.3.6.1.2.1.25.3.3.1.2.196608' => '1', ) Intel Xeon Gold 6140 @ 2.30GHz: 1% >> Runtime for poller module 'processors': 0.0282 seconds with 60456 bytes >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module processors #### Modules status: Global+ OS Device #### Load poller module mempools #### SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[661][0m 0.42ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.2.3.1.6.1' '.1.3.6.1.2.1.25.2.3.1.6.3' '.1.3.6.1.2.1.25.2.3.1.6.6' '.1.3.6.1.2.1.25.2.3.1.6.7' '.1.3.6.1.2.1.25.2.3.1.6.8'[0m] .*.*.* = 932188 .*.*.* = 932188 .*.*.* = 153768 .*.*.* = 616880 .*.*.* = 4636 Free memory adjusted by availability calculation: 14.75 GiB -> 15.48 GiB hrstorage [system]: Physical memory: 17.75 MiB / 15.63 GiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[165416960,16621936640,787][0m 0.29ms] hrstorage [virtual]: Virtual memory: 6�0.34 MiB / 15.63 GiB hrstorage [buffers]: Memory buffers: 10.16 MiB / 15.63 GiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[157458432,16629895168,789][0m 0.18ms] hrstorage [cached]: Cached memory: 4`2.42 MiB / 15.63 GiB hrstorage [shared]: Shared memory: 0% 4.53 MiB / 15.63 GiB >> Runtime for poller module 'mempools': 0.0324 seconds with 169536 bytes >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [3/0.01s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[661][0m 0.35ms] Storage /dev/shm: hrstorage SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m] hrStorageIndex.1 = 1 hrStorageIndex.3 = 3 hrStorageIndex.6 = 6 hrStorageIndex.7 = 7 hrStorageIndex.8 = 8 hrStorageIndex.10 = 10 hrStorageIndex.11 = 11 hrStorageIndex.33 = 33 hrStorageIndex.35 = 35 hrStorageIndex.37 = 37 hrStorageIndex.39 = 39 hrStorageIndex.40 = 40 hrStorageIndex.52 = 52 hrStorageIndex.55 = 55 hrStorageType.1 = hrStorageRam hrStorageType.3 = hrStorageVirtualMemory hrStorageType.6 = hrStorageOther hrStorageType.7 = hrStorageOther hrStorageType.8 = hrStorageOther hrStorageType.10 = hrStorageVirtualMemory hrStorageType.11 = hrStorageOther hrStorageType.33 = hrStorageFixedDisk hrStorageType.35 = hrStorageFixedDisk hrStorageType.37 = hrStorageFixedDisk hrStorageType.39 = hrStorageFixedDisk hrStorageType.40 = hrStorageFixedDisk hrStorageType.52 = hrStorageFixedDisk hrStorageType.55 = hrStorageFixedDisk hrStorageDescr.1 = Physical memory hrStorageDescr.3 = Virtual memory hrStorageDescr.6 = Memory buffers hrStorageDescr.7 = Cached memory hrStorageDescr.8 = Shared memory hrStorageDescr.10 = Swap space hrStorageDescr.11 = Available memory hrStorageDescr.33 = /dev/shm hrStorageDescr.35 = /run hrStorageDescr.37 = /run/wrappers hrStorageDescr.39 = / hrStorageDescr.40 = /nix/store hrStorageDescr.52 = /boot hrStorageDescr.55 = /run/user/1000 hrStorageAllocationUnits.1 = 1024 hrStorageAllocationUnits.3 = 1024 hrStorageAllocationUnits.6 = 1024 hrStorageAllocationUnits.7 = 1024 hrStorageAllocationUnits.8 = 1024 hrStorageAllocationUnits.10 = 1024 hrStorageAllocationUnits.11 = 1024 hrStorageAllocationUnits.33 = 4096 hrStorageAllocationUnits.35 = 4096 hrStorageAllocationUnits.37 = 4096 hrStorageAllocationUnits.39 = 4096 hrStorageAllocationUnits.40 = 4096 hrStorageAllocationUnits.52 = 4096 hrStorageAllocationUnits.55 = 4096 hrStorageSize.1 = 16393900 hrStorageSize.3 = 16393900 hrStorageSize.6 = 16393900 hrStorageSize.7 = 616880 hrStorageSize.8 = 4636 hrStorageSize.10 = 0 hrStorageSize.11 = 15923672 hrStorageSize.33 = 2049238 hrStorageSize.35 = 1024619 hrStorageSize.37 = 2049238 hrStorageSize.39 = 12692951 hrStorageSize.40 = 12692951 hrStorageSize.52 = 130812 hrStorageSize.55 = 409847 hrStorageUsed.1 = 932188 hrStorageUsed.3 = 932188 hrStorageUsed.6 = 153768 hrStorageUsed.7 = 616880 hrStorageUsed.8 = 4636 hrStorageUsed.10 = 0 hrStorageUsed.11 = 0 hrStorageUsed.33 = 0 hrStorageUsed.35 = 1051 hrStorageUsed.37 = 108 hrStorageUsed.39 = 626824 hrStorageUsed.40 = 626824 hrStorageUsed.52 = 8177 hrStorageUsed.55 = 0 array ( 'hrstorage' => array ( 1 => array ( 'hrStorageIndex' => '1', 'hrStorageType' => 'hrStorageRam', 'hrStorageDescr' => 'Physical memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '16393900', 'hrStorageUsed' => '932188', ), 3 => array ( 'hrStorageIndex' => '3', 'hrStorageType' => 'hrStorageVirtualMemory', 'hrStorageDescr' => 'Virtual memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '16393900', 'hrStorageUsed' => '932188', ), 6 => array ( 'hrStorageIndex' => '6', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Memory buffers', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '16393900', 'hrStorageUsed' => '153768', ), 7 => array ( 'hrStorageIndex' => '7', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Cached memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '616880', 'hrStorageUsed' => '616880', ), 8 => array ( 'hrStorageIndex' => '8', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Shared memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '4636', 'hrStorageUsed' => '4636', ), 10 => array ( 'hrStorageIndex' => '10', 'hrStorageType' => 'hrStorageVirtualMemory', 'hrStorageDescr' => 'Swap space', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '0', 'hrStorageUsed' => '0', ), 11 => array ( 'hrStorageIndex' => '11', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Available memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '15923672', 'hrStorageUsed' => '0', ), 33 => array ( 'hrStorageIndex' => '33', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/dev/shm', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '2049238', 'hrStorageUsed' => '0', ), 35 => array ( 'hrStorageIndex' => '35', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/run', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '1024619', 'hrStorageUsed' => '1051', ), 37 => array ( 'hrStorageIndex' => '37', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/run/wrappers', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '2049238', 'hrStorageUsed' => '108', ), 39 => array ( 'hrStorageIndex' => '39', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '12692951', 'hrStorageUsed' => '626824', ), 40 => array ( 'hrStorageIndex' => '40', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/nix/store', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '12692951', 'hrStorageUsed' => '626824', ), 52 => array ( 'hrStorageIndex' => '52', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/boot', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '130812', 'hrStorageUsed' => '8177', ), 55 => array ( 'hrStorageIndex' => '55', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/run/user/1000', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '409847', 'hrStorageUsed' => '0', ), ), ) array ( 'storage_id' => 1814, 'device_id' => 661, 'storage_mib' => 'hrstorage', 'storage_index' => '33', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/dev/shm', 'storage_size' => 8393678848, 'storage_units' => 4096, 'storage_used' => 0, 'storage_free' => 8393678848, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 0, 'size' => 8393678848, 'free' => 8393678848, ) 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["0","8393678848","8393678848",4096,0,1814][0m 0.31ms] Storage /run: hrstorage array ( 'storage_id' => 1815, 'device_id' => 661, 'storage_mib' => 'hrstorage', 'storage_index' => '35', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/run', 'storage_size' => 4196839424, 'storage_units' => 4096, 'storage_used' => 4304896, 'storage_free' => 4192534528, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 4304896, 'size' => 4196839424, 'free' => 4192534528, ) 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["4304896","4192534528","4196839424",4096,0,1815][0m 0.18ms] Storage /run/wrappers: hrstorage array ( 'storage_id' => 1816, 'device_id' => 661, 'storage_mib' => 'hrstorage', 'storage_index' => '37', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/run/wrappers', 'storage_size' => 8393678848, 'storage_units' => 4096, 'storage_used' => 442368, 'storage_free' => 8393236480, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 442368, 'size' => 8393678848, 'free' => 8393236480, ) 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["442368","8393236480","8393678848",4096,0,1816][0m 0.17ms] Storage /: hrstorage array ( 'storage_id' => 1817, 'device_id' => 661, 'storage_mib' => 'hrstorage', 'storage_index' => '39', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/', 'storage_size' => 51990327296, 'storage_units' => 4096, 'storage_used' => 2567471104, 'storage_free' => 49422856192, 'storage_perc' => 5, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 2567471104, 'size' => 51990327296, 'free' => 49422856192, ) 5% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["2567471104","49422856192","51990327296",4096,5,1817][0m 0.15ms] Storage /nix/store: hrstorage array ( 'storage_id' => 1818, 'device_id' => 661, 'storage_mib' => 'hrstorage', 'storage_index' => '40', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/nix/store', 'storage_size' => 51990327296, 'storage_units' => 4096, 'storage_used' => 2567471104, 'storage_free' => 49422856192, 'storage_perc' => 5, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 2567471104, 'size' => 51990327296, 'free' => 49422856192, ) 5% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["2567471104","49422856192","51990327296",4096,5,1818][0m 0.15ms] Storage /boot: hrstorage array ( 'storage_id' => 1819, 'device_id' => 661, 'storage_mib' => 'hrstorage', 'storage_index' => '52', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/boot', 'storage_size' => 535805952, 'storage_units' => 4096, 'storage_used' => 33492992, 'storage_free' => 502312960, 'storage_perc' => 6, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 33492992, 'size' => 535805952, 'free' => 502312960, ) 6% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["33492992","502312960","535805952",4096,6,1819][0m 0.15ms] Storage /run/user/1000: hrstorage array ( 'storage_id' => 1820, 'device_id' => 661, 'storage_mib' => 'hrstorage', 'storage_index' => '55', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/run/user/1000', 'storage_size' => 1678733312, 'storage_units' => 4096, 'storage_used' => 0, 'storage_free' => 1678733312, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 0, 'size' => 1678733312, 'free' => 1678733312, ) 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["0","1678733312","1678733312",4096,0,1820][0m 0.15ms] >> Runtime for poller module 'storage': 0.0239 seconds with 44824 bytes >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [8/0.02s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0'[0m] IP-MIB::icmpInMsgs.0 = 516 IP-MIB::icmpOutMsgs.0 = 520 IP-MIB::icmpInErrors.0 = 0 IP-MIB::icmpOutErrors.0 = 0 IP-MIB::icmpInEchos.0 = 72 IP-MIB::icmpOutEchos.0 = 8 IP-MIB::icmpInEchoReps.0 = 4 IP-MIB::icmpOutEchoReps.0 = 72 IP-MIB::icmpInDestUnreachs.0 = 440 IP-MIB::icmpOutDestUnreachs.0 = 440 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0'[0m] IP-MIB::icmpInParmProbs.0 = 0 IP-MIB::icmpInTimeExcds.0 = 0 IP-MIB::icmpInSrcQuenchs.0 = 0 IP-MIB::icmpInRedirects.0 = 0 IP-MIB::icmpInTimestamps.0 = 0 IP-MIB::icmpInTimestampReps.0 = 0 IP-MIB::icmpInAddrMasks.0 = 0 IP-MIB::icmpInAddrMaskReps.0 = 0 IP-MIB::icmpOutTimeExcds.0 = 0 IP-MIB::icmpOutParmProbs.0 = 0 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m] IP-MIB::icmpOutSrcQuenchs.0 = 0 IP-MIB::icmpOutRedirects.0 = 0 IP-MIB::icmpOutTimestamps.0 = 0 IP-MIB::icmpOutTimestampReps.0 = 0 IP-MIB::icmpOutAddrMasks.0 = 0 IP-MIB::icmpOutAddrMaskReps.0 = 0 ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0'[0m] IP-MIB::ipForwDatagrams.0 = 0 IP-MIB::ipInDelivers.0 = 8772 IP-MIB::ipInReceives.0 = 11236 IP-MIB::ipOutRequests.0 = 6038 IP-MIB::ipInDiscards.0 = 0 IP-MIB::ipOutDiscards.0 = 220 IP-MIB::ipOutNoRoutes.0 = 1 IP-MIB::ipReasmReqds.0 = 0 IP-MIB::ipReasmOKs.0 = 0 IP-MIB::ipReasmFails.0 = 0 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m] IP-MIB::ipFragOKs.0 = 0 IP-MIB::ipFragFails.0 = 0 IP-MIB::ipFragCreates.0 = 0 IP-MIB::ipInUnknownProtos.0 = 0 IP-MIB::ipInHdrErrors.0 = 0 IP-MIB::ipInAddrErrors.0 = 0 ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0'[0m] SNMPv2-MIB::snmpInPkts.0 = 1546 SNMPv2-MIB::snmpOutPkts.0 = 1545 SNMPv2-MIB::snmpInBadVersions.0 = 0 SNMPv2-MIB::snmpInBadCommunityNames.0 = 0 SNMPv2-MIB::snmpInBadCommunityUses.0 = 0 SNMPv2-MIB::snmpInASNParseErrs.0 = 0 SNMPv2-MIB::snmpInTooBigs.0 = 0 SNMPv2-MIB::snmpInNoSuchNames.0 = 0 SNMPv2-MIB::snmpInBadValues.0 = 0 SNMPv2-MIB::snmpInReadOnlys.0 = 0 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0'[0m] SNMPv2-MIB::snmpInGenErrs.0 = 0 SNMPv2-MIB::snmpInTotalReqVars.0 = 8426 SNMPv2-MIB::snmpInTotalSetVars.0 = 0 SNMPv2-MIB::snmpInGetRequests.0 = 854 SNMPv2-MIB::snmpInGetNexts.0 = 0 SNMPv2-MIB::snmpInSetRequests.0 = 0 SNMPv2-MIB::snmpInGetResponses.0 = 0 SNMPv2-MIB::snmpInTraps.0 = 0 SNMPv2-MIB::snmpOutTooBigs.0 = 0 SNMPv2-MIB::snmpOutNoSuchNames.0 = 0 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m] SNMPv2-MIB::snmpOutBadValues.0 = 0 SNMPv2-MIB::snmpOutGenErrs.0 = 0 SNMPv2-MIB::snmpOutGetRequests.0 = 0 SNMPv2-MIB::snmpOutGetNexts.0 = 0 SNMPv2-MIB::snmpOutSetRequests.0 = 0 SNMPv2-MIB::snmpOutGetResponses.0 = 1547 SNMPv2-MIB::snmpOutTraps.0 = 0 SNMPv2-MIB::snmpSilentDrops.0 = 0 SNMPv2-MIB::snmpProxyDrops.0 = 0 udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m] UDP-MIB::udpInDatagrams.0 = 1992 UDP-MIB::udpOutDatagrams.0 = 2359 UDP-MIB::udpInErrors.0 = 0 UDP-MIB::udpNoPorts.0 = 440 tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m] TCP-MIB::tcpActiveOpens.0 = 2 TCP-MIB::tcpPassiveOpens.0 = 3 TCP-MIB::tcpAttemptFails.0 = 0 TCP-MIB::tcpEstabResets.0 = 0 TCP-MIB::tcpCurrEstab.0 = 1 TCP-MIB::tcpInSegs.0 = 5830 TCP-MIB::tcpOutSegs.0 = 3190 TCP-MIB::tcpRetransSegs.0 = 1 TCP-MIB::tcpInErrs.0 = 0 TCP-MIB::tcpOutRsts.0 = 4 >> Runtime for poller module 'netstats': 0.3024 seconds with 46952 bytes >> [0;36mSNMP[0m: [11/0.30s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module netstats #### Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] hrSystemMaxProcesses.0 = 0 hrSystemProcesses.0 = 106 hrSystemNumUsers.0 = 1 ProcessesSQL[[1;33mselect * from `hrSystem` where (`device_id` = ?) limit 1 [0;33m[661][0m 0.37ms] Users >> Runtime for poller module 'hr-mib': 0.0240 seconds with 35232 bytes >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module hr-mib #### Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m] ssIndex.0 = 1 ssErrorName.0 = systemStats ssSwapIn.0 = 0 ssSwapOut.0 = 0 ssIOSent.0 = 0 ssIOReceive.0 = 0 ssSysInterrupts.0 = 42 ssSysContext.0 = 65 ssCpuUser.0 = 0 ssCpuSystem.0 = 0 ssCpuIdle.0 = 99 ssCpuRawUser.0 = 4146 ssCpuRawNice.0 = 0 ssCpuRawSystem.0 = 2333 ssCpuRawIdle.0 = 509548 ssCpuRawWait.0 = 1367 ssCpuRawKernel.0 = 0 ssCpuRawInterrupt.0 = 0 ssIORawSent.0 = 1120978 ssIORawReceived.0 = 563714 ssRawInterrupts.0 = 320494 ssRawContexts.0 = 573144 ssCpuRawSoftIRQ.0 = 6 ssRawSwapIn.0 = 0 ssRawSwapOut.0 = 0 ssCpuRawSteal.0 = 0 ssCpuRawGuest.0 = 0 ssCpuRawGuestNice.0 = 0 ssCpuNumCpus.0 = 1 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] laLoadInt.1 = 0 laLoadInt.2 = 0 laLoadInt.3 = 0 >> Runtime for poller module 'ucd-mib': 0.0336 seconds with 4184 bytes >> [0;36mSNMP[0m: [2/0.03s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsInReceives.ipv4 = 11125 ipSystemStatsInReceives.ipv6 = 0 ipSystemStatsHCInReceives.ipv4 = 11125 ipSystemStatsHCInReceives.ipv6 = 0 ipSystemStatsInOctets.ipv4 = 57773733 ipSystemStatsInOctets.ipv6 = 0 ipSystemStatsHCInOctets.ipv4 = 57773733 ipSystemStatsHCInOctets.ipv6 = 0 ipSystemStatsInHdrErrors.ipv4 = 0 ipSystemStatsInHdrErrors.ipv6 = 0 ipSystemStatsInNoRoutes.ipv4 = 0 ipSystemStatsInNoRoutes.ipv6 = 0 ipSystemStatsInAddrErrors.ipv4 = 0 ipSystemStatsInAddrErrors.ipv6 = 0 ipSystemStatsInUnknownProtos.ipv4 = 0 ipSystemStatsInUnknownProtos.ipv6 = 0 ipSystemStatsInTruncatedPkts.ipv4 = 0 ipSystemStatsInTruncatedPkts.ipv6 = 0 ipSystemStatsInForwDatagrams.ipv4 = 0 ipSystemStatsInForwDatagrams.ipv6 = 0 ipSystemStatsHCInForwDatagrams.ipv4 = 0 ipSystemStatsHCInForwDatagrams.ipv6 = 0 ipSystemStatsReasmReqds.ipv4 = 0 ipSystemStatsReasmReqds.ipv6 = 0 ipSystemStatsReasmOKs.ipv4 = 0 ipSystemStatsReasmOKs.ipv6 = 0 ipSystemStatsReasmFails.ipv4 = 0 ipSystemStatsReasmFails.ipv6 = 0 ipSystemStatsInDiscards.ipv4 = 0 ipSystemStatsInDiscards.ipv6 = 0 ipSystemStatsInDelivers.ipv4 = 8690 ipSystemStatsInDelivers.ipv6 = 0 ipSystemStatsHCInDelivers.ipv4 = 8690 ipSystemStatsHCInDelivers.ipv6 = 0 ipSystemStatsOutRequests.ipv4 = 5957 ipSystemStatsOutRequests.ipv6 = 28 ipSystemStatsHCOutRequests.ipv4 = 5957 ipSystemStatsHCOutRequests.ipv6 = 28 ipSystemStatsOutNoRoutes.ipv4 = 1 ipSystemStatsOutNoRoutes.ipv6 = 27 ipSystemStatsOutForwDatagrams.ipv4 = 0 ipSystemStatsOutForwDatagrams.ipv6 = 0 ipSystemStatsHCOutForwDatagrams.ipv4 = 0 ipSystemStatsHCOutForwDatagrams.ipv6 = 0 ipSystemStatsOutDiscards.ipv4 = 220 ipSystemStatsOutDiscards.ipv6 = 3 ipSystemStatsOutFragReqds.ipv4 = 0 ipSystemStatsOutFragReqds.ipv6 = 0 ipSystemStatsOutFragOKs.ipv4 = 0 ipSystemStatsOutFragOKs.ipv6 = 0 ipSystemStatsOutFragFails.ipv4 = 0 ipSystemStatsOutFragFails.ipv6 = 0 ipSystemStatsOutFragCreates.ipv4 = 0 ipSystemStatsOutFragCreates.ipv6 = 0 ipSystemStatsOutTransmits.ipv4 = 5736 ipSystemStatsOutTransmits.ipv6 = 4294967294 ipSystemStatsHCOutTransmits.ipv4 = 5736 ipSystemStatsHCOutTransmits.ipv6 = 18446744073709551614 ipSystemStatsOutOctets.ipv4 = 806301 ipSystemStatsOutOctets.ipv6 = 1876 ipSystemStatsHCOutOctets.ipv4 = 806301 ipSystemStatsHCOutOctets.ipv6 = 1876 ipSystemStatsInMcastPkts.ipv4 = 86 ipSystemStatsInMcastPkts.ipv6 = 0 ipSystemStatsHCInMcastPkts.ipv4 = 86 ipSystemStatsHCInMcastPkts.ipv6 = 0 ipSystemStatsInMcastOctets.ipv4 = 2760 ipSystemStatsInMcastOctets.ipv6 = 0 ipSystemStatsHCInMcastOctets.ipv4 = 2760 ipSystemStatsHCInMcastOctets.ipv6 = 0 ipSystemStatsOutMcastPkts.ipv4 = 0 ipSystemStatsOutMcastPkts.ipv6 = 27 ipSystemStatsHCOutMcastPkts.ipv4 = 0 ipSystemStatsHCOutMcastPkts.ipv6 = 27 ipSystemStatsOutMcastOctets.ipv4 = 0 ipSystemStatsOutMcastOctets.ipv6 = 1800 ipSystemStatsHCOutMcastOctets.ipv4 = 0 ipSystemStatsHCOutMcastOctets.ipv6 = 1800 ipSystemStatsInBcastPkts.ipv4 = 2314 ipSystemStatsHCInBcastPkts.ipv4 = 2314 ipSystemStatsOutBcastPkts.ipv4 = 0 ipSystemStatsHCOutBcastPkts.ipv4 = 0 ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00 ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00 ipSystemStatsRefreshRate.ipv4 = 60000 ipSystemStatsRefreshRate.ipv6 = 60000 ipv4 ipv6 >> Runtime for poller module 'ipSystemStats': 0.0253 seconds with 20560 bytes >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ipSystemStats #### Modules status: Global+ OS Device #### Load poller module ports #### SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[661][0m 0.63ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifName.1 = lo ifName.2 = ens192 ifInMulticastPkts.1 = 0 ifInMulticastPkts.2 = 84 ifInBroadcastPkts.1 = 0 ifInBroadcastPkts.2 = 0 ifOutMulticastPkts.1 = 0 ifOutMulticastPkts.2 = 0 ifOutBroadcastPkts.1 = 0 ifOutBroadcastPkts.2 = 0 ifHCInOctets.1 = 80080 ifHCInOctets.2 = 58228576 ifHCInUcastPkts.1 = 880 ifHCInUcastPkts.2 = 16633 ifHCInMulticastPkts.1 = 0 ifHCInMulticastPkts.2 = 84 ifHCInBroadcastPkts.1 = 0 ifHCInBroadcastPkts.2 = 0 ifHCOutOctets.1 = 80080 ifHCOutOctets.2 = 812920 ifHCOutUcastPkts.1 = 880 ifHCOutUcastPkts.2 = 5186 ifHCOutMulticastPkts.1 = 0 ifHCOutMulticastPkts.2 = 0 ifHCOutBroadcastPkts.1 = 0 ifHCOutBroadcastPkts.2 = 0 ifHighSpeed.1 = 10 ifHighSpeed.2 = 10000 ifPromiscuousMode.1 = false ifPromiscuousMode.2 = false ifConnectorPresent.1 = false ifConnectorPresent.2 = true ifAlias.1 = ifAlias.2 = ifCounterDiscontinuityTime.1 = 0:0:00:00.00 ifCounterDiscontinuityTime.2 = 0:0:00:00.00 ifDescr SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifDescr'[0m] ifDescr.1 = lo ifDescr.2 = ens192 ifAdminStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifAdminStatus'[0m] ifAdminStatus.1 = up ifAdminStatus.2 = up ifOperStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOperStatus'[0m] ifOperStatus.1 = up ifOperStatus.2 = up ifLastChange SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifLastChange'[0m] ifLastChange.1 = 0 ifLastChange.2 = 0 ifType SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifType'[0m] ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifPhysAddress SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifPhysAddress'[0m] ifPhysAddress.1 = ifPhysAddress.2 = 0:50:56:ba:28:3c ifMtu SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifMtu'[0m] ifMtu.1 = 65536 ifMtu.2 = 1500 ifInErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInErrors'[0m] ifInErrors.1 = 0 ifInErrors.2 = 0 ifOutErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutErrors'[0m] ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifInDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInDiscards'[0m] ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifOutDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutDiscards'[0m] ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID array ( 1 => array ( 'ifName' => 'lo', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '80080', 'ifHCInUcastPkts' => '880', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '80080', 'ifHCOutUcastPkts' => '880', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '10', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'false', 'ifAlias' => '', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'lo', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'softwareLoopback', 'ifPhysAddress' => '', 'ifMtu' => '65536', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 2 => array ( 'ifName' => 'ens192', 'ifInMulticastPkts' => '84', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '58228576', 'ifHCInUcastPkts' => '16633', 'ifHCInMulticastPkts' => '84', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '812920', 'ifHCOutUcastPkts' => '5186', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '10000', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => '', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'ens192', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '0:50:56:ba:28:3c', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), ) valid valid Port lo: lo (1 / #11865) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed (10) VLAN = ? Using ifDescr as ifAlias Reporting disabled by user setting lo ifInOctets (0 B) 0 Bps 41 secs ifOutOctets (0 B) 0 Bps 41 secs ifInErrors (0 B) 0 Bps 41 secs ifOutErrors (0 B) 0 Bps 41 secs ifInUcastPkts (0 B) 0 Bps 41 secs ifOutUcastPkts (0 B) 0 Bps 41 secs ifInNUcastPkts (0 B) 0 Bps 41 secs ifOutNUcastPkts (0 B) 0 Bps 41 secs ifInDiscards (0 B) 0 Bps 41 secs ifOutDiscards (0 B) 0 Bps 41 secs ifInUnknownProtos (0 B) 0 Bps 41 secs ifInBroadcastPkts (0 B) 0 Bps 41 secs ifOutBroadcastPkts (0 B) 0 Bps 41 secs ifInMulticastPkts (0 B) 0 Bps 41 secs ifOutMulticastPkts (0 B) 0 Bps 41 secs bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["80080",80080,0,0,"80080",80080,0,0,"0",0,0,0,"0",0,0,0,"880",880,0,0,"880",880,0,0,1687434108,1687434067,41,11865][0m 0.37ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,11865][0m 0.26ms] 1 updated Port ens192: ens192 (2 / #11866) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifHCInMulticastPkts ifOutMulticastPkts ifHighSpeed (10000) VLAN = ? Using ifDescr as ifAlias ens192 ifInOctets (14906 B) 363.56097560976 Bps 41 secs ifOutOctets (13773 B) 335.92682926829 Bps 41 secs ifInErrors (0 B) 0 Bps 41 secs ifOutErrors (0 B) 0 Bps 41 secs ifInUcastPkts (164 B) 4 Bps 41 secs ifOutUcastPkts (65 B) 1.5853658536585 Bps 41 secs ifInNUcastPkts (0 B) 0 Bps 41 secs ifOutNUcastPkts (0 B) 0 Bps 41 secs ifInDiscards (0 B) 0 Bps 41 secs ifOutDiscards (0 B) 0 Bps 41 secs ifInUnknownProtos (0 B) 0 Bps 41 secs ifInBroadcastPkts (0 B) 0 Bps 41 secs ifOutBroadcastPkts (0 B) 0 Bps 41 secs ifInMulticastPkts (0 B) 0 Bps 41 secs ifOutMulticastPkts (0 B) 0 Bps 41 secs bps(2.91 kbps/2.69 kbps)bytes(14.56 KiB/13.45 KiB)pkts(4 pps/1.59 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["58228576",58213670,363.5609756097561,14906,"812920",799147,335.9268292682927,13773,"0",0,0,0,"0",0,0,0,"16633",16469,4,164,"5186",5121,1.5853658536585367,65,1687434108,1687434067,41,11866][0m 0.26ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"84",84,0,0,"0",0,0,0,11866][0m 0.24ms] 2 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1687434108,1687434067,null][0m 0.14ms] 0 updated >> Runtime for poller module 'ports': 0.2495 seconds with 98024 bytes >> [0;36mSNMP[0m: [14/0.24s] [1;33mMySQL[0m: [6/0.02s] #### Unload poller module ports #### Modules status: Global- OS Device Module [ xdsl ] disabled globally. Modules status: Global+ OS Device #### Load poller module customoid #### SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[661][0m 0.29ms] >> Runtime for poller module 'customoid': 0.0007 seconds with 1464 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module customoid #### Modules status: Global+ OS- Device Module [ bgp-peers ] disabled on os. Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[661][0m 0.23ms] >> Runtime for poller module 'ucd-diskio': 0.0005 seconds with 928 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module ucd-diskio #### Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: linux Attempting to initialize Group OS: unix OS initialized: LibreNMS\OS\Shared\Unix SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[661][0m 0.31ms] >> Runtime for poller module 'wireless': 0.0018 seconds with 104056 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module wireless #### Modules status: Global+ OS- Device Module [ ospf ] disabled on os. Modules status: Global- OS Device Module [ isis ] disabled globally. Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ slas ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-qfp ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ nac ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global- OS Device Module [ aruba-controller ] disabled globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### >> Runtime for poller module 'entity-physical': 0.0001 seconds with 392 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module entity-physical #### Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [0;33m[661][0m 0.29ms] >> Runtime for poller module 'applications': 0.0013 seconds with 28384 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module applications #### Modules status: Global+ OS- Device Module [ stp ] disabled on os. Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 320 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ntp #### Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device #### Load poller module mpls #### >> Runtime for poller module 'mpls': 0.0004 seconds with 36872 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module mpls #### Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[661][0m 0.33ms] SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[1.856,661][0m 0.28ms] Updating 10.1.250.132 Polled in 1.856 seconds ### Start Device Groups ### SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.26ms] SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) [0;33m[][0m 1.57ms] SQL[[1;33mselect exists(select * from `devices` where ((`devices`.`sysName` LIKE ? OR `devices`.`sysName` LIKE ? OR `devices`.`sysName` LIKE ?) AND `devices`.`sysDescr` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%staff%","censw%","lscsw%","%Intel%",661][0m 0.31ms] SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.2.%","2920-48G-POE+",661][0m 0.27ms] SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where ((`ipv4_addresses`.`ipv4_address` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ?) AND `devices`.`os` LIKE ? AND `devices`.`hostname` != ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.1.250.%","10.1.251.%","[1;37mindows%","porcupine",661][0m 0.26ms] SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where ((`ipv4_addresses`.`ipv4_address` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ? OR `devices`.`hostname` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ?) AND (`devices`.`os` LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["10.2.250.%","10.2.251.%","[0;35mc001","10.2.150.%","10.2.151.%","[1;37mindows%",661][0m 0.29ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` LIKE ? OR `devices`.`hostname` = ? OR `devices`.`os` LIKE ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%Linux%","[5mreeBSD%","%OpenBSD%","callastorySP","ciscoprime","crafty","emccallhome","foundation%","informacast","%VMware%","lobster","pr","bonobo","Cisco Unified Communications Manager%",661][0m 0.26ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? AND `devices`.`hostname` != ? AND `devices`.`hostname` != ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%vc%","vcenter.indypl.org","vcenter7",661][0m 0.21ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%doorcounter%",661][0m 0.2ms] SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.2.%","[0;35mc%",661][0m 0.24ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["iDRAC%",661][0m 0.2ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["Ecoreader",661][0m 0.2ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[661][0m 0.22ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0267s ### #### Start Alerts #### SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[661][0m 0.28ms] SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`start`) <= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` in (7)) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2023-06-22T11:41:48.386512Z","2023-06-22T11:41:48.386512Z",0,1,"11:41:48","11:41:48","11:41:48","11:41:48","[44m%","device",661,"device_group","location",46][0m 0.65ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[661][0m 0.35ms] SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?) LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?)) LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?)) LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ? LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ? WHERE a.disabled = 0 AND ( (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?)) OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL) AND (ld.device_id != ? OR ld.device_id IS NULL)) ) [0;33m[661,661,661,661,661,661,661,661,661,661,661][0m 2.02ms] Rule [0;35m#1 (Device Down! Due to no ICMP response.):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [0;33m[661][0m 0.33ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,661][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [0;33m[661][0m 0.31ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,661][0m 0.19ms] Status: [0;34mNOCHG[0m Rule [0;35m#3 (Device rebooted):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed> 50 [0;33m[661][0m 0.32ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,661][0m 0.18ms] Status: [0;34mNOCHG[0m Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 0.39ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,661][0m 0.19ms] Status: [0;34mNOCHG[0m Rule [0;35m#8 (Sensor under limit - Check Device Health Settings):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 1.16ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,661][0m 0.18ms] Status: [0;34mNOCHG[0m Rule [0;35m#11 (Wireless Sensor under limit):[0m SQL[[1;33mSELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 0.37ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,661][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#12 (State Sensor Critical):[0m SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 0.87ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,661][0m 0.74ms] Status: [0;34mNOCHG[0m Rule [0;35m#13 (UPS is running on the bypass):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 4 AND sensors.sensor_type = "upsOutputSourceState" [0;33m[661][0m 0.54ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,661][0m 0.28ms] Status: [0;34mNOCHG[0m Rule [0;35m#14 (UPS is running on the battery):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 5 AND sensors.sensor_type = "upsOutputSourceState" [0;33m[661][0m 0.52ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[14,661][0m 0.27ms] Status: [0;34mNOCHG[0m Rule [0;35m#15 (UPS has a low battery):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 3 AND sensors.sensor_type = "upsBatteryStatusState" [0;33m[661][0m 0.54ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,661][0m 0.29ms] Status: [0;34mNOCHG[0m Rule [0;35m#16 (UPS has a depleted battery):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 4 AND sensors.sensor_type = "upsBatteryStatusState" [0;33m[661][0m 0.57ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[16,661][0m 0.28ms] Status: [0;34mNOCHG[0m Rule [0;35m#17 (UPS has a heavy load):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_descr REGEXP "Percentage load" AND sensors.sensor_current >= 90 AND sensors.sensor_type = "rfc1628" [0;33m[661][0m 0.53ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[17,661][0m 0.28ms] Status: [0;34mNOCHG[0m Rule [0;35m#18 (Dell Server Raid Battery Failed/Degraded):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[2|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10893.1.20.130.15.1.4.1" [0;33m[661][0m 0.54ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,661][0m 0.29ms] Status: [0;34mNOCHG[0m Rule [0;35m#19 (Dell Server CPU Status Critical):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 2 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.1.1100.32.1.5" [0;33m[661][0m 0.58ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[19,661][0m 0.27ms] Status: [0;34mNOCHG[0m Rule [0;35m#20 (Dell Server Disk Controller State Failed/Degraded):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[2|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10893.1.20.130.1.1.5" [0;33m[661][0m 0.51ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[20,661][0m 0.32ms] Status: [0;34mNOCHG[0m Rule [0;35m#21 (Dell Server Disk Array State Failed/Degraded):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[2|5]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10893.1.20.130.4.1.4" [0;33m[661][0m 0.49ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[21,661][0m 0.29ms] Status: [0;34mNOCHG[0m Rule [0;35m#22 (Dell Server PSU State Critical/NonRecvoverable):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[5|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.1.600.12.1.5" [0;33m[661][0m 0.6ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[22,661][0m 0.26ms] Status: [0;34mNOCHG[0m Rule [0;35m#23 (Dell Server Virtual Disk Failed/Degraded):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[2|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10893.1.20.140.1.1.4" [0;33m[661][0m 0.52ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[23,661][0m 0.25ms] Status: [0;34mNOCHG[0m Rule [0;35m#24 (Cisco PSU status failed):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 8 AND sensors.sensor_oid = ".1.3.6.1.4.1.9.9.13.1.5.1.3" [0;33m[661][0m 0.44ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[24,661][0m 0.24ms] Status: [0;34mNOCHG[0m Rule [0;35m#25 (Cisco Fan Status failed ):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 9 AND sensors.sensor_oid = ".1.3.6.1.4.1.9.9.13.1.4.1.3" [0;33m[661][0m 0.48ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[25,661][0m 0.28ms] Status: [0;34mNOCHG[0m Rule [0;35m#26 (Dell iDRAC Processor Status Critical):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 5 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.1100.30.1.5" [0;33m[661][0m 0.46ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[26,661][0m 0.24ms] Status: [0;34mNOCHG[0m Rule [0;35m#27 (Dell iDRAC Virtual Disk Failed/Degraded):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[3|4]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.5.1.20.140.1.1.4" [0;33m[661][0m 0.49ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[27,661][0m 0.22ms] Status: [0;34mNOCHG[0m Rule [0;35m#28 (Dell iDRAC Memory Status Critical):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 5 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.1100.50.1.5" [0;33m[661][0m 0.49ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[28,661][0m 0.23ms] Status: [0;34mNOCHG[0m Rule [0;35m#29 (Dell iDRAC Voltage Probe Status Failed):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 10 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.600.20.1.5" [0;33m[661][0m 0.48ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[29,661][0m 0.22ms] Status: [0;34mNOCHG[0m Rule [0;35m#30 (Dell iDRAC Amperage Probe Status Failed):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 10 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.600.30.1.5" [0;33m[661][0m 0.48ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[30,661][0m 0.22ms] Status: [0;34mNOCHG[0m Rule [0;35m#31 (Dell iDRAC Battery Status Failed):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP 10 AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.5.4.600.50.1.5" [0;33m[661][0m 0.49ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[31,661][0m 0.25ms] Status: [0;34mNOCHG[0m Rule [0;35m#32 (Dell iDRAC Global System Status Critical/NonRecoverable):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current REGEXP "[5|6]" AND sensors.sensor_oid = ".1.3.6.1.4.1.674.10892.2.2.1" [0;33m[661][0m 0.43ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[32,661][0m 0.27ms] Status: [0;34mNOCHG[0m Rule [0;35m#33 (Storage percentage exceeded):[0m SQL[[1;33mSELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND storage.storage_perc >= storage.storage_perc_warn [0;33m[661][0m 0.44ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[33,661][0m 0.29ms] Status: [0;34mNOCHG[0m Rule [0;35m#36 (State Sensor Warning):[0m SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 1) = 1 AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[661][0m 0.65ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[36,661][0m 0.28ms] Status: [0;34mNOCHG[0m Rule [0;35m#37 (Cisco ASA Primary unit changed to standby):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_descr = "Primary Unit.*" AND sensors.sensor_current = 10 AND sensors.sensor_prev = 9 [0;33m[661][0m 0.46ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[37,661][0m 0.22ms] Status: [0;34mNOCHG[0m Rule [0;35m#38 (Interface Errors Rate greater than 100):[0m SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (ports.ifOutErrors_rate >= 100 OR ports.ifInErrors_rate >= 100) [0;33m[661][0m 0.53ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[38,661][0m 0.22ms] Status: [0;34mNOCHG[0m Rule [0;35m#39 (Service warning):[0m SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status = 1 [0;33m[661][0m 0.39ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[39,661][0m 0.21ms] Status: [0;34mNOCHG[0m Rule [0;35m#40 (Service critical):[0m SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status = 2 [0;33m[661][0m 0.34ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[40,661][0m 0.21ms] Status: [0;34mNOCHG[0m Rule [0;35m#41 (APC UPS Battery Needs Replacement):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_type = "upsAdvBatteryReplaceIndicator" AND sensors.sensor_current = 2 [0;33m[661][0m 0.4ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[41,661][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#42 (APC UPS Diagonstics Test Result):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_type = "upsAdvTestDiagnosticsResults" AND (sensors.sensor_current = 2 OR sensors.sensor_current = 3) [0;33m[661][0m 0.41ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[42,661][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#43 (APC UPS Switched to Battery Power):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND (sensors.sensor_current = 3 AND sensors.sensor_type = "upsBasicOutputStatus") AND (sensors.sensor_current != 4 AND sensors.sensor_type = "upsAdvTestDiagnosticsResults") [0;33m[661][0m 0.31ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[43,661][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#44 (APC UPS in Hardware Failure Bypass Mode):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 10 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[661][0m 0.39ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[44,661][0m 0.42ms] Status: [0;34mNOCHG[0m Rule [0;35m#45 (APC UPS in Emergency Static Bypass Mode):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 16 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[661][0m 0.44ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[45,661][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#46 (APC UPS in Smart Trim Mode):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 12 AND sensors.sensor_type = "upsBasicOutputStatus" [0;33m[661][0m 0.41ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[46,661][0m 0.2ms] Status: [0;34mNOCHG[0m Rule [0;35m#47 (HP Procurve Fan Fault):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_oid = ".1.3.6.1.4.1.11.2.14.11.1.2.6.1.4.1" AND sensors.sensor_current = 2 [0;33m[661][0m 1.02ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[47,661][0m 0.33ms] Status: [0;34mNOCHG[0m Rule [0;35m#48 (Cisco NX-OS device has a bad fan):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND devices.os = "nxos" AND sensors.sensor_type = "cefcFanTrayOperStatus" AND sensors.sensor_current = "[3-4]" [0;33m[661][0m 0.47ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[48,661][0m 0.31ms] Status: [0;34mNOCHG[0m Rule [0;35m#52 (Cisco IP SLA):[0m SQL[[1;33mSELECT * FROM devices,slas WHERE (devices.device_id = ? AND devices.device_id = slas.device_id) AND slas.deleted = 0 AND slas.opstatus = 3 [0;33m[661][0m 0.38ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[52,661][0m 0.4ms] Status: [0;34mNOCHG[0m #### End Alerts #### ./poller.php 10.1.250.132 2023-06-22 07:41:48 - 1 devices polled in 2.183 secs [0;36mSNMP[0m [35/0.78s]: Snmpget[18/0.48s] Snmpwalk[17/0.30s] [1;33mSQL[0m [158/0.56s]: Select[136/0.51s] Insert[1/0.00s] Update[21/0.04s]