Override poller modules: unix-agent, core, os, availability, ipmi, sensors, processors, mempools, storage, netstats, hr-mib, ucd-mib, ipSystemStats, ports, xdsl, customoid, bgp-peers, junose-atm-vp, printer-supplies, ucd-diskio, vminfo, wifi, wireless, ospf, isis, cisco-ipsec-flow-monitor, cisco-remote-access-monitor, cisco-cef, slas, cisco-mac-accounting, cipsec-tunnels, cisco-ace-loadbalancer, cisco-ace-serverfarms, cisco-asa-firewall, cisco-voice, cisco-cbqos, cisco-otv, cisco-qfp, cisco-vpdn, nac, netscaler-vsvr, aruba-controller, entity-physical, entity-state, applications, stp, ntp, loadbalancers, mef, mpls  
SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.48ms] 
  
SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.34ms] 
  
SQL[[1;33mselect version() [0;33m[][0m 0.31ms] 
  
===========================================
Component | Version
--------- | -------
LibreNMS  | 24.6.0 (2024-06-16T18:23:37+02:00)
DB Schema | 2024_04_29_183605_custom_maps_drop_background_suffix_and_background_version (294)
PHP       | 8.1.28
Python    | 3.6.8
Database  | MariaDB 10.5.24-MariaDB
RRDTool   | 1.4.8
SNMP      | 5.7.2
===========================================
  
Updating os_def.cache  
Starting polling run:
  
SQL[[1;33mselect `device_id` from `devices` where `hostname` = ? [0;33m["skycontrol"][0m 0.56ms] 
  
SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[8][0m 0.74ms] 
  
Hostname:  skycontrol  (unix)
ID:        8
OS:        linux
IP:        10.100.98.60
  
Attempting to initialize OS: linux  
OS initialized: LibreNMS\OS\Linux  
SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[8][0m 0.55ms] 
  
[FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' 'skycontrol'
  
response: skycontrol : xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.34/0.44/0.5  
SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
SNMPv2-MIB::sysObjectID.0 = NET-SNMP-MIB::netSnmpAgentOIDs.10
  
  
SQL[[1;33mupdate `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? [0;33m["2024-06-19 09:12:17",0.44,8][0m 0.87ms] 
  
RRD[[0;32mcreate /opt/librenms/rrd/skycontrol/icmp-perf.rrd --step 300 --source /opt/librenms/rrd/skycontrol/ping-perf.rrd DS:avg=ping[1]:GAUGE:600:0:65535 DS:xmt:GAUGE:600:0:65535 DS:rcv:GAUGE:600:0:65535 DS:min:GAUGE:600:0:65535 DS:max:GAUGE:600:0:65535   RRA:AVERAGE:0.5:1:2016 RRA:AVERAGE:0.5:6:1440 RRA:AVERAGE:0.5:24:1440 RRA:AVERAGE:0.5:288:1440 RRA:MIN:0.5:1:2016 RRA:MIN:0.5:6:1440 RRA:MIN:0.5:24:1440 RRA:MIN:0.5:288:1440 RRA:MAX:0.5:1:2016 RRA:MAX:0.5:6:1440 RRA:MAX:0.5:24:1440 RRA:MAX:0.5:288:1440 RRA:LAST:0.5:1:2016  -O[0m]  
RRD[[0;32mupdate skycontrol/icmp-perf.rrd N:0.44:3:3:0.34:0.5 --daemon unix:/var/run/rrdcached.sock[0m]  
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[8][0m 0.63ms] 
  
#### Load poller module core ####
  
Module enabled: Global + | OS   | Device   | Manual    
SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' '-r' '4' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m]  
.*.*.0 = 708432501
  
  
SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 7084325
HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
  
  
Uptime seconds: 7084325
  
RRD[[0;32mupdate skycontrol/uptime.rrd N:7084325 --daemon unix:/var/run/rrdcached.sock[0m]  
Uptime: 2 months 3 weeks 4 days 23 hours 52 minutes 5 seconds  
SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[7084325,8][0m 1.01ms] 
  
  
>> [0;36mSNMP[0m: [3/0.09s] [1;33mMySQL[0m: [4/0.03s] [0;32mRRD[0m: [3/0.00s]  
>> Runtime for poller module 'core': 0.0711 seconds with 127448 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-core.rrd N:0.071110963821411 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module core ####
  
#### Load poller module os ####
  
Module enabled: Global + | OS   | Device   | Manual    
SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[26][0m 0.47ms] 
  
Location: Skycontrol EMS
Hardware: 
OS Version: 
OS Features: 
Serial: 
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'os': 0.0037 seconds with 189424 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-os.rrd N:0.0037150382995605 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module os ####
  
#### Load poller module availability ####
  
Module enabled: Global + | OS   | Device   | Manual    
SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[8,1718694737][0m 0.48ms] 
  
SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[8,86400][0m 0.35ms] 
  
SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,249][0m 0.23ms] 
  
RRD[[0;32mupdate skycontrol/availability-86400.rrd N:100 --daemon unix:/var/run/rrdcached.sock[0m]  
1 day   : 100%  
SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[8,1718176337][0m 0.41ms] 
  
SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[8,604800][0m 0.3ms] 
  
SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,250][0m 0.25ms] 
  
RRD[[0;32mupdate skycontrol/availability-604800.rrd N:100 --daemon unix:/var/run/rrdcached.sock[0m]  
1 week  : 100%  
SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[8,1716189137][0m 0.41ms] 
  
SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[8,2592000][0m 0.3ms] 
  
SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,251][0m 0.23ms] 
  
RRD[[0;32mupdate skycontrol/availability-2592000.rrd N:100 --daemon unix:/var/run/rrdcached.sock[0m]  
1 month : 100%  
SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[8,1687245137][0m 0.44ms] 
  
SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[8,31536000][0m 0.3ms] 
  
SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[99.997,252][0m 0.22ms] 
  
RRD[[0;32mupdate skycontrol/availability-31536000.rrd N:99.997 --daemon unix:/var/run/rrdcached.sock[0m]  
1 year  : 99.997%  
SQL[[1;33mdelete from `availability` where `availability`.`device_id` = ? and `availability`.`device_id` is not null and `availability_id` not in (?, ?, ?, ?) [0;33m[8,249,250,251,252][0m 0.47ms] 
  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [13/0.04s] [0;32mRRD[0m: [5/0.00s]  
>> Runtime for poller module 'availability': 0.0118 seconds with 77832 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-availability.rrd N:0.0118088722229 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module availability ####
  
#### Load poller module ipmi ####
  
Module enabled: Global + | OS   | Device   | Manual    
SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[8][0m 0.58ms] 
  
array (
)  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'ipmi': 0.0029 seconds with 96632 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-ipmi.rrd N:0.0029051303863525 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module ipmi ####
  
#### Load poller module sensors ####
  
Module enabled: Global + | OS   | Device   | Manual    
SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[8][0m 0.48ms] 
  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'sensors': 0.0015 seconds with 2440 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-sensors.rrd N:0.0015449523925781 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module sensors ####
  
#### Load poller module processors ####
  
Module enabled: Global + | OS   | Device   | Manual    
Attempting to initialize OS: linux  
OS initialized: LibreNMS\OS\Linux  
SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[8][0m 0.36ms] 
  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'processors': 0.0025 seconds with 103440 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-processors.rrd N:0.0024678707122803 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module processors ####
  
#### Load poller module mempools ####
  
Module enabled: Global + | OS   | Device   | Manual    
SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[8][0m 0.41ms] 
  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'mempools': 0.0021 seconds with 83064 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-mempools.rrd N:0.0021169185638428 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module mempools ####
  
#### Load poller module storage ####
  
Module enabled: Global + | OS   | Device   | Manual    
SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[8][0m 0.41ms] 
  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'storage': 0.0011 seconds with 3240 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-storage.rrd N:0.001060962677002 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module storage ####
  
#### Load poller module netstats ####
  
Module enabled: Global + | OS   | Device   | Manual    
icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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 = No Such Object available on this agent at this OID
IP-MIB::icmpOutMsgs.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInErrors.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutErrors.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInEchos.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutEchos.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInEchoReps.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutEchoReps.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInDestUnreachs.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutDestUnreachs.0 = No Such Object available on this agent at this OID
  
  
SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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 = No Such Object available on this agent at this OID
IP-MIB::icmpInTimeExcds.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInSrcQuenchs.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInRedirects.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInTimestamps.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInTimestampReps.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInAddrMasks.0 = No Such Object available on this agent at this OID
IP-MIB::icmpInAddrMaskReps.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutTimeExcds.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutParmProbs.0 = No Such Object available on this agent at this OID
  
  
SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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 = No Such Object available on this agent at this OID
IP-MIB::icmpOutRedirects.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutTimestamps.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutTimestampReps.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutAddrMasks.0 = No Such Object available on this agent at this OID
IP-MIB::icmpOutAddrMaskReps.0 = No Such Object available on this agent at this OID
  
  
ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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 = No Such Object available on this agent at this OID
IP-MIB::ipInDelivers.0 = No Such Object available on this agent at this OID
IP-MIB::ipInReceives.0 = No Such Object available on this agent at this OID
IP-MIB::ipOutRequests.0 = No Such Object available on this agent at this OID
IP-MIB::ipInDiscards.0 = No Such Object available on this agent at this OID
IP-MIB::ipOutDiscards.0 = No Such Object available on this agent at this OID
IP-MIB::ipOutNoRoutes.0 = No Such Object available on this agent at this OID
IP-MIB::ipReasmReqds.0 = No Such Object available on this agent at this OID
IP-MIB::ipReasmOKs.0 = No Such Object available on this agent at this OID
IP-MIB::ipReasmFails.0 = No Such Object available on this agent at this OID
  
  
SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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 = No Such Object available on this agent at this OID
IP-MIB::ipFragFails.0 = No Such Object available on this agent at this OID
IP-MIB::ipFragCreates.0 = No Such Object available on this agent at this OID
IP-MIB::ipInUnknownProtos.0 = No Such Object available on this agent at this OID
IP-MIB::ipInHdrErrors.0 = No Such Object available on this agent at this OID
IP-MIB::ipInAddrErrors.0 = No Such Object available on this agent at this OID
  
  
ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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 = 707545
SNMPv2-MIB::snmpOutPkts.0 = 707544
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' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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 = 4012142
SNMPv2-MIB::snmpInTotalSetVars.0 = 0
SNMPv2-MIB::snmpInGetRequests.0 = 550938
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' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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 = 707546
SNMPv2-MIB::snmpOutTraps.0 = 0
SNMPv2-MIB::snmpSilentDrops.0 = 0
SNMPv2-MIB::snmpProxyDrops.0 = 0
  
  
RRD[[0;32mupdate skycontrol/netstats-snmp.rrd N:707545:707544:0:0:0:0:0:0:0:0:0:4012142:0:550938:0:0:0:0:0:0:0:0:0:0:0:707546:0:0:0 --daemon unix:/var/run/rrdcached.sock[0m]  
udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
UDP-MIB::udpInDatagrams.0 = No Such Object available on this agent at this OID
UDP-MIB::udpOutDatagrams.0 = No Such Object available on this agent at this OID
UDP-MIB::udpInErrors.0 = No Such Object available on this agent at this OID
UDP-MIB::udpNoPorts.0 = No Such Object available on this agent at this OID
  
  
tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-r' '4' '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 = No Such Object available on this agent at this OID
TCP-MIB::tcpPassiveOpens.0 = No Such Object available on this agent at this OID
TCP-MIB::tcpAttemptFails.0 = No Such Object available on this agent at this OID
TCP-MIB::tcpEstabResets.0 = No Such Object available on this agent at this OID
TCP-MIB::tcpCurrEstab.0 = No Such Object available on this agent at this OID
TCP-MIB::tcpInSegs.0 = No Such Object available on this agent at this OID
TCP-MIB::tcpOutSegs.0 = No Such Object available on this agent at this OID
TCP-MIB::tcpRetransSegs.0 = No Such Object available on this agent at this OID
TCP-MIB::tcpInErrs.0 = No Such Object available on this agent at this OID
TCP-MIB::tcpOutRsts.0 = No Such Object available on this agent at this OID
  
  

  
>> [0;36mSNMP[0m: [11/0.34s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [2/0.00s]  
>> Runtime for poller module 'netstats': 0.3439 seconds with 53528 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-netstats.rrd N:0.34390997886658 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module netstats ####
  
#### Load poller module hr-mib ####
  
Module enabled: Global + | OS   | Device   | Manual    
SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' '-r' '4' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
hrSystemMaxProcesses.0 = No Such Object available on this agent at this OID
hrSystemProcesses.0 = No Such Object available on this agent at this OID
hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  

  
>> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'hr-mib': 0.0312 seconds with 3064 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-hr-mib.rrd N:0.031219005584717 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module hr-mib ####
  
#### Load poller module ucd-mib ####
  
Module enabled: Global + | OS   | Device   | Manual    
SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' '-r' '4' '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['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' '-r' '4' '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  
  
  
>> [0;36mSNMP[0m: [2/0.10s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'ucd-mib': 0.1003 seconds with 4424 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-ucd-mib.rrd N:0.10034799575806 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module ucd-mib ####
  
#### Load poller module ipSystemStats ####
  
Module enabled: Global + | OS   | Device   | Manual    
SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' '-r' '4' '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  

  
>> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'ipSystemStats': 0.0419 seconds with 3344 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-ipSystemStats.rrd N:0.041935920715332 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module ipSystemStats ####
  
#### Load poller module ports ####
  
Module enabled: Global + | OS   | Device   | Manual    
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[8][0m 0.92ms] 
  
Caching Oids: Full ports polling SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-r' '4' '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['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-r' '4' 'udp:HOSTNAME:161' 'ifEntry'[0m]
ifEntry = No Such Object available on this agent at this OID  
  
Invalid snmp_walk() data = ifEntry = No Such Object available on this agent at this OID  
dot3StatsDuplexStatusSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' '-r' '4' '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['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' '-r' '4' '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 (
)  

SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1718781138,null,1718781138][0m 0.58ms] 
  
0 updated  
  
>> [0;36mSNMP[0m: [4/0.20s] [1;33mMySQL[0m: [2/0.02s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'ports': 0.2018 seconds with 27704 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-ports.rrd N:0.20175099372864 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module ports ####
  
#### Load poller module customoid ####
  
Module enabled: Global + | OS   | Device   | Manual    
SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[8][0m 0.68ms] 
  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'customoid': 0.0018 seconds with 3080 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-customoid.rrd N:0.0017590522766113 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module customoid ####
  
#### Load poller module ucd-diskio ####
  
Module enabled: Global + | OS   | Device   | Manual    
SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[8][0m 0.48ms] 
  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'ucd-diskio': 0.0016 seconds with 2624 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-ucd-diskio.rrd N:0.0015888214111328 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module ucd-diskio ####
  
#### Load poller module wireless ####
  
Module enabled: Global + | OS   | Device   | Manual    
Attempting to initialize OS: linux  
OS initialized: LibreNMS\OS\Linux  
SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[8][0m 0.52ms] 
  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'wireless': 0.0024 seconds with 170120 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-wireless.rrd N:0.0024471282958984 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module wireless ####
  
#### Load poller module entity-physical ####
  
Module enabled: Global + | OS   | Device   | Manual    
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'entity-physical': 0.0004 seconds with 2048 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-entity-physical.rrd N:0.00043988227844238 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module entity-physical ####
  
#### Load poller module applications ####
  
Module enabled: Global + | OS   | Device   | Manual    
SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null and `applications`.`deleted_at` is null [0;33m[8][0m 0.44ms] 
  
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'applications': 0.0024 seconds with 67080 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-applications.rrd N:0.0023579597473145 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module applications ####
  
#### Load poller module ntp ####
  
Module enabled: Global + | OS   | Device   | Manual    
  
>> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]  
>> Runtime for poller module 'ntp': 0.0004 seconds with 18376 bytes  
RRD[[0;32mupdate skycontrol/poller-perf-ntp.rrd N:0.00043106079101562 --daemon unix:/var/run/rrdcached.sock[0m]  
#### Unload poller module ntp ####
  
RRD[[0;32mupdate skycontrol/poller-perf.rrd N:1.9018290042877 --daemon unix:/var/run/rrdcached.sock[0m]  
SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[8][0m 0.39ms] 
  
Enabled graphs (7): uptime netstat_snmp netstat_snmp_pkt poller_perf availability ping_perf poller_modules_perf

  
SQL[[1;33mupdate `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? [0;33m["2024-06-19 09:12:18",1.9018290042877197,8][0m 0.73ms] 
  
#### 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[8][0m 0.47ms] 
  
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 `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 (5)) 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["2024-06-19T07:12:18.562160Z","2024-06-19T07:12:18.562160Z",0,1,"07:12:18","07:12:18","07:12:18","07:12:18","[43m%","device",8,"device_group","location",26][0m 1.07ms] 
  
SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[8][0m 0.63ms] 
  
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[8,8,8,8,8,8,8,8,8,8,8][0m 1.79ms] 
  
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[8][0m 0.53ms] 
  
SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,8][0m 0.3ms] 
  
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[8][0m 0.45ms] 
  
SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,8][0m 0.29ms] 
  
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> 30 [0;33m[8][0m 0.42ms] 
  
SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,8][0m 0.28ms] 
  
Status: [0;34mNOCHG[0m  
Rule [0;35m#6 (Port utilisation over threshold):[0m   
  
SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((ports.ifInOctets_rate*8) / ports.ifSpeed)*100) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[8][0m 0.68ms] 
  
SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,8][0m 0.27ms] 
  
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[8][0m 0.58ms] 
  
SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,8][0m 0.27ms] 
  
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[8][0m 0.56ms] 
  
SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,8][0m 0.27ms] 
  
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 &lt;= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[8][0m 0.54ms] 
  
SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,8][0m 0.28ms] 
  
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 [0;33m[8][0m 0.67ms] 
  
SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,8][0m 0.27ms] 
  
Status: [0;34mNOCHG[0m  
#### End Alerts (0.0294s) ####
  
### Start Device Groups ###  
SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.28ms] 
  
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) [0;33m[][0m 1.9ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;31mouteros%",8][0m 0.37ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;35mowerconnect%",8][0m 0.33ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;35mrocurve%",8][0m 0.3ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? OR `devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[1;35microsoft Windows%","[0;37mindows%",8][0m 0.33ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%linux%",8][0m 0.31ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? OR `devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;30monica%","jetdirect",8][0m 0.31ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%qnap%","%dsm%","%hpe-msa%",8][0m 0.33ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`os` LIKE ? OR `devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%hpe%","%vmware-esxi%","%drac %","%drac%","%junos%","%ibm-imm%",8][0m 0.34ms] 
  
SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%jetstream%",8][0m 0.32ms] 
  
SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[8][0m 0.3ms] 
  
Groups Added:   Removed:   
### End Device Groups (0.0185s) ### 
  

>>> Polled skycontrol (8) in 1.902 seconds &lt;&lt;&lt;  

[0;36mSNMP[0m [22/0.80s]: Snmpget[16/0.49s] Snmpwalk[6/0.31s]  
[1;33mSQL[0m [77/0.37s]: Select[68/0.33s] Update[8/0.04s] Delete[1/0.00s]  
[0;32mRRD[0m [28/0.01s]: Create[1/0.00s] Update[27/0.01s]