- 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]