- SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.44ms]
- SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.35ms]
- SQL[[1;33mselect version() [0;33m[][0m 0.16ms]
- ===========================================
- Component | Version
- --------- | -------
- LibreNMS | 25.1.0-53-gf885e6bf2 (2025-01-29T17:14:52-06:00)
- DB Schema | 2025_01_28_135558_ports_drop_unique_ifindex (313)
- 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[[1;33mselect `config_name`, `config_value` from `config` [0;33m[][0m 0.47ms]
- SQL[[1;33mselect * from `graph_types` [0;33m[][0m 0.31ms]
- Starting polling run:
- SQL[[1;33mselect `device_id` from `devices` where `hostname` = ? [0;33m["10.29.2.250"][0m 0.29ms]
- SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[143][0m 0.37ms]
- Hostname: 10.29.2.250
- ID: 143
- OS: generic
- IP: 10.29.2.250
- Attempting to initialize OS: generic
- OS initialized: LibreNMS\OS\Generic
- SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[143][0m 0.32ms]
- [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '750' '-O' '0' '10.29.2.250'
- response: 10.29.2.250 : xmt/rcv/%loss = 3/3/0%, min/avg/max = 9.49/14/21.9
- 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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]
- SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.789.1123.2
- SQL[[1;33mupdate `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? [0;33m["2025-01-30 07:39:32",14,143][0m 272.28ms]
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/icmp-perf.rrd N:14:3:3:9.49:21.9[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[143][0m 0.4ms]
- #### 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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-Pu' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m]
- .*.*.0 = 188847300
- 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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]
- SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 1888398
- HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
- Uptime seconds: 1888473
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/uptime.rrd N:1888473[0m]
- Uptime: 3 weeks 20 hours 34 minutes 33 seconds
- SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[1888473,143][0m 87.66ms]
- >> [0;36mSNMP[0m: [3/0.14s] [1;33mMySQL[0m: [4/3.61s] [0;32mRRD[0m: [2/0.00s]
- >> Runtime for poller module 'core': 0.1905 seconds with 136256 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-core.rrd N:0.1904890537262[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[7][0m 0.47ms]
- Location: Houston, TX
- 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.0026 seconds with 128656 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-os.rrd N:0.0025548934936523[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[143,1738157973][0m 0.33ms]
- SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[143,86400][0m 0.25ms]
- SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,573][0m 0.2ms]
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/availability-86400.rrd N:100[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[143,1737639573][0m 0.29ms]
- SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[143,604800][0m 0.21ms]
- SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,574][0m 0.2ms]
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/availability-604800.rrd N:100[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[143,1735652373][0m 0.24ms]
- SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[143,2592000][0m 0.24ms]
- SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,575][0m 0.16ms]
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/availability-2592000.rrd N:100[0m]
- 4 weeks : 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[143,1706708373][0m 0.24ms]
- SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[143,31536000][0m 0.19ms]
- SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,576][0m 0.14ms]
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/availability-31536000.rrd N:100[0m]
- 11 months : 100%
- SQL[[1;33mdelete from `availability` where `availability`.`device_id` = ? and `availability`.`device_id` is not null and `availability_id` not in (?, ?, ?, ?) [0;33m[143,573,574,575,576][0m 0.17ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [13/0.03s] [0;32mRRD[0m: [5/0.00s]
- >> Runtime for poller module 'availability': 0.0081 seconds with 72776 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-availability.rrd N:0.0081160068511963[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[143][0m 0.28ms]
- array (
- )
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'ipmi': 0.0019 seconds with 91272 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-ipmi.rrd N:0.0019030570983887[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[143][0m 0.27ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'sensors': 0.0008 seconds with 3024 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-sensors.rrd N:0.00079584121704102[0m]
- #### Unload poller module sensors ####
- #### Load poller module processors ####
- Module enabled: Global + | OS | Device | Manual
- Attempting to initialize OS: generic
- OS initialized: LibreNMS\OS\Generic
- SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[143][0m 0.22ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'processors': 0.0016 seconds with 127560 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-processors.rrd N:0.0015668869018555[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[143][0m 0.25ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'mempools': 0.0015 seconds with 67904 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-mempools.rrd N:0.0014681816101074[0m]
- #### Unload poller module mempools ####
- #### Load poller module storage ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mselect * from `storage` where `storage`.`device_id` = ? and `storage`.`device_id` is not null [0;33m[143][0m 0.25ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'storage': 0.0013 seconds with 57440 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-storage.rrd N:0.0013110637664795[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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-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'[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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-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'[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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-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'[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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-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'[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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-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'[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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-Pu' '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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-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'[0m]
- SNMPv2-MIB::snmpInPkts.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpOutPkts.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInBadVersions.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInBadCommunityNames.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInBadCommunityUses.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInASNParseErrs.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInTooBigs.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInNoSuchNames.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInBadValues.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInReadOnlys.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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-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'[0m]
- SNMPv2-MIB::snmpInGenErrs.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInTotalReqVars.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInTotalSetVars.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInGetRequests.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInGetNexts.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInSetRequests.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInGetResponses.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpInTraps.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpOutTooBigs.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpOutNoSuchNames.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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-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'[0m]
- SNMPv2-MIB::snmpOutBadValues.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpOutGenErrs.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpOutGetRequests.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpOutGetNexts.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpOutSetRequests.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpOutGetResponses.0 = No Such Object available on this agent at this OID
- SNMPv2-MIB::snmpOutTraps.0 = No Such Object available on this agent at this OID
- 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' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-Pu' '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' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-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'[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.40s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'netstats': 0.4044 seconds with 50480 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-netstats.rrd N:0.40440487861633[0m]
- #### Unload poller module netstats ####
- #### Load poller module hr-mib ####
- Module enabled: Global + | OS | Device | Manual
- SNMP['/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' '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.0331 seconds with 3064 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-hr-mib.rrd N:0.033109903335571[0m]
- #### Unload poller module hr-mib ####
- #### Load poller module ucd-mib ####
- Module enabled: Global + | OS | Device | Manual
- SNMP['/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-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['/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-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
- >> [0;36mSNMP[0m: [2/0.08s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'ucd-mib': 0.0763 seconds with 8552 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-ucd-mib.rrd N:0.076343059539795[0m]
- #### Unload poller module ucd-mib ####
- #### Load poller module ipSystemStats ####
- Module enabled: Global + | OS | Device | Manual
- SNMP['/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-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
- >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'ipSystemStats': 0.0433 seconds with 3344 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-ipSystemStats.rrd N:0.043300151824951[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[143][0m 4.97ms]
- Caching Oids: Full ports polling SNMP['/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-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['/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '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' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-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['/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-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 (
- )
- SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1738244373,null,1738244373][0m 0.26ms]
- 0 updated
- >> [0;36mSNMP[0m: [4/0.17s] [1;33mMySQL[0m: [2/0.05s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'ports': 0.1801 seconds with 28056 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-ports.rrd N:0.18005108833313[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[143][0m 0.32ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'customoid': 0.0008 seconds with 3080 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-customoid.rrd N:0.00082612037658691[0m]
- #### Unload poller module customoid ####
- #### Load poller module bgp-peers ####
- Module enabled: Global + | OS | Device | Manual
- 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[143][0m 0.32ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'bgp-peers': 0.0024 seconds with 1324864 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-bgp-peers.rrd N:0.002418041229248[0m]
- #### Unload poller module bgp-peers ####
- #### Load poller module ucd-diskio ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[143][0m 0.25ms]
- >> [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.0006 seconds with 2512 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-ucd-diskio.rrd N:0.00064802169799805[0m]
- #### Unload poller module ucd-diskio ####
- #### Load poller module wireless ####
- Module enabled: Global + | OS | Device | Manual
- Attempting to initialize OS: generic
- OS initialized: LibreNMS\OS\Generic
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[143][0m 0.26ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'wireless': 0.0014 seconds with 104344 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-wireless.rrd N:0.0013589859008789[0m]
- #### Unload poller module wireless ####
- #### Load poller module ospf ####
- Module enabled: Global + | OS | Device | Manual
- SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[143][0m 0.31ms]
- Processes:
- SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA-256' '-A' 'PASSWORD' '-u' 'USER' '-OQXUt' '-Pu' '-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[143,""][0m 0.25ms]
- Total processes: 0
- >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [2/0.01s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'ospf': 0.0464 seconds with 112176 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-ospf.rrd N:0.046414136886597[0m]
- #### Unload poller module ospf ####
- #### 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.0003 seconds with 8136 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-entity-physical.rrd N:0.00026988983154297[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[143][0m 0.27ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'applications': 0.0012 seconds with 65064 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-applications.rrd N:0.0012478828430176[0m]
- #### Unload poller module applications ####
- #### Load poller module stp ####
- Module enabled: Global + | OS | Device | Manual
- Instances:
- SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[143][0m 0.25ms]
- Ports:
- SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[143][0m 0.25ms]
- >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.01s] [0;32mRRD[0m: [1/0.00s]
- >> Runtime for poller module 'stp': 0.0016 seconds with 72544 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-stp.rrd N:0.0016140937805176[0m]
- #### Unload poller module stp ####
- #### 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.0002 seconds with 1992 bytes
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf-ntp.rrd N:0.00022792816162109[0m]
- #### Unload poller module ntp ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.29.2.250/poller-perf.rrd N:2.353670835495[0m]
- SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[143][0m 0.28ms]
- Enabled graphs (5): uptime poller_modules_perf availability poller_perf ping_perf
- SQL[[1;33mupdate `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? [0;33m["2025-01-30 07:39:34",2.353670835494995,143][0m 284.47ms]
- >>> Polled gts-ng-prod-san00 (143) in 2.354 seconds <<<
- #### 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[143][0m 0.37ms]
- SQL[[1;33mselect 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 `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 (2)) 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["2025-01-30T13:39:34.294979Z","2025-01-30T13:39:34.294979Z",0,1,"13:39:34","13:39:34","13:39:34","13:39:34","[44m%","device",143,"device_group","location",7][0m 0.58ms]
- SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[143][0m 0.28ms]
- 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[143,143,143,143,143,143,143,143,143,143,143][0m 1.14ms]
- Rule [0;35m#2 (Device down (no SNMP 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 = "snmp" [0;33m[143][0m 0.31ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,143][0m 0.2ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#3 (device rebooted):[0m
- SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 180 AND (devices.disabled = 0 && devices.ignore = 0) = 1 [0;33m[143][0m 0.26ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[3,143][0m 0.14ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#6 (Port utilization over 90%for longer than 10 minutes):[0m
- SQL[[1;33mSELECT * 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 [0;33m[143][0m 4.77ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,143][0m 0.16ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#7 (Device sensor over limit):[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[143][0m 0.47ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,143][0m 0.23ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#8 (Device sensor under limit):[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_low AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[143][0m 0.35ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,143][0m 0.2ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#12 (Device 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[143][0m 0.43ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[12,143][0m 0.19ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#29 (Device not responding (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[143][0m 0.27ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[29,143][0m 0.19ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#30 (Disk space critically low (5%remaining)):[0m
- SQL[[1;33mSELECT * FROM devices,storage WHERE (devices.device_id = ? AND devices.device_id = storage.device_id) AND storage.storage_perc >= 95 [0;33m[143][0m 0.33ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[30,143][0m 0.21ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#31 (Interface error rate over 350 per second):[0m
- SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (ports.ifOutErrors_rate >= 350 OR ports.ifInErrors_rate >= 350) [0;33m[143][0m 4.75ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[31,143][0m 0.2ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#33 (.Device not responding (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[143][0m 0.3ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[33,143][0m 0.2ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#34 (.Device down (no SNMP 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 = "snmp" [0;33m[143][0m 0.27ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[34,143][0m 0.21ms]
- Status: [0;34mNOCHG[0m
- #### End Alerts (0.0257s) ####
- ### Start Device Groups ###
- SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.22ms]
- SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17) [0;33m[][0m 0.48ms]
- SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gts-tc%","gts-tc%","terre%","terre%","10.51.1.%","10.51.22.%","192.168.25.%",143][0m 1.14ms]
- SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gts-ng-%","gts-ng-%","10.29.2.%",143][0m 1.11ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gts-colo-%","gts-colo-%",143][0m 0.22ms]
- SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `ipv4_addresses`.`ipv4_address` LIKE ? OR `devices`.`hostname` = ? OR `devices`.`notes` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gts-hq-%","gts-hq-%","10.49.2.%"," ra12-b89935","10.49.2.%",143][0m 1.1ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gts-sr-%","gts-sr-%",143][0m 0.21ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `devices`.`type` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;35mtr%","[0;35mtr%","printer",143][0m 0.22ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-fw%","%-fw%",143][0m 0.22ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gts-tc-prod-sw-acc-apple%","gts-tc-prod-sw-acc-apple%","gts-tc-prod-sw-acc-acronis%","gts-tc-prod-sw-acc-acronis%","gts-tc-prod-sw-core%","gts-tc-prod-sw-core%","gts-tc-cjis-sw%","gts-tc-cjis-sw%",143][0m 0.22ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-sw%","%-sw%",143][0m 0.21ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%isp-tc%","%isp-tc%",143][0m 0.21ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["isp-%","isp-%",143][0m 0.22ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ? OR `devices`.`sysName` = ? OR `devices`.`hostname` = ? OR `devices`.`sysName` = ? OR `devices`.`hostname` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%-vm%","%-vm%","gts-tc-auth00","gts-tc-auth00","gts-tc-nms00","gts-tc-nms00",143][0m 0.23ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`type` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["power",143][0m 0.21ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;36mjis%","[0;36mjis%",143][0m 0.2ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ? OR `devices`.`sysName` LIKE ? OR `devices`.`hostname` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gts-ng-prod-sw-dist%","gts-ng-prod-sw-dist%","gts-ng-prod-sw-imaging%","gts-ng-prod-sw-imaging%","gts-ng-txdot-sw%","gts-ng-txdot-sw",143][0m 0.25ms]
- SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ? OR `devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gts-az%","gts-az%",143][0m 0.22ms]
- SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[143][0m 0.24ms]
- Groups Added: Removed:
- ### End Device Groups (0.0168s) ###
- [0;36mSNMP[0m [23/0.91s]: Snmpget[16/0.61s] Snmpwalk[7/0.30s]
- [1;33mSQL[0m [89/6.85s]: Select[79/0.40s] Update[8/6.45s] Delete[2/0.00s]
- [0;32mRRD[0m [29/0.00s]: Update[29/0.00s]