- LibreNMS Poller
- ===================================
- Version info:
- Commit SHA: 34a55470fc29f1c709b59cab5675de5eea3b308c
- Commit Date: 1493226483
- DB Schema: 186
- PHP: 7.0.17
- MySQL: 5.5.52-MariaDB
- RRDTool: 1.4.8
- SNMP: NET-SNMP 5.7.2
- ==================================DEBUG!
- Starting polling run:
- SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'nb-clearpass2.nbisd.edu' ORDER BY `device_id` ASC]
- SQL[SELECT * FROM devices_attribs WHERE `device_id` = '277']
- Hostname: nb-clearpass2.nbisd.edu
- Device ID: 277
- OS: linux (unix)
- SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','0.16','0.22','0.18','277',NOW())]
- SNMP Check response code: 0
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0]
- sysUpTime.0 = 1043559
- sysLocation.0 = Unknown
- sysContact.0 = root@localhost
- sysName.0 = NB-CLEARPASS2
- sysObjectID.0 = enterprises.8*
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 sysDescr.0]
- ClearPass Policy Manager *381, Model: CP-HW-5K, FIPS Mode: Disabled, High Capacity Guest Mode: Disabled
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
- snmpEngineTime.0 = No Such Object available on this agent at this OID
- hrSystemUptime.0 = 1343983
- Using hrSystemUptime (13439s)
- RRD[update nb-clearpass2.nbisd.edu/uptime.rrd N:13439 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Uptime: 3h 43m 59s
- SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`='430 West Mill St New Branufles, TX 78130' LIMIT 1]
- Using cached lat/lng from other device
- Modules status: Global- OS Device Module [ unix-agent ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module os ####
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m NET-SNMP-EXTEND-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 .1.3.6.1.4.1.8072.1.3.2.3.1.1.6.100.105.115.116.114.111]
- No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.1.3.1.1.6.100.105.115.116.114.111]
- No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.1.101.1]
- No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m MIB-Dell-10892 -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 .1.3.6.1.4.1.674.10892.1.300.10.1.9.1]
- No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m CPQSINFO-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/hp udp:HOSTNAME:161 cpqSiProductName.0]
- No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.2.4.1.2.8.104.97.114.100.119.97.114.101.1]
- No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.3.4.1.2.12.109.97.110.117.102.97.99.116.117.114.101.114.1]
- No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m MIB-Dell-10892 -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 .1.3.6.1.4.1.674.10892.1.300.10.1.11.1]
- No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.4.4.1.2.6.115.101.114.105.97.108.1]
- No Such Object available on this agent at this OID
- Hardware:
- Version: Manager
- Features:
- Serial:
- >> Runtime for poller module 'os': 0.2317 seconds with 3840 bytes
- #### Unload poller module os ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-os.rrd N:0.23170495033264 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ipmi ####
- SQL[SELECT * FROM sensors WHERE device_id = '277' AND poller_type='ipmi']
- Array
- (
- )
- >> Runtime for poller module 'ipmi': 0.0007 seconds with 6952 bytes
- #### Unload poller module ipmi ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-ipmi.rrd N:0.00073981285095215 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module sensors ####
- SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = '277' GROUP BY `sensor_class`]
- >> Runtime for poller module 'sensors': 0.0005 seconds with 208 bytes
- #### Unload poller module sensors ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-sensors.rrd N:0.00045585632324219 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module processors ####
- SQL[SELECT * FROM processors WHERE device_id = '277']
- >> Runtime for poller module 'processors': 0.0004 seconds with 600 bytes
- #### Unload poller module processors ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-processors.rrd N:0.00036478042602539 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module mempools ####
- SQL[SELECT * FROM mempools WHERE device_id = '277']
- >> Runtime for poller module 'mempools': 0.0004 seconds with 600 bytes
- #### Unload poller module mempools ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-mempools.rrd N:0.00043606758117676 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module storage ####
- SQL[SELECT * FROM storage WHERE device_id = '277']
- Storage Swap space: hrstorage
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 hrStorageEntry]
- hrStorageDescr.10 = Swap space
- hrStorageDescr.31 = /
- hrStorageAllocationUnits.10 = 1024
- hrStorageAllocationUnits.31 = 4096
- hrStorageSize.10 = 6143996
- hrStorageSize.31 = 118669090
- hrStorageUsed.10 = 64
- hrStorageUsed.31 = 10410418
- Array
- (
- [hrstorage] => Array
- (
- [10] => Array
- (
- [hrStorageDescr] => Swap space
- [hrStorageAllocationUnits] => 1024
- [hrStorageSize] => 6143996
- [hrStorageUsed] => 64
- )
- [31] => Array
- (
- [hrStorageDescr] => /
- [hrStorageAllocationUnits] => 4096
- [hrStorageSize] => 118669090
- [hrStorageUsed] => 10410418
- )
- )
- )
- Array
- (
- [storage_id] => 154
- [device_id] => 277
- [storage_mib] => hrstorage
- [storage_index] => 10
- [storage_type] =>
- [storage_descr] => Swap space
- [storage_size] => 6291451904
- [storage_units] => 1024
- [storage_used] => 65536
- [storage_free] => 6291386368
- [storage_perc] => 0
- [storage_perc_warn] => 60
- [storage_deleted] => 0
- [units] => 1024
- [used] => 65536
- [size] => 6291451904
- [free] => 6291386368
- )
- 0% RRD[update nb-clearpass2.nbisd.edu/storage-hrstorage-Swap_space.rrd N:65536:6291386368 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]SQL[UPDATE `storage` set `storage_used` ='65536',`storage_free` ='6291386368',`storage_size` ='6291451904',`storage_units` ='1024',`storage_perc` ='0' WHERE `storage_id` = '154']
- Storage /: hrstorage
- Array
- (
- [storage_id] => 155
- [device_id] => 277
- [storage_mib] => hrstorage
- [storage_index] => 31
- [storage_type] =>
- [storage_descr] => /
- [storage_size] => 486068592640
- [storage_units] => 4096
- [storage_used] => 42640818176
- [storage_free] => 443427774464
- [storage_perc] => 9
- [storage_perc_warn] => 60
- [storage_deleted] => 0
- [units] => 4096
- [used] => 42641072128
- [size] => 486068592640
- [free] => 443427520512
- )
- 9% RRD[update nb-clearpass2.nbisd.edu/storage-hrstorage-_.rrd N:42641072128:443427520512 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]SQL[UPDATE `storage` set `storage_used` ='42641072128',`storage_free` ='443427520512',`storage_size` ='486068592640',`storage_units` ='4096',`storage_perc` ='9' WHERE `storage_id` = '155']
- >> Runtime for poller module 'storage': 0.0424 seconds with 6352 bytes
- #### Unload poller module storage ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-storage.rrd N:0.042396068572998 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module netstats ####
- IPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro 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]
- ipForwDatagrams.0 = No Such Object available on this agent at this OID
- ipInDelivers.0 = No Such Object available on this agent at this OID
- ipInReceives.0 = No Such Object available on this agent at this OID
- ipOutRequests.0 = No Such Object available on this agent at this OID
- ipInDiscards.0 = No Such Object available on this agent at this OID
- ipOutDiscards.0 = No Such Object available on this agent at this OID
- ipOutNoRoutes.0 = No Such Object available on this agent at this OID
- ipReasmReqds.0 = No Such Object available on this agent at this OID
- ipReasmOKs.0 = No Such Object available on this agent at this OID
- ipReasmFails.0 = No Such Object available on this agent at this OID
- ipFragOKs.0 = No Such Object available on this agent at this OID
- ipFragFails.0 = No Such Object available on this agent at this OID
- ipFragCreates.0 = No Such Object available on this agent at this OID
- ipInUnknownProtos.0 = No Such Object available on this agent at this OID
- ipInHdrErrors.0 = No Such Object available on this agent at this OID
- ipInAddrErrors.0 = No Such Object available on this agent at this OID
- TCPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro 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 tcpHCInSegs.0 tcpHCOutSegs.0]
- tcpActiveOpens.0 = No Such Object available on this agent at this OID
- tcpPassiveOpens.0 = No Such Object available on this agent at this OID
- tcpAttemptFails.0 = No Such Object available on this agent at this OID
- tcpEstabResets.0 = No Such Object available on this agent at this OID
- tcpCurrEstab.0 = No Such Object available on this agent at this OID
- tcpInSegs.0 = No Such Object available on this agent at this OID
- tcpOutSegs.0 = No Such Object available on this agent at this OID
- tcpRetransSegs.0 = No Such Object available on this agent at this OID
- tcpInErrs.0 = No Such Object available on this agent at this OID
- tcpOutRsts.0 = No Such Object available on this agent at this OID
- tcpHCInSegs.0 = No Such Object available on this agent at this OID
- tcpHCOutSegs.0 = No Such Object available on this agent at this OID
- UDPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0]
- udpInDatagrams.0 = No Such Object available on this agent at this OID
- udpOutDatagrams.0 = No Such Object available on this agent at this OID
- udpInErrors.0 = No Such Object available on this agent at this OID
- udpNoPorts.0 = No Such Object available on this agent at this OID
- ICMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 icmp]
- icmp = No Such Object available on this agent at this OID
- SNMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m SNMPv2-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 snmp]
- snmp = No Such Object available on this agent at this OID
- IP-FORWARDSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 IP-FORWARD-MIB::ipCidrRouteNumber.0]
- No Such Object available on this agent at this OID
- >> Runtime for poller module 'netstats': 0.1361 seconds with 12456 bytes
- #### Unload poller module netstats ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-netstats.rrd N:0.13605308532715 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module hr-mib ####
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 hrSystemProcesses.0 hrSystemNumUsers.0]
- hrSystemProcesses.0 = 302
- hrSystemNumUsers.0 = 0
- RRD[update nb-clearpass2.nbisd.edu/hr_processes.rrd N:302 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled] ProcessesRRD[update nb-clearpass2.nbisd.edu/hr_users.rrd N:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled] Users
- >> Runtime for poller module 'hr-mib': 0.0203 seconds with 2104 bytes
- #### Unload poller module hr-mib ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-hr-mib.rrd N:0.020311117172241 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ucd-mib ####
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 systemStats]
- ssCpuRawUser.0 = 541147
- ssCpuRawNice.0 = 0
- ssCpuRawSystem.0 = 86051
- ssCpuRawIdle.0 = 9674193
- RRD[update nb-clearpass2.nbisd.edu/ucd_cpu.rrd N:541147:86051:0:9674193 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]RRD[update nb-clearpass2.nbisd.edu/ucd_ssCpuRawUser.rrd N:541147 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]RRD[update nb-clearpass2.nbisd.edu/ucd_ssCpuRawNice.rrd N:0 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]RRD[update nb-clearpass2.nbisd.edu/ucd_ssCpuRawSystem.rrd N:86051 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]RRD[update nb-clearpass2.nbisd.edu/ucd_ssCpuRawIdle.rrd N:9674193 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 memTotalSwap.0 memAvailSwap.0 memTotalReal.0 memAvailReal.0 memTotalFree.0 memShared.0 memBuffer.0 memCached.0]
- memTotalSwap.0 = 6143996
- memAvailSwap.0 = 6143932
- memTotalReal.0 = 7981336
- memAvailReal.0 = 282376
- memTotalFree.0 = No Such Object available on this agent at this OID
- memShared.0 = No Such Object available on this agent at this OID
- memBuffer.0 = 14656
- memCached.0 = 3895012
- SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 laLoadInt.1 laLoadInt.2 laLoadInt.3]
- laLoadInt.1 = 20
- laLoadInt.2 = 32
- laLoadInt.3 = 47
- RRD[update nb-clearpass2.nbisd.edu/ucd_load.rrd N:20:32:47 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]
- >> Runtime for poller module 'ucd-mib': 0.0730 seconds with 2968 bytes
- #### Unload poller module ucd-mib ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-ucd-mib.rrd N:0.07296895980835 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ipSystemStats ####
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 ipSystemStats]
- ipSystemStatsTable = No Such Object available on this agent at this OID
- >> Runtime for poller module 'ipSystemStats': 0.0250 seconds with 760 bytes
- #### Unload poller module ipSystemStats ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-ipSystemStats.rrd N:0.025020122528076 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module ports ####
- Caching Oids: SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 ifXEntry]
- ifXEntry = No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 ifEntry]
- ifIndex.1 = 1
- ifIndex.2 = 2
- ifIndex.3 = 3
- ifDescr.1 = lo
- ifDescr.2 = eth0
- ifDescr.3 = eth1
- ifType.1 = softwareLoopback
- ifType.2 = ethernetCsmacd
- ifType.3 = ethernetCsmacd
- ifMtu.1 = 65536
- ifMtu.2 = 1500
- ifMtu.3 = 1500
- ifSpeed.1 = 10000000
- ifSpeed.2 = 1000000000
- ifSpeed.3 = 0
- ifPhysAddress.1 =
- ifPhysAddress.2 = f8:db:88:fd:11:44
- ifPhysAddress.3 = f8:db:88:fd:11:45
- ifAdminStatus.1 = up
- ifAdminStatus.2 = up
- ifAdminStatus.3 = up
- ifOperStatus.1 = up
- ifOperStatus.2 = up
- ifOperStatus.3 = down
- dot3StatsDuplexStatusSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 dot3StatsIndex]
- dot3StatsIndex = No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 dot3StatsDuplexStatus]
- dot3StatsDuplexStatus = No Such Object available on this agent at this OID
- SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '277' AND `ifType` = 'adsl']
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m POWER-ETHERNET-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 pethPsePortEntry]
- pethPsePortEntry = No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m CISCO-POWER-ETHERNET-EXT-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 cpeExtPsePortEntry]
- cpeExtPsePortEntry = No Such Object available on this agent at this OID
- SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro udp:HOSTNAME:161 dot1qPvid]
- dot1qPvid = No Such Object available on this agent at this OID
- Array
- (
- [1] => Array
- (
- [ifIndex] => 1
- [ifDescr] => lo
- [ifType] => softwareLoopback
- [ifMtu] => 65536
- [ifSpeed] => 10000000
- [ifPhysAddress] =>
- [ifAdminStatus] => up
- [ifOperStatus] => up
- )
- [2] => Array
- (
- [ifIndex] => 2
- [ifDescr] => eth0
- [ifType] => ethernetCsmacd
- [ifMtu] => 1500
- [ifSpeed] => 1000000000
- [ifPhysAddress] => f8:db:88:fd:11:44
- [ifAdminStatus] => up
- [ifOperStatus] => up
- )
- [3] => Array
- (
- [ifIndex] => 3
- [ifDescr] => eth1
- [ifType] => ethernetCsmacd
- [ifMtu] => 1500
- [ifSpeed] => 0
- [ifPhysAddress] => f8:db:88:fd:11:45
- [ifAdminStatus] => up
- [ifOperStatus] => down
- )
- )
- SQL[SELECT `name` FROM `port_association_mode` WHERE pom_id = '1']
- SQL[SELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = '277' ORDER BY ports.port_id]
- validvalidvalid
- Port lo: lo (1 / #12818) HC ifSpeed VLAN == Using ifDescr as ifAliasUsing ifDescr as ifNamelo
- ifInOctets (0 B) 0 Bps 113 secs
- ifOutOctets (0 B) 0 Bps 113 secs
- ifInErrors (0 B) 0 Bps 113 secs
- ifOutErrors (0 B) 0 Bps 113 secs
- ifInUcastPkts (0 B) 0 Bps 113 secs
- ifOutUcastPkts (0 B) 0 Bps 113 secs
- ifInNUcastPkts (0 B) 0 Bps 113 secs
- ifOutNUcastPkts (0 B) 0 Bps 113 secs
- ifInDiscards (0 B) 0 Bps 113 secs
- ifOutDiscards (0 B) 0 Bps 113 secs
- ifInUnknownProtos (0 B) 0 Bps 113 secs
- ifInBroadcastPkts (0 B) 0 Bps 113 secs
- ifOutBroadcastPkts (0 B) 0 Bps 113 secs
- ifInMulticastPkts (0 B) 0 Bps 113 secs
- ifOutMulticastPkts (0 B) 0 Bps 113 secs
- bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[update nb-clearpass2.nbisd.edu/port-id12818.rrd N:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]SQL[UPDATE `ports` set `poll_time` ='1493249243',`poll_prev` ='1493249130',`poll_period` ='113',`ifInOctets` ='0',`ifInOctets_prev` ='0',`ifInOctets_rate` ='0',`ifInOctets_delta` ='0',`ifOutOctets` ='0',`ifOutOctets_prev` ='0',`ifOutOctets_rate` ='0',`ifOutOctets_delta` ='0',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='0',`ifInUcastPkts_prev` ='0',`ifInUcastPkts_rate` ='0',`ifInUcastPkts_delta` ='0',`ifOutUcastPkts` ='0',`ifOutUcastPkts_prev` ='0',`ifOutUcastPkts_rate` ='0',`ifOutUcastPkts_delta` ='0' WHERE `port_id` = '12818']
- SQL[UPDATE `ports_statistics` set `ifInNUcastPkts` ='0',`ifInNUcastPkts_prev` ='0',`ifInNUcastPkts_rate` ='0',`ifInNUcastPkts_delta` ='0',`ifOutNUcastPkts` ='0',`ifOutNUcastPkts_prev` ='0',`ifOutNUcastPkts_rate` ='0',`ifOutNUcastPkts_delta` ='0',`ifInDiscards` ='0',`ifInDiscards_prev` ='0',`ifInDiscards_rate` ='0',`ifInDiscards_delta` ='0',`ifOutDiscards` ='0',`ifOutDiscards_prev` ='0',`ifOutDiscards_rate` ='0',`ifOutDiscards_delta` ='0',`ifInUnknownProtos` ='0',`ifInUnknownProtos_prev` ='0',`ifInUnknownProtos_rate` ='0',`ifInUnknownProtos_delta` ='0',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_prev` ='0',`ifInBroadcastPkts_rate` ='0',`ifInBroadcastPkts_delta` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_prev` ='0',`ifOutBroadcastPkts_rate` ='0',`ifOutBroadcastPkts_delta` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_prev` ='0',`ifInMulticastPkts_rate` ='0',`ifInMulticastPkts_delta` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_prev` ='0',`ifOutMulticastPkts_rate` ='0',`ifOutMulticastPkts
- _delta` ='0' WHERE `port_id` = '12818']
- 1 updated
- Port eth0: eth0 (2 / #12819) HC ifSpeed VLAN == Using ifDescr as ifAliasUsing ifDescr as ifNameeth0
- ifInOctets (0 B) 0 Bps 113 secs
- ifOutOctets (0 B) 0 Bps 113 secs
- ifInErrors (0 B) 0 Bps 113 secs
- ifOutErrors (0 B) 0 Bps 113 secs
- ifInUcastPkts (0 B) 0 Bps 113 secs
- ifOutUcastPkts (0 B) 0 Bps 113 secs
- ifInNUcastPkts (0 B) 0 Bps 113 secs
- ifOutNUcastPkts (0 B) 0 Bps 113 secs
- ifInDiscards (0 B) 0 Bps 113 secs
- ifOutDiscards (0 B) 0 Bps 113 secs
- ifInUnknownProtos (0 B) 0 Bps 113 secs
- ifInBroadcastPkts (0 B) 0 Bps 113 secs
- ifOutBroadcastPkts (0 B) 0 Bps 113 secs
- ifInMulticastPkts (0 B) 0 Bps 113 secs
- ifOutMulticastPkts (0 B) 0 Bps 113 secs
- bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[update nb-clearpass2.nbisd.edu/port-id12819.rrd N:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]SQL[UPDATE `ports` set `poll_time` ='1493249243',`poll_prev` ='1493249130',`poll_period` ='113',`ifInOctets` ='0',`ifInOctets_prev` ='0',`ifInOctets_rate` ='0',`ifInOctets_delta` ='0',`ifOutOctets` ='0',`ifOutOctets_prev` ='0',`ifOutOctets_rate` ='0',`ifOutOctets_delta` ='0',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='0',`ifInUcastPkts_prev` ='0',`ifInUcastPkts_rate` ='0',`ifInUcastPkts_delta` ='0',`ifOutUcastPkts` ='0',`ifOutUcastPkts_prev` ='0',`ifOutUcastPkts_rate` ='0',`ifOutUcastPkts_delta` ='0' WHERE `port_id` = '12819']
- SQL[UPDATE `ports_statistics` set `ifInNUcastPkts` ='0',`ifInNUcastPkts_prev` ='0',`ifInNUcastPkts_rate` ='0',`ifInNUcastPkts_delta` ='0',`ifOutNUcastPkts` ='0',`ifOutNUcastPkts_prev` ='0',`ifOutNUcastPkts_rate` ='0',`ifOutNUcastPkts_delta` ='0',`ifInDiscards` ='0',`ifInDiscards_prev` ='0',`ifInDiscards_rate` ='0',`ifInDiscards_delta` ='0',`ifOutDiscards` ='0',`ifOutDiscards_prev` ='0',`ifOutDiscards_rate` ='0',`ifOutDiscards_delta` ='0',`ifInUnknownProtos` ='0',`ifInUnknownProtos_prev` ='0',`ifInUnknownProtos_rate` ='0',`ifInUnknownProtos_delta` ='0',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_prev` ='0',`ifInBroadcastPkts_rate` ='0',`ifInBroadcastPkts_delta` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_prev` ='0',`ifOutBroadcastPkts_rate` ='0',`ifOutBroadcastPkts_delta` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_prev` ='0',`ifInMulticastPkts_rate` ='0',`ifInMulticastPkts_delta` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_prev` ='0',`ifOutMulticastPkts_rate` ='0',`ifOutMulticastPkts
- _delta` ='0' WHERE `port_id` = '12819']
- 1 updated
- Port eth1: eth1 (3 / #12820) HC ifSpeed VLAN == Using ifDescr as ifAliasUsing ifDescr as ifNameeth1
- ifInOctets (0 B) 0 Bps 113 secs
- ifOutOctets (0 B) 0 Bps 113 secs
- ifInErrors (0 B) 0 Bps 113 secs
- ifOutErrors (0 B) 0 Bps 113 secs
- ifInUcastPkts (0 B) 0 Bps 113 secs
- ifOutUcastPkts (0 B) 0 Bps 113 secs
- ifInNUcastPkts (0 B) 0 Bps 113 secs
- ifOutNUcastPkts (0 B) 0 Bps 113 secs
- ifInDiscards (0 B) 0 Bps 113 secs
- ifOutDiscards (0 B) 0 Bps 113 secs
- ifInUnknownProtos (0 B) 0 Bps 113 secs
- ifInBroadcastPkts (0 B) 0 Bps 113 secs
- ifOutBroadcastPkts (0 B) 0 Bps 113 secs
- ifInMulticastPkts (0 B) 0 Bps 113 secs
- ifOutMulticastPkts (0 B) 0 Bps 113 secs
- bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[update nb-clearpass2.nbisd.edu/port-id12820.rrd N:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]SQL[UPDATE `ports` set `poll_time` ='1493249243',`poll_prev` ='1493249130',`poll_period` ='113',`ifInOctets` ='0',`ifInOctets_prev` ='0',`ifInOctets_rate` ='0',`ifInOctets_delta` ='0',`ifOutOctets` ='0',`ifOutOctets_prev` ='0',`ifOutOctets_rate` ='0',`ifOutOctets_delta` ='0',`ifInErrors` ='0',`ifInErrors_prev` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_prev` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='0',`ifInUcastPkts_prev` ='0',`ifInUcastPkts_rate` ='0',`ifInUcastPkts_delta` ='0',`ifOutUcastPkts` ='0',`ifOutUcastPkts_prev` ='0',`ifOutUcastPkts_rate` ='0',`ifOutUcastPkts_delta` ='0' WHERE `port_id` = '12820']
- SQL[UPDATE `ports_statistics` set `ifInNUcastPkts` ='0',`ifInNUcastPkts_prev` ='0',`ifInNUcastPkts_rate` ='0',`ifInNUcastPkts_delta` ='0',`ifOutNUcastPkts` ='0',`ifOutNUcastPkts_prev` ='0',`ifOutNUcastPkts_rate` ='0',`ifOutNUcastPkts_delta` ='0',`ifInDiscards` ='0',`ifInDiscards_prev` ='0',`ifInDiscards_rate` ='0',`ifInDiscards_delta` ='0',`ifOutDiscards` ='0',`ifOutDiscards_prev` ='0',`ifOutDiscards_rate` ='0',`ifOutDiscards_delta` ='0',`ifInUnknownProtos` ='0',`ifInUnknownProtos_prev` ='0',`ifInUnknownProtos_rate` ='0',`ifInUnknownProtos_delta` ='0',`ifInBroadcastPkts` ='0',`ifInBroadcastPkts_prev` ='0',`ifInBroadcastPkts_rate` ='0',`ifInBroadcastPkts_delta` ='0',`ifOutBroadcastPkts` ='0',`ifOutBroadcastPkts_prev` ='0',`ifOutBroadcastPkts_rate` ='0',`ifOutBroadcastPkts_delta` ='0',`ifInMulticastPkts` ='0',`ifInMulticastPkts_prev` ='0',`ifInMulticastPkts_rate` ='0',`ifInMulticastPkts_delta` ='0',`ifOutMulticastPkts` ='0',`ifOutMulticastPkts_prev` ='0',`ifOutMulticastPkts_rate` ='0',`ifOutMulticastPkts
- _delta` ='0' WHERE `port_id` = '12820']
- 1 updated
- >> Runtime for poller module 'ports': 0.2187 seconds with 36568 bytes
- #### Unload poller module ports ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-ports.rrd N:0.21869087219238 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS- Device Module [ bgp-peers ] disabled on os.
- Modules status: Global+ OS Device
- #### Load poller module junose-atm-vp ####
- SQL[SELECT * FROM `ports` AS P, `juniAtmVp` AS J WHERE P.`device_id` = '277' AND J.port_id = P.port_id]
- >> Runtime for poller module 'junose-atm-vp': 0.0006 seconds with 168 bytes
- #### Unload poller module junose-atm-vp ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-junose-atm-vp.rrd N:0.00060892105102539 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global- OS Device Module [ toner ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module ucd-diskio ####
- SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '277']
- >> Runtime for poller module 'ucd-diskio': 0.0004 seconds with 680 bytes
- #### Unload poller module ucd-diskio ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-ucd-diskio.rrd N:0.00038790702819824 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module wifi ####
- Unsupported type: server
- >> Runtime for poller module 'wifi': 0.0002 seconds with 3608 bytes
- #### Unload poller module wifi ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-wifi.rrd N:0.00023102760314941 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global- OS- Device Module [ ospf ] disabled on os.
- 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 [ cisco-sla ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module cipsec-tunnels ####
- >> Runtime for poller module 'cipsec-tunnels': 0.0002 seconds with 1752 bytes
- #### Unload poller module cipsec-tunnels ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-cipsec-tunnels.rrd N:0.00021004676818848 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]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-vpdn ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module netscaler-vsvr ####
- >> Runtime for poller module 'netscaler-vsvr': 0.0002 seconds with 1592 bytes
- #### Unload poller module netscaler-vsvr ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-netscaler-vsvr.rrd N:0.00018787384033203 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module aruba-controller ####
- >> Runtime for poller module 'aruba-controller': 0.0003 seconds with 2784 bytes
- #### Unload poller module aruba-controller ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-aruba-controller.rrd N:0.00029993057250977 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module entity-physical ####
- SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = '277']
- >> Runtime for poller module 'entity-physical': 0.0005 seconds with 976 bytes
- #### Unload poller module entity-physical ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-entity-physical.rrd N:0.00047087669372559 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module applications ####
- SQL[SELECT * FROM `applications` WHERE `device_id` = '277']
- >> Runtime for poller module 'applications': 0.0003 seconds with 368 bytes
- #### Unload poller module applications ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-applications.rrd N:0.00028300285339355 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global- OS Device Module [ mib ] disabled globally.
- Modules status: Global+ OS- Device Module [ stp ] disabled on os.
- Modules status: Global+ OS Device
- #### Load poller module ntp ####
- >> Runtime for poller module 'ntp': 0.0000 seconds with 192 bytes
- #### Unload poller module ntp ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-ntp.rrd N:4.5061111450195E-5 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global+ OS Device
- #### Load poller module services ####
- >> Runtime for poller module 'services': 0.0000 seconds with 104 bytes
- #### Unload poller module services ####
- RRD[update nb-clearpass2.nbisd.edu/poller-perf-services.rrd N:2.6941299438477E-5 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Modules status: Global- OS Device Module [ loadbalancers ] disabled globally.
- Modules status: Global- OS Device Module [ mef ] disabled globally.
- Modules status: Global- OS Device Module [ tnms-nbi ] disabled globally.
- ### Start Device Groups ###
- SQL[SELECT * FROM device_groups ORDER BY name]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "cle" && devices.sysName REGEXP "cles" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "cses" && devices.sysName REGEXP "cse" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "ec" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "kres" && devices.sysName REGEXP "kre" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "lc" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "les" && devices.hostname REGEXP "les" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "lse" && devices.hostname REGEXP "lse" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "mes" && devices.sysName REGEXP "me" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "nbhs" && devices.sysName REGEXP "hs" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "nbms" && devices.sysName REGEXP "ms" && devices.sysName REGEXP "new" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "ngc" && devices.sysName REGEXP "ng" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "orms" && devices.sysName REGEXP "or" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "ses" && devices.sysName REGEXP "se" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "ss" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "trans" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.os = "vmware" ) LIMIT 1]
- SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id='277' AND (devices.sysName REGEXP "wses" && devices.sysName REGEXP "wse" ) LIMIT 1]
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='277']
- Groups Added:
- Groups Removed:
- ### End Device Groups ###
- SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '277']
- uptime hr_processes hr_users ucd_cpu ucd_load RRD[update nb-clearpass2.nbisd.edu/poller-perf.rrd N:1.271 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]RRD[update nb-clearpass2.nbisd.edu/ping-perf.rrd N:0.18 --daemon unix:/var/run/rrdcached/rrdcached.sock]
- [RRD Disabled]Polled in 1.271 seconds
- Updating nb-clearpass2.nbisd.edu
- SQL[UPDATE `devices` set `uptime` ='13439',`last_ping` =NOW(),`last_ping_timetaken` ='0.18',`last_polled` =NOW(),`last_polled_timetaken` ='1.271' WHERE `device_id` = '277']
- UPDATED!
- #### Start Alerts ####
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='277']
- SQL[SELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '277' || alert_schedule_items.target = 'g13' ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '--%d') AND (end_recurring_dt >= date_format(NOW(), '--%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), ''),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1]
- SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='277']
- SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE alert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = '277' ) || alert_map.target = '277' || alert_map.target = 'g13' )]
- Rule #1 (Device Down):
- SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '277') && ( ( ( devices.status = 0 && ( ( devices.disabled = 0 && devices.ignore = 0 ) ) ) ) = "1" )]
- Status: NOCHG
- Rule #2 (Device has been rebooted):
- SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices WHERE (devices.device_id = '277') && (devices.uptime < "300" && ( ( devices.disabled = 0 && devices.ignore = 0 ) ) = "1" )]
- Status: NOCHG
- Rule #3 (BGP Session down):
- SQL[SELECT state FROM alerts WHERE rule_id = '3' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '277') && (bgpPeers.bgpPeerState != "established" && ( ( devices.status = 1 && ( ( devices.disabled = 0 && devices.ignore = 0 ) ) ) ) = "1")]
- Status: NOCHG
- Rule #4 (BGP Session established):
- SQL[SELECT state FROM alerts WHERE rule_id = '4' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '277') && (bgpPeers.bgpPeerFsmEstablishedTime < "300" && bgpPeers.bgpPeerState = "established" && ( ( devices.status = 1 && ( ( devices.disabled = 0 && devices.ignore = 0 ) ) ) ) = "1")]
- Status: NOCHG
- Rule #6 (Port utilisation over threshold):
- SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM ports WHERE (ports.device_id = '277') && ( ( ( ( ports.ifInOctets_rate*8 ) / ports.ifSpeed ) *100 ) >= "80" && ( ( ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && ( ( ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0 ) ) ) ) = "1" && ( ( ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0 ) ) = "1" )]
- Status: NOCHG
- Rule #7 (Sensor over limit):
- SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '277') && (sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = "1" && ( ( devices.status = 1 && ( ( devices.disabled = 0 && devices.ignore = 0 ) ) ) ) = "1" )]
- Status: NOCHG
- Rule #8 (Sensor under limit):
- SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM sensors,devices WHERE (( devices.device_id = sensors.device_id ) && sensors.device_id = '277') && (sensors.sensor_current < sensors sensors.sensor_alert = "1" xss=removed xss=removed xss=removed rule_id = '9' device_id = '277' xss=removed services.device_id = '277' xss=removed xss=removed xss=removed rule_id = '10' device_id = '277' xss=removed devices.device_id = '277' xss=removed xss=removed xss=removed xss=removed>= "90" )]
- Status: NOCHG
- Rule #20 (Storage at Warning Level):
- SQL[SELECT state FROM alerts WHERE rule_id = '20' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM devices,storage WHERE (( storage.device_id = devices.device_id ) && devices.device_id = '277') && (devices.type = "server" && storage.storage_descr NOT REGEXP "/boot" && storage.storage_perc > storage.storage_perc_warn )]
- Status: NOCHG
- Rule #21 (Syslog, authentication failure during the last 5m):
- SQL[SELECT state FROM alerts WHERE rule_id = '21' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM syslog WHERE (syslog.device_id = '277') && (syslog.timestamp > = ( DATE_SUB( NOW() ,INTERVAL 5 MINUTE ) ) && syslog.msg REGEXP ".*authentication failure.*" )]
- Status: NOCHG
- Rule #32 (Device Memory usage high):
- SQL[SELECT state FROM alerts WHERE rule_id = '32' && device_id = '277' ORDER BY id DESC LIMIT 1]
- SQL[SELECT * FROM mempools WHERE (mempools.device_id = '277') && (mempools.mempool_perc >= "90" && mempools.mempool_descr = "Virtual memory" )]
- Status: NOCHG
- #### End Alerts ####
- SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','nb-clearpass2.nbisd.edu','1493249241.824','1.322','1','nms.nbisd.edu\n')]
- /opt/librenms/poller.php nb-clearpass2.nbisd.edu 2017-04-26 18:27:23 - 1 devices polled in 1.322 secs
- SNMP: Get[20/0.47s] Walk [12/0.28s]
- MySQL: Cell[21/0.01s] Row[14/0.00s] Rows[29/0.01s] Column[3/0.00s] Update[9/0.09s] Insert[2/0.02s] Delete[0/0.00s]