LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.31ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.24ms] SQL[[1;33mselect version() [0;33m[][0m 0.14ms] =================================== Version info: Commit SHA: d248e6561fcd8965839c5834d7f440ed0cb2a54b Commit Date: 1659026326 DB Schema: 2022_07_03_1947_add_app_data (244) PHP: 7.3.31-1~deb10u1 MySQL: 10.3.34-MariaDB-0+deb10u1 RRDTool: 1.7.1 SNMP: 5.7.3 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'elv-1-hor-15' ORDER BY `device_id` ASC [0;33m[][0m 0.6ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[205][0m 0.36ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[205][0m 0.22ms] Attempting to initialize OS: coromatic-flexy OS initialized as Generic Hostname: elv-1-hor-15 Device ID: 205 OS: coromatic-flexy Resolved IP: 192.168.202.101 [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' 'elv-1-hor-15' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 1.41/1.54/1.69 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.82* SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[1.41,1.69,1.54,3,3,0,205,"2022-07-29 15:00:32"][0m 1ms] SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[1.54,205][0m 0.94ms] 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[205][0m 0.33ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m] .*.*.0 = Linux ewon3 3.2.11-77+ #1 PREEMPT Tue Jun 22 09:12:27 UTC 2021 armv5tejl .*.*.0 = .*.4.1.82* .*.*.0 = 431827528 .*.*.0 = ewon3 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 4318275 Uptime: 49 days 23 hours 31 minutes 15 seconds SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[4318275,205][0m 0.93ms] >> Runtime for poller module 'core': 0.0214 seconds with 70768 bytes >> [0;36mSNMP[0m: [2/0.02s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module core #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[96][0m 0.28ms] Location: Unknown Hardware: 5016 OS Version: OS Features: Serial: >> Runtime for poller module 'os': 0.0019 seconds with 117288 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[205][0m 0.28ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[205][0m 0.22ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[205,1659013232][0m 0.23ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,753][0m 0.14ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[205,1658494832][0m 0.23ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,754][0m 0.13ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[205,1656507632][0m 0.22ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,755][0m 0.13ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[205,1627563632][0m 0.21ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,756][0m 0.13ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0038 seconds with 12416 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.02s] #### Unload poller module availability #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[205][0m 0.26ms] array ( ) >> Runtime for poller module 'ipmi': 0.0006 seconds with 1592 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module ipmi #### Modules status: Global+ OS Device #### Load poller module sensors #### SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[205][0m 0.26ms] >> Runtime for poller module 'sensors': 0.0004 seconds with 416 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: coromatic-flexy OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[205][0m 0.22ms] >> Runtime for poller module 'processors': 0.0011 seconds with 59280 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module processors #### Modules status: Global+ OS Device #### Load poller module mempools #### SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[205][0m 0.29ms] >> Runtime for poller module 'mempools': 0.0011 seconds with 141672 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[205][0m 0.23ms] >> Runtime for poller module 'storage': 0.0005 seconds with 904 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' '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::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::icmpInMsgs.0 = 58251 IP-MIB::icmpOutMsgs.0 = 58226 IP-MIB::icmpInErrors.0 = 30 IP-MIB::icmpOutErrors.0 = 0 IP-MIB::icmpInEchos.0 = 58159 IP-MIB::icmpOutEchos.0 = 0 IP-MIB::icmpInEchoReps.0 = 0 IP-MIB::icmpOutEchoReps.0 = 58159 IP-MIB::icmpInDestUnreachs.0 = 92 IP-MIB::icmpOutDestUnreachs.0 = 67 IP-MIB::icmpInParmProbs.0 = 0 IP-MIB::icmpInTimeExcds.0 = 0 IP-MIB::icmpInSrcQuenchs.0 = 0 IP-MIB::icmpInRedirects.0 = 0 IP-MIB::icmpInTimestamps.0 = 0 IP-MIB::icmpInTimestampReps.0 = 0 IP-MIB::icmpInAddrMasks.0 = 0 IP-MIB::icmpInAddrMaskReps.0 = 0 IP-MIB::icmpOutTimeExcds.0 = 0 IP-MIB::icmpOutParmProbs.0 = 0 IP-MIB::icmpOutSrcQuenchs.0 = 0 IP-MIB::icmpOutRedirects.0 = 0 IP-MIB::icmpOutTimestamps.0 = 0 IP-MIB::icmpOutTimestampReps.0 = 0 IP-MIB::icmpOutAddrMasks.0 = 0 IP-MIB::icmpOutAddrMaskReps.0 = 0 ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' '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::ipForwDatagrams.0 = 0 IP-MIB::ipInDelivers.0 = 414660717 IP-MIB::ipInReceives.0 = 416086613 IP-MIB::ipOutRequests.0 = 228124530 IP-MIB::ipInDiscards.0 = 0 IP-MIB::ipOutDiscards.0 = 0 IP-MIB::ipOutNoRoutes.0 = 4 IP-MIB::ipReasmReqds.0 = 0 IP-MIB::ipReasmOKs.0 = 0 IP-MIB::ipReasmFails.0 = 0 IP-MIB::ipFragOKs.0 = 0 IP-MIB::ipFragFails.0 = 0 IP-MIB::ipFragCreates.0 = 0 IP-MIB::ipInUnknownProtos.0 = 0 IP-MIB::ipInHdrErrors.0 = 0 IP-MIB::ipInAddrErrors.0 = 0 ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' '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::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::snmpInPkts.0 = 648819 SNMPv2-MIB::snmpOutPkts.0 = 638640 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 SNMPv2-MIB::snmpInGenErrs.0 = 0 SNMPv2-MIB::snmpInTotalReqVars.0 = 5086272 SNMPv2-MIB::snmpInTotalSetVars.0 = 0 SNMPv2-MIB::snmpInGetRequests.0 = 256343 SNMPv2-MIB::snmpInGetNexts.0 = 11797 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 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 = 638371 SNMPv2-MIB::snmpOutTraps.0 = 269 SNMPv2-MIB::snmpSilentDrops.0 = 0 SNMPv2-MIB::snmpProxyDrops.0 = 0 udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m] UDP-MIB::udpInDatagrams.0 = 756705 UDP-MIB::udpOutDatagrams.0 = 746619 UDP-MIB::udpInErrors.0 = 0 UDP-MIB::udpNoPorts.0 = 8 tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m] TCP-MIB::tcpActiveOpens.0 = 3 TCP-MIB::tcpPassiveOpens.0 = 295227 TCP-MIB::tcpAttemptFails.0 = 0 TCP-MIB::tcpEstabResets.0 = 1 TCP-MIB::tcpCurrEstab.0 = 1 TCP-MIB::tcpInSegs.0 = 413789886 TCP-MIB::tcpOutSegs.0 = 227319646 TCP-MIB::tcpRetransSegs.0 = 48 TCP-MIB::tcpInErrs.0 = 0 TCP-MIB::tcpOutRsts.0 = 19 >> Runtime for poller module 'netstats': 0.0705 seconds with 22720 bytes >> [0;36mSNMP[0m: [6/0.07s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module netstats #### Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] hrSystemMaxProcesses.0 = No Such 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 >> Runtime for poller module 'hr-mib': 0.0092 seconds with 608 bytes >> [0;36mSNMP[0m: [1/0.01s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module hr-mib #### Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m] systemStats = No Such Object available on this agent at this OID Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] laLoadInt.1 = No Such Object available on this agent at this OID laLoadInt.2 = No Such Object available on this agent at this OID laLoadInt.3 = No Such Object available on this agent at this OID >> Runtime for poller module 'ucd-mib': 0.0208 seconds with 104 bytes >> [0;36mSNMP[0m: [2/0.02s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ucd-mib #### Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsInReceives.ipv4 = 416080459 ipSystemStatsHCInReceives.ipv4 = 416080459 ipSystemStatsHCInOctets.ipv4 = 0 ipSystemStatsInHdrErrors.ipv4 = 0 ipSystemStatsInAddrErrors.ipv4 = 0 ipSystemStatsInUnknownProtos.ipv4 = 0 ipSystemStatsInForwDatagrams.ipv4 = 0 ipSystemStatsHCInForwDatagrams.ipv4 = 0 ipSystemStatsReasmReqds.ipv4 = 0 ipSystemStatsReasmOKs.ipv4 = 0 ipSystemStatsReasmFails.ipv4 = 0 ipSystemStatsInDiscards.ipv4 = 0 ipSystemStatsInDelivers.ipv4 = 414654585 ipSystemStatsHCInDelivers.ipv4 = 414654585 ipSystemStatsOutRequests.ipv4 = 228121183 ipSystemStatsHCOutRequests.ipv4 = 228121183 ipSystemStatsOutNoRoutes.ipv4 = 4 ipSystemStatsHCOutForwDatagrams.ipv4 = 0 ipSystemStatsOutDiscards.ipv4 = 0 ipSystemStatsOutFragFails.ipv4 = 0 ipSystemStatsOutFragCreates.ipv4 = 0 ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00 ipSystemStatsRefreshRate.ipv4 = 30000 ipv4 >> Runtime for poller module 'ipSystemStats': 0.0252 seconds with 13192 bytes >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ipSystemStats #### Modules status: Global+ OS Device #### Load poller module ports #### SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[205][0m 0.8ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifName.1 = lo ifName.2 = eth0 ifName.3 = usb0 ifName.4 = eth0.10 ifName.5 = eth0.20 ifInMulticastPkts.1 = 0 ifInMulticastPkts.2 = 0 ifInMulticastPkts.3 = 0 ifInMulticastPkts.4 = 1496485 ifInMulticastPkts.5 = 14041587 ifInBroadcastPkts.1 = 0 ifInBroadcastPkts.2 = 0 ifInBroadcastPkts.3 = 0 ifInBroadcastPkts.4 = 0 ifInBroadcastPkts.5 = 0 ifOutMulticastPkts.1 = 0 ifOutMulticastPkts.2 = 0 ifOutMulticastPkts.3 = 0 ifOutMulticastPkts.4 = 0 ifOutMulticastPkts.5 = 0 ifOutBroadcastPkts.1 = 0 ifOutBroadcastPkts.2 = 0 ifOutBroadcastPkts.3 = 0 ifOutBroadcastPkts.4 = 0 ifOutBroadcastPkts.5 = 0 ifHCInOctets.1 = 7352 ifHCInOctets.2 = 1588982902 ifHCInOctets.3 = 0 ifHCInOctets.4 = 22101280944 ifHCInOctets.5 = 1770768020 ifHCInUcastPkts.1 = 75 ifHCInUcastPkts.2 = 432316945 ifHCInUcastPkts.3 = 0 ifHCInUcastPkts.4 = 410521898 ifHCInUcastPkts.5 = 6256975 ifHCInMulticastPkts.1 = 0 ifHCInMulticastPkts.2 = 0 ifHCInMulticastPkts.3 = 0 ifHCInMulticastPkts.4 = 1496485 ifHCInMulticastPkts.5 = 14041587 ifHCInBroadcastPkts.1 = 0 ifHCInBroadcastPkts.2 = 0 ifHCInBroadcastPkts.3 = 0 ifHCInBroadcastPkts.4 = 0 ifHCInBroadcastPkts.5 = 0 ifHCOutOctets.1 = 7352 ifHCOutOctets.2 = 1543292265 ifHCOutOctets.3 = 0 ifHCOutOctets.4 = 14478910698 ifHCOutOctets.5 = 3331154951 ifHCOutUcastPkts.1 = 75 ifHCOutUcastPkts.2 = 228273950 ifHCOutUcastPkts.3 = 0 ifHCOutUcastPkts.4 = 222501225 ifHCOutUcastPkts.5 = 5772725 ifHCOutMulticastPkts.1 = 0 ifHCOutMulticastPkts.2 = 0 ifHCOutMulticastPkts.3 = 0 ifHCOutMulticastPkts.4 = 0 ifHCOutMulticastPkts.5 = 0 ifHCOutBroadcastPkts.1 = 0 ifHCOutBroadcastPkts.2 = 0 ifHCOutBroadcastPkts.3 = 0 ifHCOutBroadcastPkts.4 = 0 ifHCOutBroadcastPkts.5 = 0 ifHighSpeed.1 = 10 ifHighSpeed.2 = 100 ifHighSpeed.3 = 10 ifHighSpeed.4 = 100 ifHighSpeed.5 = 100 ifPromiscuousMode.1 = false ifPromiscuousMode.2 = false ifPromiscuousMode.3 = false ifPromiscuousMode.4 = false ifPromiscuousMode.5 = false ifConnectorPresent.2 = true ifConnectorPresent.3 = true ifConnectorPresent.4 = true ifConnectorPresent.5 = true ifAlias.1 = ifAlias.2 = ifAlias.3 = ifAlias.4 = ifAlias.5 = ifCounterDiscontinuityTime.1 = 0:0:00:00.00 ifCounterDiscontinuityTime.2 = 0:0:00:00.00 ifCounterDiscontinuityTime.3 = 0:0:00:00.00 ifCounterDiscontinuityTime.4 = 0:0:00:00.00 ifCounterDiscontinuityTime.5 = 0:0:00:00.00 ifDescr SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifDescr'[0m] ifDescr.1 = lo ifDescr.2 = eth0 ifDescr.3 = usb0 ifDescr.4 = eth0.10 ifDescr.5 = eth0.20 ifAdminStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifAdminStatus'[0m] ifAdminStatus.1 = up ifAdminStatus.2 = up ifAdminStatus.3 = down ifAdminStatus.4 = up ifAdminStatus.5 = up ifOperStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOperStatus'[0m] ifOperStatus.1 = up ifOperStatus.2 = up ifOperStatus.3 = down ifOperStatus.4 = up ifOperStatus.5 = up ifLastChange SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifLastChange'[0m] ifLastChange.1 = 0 ifLastChange.2 = 0 ifLastChange.3 = 0 ifLastChange.4 = 0 ifLastChange.5 = 1513 ifType SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifType'[0m] ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.5 = ethernetCsmacd ifPhysAddress SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifPhysAddress'[0m] ifPhysAddress.1 = ifPhysAddress.2 = 0:3:27:14:56:92 ifPhysAddress.3 = ae:6:4b:73:55:8 ifPhysAddress.4 = 0:3:27:54:56:92 ifPhysAddress.5 = 0:3:27:14:56:92 ifMtu SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifMtu'[0m] ifMtu.1 = 16436 ifMtu.2 = 1500 ifMtu.3 = 1500 ifMtu.4 = 1500 ifMtu.5 = 1500 ifInErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInErrors'[0m] ifInErrors.1 = 0 ifInErrors.2 = 0 ifInErrors.3 = 0 ifInErrors.4 = 0 ifInErrors.5 = 0 ifOutErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutErrors'[0m] ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifOutErrors.3 = 0 ifOutErrors.4 = 0 ifOutErrors.5 = 0 ifInDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInDiscards'[0m] ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInDiscards.3 = 0 ifInDiscards.4 = 37513 ifInDiscards.5 = 14184020 ifOutDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutDiscards'[0m] ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 ifOutDiscards.3 = 0 ifOutDiscards.4 = 0 ifOutDiscards.5 = 0 dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID array ( 1 => array ( 'ifName' => 'lo', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '7352', 'ifHCInUcastPkts' => '75', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '7352', 'ifHCOutUcastPkts' => '75', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '10', 'ifPromiscuousMode' => 'false', 'ifAlias' => '', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'lo', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'softwareLoopback', 'ifPhysAddress' => '', 'ifMtu' => '16436', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 2 => array ( 'ifName' => 'eth0', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '1588982902', 'ifHCInUcastPkts' => '432316945', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '1543292265', 'ifHCOutUcastPkts' => '228273950', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '100', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => '', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'eth0', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '0:3:27:14:56:92', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 3 => array ( 'ifName' => 'usb0', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '10', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => '', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'usb0', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => 'ae:6:4b:73:55:8', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 4 => array ( 'ifName' => 'eth0.10', 'ifInMulticastPkts' => '1496485', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '22101280944', 'ifHCInUcastPkts' => '410521898', 'ifHCInMulticastPkts' => '1496485', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '14478910698', 'ifHCOutUcastPkts' => '222501225', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '100', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => '', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'eth0.10', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '0:3:27:54:56:92', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '37513', 'ifOutDiscards' => '0', ), 5 => array ( 'ifName' => 'eth0.20', 'ifInMulticastPkts' => '14041587', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '1770768020', 'ifHCInUcastPkts' => '6256975', 'ifHCInMulticastPkts' => '14041587', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '3331154951', 'ifHCOutUcastPkts' => '5772725', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '100', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => '', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'eth0.20', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '1513', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '0:3:27:14:56:92', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '14184020', 'ifOutDiscards' => '0', ), ) valid valid valid valid valid Port lo: lo (1 / #1026427) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed (10) VLAN = Using ifDescr as ifAlias lo ifInOctets (0 B) 0 Bps 188 secs ifOutOctets (0 B) 0 Bps 188 secs ifInErrors (0 B) 0 Bps 188 secs ifOutErrors (0 B) 0 Bps 188 secs ifInUcastPkts (0 B) 0 Bps 188 secs ifOutUcastPkts (0 B) 0 Bps 188 secs ifInNUcastPkts (0 B) 0 Bps 188 secs ifOutNUcastPkts (0 B) 0 Bps 188 secs ifInDiscards (0 B) 0 Bps 188 secs ifOutDiscards (0 B) 0 Bps 188 secs ifInUnknownProtos (0 B) 0 Bps 188 secs ifInBroadcastPkts (0 B) 0 Bps 188 secs ifOutBroadcastPkts (0 B) 0 Bps 188 secs ifInMulticastPkts (0 B) 0 Bps 188 secs ifOutMulticastPkts (0 B) 0 Bps 188 secs bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["7352",7352,0,0,"7352",7352,0,0,"0",0,0,0,"0",0,0,0,"75",75,0,0,"75",75,0,0,1659099633,1659099445,188,1026427][0m 1.24ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,1026427][0m 0.24ms] 1 updated Port eth0: eth0 (2 / #1026428) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed (100) VLAN = Using ifDescr as ifAlias eth0 ifInOctets (1404942 B) 7473.0957446809 Bps 188 secs ifOutOctets (705976 B) 3755.1914893617 Bps 188 secs ifInErrors (0 B) 0 Bps 188 secs ifOutErrors (0 B) 0 Bps 188 secs ifInUcastPkts (19376 B) 103.06382978723 Bps 188 secs ifOutUcastPkts (10102 B) 53.734042553191 Bps 188 secs ifInNUcastPkts (0 B) 0 Bps 188 secs ifOutNUcastPkts (0 B) 0 Bps 188 secs ifInDiscards (0 B) 0 Bps 188 secs ifOutDiscards (0 B) 0 Bps 188 secs ifInUnknownProtos (0 B) 0 Bps 188 secs ifInBroadcastPkts (0 B) 0 Bps 188 secs ifOutBroadcastPkts (0 B) 0 Bps 188 secs ifInMulticastPkts (0 B) 0 Bps 188 secs ifOutMulticastPkts (0 B) 0 Bps 188 secs bps(59.79 kbps/30.04 kbps)bytes(1.34 MiB/689.43 KiB)pkts(103.06 pps/53.73 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1588982902",1587577960,7473.095744680851,1404942,"1543292265",1542586289,3755.191489361702,705976,"0",0,0,0,"0",0,0,0,"432316945",432297569,103.06382978723404,19376,"228273950",228263848,53.734042553191486,10102,1659099633,1659099445,188,1026428][0m 0.82ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,1026428][0m 0.22ms] 1 updated Port usb0: usb0 (3 / #1026429) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed (10) VLAN = Using ifDescr as ifAlias usb01026429 skipped because port is still down since last polling. Port eth0.10: eth0.10 (4 / #1026430) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifHCInMulticastPkts ifOutMulticastPkts ifHighSpeed (100) VLAN = Using ifDescr as ifAlias eth0.10 ifInOctets (997969 B) 5308.3457446809 Bps 188 secs ifOutOctets (653454 B) 3475.8191489362 Bps 188 secs ifInErrors (0 B) 0 Bps 188 secs ifOutErrors (0 B) 0 Bps 188 secs ifInUcastPkts (18537 B) 98.601063829787 Bps 188 secs ifOutUcastPkts (10043 B) 53.420212765957 Bps 188 secs ifInNUcastPkts (0 B) 0 Bps 188 secs ifOutNUcastPkts (0 B) 0 Bps 188 secs ifInDiscards (1 B) 0.0053191489361702 Bps 188 secs ifOutDiscards (0 B) 0 Bps 188 secs ifInUnknownProtos (0 B) 0 Bps 188 secs ifInBroadcastPkts (0 B) 0 Bps 188 secs ifOutBroadcastPkts (0 B) 0 Bps 188 secs ifInMulticastPkts (67 B) 0.3563829787234 Bps 188 secs ifOutMulticastPkts (0 B) 0 Bps 188 secs bps(42.47 kbps/27.81 kbps)bytes(974.58 KiB/638.14 KiB)pkts(98.6 pps/53.42 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["22101280944",22100282975,5308.345744680851,997969,"14478910698",14478257244,3475.81914893617,653454,"0",0,0,0,"0",0,0,0,"410521898",410503361,98.60106382978724,18537,"222501225",222491182,53.420212765957444,10043,1659099633,1659099445,188,1026430][0m 0.66ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"37513",37512,0.005319148936170213,1,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"1496485",1496418,0.35638297872340424,67,"0",0,0,0,1026430][0m 0.55ms] 2 updated Port eth0.20: eth0.20 (5 / #1026431) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifHCInMulticastPkts ifOutMulticastPkts ifHighSpeed (100) VLAN = Using ifDescr as ifAlias eth0.20 ifInOctets (58205 B) 309.60106382979 Bps 188 secs ifOutOctets (12114 B) 64.436170212766 Bps 188 secs ifInErrors (0 B) 0 Bps 188 secs ifOutErrors (0 B) 0 Bps 188 secs ifInUcastPkts (135 B) 0.71808510638298 Bps 188 secs ifOutUcastPkts (59 B) 0.31382978723404 Bps 188 secs ifInNUcastPkts (0 B) 0 Bps 188 secs ifOutNUcastPkts (0 B) 0 Bps 188 secs ifInDiscards (643 B) 3.4202127659574 Bps 188 secs ifOutDiscards (0 B) 0 Bps 188 secs ifInUnknownProtos (0 B) 0 Bps 188 secs ifInBroadcastPkts (0 B) 0 Bps 188 secs ifOutBroadcastPkts (0 B) 0 Bps 188 secs ifInMulticastPkts (637 B) 3.3882978723404 Bps 188 secs ifOutMulticastPkts (0 B) 0 Bps 188 secs bps(2.48 kbps/515 bps)bytes(56.84 KiB/11.83 KiB)pkts(0.72 pps/0.31 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1770768020",1770709815,309.6010638297872,58205,"3331154951",3331142837,64.43617021276596,12114,"0",0,0,0,"0",0,0,0,"6256975",6256840,0.7180851063829787,135,"5772725",5772666,0.31382978723404253,59,1659099633,1659099445,188,1026431][0m 0.91ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"14184020",14183377,3.4202127659574466,643,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"14041587",14040950,3.3882978723404253,637,"0",0,0,0,1026431][0m 0.57ms] 2 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where `port_id` in (1026429) [0;33m[1659099633,1659099445,null][0m 0.47ms] 1 updated >> Runtime for poller module 'ports': 0.2285 seconds with 39136 bytes >> [0;36mSNMP[0m: [14/0.21s] [1;33mMySQL[0m: [10/0.06s] #### Unload poller module ports #### Modules status: Global+ OS Device #### Load poller module customoid #### SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[205][0m 0.32ms] >> Runtime for poller module 'customoid': 0.0006 seconds with 1232 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module customoid #### Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[205][0m 0.3ms] >> Runtime for poller module 'bgp-peers': 0.0016 seconds with 13984 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module bgp-peers #### Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[205][0m 0.21ms] >> Runtime for poller module 'ucd-diskio': 0.0004 seconds with 784 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module ucd-diskio #### Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: coromatic-flexy OS initialized as Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[205][0m 0.27ms] >> Runtime for poller module 'wireless': 0.0012 seconds with 102128 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module wireless #### Modules status: Global+ OS Device #### Load poller module ospf #### SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[205][0m 0.23ms] Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m] ospfGeneralGroup = No Such Object available on this agent at this OID SQL[[1;33mdelete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[205,""][0m 0.2ms] 0 >> Runtime for poller module 'ospf': 0.0176 seconds with 93472 bytes >> [0;36mSNMP[0m: [1/0.02s] [1;33mMySQL[0m: [2/0.00s] #### Unload poller module ospf #### Modules status: Global+ OS Device #### Load poller module isis #### SQL[[1;33mselect * from `isis_adjacencies` where `isis_adjacencies`.`device_id` = ? and `isis_adjacencies`.`device_id` is not null [0;33m[205][0m 0.25ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ISIS-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'isisISAdjState'[0m] isisISAdjState = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'ISIS-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'isisISAdjLastUpTime'[0m] isisISAdjLastUpTime = No Such Object available on this agent at this OID >> Runtime for poller module 'isis': 0.0326 seconds with 75256 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module isis #### Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ slas ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-qfp ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ nac ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global- OS Device Module [ aruba-controller ] disabled globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### >> Runtime for poller module 'entity-physical': 0.0001 seconds with 472 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module entity-physical #### Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [0;33m[205][0m 0.26ms] >> Runtime for poller module 'applications': 0.0008 seconds with 36440 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s] #### Unload poller module applications #### Modules status: Global+ OS Device #### Load poller module stp #### Instances: SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[205][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[205][0m 0.23ms] >> Runtime for poller module 'stp': 0.0014 seconds with 47224 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.00s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ntp #### Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device #### Load poller module mpls #### >> Runtime for poller module 'mpls': 0.0002 seconds with 23456 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module mpls #### Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[205][0m 0.55ms] SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[1.479,205][0m 1.11ms] Updating elv-1-hor-15 Polled in 1.479 seconds ### Start Device Groups ### SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.15ms] 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) [0;33m[][0m 0.49ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` REGEXP ? AND `devices`.`community` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["ASR-920","bi80jen",205][0m 0.27ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ? OR `devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0m540%","[0mCS-540%",205][0m 0.22ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%ASR9K%",205][0m 0.2ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["WS-C4506-E",205][0m 0.21ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysObjectID` = ? OR `devices`.`sysObjectID` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m[".1.3.6.1.4.1.9303.1.5.65",".1.3.6.1.4.1.9303.1.5.124",205][0m 0.2ms] SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["flk%",205][0m 0.21ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[205][0m 0.24ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0094s ### #### 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[205][0m 0.27ms] SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2022-07-29T13:00:33.166019Z","2022-07-29T13:00:33.166019Z",0,1,"13:00:33","13:00:33","13:00:33","13:00:33","[45m%","device",205,"location",96][0m 0.51ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[205][0m 0.33ms] 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 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) OR (a.invert_map = 0 AND (d.device_id=? OR dg.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)) ) [0;33m[205,205,205,205,205,205,205,205][0m 0.84ms] Rule [0;35m#1 (Cisco PSU status failed):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current = 8 AND sensors.sensor_oid = ".1.3.6.1.4.1.9.9.13.1.5.1.3" [0;33m[205][0m 0.38ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,205][0m 0.21ms] Status: [0;34mNOCHG[0m Rule [0;35m#2 (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[205][0m 0.55ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,205][0m 0.27ms] Status: [0;34mNOCHG[0m #### End Alerts #### ./poller.php elv-1-hor-15 2022-07-29 15:00:33 - 1 devices polled in 1.659 secs [0;36mSNMP[0m [28/0.38s]: Snmpget[11/0.11s] Snmpwalk[17/0.27s] [1;33mSQL[0m [68/0.27s]: Select[50/0.17s] Insert[1/0.01s] Update[16/0.09s] Delete[1/0.00s]