##### Module Start: sla ##### SQL[SELECT * FROM `slas` WHERE `device_id` = '458' AND `deleted` = 0;] SQL RUNTIME[0.00050807s] o MIBs CISCO-RTTMON-MIB CMD[/usr/bin/snmpbulkwalk -t '5' -r '3' -v2c -c *** -Pu -OQUs -m CISCO-RTTMON-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'rtr-123.lab.cdc.local':'161' rttMonLatestRttOperEntry] CMD EXITCODE[0] CMD RUNTIME[0.5045s] STDOUT[ rttMonLatestRttOperCompletionTime.122 = 2 rttMonLatestRttOperCompletionTime.200 = 9 rttMonLatestRttOperCompletionTime.201 = 31 rttMonLatestRttOperCompletionTime.202 = 28 rttMonLatestRttOperCompletionTime.203 = 46 rttMonLatestRttOperCompletionTime.204 = 37 rttMonLatestRttOperCompletionTime.205 = 41 rttMonLatestRttOperCompletionTime.206 = 50 rttMonLatestRttOperCompletionTime.207 = 46 rttMonLatestRttOperCompletionTime.211 = 1 rttMonLatestRttOperCompletionTime.250 = 1 rttMonLatestRttOperCompletionTime.251 = 6 rttMonLatestRttOperCompletionTime.252 = 19 rttMonLatestRttOperCompletionTime.253 = 1 rttMonLatestRttOperCompletionTime.254 = 24 rttMonLatestRttOperCompletionTime.255 = 14 rttMonLatestRttOperCompletionTime.256 = 9 rttMonLatestRttOperCompletionTime.257 = 11 rttMonLatestRttOperSense.122 = ok rttMonLatestRttOperSense.200 = ok rttMonLatestRttOperSense.201 = ok rttMonLatestRttOperSense.202 = ok rttMonLatestRttOperSense.203 = ok rttMonLatestRttOperSense.204 = ok rttMonLatestRttOperSense.205 = ok rttMonLatestRttOperSense.206 = ok rttMonLatestRttOperSense.207 = ok rttMonLatestRttOperSense.211 = ok rttMonLatestRttOperSense.250 = ok rttMonLatestRttOperSense.251 = ok rttMonLatestRttOperSense.252 = ok rttMonLatestRttOperSense.253 = ok rttMonLatestRttOperSense.254 = ok rttMonLatestRttOperSense.255 = ok rttMonLatestRttOperSense.256 = ok rttMonLatestRttOperSense.257 = ok rttMonLatestRttOperApplSpecificSense.122 = 0 rttMonLatestRttOperApplSpecificSense.200 = 0 rttMonLatestRttOperApplSpecificSense.201 = 0 rttMonLatestRttOperApplSpecificSense.202 = 0 rttMonLatestRttOperApplSpecificSense.203 = 0 rttMonLatestRttOperApplSpecificSense.204 = 0 rttMonLatestRttOperApplSpecificSense.205 = 0 rttMonLatestRttOperApplSpecificSense.206 = 0 rttMonLatestRttOperApplSpecificSense.207 = 0 rttMonLatestRttOperApplSpecificSense.211 = 0 rttMonLatestRttOperApplSpecificSense.250 = 0 rttMonLatestRttOperApplSpecificSense.251 = 0 rttMonLatestRttOperApplSpecificSense.252 = 0 rttMonLatestRttOperApplSpecificSense.253 = 0 rttMonLatestRttOperApplSpecificSense.254 = 0 rttMonLatestRttOperApplSpecificSense.255 = 0 rttMonLatestRttOperApplSpecificSense.256 = 0 rttMonLatestRttOperApplSpecificSense.257 = 0 rttMonLatestRttOperTime.122 = 0:2:19:43.42 rttMonLatestRttOperTime.200 = 0:2:19:44.84 rttMonLatestRttOperTime.201 = 0:2:19:44.84 rttMonLatestRttOperTime.202 = 0:2:19:44.84 rttMonLatestRttOperTime.203 = 0:2:19:44.84 rttMonLatestRttOperTime.204 = 0:2:19:44.84 rttMonLatestRttOperTime.205 = 0:2:19:44.84 rttMonLatestRttOperTime.206 = 0:2:19:44.84 rttMonLatestRttOperTime.207 = 0:2:19:44.84 rttMonLatestRttOperTime.211 = 0:2:19:44.90 rttMonLatestRttOperTime.250 = 0:2:19:45.04 rttMonLatestRttOperTime.251 = 0:2:19:44.03 rttMonLatestRttOperTime.252 = 0:2:19:44.03 rttMonLatestRttOperTime.253 = 0:2:19:44.03 rttMonLatestRttOperTime.254 = 0:2:19:44.03 rttMonLatestRttOperTime.255 = 0:2:19:44.04 rttMonLatestRttOperTime.256 = 0:2:19:44.03 rttMonLatestRttOperTime.257 = 0:2:19:45.07 rttMonLatestRttOperAddress.122 = "0A 04 64 7A " rttMonLatestRttOperAddress.200 = "0A 04 64 15 " rttMonLatestRttOperAddress.201 = "0A 04 64 16 " rttMonLatestRttOperAddress.202 = "0A 04 64 7A " rttMonLatestRttOperAddress.203 = "0A 04 64 7C " rttMonLatestRttOperAddress.204 = "6D 4A FF 16 " rttMonLatestRttOperAddress.205 = "6D 4A FF 17 " rttMonLatestRttOperAddress.206 = "6D 4A FF 2E " rttMonLatestRttOperAddress.207 = "6D 4A FF 2F " rttMonLatestRttOperAddress.211 = "0A 04 00 81 " ] SNMP STATUS[TRUE] SQL[SELECT DISTINCT `rtt_type` FROM `slas` WHERE `device_id` = '458' AND `rtt_type` != 'echo' AND `deleted` = 0 AND `sla_status` = 'active';] SQL RUNTIME[0.00071096s] CMD[/usr/bin/snmpbulkwalk -t '5' -r '3' -v2c -c *** -Pu -OQUs -m CISCO-RTTMON-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/cisco 'udp':'rtr-123.lab.cdc.local':'161' rttMonLatestJitterOperEntry] CMD EXITCODE[0] CMD RUNTIME[0.3334s] STDOUT[ rttMonLatestJitterOperNumOfRTT.122 = 16 rttMonLatestJitterOperRTTSum.122 = 46 rttMonLatestJitterOperRTTSum2.122 = 864 rttMonLatestJitterOperRTTMin.122 = 1 rttMonLatestJitterOperRTTMax.122 = 29 rttMonLatestJitterOperMinOfPositivesSD.122 = 0 rttMonLatestJitterOperMaxOfPositivesSD.122 = 0 rttMonLatestJitterOperNumOfPositivesSD.122 = 0 rttMonLatestJitterOperSumOfPositivesSD.122 = 0 rttMonLatestJitterOperSum2PositivesSD.122 = 0 rttMonLatestJitterOperMinOfNegativesSD.122 = 0 rttMonLatestJitterOperMaxOfNegativesSD.122 = 0 rttMonLatestJitterOperNumOfNegativesSD.122 = 0 rttMonLatestJitterOperSumOfNegativesSD.122 = 0 rttMonLatestJitterOperSum2NegativesSD.122 = 0 rttMonLatestJitterOperMinOfPositivesDS.122 = 0 rttMonLatestJitterOperMaxOfPositivesDS.122 = 0 rttMonLatestJitterOperNumOfPositivesDS.122 = 0 rttMonLatestJitterOperSumOfPositivesDS.122 = 0 rttMonLatestJitterOperSum2PositivesDS.122 = 0 rttMonLatestJitterOperMinOfNegativesDS.122 = 0 rttMonLatestJitterOperMaxOfNegativesDS.122 = 0 rttMonLatestJitterOperNumOfNegativesDS.122 = 0 rttMonLatestJitterOperSumOfNegativesDS.122 = 0 rttMonLatestJitterOperSum2NegativesDS.122 = 0 rttMonLatestJitterOperPacketLossSD.122 = 0 rttMonLatestJitterOperPacketLossDS.122 = 0 rttMonLatestJitterOperPacketOutOfSequence.122 = 0 rttMonLatestJitterOperPacketMIA.122 = 16 rttMonLatestJitterOperPacketLateArrival.122 = 0 rttMonLatestJitterOperOWSumSD.122 = 0 rttMonLatestJitterOperOWSum2SD.122 = 0 rttMonLatestJitterOperOWMinSD.122 = 0 rttMonLatestJitterOperOWMaxSD.122 = 0 rttMonLatestJitterOperOWSumDS.122 = 0 rttMonLatestJitterOperOWSum2DS.122 = 0 rttMonLatestJitterOperOWMinDS.122 = 0 rttMonLatestJitterOperOWMaxDS.122 = 0 rttMonLatestJitterOperNumOfOW.122 = 0 rttMonLatestJitterOperIAJOut.122 = 0 rttMonLatestJitterOperIAJIn.122 = 0 rttMonLatestJitterOperAvgJitter.122 = 0 ] SNMP STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='2',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_minimum` ='1',`rtt_maximum` ='29',`rtt_success` ='16',`rtt_loss` ='0',`rtt_last_change` ='1502370933' WHERE `sla_id` = '220'] SQL RUNTIME[0.00586104s] RRD CMD[update rtr-123.lab.cdc.local/sla_jitter-cisco-rttmon-mib-122.rrd N:2:1:29:16:0 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:0.96] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='9',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502378908' WHERE `sla_id` = '335'] SQL RUNTIME[0.00537205s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-200.rrd N:9 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:0.97] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='31',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '336'] SQL RUNTIME[0.00377703s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-201.rrd N:31 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:0.98] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='28',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '337'] SQL RUNTIME[0.00351286s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-202.rrd N:28 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:0.98] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='46',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '338'] SQL RUNTIME[0.00332808s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-203.rrd N:46 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0013s] RRD STDOUT[OK u:0.00 s:0.00 r:0.99] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='37',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '339'] SQL RUNTIME[0.00359011s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-204.rrd N:37 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:0.99] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='41',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '340'] SQL RUNTIME[0.00334191s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-205.rrd N:41 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.00] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='50',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '341'] SQL RUNTIME[0.00295901s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-206.rrd N:50 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.00] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='46',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '342'] SQL RUNTIME[0.00310183s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-207.rrd N:46 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.00] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='1',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '318'] SQL RUNTIME[0.00322080s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-211.rrd N:1 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.01] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='1',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '343'] SQL RUNTIME[0.00323582s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-250.rrd N:1 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.01] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='6',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '344'] SQL RUNTIME[0.00295782s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-251.rrd N:6 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.02] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='19',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '345'] SQL RUNTIME[0.00264788s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-252.rrd N:19 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.02] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='1',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '346'] SQL RUNTIME[0.00324702s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-253.rrd N:1 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.03] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='24',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '347'] SQL RUNTIME[0.00341892s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-254.rrd N:24 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.03] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='14',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '348'] SQL RUNTIME[0.00294495s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-255.rrd N:14 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.04] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='9',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '349'] SQL RUNTIME[0.00284004s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-256.rrd N:9 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.04] RRD_STATUS[TRUE] SQL[UPDATE `slas` set `rtt_value` ='11',`rtt_sense` ='ok',`rtt_unixtime` ='1502379078',`rtt_event` ='ok',`rtt_last_change` ='1502370933' WHERE `sla_id` = '350'] SQL RUNTIME[0.00302100s] RRD CMD[update rtr-123.lab.cdc.local/sla-cisco-rttmon-mib-257.rrd N:11 --daemon unix:/var/run/rrdcached.sock] RRD RUNTIME[0.0012s] RRD STDOUT[OK u:0.00 s:0.00 r:1.05] RRD_STATUS[TRUE] +---------+------------------+--------+-------+---------------+-------+----------+ | Label | MIB | Type | Owner | Tag | Sense | Response | +---------+------------------+--------+-------+---------------+-------+----------+ | SLA 122 | CISCO-RTTMON-MIB | jitter | | 10.4.100.122 | ok | 2ms | | SLA 200 | CISCO-RTTMON-MIB | echo | | 10.4.100.21 | ok | 9ms | | SLA 201 | CISCO-RTTMON-MIB | echo | | 10.4.100.22 | ok | 31ms | | SLA 202 | CISCO-RTTMON-MIB | echo | | 10.4.100.122 | ok | 28ms | | SLA 203 | CISCO-RTTMON-MIB | echo | | 10.4.100.124 | ok | 46ms | | SLA 204 | CISCO-RTTMON-MIB | echo | | 109.74.255.22 | ok | 37ms | | SLA 205 | CISCO-RTTMON-MIB | echo | | 109.74.255.23 | ok | 41ms | | SLA 206 | CISCO-RTTMON-MIB | echo | | 109.74.255.46 | ok | 50ms | | SLA 207 | CISCO-RTTMON-MIB | echo | | 109.74.255.47 | ok | 46ms | | SLA 211 | CISCO-RTTMON-MIB | echo | | 10.4.0.129 | ok | 1ms | | SLA 250 | CISCO-RTTMON-MIB | echo | | | ok | 1ms | | SLA 251 | CISCO-RTTMON-MIB | echo | | | ok | 6ms | | SLA 252 | CISCO-RTTMON-MIB | echo | | | ok | 19ms | | SLA 253 | CISCO-RTTMON-MIB | echo | | | ok | 1ms | | SLA 254 | CISCO-RTTMON-MIB | echo | | | ok | 24ms | | SLA 255 | CISCO-RTTMON-MIB | echo | | | ok | 14ms | | SLA 256 | CISCO-RTTMON-MIB | echo | | | ok | 9ms | | SLA 257 | CISCO-RTTMON-MIB | echo | | | ok | 11ms | +---------+------------------+--------+-------+---------------+-------+----------+ o Module time 0.9648s