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]