LibreNMS Poller
SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.46ms] 
  
SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.4ms] 
  
SQL[[1;33mselect version() [0;33m[][0m 0.32ms] 
  
===========================================
Component | Version
--------- | -------
LibreNMS  | 23.7.0-14-ge966855 (2023-07-21T18:55:48+02:00)
DB Schema | 2023_06_02_230406_create_vendor_oui_table (253)
PHP       | 8.1.11
Python    | 3.6.8
Database  | MariaDB 10.5.9-MariaDB
RRDTool   | 1.4.8
SNMP      | 5.7.2
===========================================
DEBUG!
Updating os_def.cache  
Starting polling run:

SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '193.203.13.217' ORDER BY `device_id` ASC [0;33m[][0m 0.83ms] 
  
SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[224][0m 0.48ms] 
  
SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[224][0m 0.38ms] 
  
Attempting to initialize OS: generic  
OS initialized: LibreNMS\OS\Generic  
Hostname:    193.203.13.217
Device ID:   224
OS:          generic


[FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '193.203.13.217'
  
response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.34/1.1/2.6  
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 = SNMPv2-SMI::enterprises.23*.1.4
  
  
SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.34,2.6,1.1,3,3,0,"{\"poller_name\":\"lnms\"}",224,"2023-07-24 09:49:10"][0m 1.21ms] 
  
SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[1.1,224][0m 1.02ms] 
  
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[224][0m 0.96ms] 
  
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 = 59520
  
  
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 = 594
HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Instance currently exists at this OID
  
  
Uptime seconds: 595
  
Uptime: 9 minutes 55 seconds
SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[595,224][0m 1.09ms] 
  

>> Runtime for poller module 'core': 0.1216 seconds with 119728 bytes
>> [0;36mSNMP[0m: [2/0.11s] [1;33mMySQL[0m: [1/0.01s]   
#### 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[103][0m 0.74ms] 
  
Location: ED K./EFP
Hardware: 
OS Version: 
OS Features: 
Serial: 

>> Runtime for poller module 'os': 0.0057 seconds with 121360 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### Unload poller module os ####

Modules status: Global+  
OS  
Device  

#### Load poller module availability ####
SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[224][0m 0.71ms] 
  
Availability: 
SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[224][0m 0.68ms] 
  
SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[224,1690098551][0m 0.79ms] 
  
SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[9.536,745][0m 0.82ms] 
  
1 day : 9.536%
SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[224,1689580151][0m 0.74ms] 
  
SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[62.55,746][0m 0.51ms] 
  
1 week : 62.55%
SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[224,1687592951][0m 0.75ms] 
  
SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[91.262,747][0m 0.52ms] 
  
1 month : 91.262%
SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[224,1658648951][0m 0.76ms] 
  
SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.282,748][0m 0.5ms] 
  
1 year : 99.282%

>> Runtime for poller module 'availability': 0.0151 seconds with 25480 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.07s]   
#### 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[224][0m 0.87ms] 
  
array (
)  

>> Runtime for poller module 'ipmi': 0.0019 seconds with 2944 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### 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[224][0m 0.74ms] 
  

>> Runtime for poller module 'sensors': 0.0014 seconds with 1088 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### Unload poller module sensors ####

Modules status: Global+  
OS  
Device  

#### Load poller module processors ####
Attempting to initialize OS: generic  
OS initialized: LibreNMS\OS\Generic  
SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[224][0m 0.7ms] 
  

>> Runtime for poller module 'processors': 0.0033 seconds with 124696 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### 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[224][0m 0.8ms] 
  
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'[0m]
.*.*.* = 3072  
  
hrstorage [system]: Allocated memory for Printer: 100%  3 MiB / 3 MiB

>> Runtime for poller module 'mempools': 0.0609 seconds with 87224 bytes
>> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [1/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[224][0m 0.77ms] 
  

>> Runtime for poller module 'storage': 0.0017 seconds with 1424 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### 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 = 21
IP-MIB::icmpOutMsgs.0 = 17
IP-MIB::icmpInErrors.0 = 4
IP-MIB::icmpOutErrors.0 = 0
IP-MIB::icmpInEchos.0 = 15
IP-MIB::icmpOutEchos.0 = 0
IP-MIB::icmpInEchoReps.0 = 0
IP-MIB::icmpOutEchoReps.0 = 15
IP-MIB::icmpInDestUnreachs.0 = 2
IP-MIB::icmpOutDestUnreachs.0 = 2
  
  
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 = 6253
IP-MIB::ipInReceives.0 = 9096
IP-MIB::ipOutRequests.0 = 4972
IP-MIB::ipInDiscards.0 = 0
IP-MIB::ipOutDiscards.0 = 0
IP-MIB::ipOutNoRoutes.0 = 0
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 = 638
  
  
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 = 220
SNMPv2-MIB::snmpOutPkts.0 = 219
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 = 349
SNMPv2-MIB::snmpInTotalSetVars.0 = 0
SNMPv2-MIB::snmpInGetRequests.0 = 133
SNMPv2-MIB::snmpInGetNexts.0 = 4
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 = 221
SNMPv2-MIB::snmpOutTraps.0 = 0
SNMPv2-MIB::snmpSilentDrops.0 = No Such Object available on this agent at this OID
SNMPv2-MIB::snmpProxyDrops.0 = No Such Object available on this agent at this OID
  
  
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 = 1470
UDP-MIB::udpOutDatagrams.0 = 245
UDP-MIB::udpInErrors.0 = 0
UDP-MIB::udpNoPorts.0 = 2
  
  
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 = 4
TCP-MIB::tcpInSegs.0 = 4715
TCP-MIB::tcpOutSegs.0 = 4707
TCP-MIB::tcpRetransSegs.0 = 1
TCP-MIB::tcpInErrs.0 = 0
TCP-MIB::tcpOutRsts.0 = 0
  
  


>> Runtime for poller module 'netstats': 0.6720 seconds with 38856 bytes
>> [0;36mSNMP[0m: [11/0.67s] [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 = No Such Instance currently exists at this OID
hrSystemProcesses.0 = No Such Instance currently exists at this OID
hrSystemNumUsers.0 = No Such Instance currently exists at this OID  
  


>> Runtime for poller module 'hr-mib': 0.0318 seconds with 1216 bytes
>> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [0/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]
systemStats = No Such Object available on this agent at this OID  
  
Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
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 = No Such Object available on this agent at this OID
laLoadInt.2 = No Such Object available on this agent at this OID
laLoadInt.3 = No Such Object available on this agent at this OID  
  

>> Runtime for poller module 'ucd-mib': 0.0597 seconds with 9792 bytes
>> [0;36mSNMP[0m: [2/0.06s] [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]
ipSystemStatsTable = No Such Object available on this agent at this OID  
  
Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  


>> Runtime for poller module 'ipSystemStats': 0.0396 seconds with 1736 bytes
>> [0;36mSNMP[0m: [1/0.04s] [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[224][0m 1.99ms] 
  
Caching Oids: Full ports polling Reporting disabled by user setting  
SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
ifXEntry = No Such Object available on this agent at this OID  
  
Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m]
ifIndex.1 = 1
ifIndex.2 = 2
ifDescr.1 = eth0
ifDescr.2 = lo
ifType.1 = ethernetCsmacd
ifType.2 = softwareLoopback
ifMtu.1 = 1500
ifMtu.2 = 65536
ifSpeed.1 = 1000000000
ifSpeed.2 = 0
ifPhysAddress.1 = ac:a8:8e:f7:df:9b
ifPhysAddress.2 = 
ifAdminStatus.1 = up
ifAdminStatus.2 = up
ifOperStatus.1 = up
ifOperStatus.2 = up
ifLastChange.1 = 309
ifLastChange.2 = 0
ifInOctets.1 = 2245802
ifInOctets.2 = 2829488
ifInUcastPkts.1 = 18144
ifInUcastPkts.2 = 4686
ifInNUcastPkts.1 = 4534
ifInNUcastPkts.2 = 0
ifInDiscards.1 = 0
ifInDiscards.2 = 0
ifInErrors.1 = 0
ifInErrors.2 = 0
ifInUnknownProtos.1 = 0
ifInUnknownProtos.2 = 0
ifOutOctets.1 = 62969
ifOutOctets.2 = 2829488
ifOutUcastPkts.1 = 362
ifOutUcastPkts.2 = 4686
ifOutNUcastPkts.1 = 0
ifOutNUcastPkts.2 = 0
ifOutDiscards.1 = 0
ifOutDiscards.2 = 0
ifOutErrors.1 = 0
ifOutErrors.2 = 0
ifOutQLen.1 = 0
ifOutQLen.2 = 0
ifSpecific.1 = zeroDotZero
ifSpecific.2 = zeroDotZero  
  
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 (
    'ifIndex' => '1',
    'ifDescr' => 'eth0',
    'ifType' => 'ethernetCsmacd',
    'ifMtu' => '1500',
    'ifSpeed' => '1000000000',
    'ifPhysAddress' => 'ac:a8:8e:f7:df:9b',
    'ifAdminStatus' => 'up',
    'ifOperStatus' => 'up',
    'ifLastChange' => '309',
    'ifInOctets' => '2245802',
    'ifInUcastPkts' => '18144',
    'ifInNUcastPkts' => '4534',
    'ifInDiscards' => '0',
    'ifInErrors' => '0',
    'ifInUnknownProtos' => '0',
    'ifOutOctets' => '62969',
    'ifOutUcastPkts' => '362',
    'ifOutNUcastPkts' => '0',
    'ifOutDiscards' => '0',
    'ifOutErrors' => '0',
    'ifOutQLen' => '0',
    'ifSpecific' => 'zeroDotZero',
  ),
  2 => 
  array (
    'ifIndex' => '2',
    'ifDescr' => 'lo',
    'ifType' => 'softwareLoopback',
    'ifMtu' => '65536',
    'ifSpeed' => '0',
    'ifPhysAddress' => '',
    'ifAdminStatus' => 'up',
    'ifOperStatus' => 'up',
    'ifLastChange' => '0',
    'ifInOctets' => '2829488',
    'ifInUcastPkts' => '4686',
    'ifInNUcastPkts' => '0',
    'ifInDiscards' => '0',
    'ifInErrors' => '0',
    'ifInUnknownProtos' => '0',
    'ifOutOctets' => '2829488',
    'ifOutUcastPkts' => '4686',
    'ifOutNUcastPkts' => '0',
    'ifOutDiscards' => '0',
    'ifOutErrors' => '0',
    'ifOutQLen' => '0',
    'ifSpecific' => 'zeroDotZero',
  ),
)  
 valid  
 valid  

Port eth0: eth0 (1 / #104129) ifInOctets  
ifOutOctets  
ifInUcastPkts  
ifOutUcastPkts  
ifInBroadcastPkts  
ifOutBroadcastPkts  
ifInMulticastPkts  
ifOutMulticastPkts  
ifSpeed (1000000000)  
VLAN = ?  Using ifDescr as ifAlias  
 Using ifDescr as ifName  
eth0
 ifInOctets (665095 B) 4963.3955223881 Bps 134 secs  

 ifOutOctets (20452 B) 152.62686567164 Bps 134 secs  

 ifInErrors (0 B) 0 Bps 134 secs  

 ifOutErrors (0 B) 0 Bps 134 secs  

 ifInUcastPkts (4403 B) 32.858208955224 Bps 134 secs  

 ifOutUcastPkts (137 B) 1.0223880597015 Bps 134 secs  

 ifInNUcastPkts (947 B) 7.0671641791045 Bps 134 secs  

 ifOutNUcastPkts (0 B) 0 Bps 134 secs  

 ifInDiscards (0 B) 0 Bps 134 secs  

 ifOutDiscards (0 B) 0 Bps 134 secs  

 ifInUnknownProtos (0 B) 0 Bps 134 secs  

 ifInBroadcastPkts (0 B) 0 Bps 134 secs  

 ifOutBroadcastPkts (0 B) 0 Bps 134 secs  

 ifInMulticastPkts (0 B) 0 Bps 134 secs  

 ifOutMulticastPkts (0 B) 0 Bps 134 secs  
bps(39.71 kbps/1.22 kbps)bytes(649.51 KiB/19.97 KiB)pkts(32.86 pps/1.02 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["2245802",1580707,4963.395522388059,665095,"62969",42517,152.62686567164178,20452,"0",0,0,0,"0",0,0,0,"18144",13741,32.85820895522388,4403,"362",225,1.0223880597014925,137,1690184952,1690184818,134,104129][0m 1.48ms] 
  
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["4534",3587,7.067164179104478,947,"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,104129][0m 1.07ms] 
  
2 updated  

Port lo: lo (2 / #104130) ifInOctets  
ifOutOctets  
ifInUcastPkts  
ifOutUcastPkts  
ifInBroadcastPkts  
ifOutBroadcastPkts  
ifInMulticastPkts  
ifOutMulticastPkts  
ifSpeed (0)  
VLAN = ?  Using ifDescr as ifAlias  
 Using ifDescr as ifName  
lo
 ifInOctets (1392 B) 10.388059701493 Bps 134 secs  

 ifOutOctets (1392 B) 10.388059701493 Bps 134 secs  

 ifInErrors (0 B) 0 Bps 134 secs  

 ifOutErrors (0 B) 0 Bps 134 secs  

 ifInUcastPkts (24 B) 0.17910447761194 Bps 134 secs  

 ifOutUcastPkts (24 B) 0.17910447761194 Bps 134 secs  

 ifInNUcastPkts (0 B) 0 Bps 134 secs  

 ifOutNUcastPkts (0 B) 0 Bps 134 secs  

 ifInDiscards (0 B) 0 Bps 134 secs  

 ifOutDiscards (0 B) 0 Bps 134 secs  

 ifInUnknownProtos (0 B) 0 Bps 134 secs  

 ifInBroadcastPkts (0 B) 0 Bps 134 secs  

 ifOutBroadcastPkts (0 B) 0 Bps 134 secs  

 ifInMulticastPkts (0 B) 0 Bps 134 secs  

 ifOutMulticastPkts (0 B) 0 Bps 134 secs  
bps(83 bps/83 bps)bytes(1.36 KiB/1.36 KiB)pkts(0.18 pps/0.18 pps)SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`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["0","2829488",2828096,10.388059701492537,1392,"2829488",2828096,10.388059701492537,1392,"0",0,0,0,"0",0,0,0,"4686",4662,0.1791044776119403,24,"4686",4662,0.1791044776119403,24,1690184952,1690184818,134,104130][0m 1.02ms] 
  
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,104130][0m 0.76ms] 
  
1 updated  

SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1690184952,1690184818,null][0m 0.48ms] 
  
0 updated  

>> Runtime for poller module 'ports': 0.1690 seconds with 85544 bytes
>> [0;36mSNMP[0m: [4/0.15s] [1;33mMySQL[0m: [6/0.07s]   
#### 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[224][0m 0.8ms] 
  

>> Runtime for poller module 'customoid': 0.0016 seconds with 1496 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### Unload poller module customoid ####

Modules status: Global+  
OS  
Device  

#### Load poller module bgp-peers ####
SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[224][0m 0.94ms] 
  

>> Runtime for poller module 'bgp-peers': 0.0045 seconds with 13176 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### Unload poller module bgp-peers ####

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[224][0m 0.66ms] 
  

>> Runtime for poller module 'ucd-diskio': 0.0014 seconds with 960 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### 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: generic  
OS initialized: LibreNMS\OS\Generic  
SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[224][0m 0.82ms] 
  

>> Runtime for poller module 'wireless': 0.0038 seconds with 103800 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### Unload poller module wireless ####

Modules status: Global+  
OS  
Device  

#### Load poller module ospf ####
SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[224][0m 0.73ms] 
  
 Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]  
ospfGeneralGroup = No Such Object available on this agent at this OID
  
  
SQL[[1;33mdelete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[224,""][0m 0.61ms] 
  
0
>> Runtime for poller module 'ospf': 0.0668 seconds with 103648 bytes
>> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [2/0.01s]   
#### Unload poller module ospf ####

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.0002 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[224][0m 0.84ms] 
  

>> Runtime for poller module 'applications': 0.0025 seconds with 28368 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]   
#### Unload poller module applications ####

Modules status: Global+  
OS  
Device  

#### Load poller module stp ####
Instances: SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[224][0m 0.83ms] 
  

Ports: SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[224][0m 0.8ms] 
  

>> Runtime for poller module 'stp': 0.0049 seconds with 72904 bytes
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.02s]   
#### Unload poller module stp ####

Modules status: Global+  
OS  
Device  

#### Load poller module ntp ####

>> Runtime for poller module 'ntp': 0.0002 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.0009 seconds with 36712 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[224][0m 0.9ms] 
  

SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[2.394,224][0m 1.08ms] 
  
Updating 193.203.13.217  

Polled in 2.394 seconds
### Start Device Groups ###
SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.67ms] 
  
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 (3, 4, 5, 6, 7) [0;33m[][0m 1.22ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`location_id` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["33",224][0m 0.77ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`location_id` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["32",224][0m 0.65ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`location_id` = ? OR `devices`.`location_id` = ? OR `devices`.`location_id` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["39","36","37",224][0m 0.74ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.31.10.250","10.31.10.1","10.38.1.2","193.203.13.242","193.203.13.234","193.203.13.241","10.0.1.3","10.0.2.3","10.0.3.3","10.0.4.3","10.0.5.3","10.0.6.3","10.31.10.2","10.31.10.3",224][0m 0.83ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.33.128.11","10.33.128.12","10.33.128.13","10.33.128.14","10.33.128.15","10.33.128.15","10.33.160.11","10.33.160.12","10.33.160.13",224][0m 0.7ms] 
  
SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[224][0m 0.65ms] 
  
Groups Added:  
Groups Removed:  
### End Device Groups, runtime: 0.0255s ### 

#### 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[224][0m 0.82ms] 
  
SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` &lt;= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`start`) &lt;= ? 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 `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-07-24T07:49:12.271068Z","2023-07-24T07:49:12.271068Z",0,1,"07:49:12","07:49:12","07:49:12","07:49:12","[41m%","device",224,"location",103][0m 1.94ms] 
  
SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[224][0m 1.03ms] 
  
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[224,224,224,224,224,224,224,224,224,224,224][0m 3.22ms] 
  
#### End Alerts ####
./poller.php 193.203.13.217 2023-07-24 09:49:12 - 1 devices polled in 2.839 secs  

[0;36mSNMP[0m [24/1.24s]: Snmpget[17/0.96s] Snmpwalk[7/0.28s]  
[1;33mSQL[0m [56/0.48s]: Select[42/0.36s] Insert[1/0.01s] Update[12/0.10s] Delete[1/0.01s]