- SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.61ms]
- SQL[select count(*) as aggregate from `migrations` [] 0.69ms]
- SQL[select version() [] 0.37ms]
- ===========================================
- Component | Version
- --------- | -------
- LibreNMS | 25.1.0-114-gac01305ae (2025-02-14T13:28:45+08:00)
- DB Schema | 2025_01_07_223946_drop_cisco_a_s_a_table (315)
- PHP | 8.3.6
- Python | 3.12.3
- Database | MariaDB 10.11.8-MariaDB-0ubuntu0.24.04.1
- RRDTool | 1.7.2
- SNMP | 5.9.4.pre2
- ===========================================
- LibreNMS config cache cleared and config reloaded.
- SQL[select `config_name`, `config_value` from `config` [] 0.66ms]
- SQL[select * from `graph_types` [] 0.32ms]
- Starting polling run:
- SQL[select `device_id` from `devices` where `hostname` = ? ["172.29.1.211"] 0.47ms]
- SQL[select * from `devices` where `device_id` = ? limit 1 [75] 0.71ms]
- Hostname: 172.29.1.211 (unix)
- ID: 75
- OS: linux
- IP: 172.29.1.211
- Attempting to initialize OS: linux
- OS initialized: LibreNMS\OS\Linux
- SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [75] 0.74ms]
- [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '172.29.1.211'
- response: 172.29.1.211 : xmt/rcv/%loss = 3/3/0%, min/avg/max = 1.29/1.34/1.39
- SNMP['/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' '-Pu' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0']
- SNMPv2-MIB::sysObjectID.0 = NET-SNMP-MIB::netSnmpAgentOIDs.10
- SQL[update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? ["2025-02-14 15:51:38",1.34,75] 1.42ms]
- RRD[update /opt/librenms/rrd/172.29.1.211/icmp-perf.rrd N:1.34:3:3:1.29:1.39]
- SQL[select * 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 [75] 0.8ms]
- #### Load poller module core ####
- Module enabled: Global + | OS | Device | Manual
- SNMP['/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' '-Pu' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0']
- .*.*.0 = 88231003
- SNMP['/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' '-Pu' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0']
- SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 882303
- HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
- Uptime seconds: 882310
- RRD[update /opt/librenms/rrd/172.29.1.211/uptime.rrd N:882310]
- Uptime: 1 week 3 days 5 hours 5 minutes
- SQL[update `devices` set `uptime` = ? where `device_id` = ? [882310,75] 1.35ms]
- >> SNMP: [3/0.12s] MySQL: [4/0.04s] RRD: [2/0.00s]
- >> Runtime for poller module 'core': 0.0948 seconds with 136024 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-core.rrd N:0.094840049743652]
- #### Unload poller module core ####
- #### Load poller module os ####
- Module enabled: Global + | OS | Device | Manual
- SQL[select * from `locations` where `locations`.`id` = ? limit 1 [100] 0.73ms]
- Location: Tiaong Quezon
- Hardware: Generic ARMv7
- OS Version: 4.19.90
- OS Features:
- Serial:
- >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'os': 0.0080 seconds with 128696 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-os.rrd N:0.0080060958862305]
- #### Unload poller module os ####
- #### Load poller module availability ####
- Module enabled: Global + | OS | Device | Manual
- SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [75,1739433099] 0.86ms]
- SQL[select * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [75,86400] 0.54ms]
- SQL[update `availability` set `availability_perc` = ? where `availability_id` = ? [100,297] 0.38ms]
- RRD[update /opt/librenms/rrd/172.29.1.211/availability-86400.rrd N:100]
- 1 day : 100%
- SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [75,1738914699] 0.7ms]
- SQL[select * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [75,604800] 0.71ms]
- SQL[update `availability` set `availability_perc` = ? where `availability_id` = ? [98.947,298] 1.02ms]
- RRD[update /opt/librenms/rrd/172.29.1.211/availability-604800.rrd N:98.947]
- 1 week : 98.947%
- SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [75,1736927499] 0.83ms]
- SQL[select * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [75,2592000] 0.54ms]
- SQL[update `availability` set `availability_perc` = ? where `availability_id` = ? [98.947,299] 0.93ms]
- RRD[update /opt/librenms/rrd/172.29.1.211/availability-2592000.rrd N:98.947]
- 4 weeks : 98.947%
- SQL[select * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [75,1707983499] 0.69ms]
- SQL[select * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [75,31536000] 0.52ms]
- SQL[update `availability` set `availability_perc` = ? where `availability_id` = ? [98.947,300] 0.92ms]
- RRD[update /opt/librenms/rrd/172.29.1.211/availability-31536000.rrd N:98.947]
- 11 months : 98.947%
- SQL[delete from `availability` where `availability`.`device_id` = ? and `availability`.`device_id` is not null and `availability_id` not in (?, ?, ?, ?) [75,297,298,299,300] 0.48ms]
- >> SNMP: [0/0.00s] MySQL: [13/0.09s] RRD: [5/0.00s]
- >> Runtime for poller module 'availability': 0.0277 seconds with 75120 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-availability.rrd N:0.0277259349823]
- #### Unload poller module availability ####
- #### Load poller module ipmi ####
- Module enabled: Global + | OS | Device | Manual
- SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [75] 0.96ms]
- array (
- )
- >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'ipmi': 0.0056 seconds with 156808 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-ipmi.rrd N:0.0055520534515381]
- #### Unload poller module ipmi ####
- #### Load poller module sensors ####
- Module enabled: Global + | OS | Device | Manual
- SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [75] 0.74ms]
- >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'sensors': 0.0023 seconds with 3024 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-sensors.rrd N:0.0022881031036377]
- #### 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[SELECT * FROM processors WHERE device_id=? [75] 0.69ms]
- >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'processors': 0.0046 seconds with 62024 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-processors.rrd N:0.0045881271362305]
- #### Unload poller module processors ####
- #### Load poller module mempools ####
- Module enabled: Global + | OS | Device | Manual
- SQL[select * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [75] 0.84ms]
- >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'mempools': 0.0044 seconds with 67904 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-mempools.rrd N:0.0043809413909912]
- #### Unload poller module mempools ####
- #### Load poller module storage ####
- Module enabled: Global + | OS | Device | Manual
- SQL[select * from `storage` where `storage`.`device_id` = ? and `storage`.`device_id` is not null [75] 0.82ms]
- >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'storage': 0.0039 seconds with 58328 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-storage.rrd N:0.0039389133453369]
- #### Unload poller module storage ####
- #### Load poller module netstats ####
- Module enabled: Global + | OS | Device | Manual
- icmp
- SNMP['/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' '-Pu' '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']
- 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['/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' '-Pu' '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']
- 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['/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' '-Pu' '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']
- 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['/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' '-Pu' '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']
- 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['/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' '-Pu' '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']
- 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['/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' '-Pu' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0']
- IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
- snmp
- SNMP['/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' '-Pu' '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']
- SNMPv2-MIB::snmpInPkts.0 = 40246
- SNMPv2-MIB::snmpOutPkts.0 = 40245
- 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['/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' '-Pu' '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']
- SNMPv2-MIB::snmpInGenErrs.0 = 0
- SNMPv2-MIB::snmpInTotalReqVars.0 = 290146
- SNMPv2-MIB::snmpInTotalSetVars.0 = 0
- SNMPv2-MIB::snmpInGetRequests.0 = 20018
- 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['/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' '-Pu' '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']
- 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 = 40247
- SNMPv2-MIB::snmpOutTraps.0 = 0
- SNMPv2-MIB::snmpSilentDrops.0 = 0
- SNMPv2-MIB::snmpProxyDrops.0 = 0
- RRD[update /opt/librenms/rrd/172.29.1.211/netstats-snmp.rrd N:40246:40245:0:0:0:0:0:0:0:0:0:290146:0:20018:0:0:0:0:0:0:0:0:0:0:0:40247:0:0:0]
- udp
- SNMP['/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' '-Pu' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0']
- 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['/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' '-Pu' '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']
- 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
- >> SNMP: [11/0.46s] MySQL: [0/0.00s] RRD: [2/0.00s]
- >> Runtime for poller module 'netstats': 0.4681 seconds with 48296 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-netstats.rrd N:0.4680860042572]
- #### 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' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0']
- 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
- >> SNMP: [1/0.04s] MySQL: [0/0.00s] RRD: [1/0.00s]
- >> Runtime for poller module 'hr-mib': 0.0428 seconds with 3064 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-hr-mib.rrd N:0.042757034301758]
- #### 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' 'udp:HOSTNAME:161' 'systemStats']
- 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' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3']
- 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
- >> SNMP: [2/0.06s] MySQL: [0/0.00s] RRD: [1/0.00s]
- >> Runtime for poller module 'ucd-mib': 0.0649 seconds with 4456 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-ucd-mib.rrd N:0.064907073974609]
- #### 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' 'udp:HOSTNAME:161' 'ipSystemStats']
- 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
- >> SNMP: [1/0.06s] MySQL: [0/0.00s] RRD: [1/0.00s]
- >> Runtime for poller module 'ipSystemStats': 0.0653 seconds with 3344 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-ipSystemStats.rrd N:0.065265893936157]
- #### Unload poller module ipSystemStats ####
- #### Load poller module ports ####
- Module enabled: Global + | OS | Device | Manual
- SQL[SELECT *, `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 [75] 1.75ms]
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry']
- 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' 'udp:HOSTNAME:161' 'ifEntry']
- 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
- SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus']
- 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' 'udp:HOSTNAME:161' 'dot1qPvid']
- 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
- Fetched data (Full ports polling): dot3StatsDuplexStatus
- array (
- )
- SQL[update `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [1739519500,null,1739519500] 0.55ms]
- 0 updated
- >> SNMP: [4/0.21s] MySQL: [2/0.02s] RRD: [1/0.00s]
- >> Runtime for poller module 'ports': 0.2211 seconds with 28624 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-ports.rrd N:0.22111511230469]
- #### Unload poller module ports ####
- #### Load poller module customoid ####
- Module enabled: Global + | OS | Device | Manual
- SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [75] 1.1ms]
- >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'customoid': 0.0030 seconds with 3080 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-customoid.rrd N:0.0030310153961182]
- #### Unload poller module customoid ####
- #### Load poller module ucd-diskio ####
- Module enabled: Global + | OS | Device | Manual
- SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = ? [75] 0.67ms]
- >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'ucd-diskio': 0.0023 seconds with 2624 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-ucd-diskio.rrd N:0.0023219585418701]
- #### Unload poller module ucd-diskio ####
- #### Load poller module wireless ####
- Module enabled: Global + | OS | Device | Manual
- SQL[select * from `wireless_sensors` where `wireless_sensors`.`device_id` = ? and `wireless_sensors`.`device_id` is not null [75] 0.87ms]
- SNMP['/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' '-Pu' '-On' 'udp:HOSTNAME:161']
- Exitcode: 1 ["Missing object name
- USAGE: snmpget [OPTIONS] AGENT OID [OID]...
- Version: 5.9.4.pre2
- Web: http://www.net-snmp.org/
- Email: net-snmp-coders@lists.sourceforge.net
- OPTIONS:
- -h, --help\t\tdisplay this help message
- -H\t\t\tdisplay configuration file directives understood
- -v 1|2c|3\t\tspecifies SNMP version to use
- -V, --version\t\tdisplay package version number
- SNMP Version 1 or 2c specific
- -c COMMUNITY\t\tset the community string
- SNMP Version 3 specific
- -a PROTOCOL\t\tset authentication protocol (MD5|SHA|SHA-224|SHA-256|SHA-384|SHA-512)
- -A PASSPHRASE\t\tset authentication protocol pass phrase
- -e ENGINE-ID\t\tset security engine ID (e.g. 800000020109840301)
- -E ENGINE-ID\t\tset context engine ID (e.g. 800000020109840301)
- -l LEVEL\t\tset security level (noAuthNoPriv|authNoPriv|authPriv)
- -n CONTEXT\t\tset context name (e.g. bridge1)
- -u USER-NAME\t\tset security name (e.g. bert)
- -x PROTOCOL\t\tset privacy protocol (DES|AES|AES-192|AES-256)
- -X PASSPHRASE\t\tset privacy protocol pass phrase
- -Z BOOTS,TIME\t\tset destination engine boots/time
- General communication options
- -r RETRIES\t\tset the number of retries
- -t TIMEOUT\t\tset the request timeout (in seconds)
- Debugging
- -d\t\t\tdump input/output packets in hexadecimal
- -D[TOKEN[,...]]\tturn on debugging output for the specified TOKENs
- \t\t\t (ALL gives extremely verbose debugging output)
- General options
- -m MIB[:...]\t\tload given list of MIBs (ALL loads everything)
- -M DIR[:...]\t\tlook in given list of directories for MIBs
- (default: /opt/librenms/mibs)
- -P MIBOPTS\t\tToggle various defaults controlling MIB parsing:
- \t\t\t u: disallow the use of underlines in MIB symbols
- \t\t\t c: disallow the use of \"--\" to terminate comments
- \t\t\t d: save the DESCRIPTIONs of the MIB objects
- \t\t\t e: disable errors when MIB symbols conflict
- \t\t\t w: enable warnings when MIB symbols conflict
- \t\t\t W: enable detailed warnings when MIB symbols conflict
- \t\t\t R: replace MIB symbols from latest module
- -O OUTOPTS\t\tToggle various defaults controlling output display:
- \t\t\t 0: print leading 0 for single-digit hex characters
- \t\t\t a: print all strings in ascii format
- \t\t\t b: do not break OID indexes down
- \t\t\t e: print enums numerically
- \t\t\t E: escape quotes in string indices
- \t\t\t f: print full OIDs on output
- \t\t\t n: print OIDs numerically
- \t\t\t p PRECISION: display floating point values with specified PRECISION (printf format string)
- \t\t\t q: quick print for easier parsing
- \t\t\t Q: quick print with equal-signs
- \t\t\t s: print only last symbolic element of OID
- \t\t\t S: print MIB module-id plus last element
- \t\t\t t: print timeticks unparsed as numeric integers
- \t\t\t T: print human-readable text along with hex strings
- \t\t\t u: print OIDs using UCD-style prefix suppression
- \t\t\t U: don't print units
- \t\t\t v: print values only (not OID = value)
- \t\t\t x: print all strings in hex format
- \t\t\t X: extended index format
- -I INOPTS\t\tToggle various defaults controlling input parsing:
- \t\t\t b: do best/regex matching to find a MIB node
- \t\t\t h: don't apply DISPLAY-HINTs
- \t\t\t r: do not check values for range/type legality
- \t\t\t R: do random access to OID labels
- \t\t\t u: top-level OIDs must have '.' prefix (UCD-style)
- \t\t\t s SUFFIX: Append all textual OIDs with SUFFIX before parsing
- \t\t\t S PREFIX: Prepend all textual OIDs with PREFIX before parsing
- -L LOGOPTS\t\tToggle various defaults controlling logging:
- \t\t\t e: log to standard error
- \t\t\t o: log to standard output
- \t\t\t n: don't log at all
- \t\t\t f file: log to the specified file
- \t\t\t s facility: log to syslog (via the specified facility)
- \t\t\t (variants)
- \t\t\t [EON] pri: log to standard error, output or /dev/null for level 'pri' and above
- \t\t\t [EON] p1-p2: log to standard error, output or /dev/null for levels 'p1' to 'p2'
- \t\t\t [FS] pri token: log to file/syslog for level 'pri' and above
- \t\t\t [FS] p1-p2 token: log to file/syslog for levels 'p1' to 'p2'
- -C APPOPTS\t\tSet various application specific behaviours:
- \t\t\t f: do not fix errors and retry the request
- "]
- Missing object name
- USAGE: snmpget [OPTIONS] AGENT OID [OID]...
- Version: 5.9.4.pre2
- Web: http://www.net-snmp.org/
- Email: net-snmp-coders@lists.sourceforge.net
- OPTIONS:
- -h, --help display this help message
- -H display configuration file directives understood
- -v 1|2c|3 specifies SNMP version to use
- -V, --version display package version number
- SNMP Version 1 or 2c specific
- -c COMMUNITY set the community string
- SNMP Version 3 specific
- -a PROTOCOL set authentication protocol (MD5|SHA|SHA-224|SHA-256|SHA-384|SHA-512)
- -A PASSPHRASE set authentication protocol pass phrase
- -e ENGINE-ID set security engine ID (e.g. 800000020109840301)
- -E ENGINE-ID set context engine ID (e.g. 800000020109840301)
- -l LEVEL set security level (noAuthNoPriv|authNoPriv|authPriv)
- -n CONTEXT set context name (e.g. bridge1)
- -u USER-NAME set security name (e.g. bert)
- -x PROTOCOL set privacy protocol (DES|AES|AES-192|AES-256)
- -X PASSPHRASE set privacy protocol pass phrase
- -Z BOOTS,TIME set destination engine boots/time
- General communication options
- -r RETRIES set the number of retries
- -t TIMEOUT set the request timeout (in seconds)
- Debugging
- -d dump input/output packets in hexadecimal
- -D[TOKEN[,...]] turn on debugging output for the specified TOKENs
- (ALL gives extremely verbose debugging output)
- General options
- -m MIB[:...] load given list of MIBs (ALL loads everything)
- -M DIR[:...] look in given list of directories for MIBs
- (default: /opt/librenms/mibs)
- -P MIBOPTS Toggle various defaults controlling MIB parsing:
- u: disallow the use of underlines in MIB symbols
- c: disallow the use of "--" to terminate comments
- d: save the DESCRIPTIONs of the MIB objects
- e: disable errors when MIB symbols conflict
- w: enable warnings when MIB symbols conflict
- W: enable detailed warnings when MIB symbols conflict
- R: replace MIB symbols from latest module
- -O OUTOPTS Toggle various defaults controlling output display:
- 0: print leading 0 for single-digit hex characters
- a: print all strings in ascii format
- b: do not break OID indexes down
- e: print enums numerically
- E: escape quotes in string indices
- f: print full OIDs on output
- n: print OIDs numerically
- p PRECISION: display floating point values with specified PRECISION (printf format string)
- q: quick print for easier parsing
- Q: quick print with equal-signs
- s: print only last symbolic element of OID
- S: print MIB module-id plus last element
- t: print timeticks unparsed as numeric integers
- T: print human-readable text along with hex strings
- u: print OIDs using UCD-style prefix suppression
- U: don't print units
- v: print values only (not OID = value)
- x: print all strings in hex format
- X: extended index format
- -I INOPTS Toggle various defaults controlling input parsing:
- b: do best/regex matching to find a MIB node
- h: don't apply DISPLAY-HINTs
- r: do not check values for range/type legality
- R: do random access to OID labels
- u: top-level OIDs must have '.' prefix (UCD-style)
- s SUFFIX: Append all textual OIDs with SUFFIX before parsing
- S PREFIX: Prepend all textual OIDs with PREFIX before parsing
- -L LOGOPTS Toggle various defaults controlling logging:
- e: log to standard error
- o: log to standard output
- n: don't log at all
- f file: log to the specified file
- s facility: log to syslog (via the specified facility)
- (variants)
- [EON] pri: log to standard error, output or /dev/null for level 'pri' and above
- [EON] p1-p2: log to standard error, output or /dev/null for levels 'p1' to 'p2'
- [FS] pri token: log to file/syslog for level 'pri' and above
- [FS] p1-p2 token: log to file/syslog for levels 'p1' to 'p2'
- -C APPOPTS Set various application specific behaviours:
- f: do not fix errors and retry the request
- >> SNMP: [1/0.02s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'wireless': 0.0272 seconds with 85136 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-wireless.rrd N:0.02721905708313]
- #### Unload poller module wireless ####
- #### Load poller module entity-physical ####
- Module enabled: Global + | OS | Device | Manual
- >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [1/0.00s]
- >> Runtime for poller module 'entity-physical': 0.0011 seconds with 8096 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-entity-physical.rrd N:0.001101016998291]
- #### Unload poller module entity-physical ####
- #### Load poller module applications ####
- Module enabled: Global + | OS | Device | Manual
- SQL[select * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null and `applications`.`deleted_at` is null [75] 0.89ms]
- >> SNMP: [0/0.00s] MySQL: [1/0.01s] RRD: [1/0.00s]
- >> Runtime for poller module 'applications': 0.0048 seconds with 65096 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-applications.rrd N:0.0047647953033447]
- #### Unload poller module applications ####
- #### Load poller module ntp ####
- Module enabled: Global + | OS | Device | Manual
- >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [1/0.00s]
- >> Runtime for poller module 'ntp': 0.0010 seconds with 1992 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-ntp.rrd N:0.0010440349578857]
- #### Unload poller module ntp ####
- #### Load poller module loadbalancers ####
- Module enabled: Global + | OS | Device | Manual
- >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [1/0.00s]
- >> Runtime for poller module 'loadbalancers': 0.0009 seconds with 1976 bytes
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf-loadbalancers.rrd N:0.00092697143554688]
- #### Unload poller module loadbalancers ####
- RRD[update /opt/librenms/rrd/172.29.1.211/poller-perf.rrd N:2.1586790084839]
- SQL[select * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [75] 0.83ms]
- Enabled graphs (7): uptime poller_modules_perf availability netstat_snmp netstat_snmp_pkt poller_perf ping_perf
- SQL[update `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? ["2025-02-14 15:51:40",2.1586790084838867,75] 1.46ms]
- >>> Polled Tiaong Hub Cabinet (75) in 2.159 seconds <<<
- #### Start Alerts ####
- SQL[select `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` = ? [75] 0.92ms]
- SQL[select exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time(`end`) and time(`start`) <= ? and time(`end`) > ?) 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 `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` ["2025-02-14T07:51:40.098976Z","2025-02-14T07:51:40.098976Z",0,1,"07:51:40","07:51:40","07:51:40","07:51:40","%","device",75,"location",100] 2ms]
- SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [75] 0.95ms]
- SQL[SELECT 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))
- ) [75,75,75,75,75,75,75,75,75,75,75] 2.97ms]
- Rule #1 (Devices up/down):
- SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [75] 0.91ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,75] 0.49ms]
- Status: NOCHG
- Rule #2 (Ping Latency):
- SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.last_ping_timetaken > 600 [75] 0.8ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,75] 0.46ms]
- Status: NOCHG
- Rule #3 (Port utilisation over threshold):
- SQL[SELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 90 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [75] 1.69ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [3,75] 0.5ms]
- Status: NOCHG
- Rule #6 (Sensor over limit - Check Device Health Settings):
- SQL[SELECT * 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 [75] 1.39ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [6,75] 0.5ms]
- Status: NOCHG
- Rule #7 (Sensor under limit - Check Device Health Settings):
- SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors.sensor_limit_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [75] 1.35ms]
- SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [7,75] 0.51ms]
- Status: NOCHG
- #### End Alerts (0.04s) ####
- ### Start Device Groups ###
- SQL[select * from `device_groups` [] 0.49ms]
- SQL[select `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) [] 1.27ms]
- SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [75] 0.65ms]
- Groups Added: Removed:
- ### End Device Groups (0.0126s) ###
- SNMP [23/0.98s]: Snmpget[17/0.66s] Snmpwalk[6/0.32s]
- SQL [56/0.50s]: Select[47/0.42s] Update[8/0.08s] Delete[1/0.00s]
- RRD [28/0.01s]: Update[28/0.01s]