CMD[/usr/bin/snmpget -t '3' -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' sysObjectID.0 sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0406s]
STDOUT[
sysObjectID.0 = enterprises.9.1.1639
sysUpTime.0 = 67:6:02:39.24
]
SNMP STATUS[TRUE]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '39']
SQL RUNTIME[0.00438905s]

SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '39' AND `poller_id` = '0']
SQL RUNTIME[0.00033307s]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`)  VALUES ('7765','discovery.php','7753','0','php /opt/observium/discovery.php -h all -m vrf -d','1611219602','39')]
SQL RUNTIME[0.01003098s]
#####  pop19-asr [39]  #####

 o OS Type              iosxr
 o OS Group             cisco
 o SNMP Version         v2c
 o Last discovery       2021-01-21 09:58:11
 o Last duration        35.92 seconds

#####  Module Start: vrf  #####


SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '39' AND `use` = 'mib' AND `disabled` = '1']
SQL RUNTIME[0.00054002s]
 o MPLS-L3VPN-STD-MIB   
CMD[/usr/bin/snmpget -t '3' -v2c -c *** -Pud -OQUv -m MPLS-L3VPN-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsL3VpnConfiguredVrfs.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0551s]
STDOUT[
6
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pud -OQUs -m MPLS-L3VPN-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsL3VpnVrfEntry]

CMD EXITCODE[0]
CMD RUNTIME[0.2979s]
STDOUT[
mplsL3VpnVrfVpnId."VR_MGMT" = ""
mplsL3VpnVrfVpnId."default" = ""
mplsL3VpnVrfVpnId."VRF_IPSUBS" = ""
mplsL3VpnVrfVpnId."VR_INT_MGMT" = ""
mplsL3VpnVrfVpnId."VR_MFH_MGMT" = ""
mplsL3VpnVrfVpnId."VRF_INFRA_INT" = ""
mplsL3VpnVrfVpnId."VR_SMART-METER" = ""
mplsL3VpnVrfDescription."VR_MGMT" = 
mplsL3VpnVrfDescription."default" = 
mplsL3VpnVrfDescription."VRF_IPSUBS" = 
mplsL3VpnVrfDescription."VR_INT_MGMT" = 
mplsL3VpnVrfDescription."VR_MFH_MGMT" = 
mplsL3VpnVrfDescription."VRF_INFRA_INT" = 
mplsL3VpnVrfDescription."VR_SMART-METER" = 
mplsL3VpnVrfRD."VR_MGMT" = ""
mplsL3VpnVrfRD."default" = ""
mplsL3VpnVrfRD."VRF_IPSUBS" = "15943:1007"
mplsL3VpnVrfRD."VR_INT_MGMT" = ""
mplsL3VpnVrfRD."VR_MFH_MGMT" = "15943:1009"
mplsL3VpnVrfRD."VRF_INFRA_INT" = "15943:1015"
mplsL3VpnVrfRD."VR_SMART-METER" = "15943:999"
mplsL3VpnVrfCreationTime."VR_MGMT" = 0:0:00:16.72
mplsL3VpnVrfCreationTime."default" = 0:0:00:00.00
mplsL3VpnVrfCreationTime."VRF_IPSUBS" = 0:0:00:16.72
mplsL3VpnVrfCreationTime."VR_INT_MGMT" = 0:0:00:16.72
mplsL3VpnVrfCreationTime."VR_MFH_MGMT" = 0:0:00:16.72
mplsL3VpnVrfCreationTime."VRF_INFRA_INT" = 0:0:00:16.72
mplsL3VpnVrfCreationTime."VR_SMART-METER" = 0:0:00:16.72
mplsL3VpnVrfOperStatus."VR_MGMT" = up
mplsL3VpnVrfOperStatus."default" = down
mplsL3VpnVrfOperStatus."VRF_IPSUBS" = up
mplsL3VpnVrfOperStatus."VR_INT_MGMT" = down
mplsL3VpnVrfOperStatus."VR_MFH_MGMT" = up
mplsL3VpnVrfOperStatus."VRF_INFRA_INT" = up
mplsL3VpnVrfOperStatus."VR_SMART-METER" = up
mplsL3VpnVrfActiveInterfaces."VR_MGMT" = 1
mplsL3VpnVrfActiveInterfaces."default" = 0
mplsL3VpnVrfActiveInterfaces."VRF_IPSUBS" = 1
mplsL3VpnVrfActiveInterfaces."VR_INT_MGMT" = 0
mplsL3VpnVrfActiveInterfaces."VR_MFH_MGMT" = 2
mplsL3VpnVrfActiveInterfaces."VRF_INFRA_INT" = 2
mplsL3VpnVrfActiveInterfaces."VR_SMART-METER" = 1
mplsL3VpnVrfAssociatedInterfaces."VR_MGMT" = 2
mplsL3VpnVrfAssociatedInterfaces."default" = 0
mplsL3VpnVrfAssociatedInterfaces."VRF_IPSUBS" = 1
mplsL3VpnVrfAssociatedInterfaces."VR_INT_MGMT" = 0
mplsL3VpnVrfAssociatedInterfaces."VR_MFH_MGMT" = 2
mplsL3VpnVrfAssociatedInterfaces."VRF_INFRA_INT" = 2
mplsL3VpnVrfAssociatedInterfaces."VR_SMART-METER" = 1
mplsL3VpnVrfConfMidRteThresh."VR_MGMT" = 0
mplsL3VpnVrfConfMidRteThresh."default" = 0
mplsL3VpnVrfConfMidRteThresh."VRF_IPSUBS" = 0
mplsL3VpnVrfConfMidRteThresh."VR_INT_MGMT" = 0
mplsL3VpnVrfConfMidRteThresh."VR_MFH_MGMT" = 0
mplsL3VpnVrfConfMidRteThresh."VRF_INFRA_INT" = 0
mplsL3VpnVrfConfMidRteThresh."VR_SMART-METER" = 0
mplsL3VpnVrfConfHighRteThresh."VR_MGMT" = 0
mplsL3VpnVrfConfHighRteThresh."default" = 0
mplsL3VpnVrfConfHighRteThresh."VRF_IPSUBS" = 0
mplsL3VpnVrfConfHighRteThresh."VR_INT_MGMT" = 0
mplsL3VpnVrfConfHighRteThresh."VR_MFH_MGMT" = 0
mplsL3VpnVrfConfHighRteThresh."VRF_INFRA_INT" = 0
mplsL3VpnVrfConfHighRteThresh."VR_SMART-METER" = 0
mplsL3VpnVrfConfMaxRoutes."VR_MGMT" = 0
mplsL3VpnVrfConfMaxRoutes."default" = 0
mplsL3VpnVrfConfMaxRoutes."VRF_IPSUBS" = 0
mplsL3VpnVrfConfMaxRoutes."VR_INT_MGMT" = 0
mplsL3VpnVrfConfMaxRoutes."VR_MFH_MGMT" = 0
mplsL3VpnVrfConfMaxRoutes."VRF_INFRA_INT" = 0
mplsL3VpnVrfConfMaxRoutes."VR_SMART-METER" = 0
mplsL3VpnVrfConfLastChanged."VR_MGMT" = 0:0:00:29.72
mplsL3VpnVrfConfLastChanged."default" = 0:0:00:00.00
mplsL3VpnVrfConfLastChanged."VRF_IPSUBS" = 0:0:05:11.72
mplsL3VpnVrfConfLastChanged."VR_INT_MGMT" = 0:0:00:00.00
mplsL3VpnVrfConfLastChanged."VR_MFH_MGMT" = 0:0:05:11.72
mplsL3VpnVrfConfLastChanged."VRF_INFRA_INT" = 0:0:05:11.72
mplsL3VpnVrfConfLastChanged."VR_SMART-METER" = 0:0:05:11.72
mplsL3VpnVrfConfRowStatus."VR_MGMT" = active
mplsL3VpnVrfConfRowStatus."default" = active
mplsL3VpnVrfConfRowStatus."VRF_IPSUBS" = active
mplsL3VpnVrfConfRowStatus."VR_INT_MGMT" = active
mplsL3VpnVrfConfRowStatus."VR_MFH_MGMT" = active
mplsL3VpnVrfConfRowStatus."VRF_INFRA_INT" = active
mplsL3VpnVrfConfRowStatus."VR_SMART-METER" = active
mplsL3VpnVrfConfAdminStatus."VR_MGMT" = up
mplsL3VpnVrfConfAdminStatus."default" = down
mplsL3VpnVrfConfAdminStatus."VRF_IPSUBS" = up
mplsL3VpnVrfConfAdminStatus."VR_INT_MGMT" = down
mplsL3VpnVrfConfAdminStatus."VR_MFH_MGMT" = up
mplsL3VpnVrfConfAdminStatus."VRF_INFRA_INT" = up
mplsL3VpnVrfConfAdminStatus."VR_SMART-METER" = up
mplsL3VpnVrfConfStorageType."VR_MGMT" = readOnly
mplsL3VpnVrfConfStorageType."default" = readOnly
mplsL3VpnVrfConfStorageType."VRF_IPSUBS" = readOnly
mplsL3VpnVrfConfStorageType."VR_INT_MGMT" = readOnly
mplsL3VpnVrfConfStorageType."VR_MFH_MGMT" = readOnly
mplsL3VpnVrfConfStorageType."VRF_INFRA_INT" = readOnly
mplsL3VpnVrfConfStorageType."VR_SMART-METER" = readOnly
]
SNMP STATUS[TRUE]

CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pud -OQUs -m MPLS-L3VPN-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsL3VpnVrfPerfEntry]

CMD EXITCODE[0]
CMD RUNTIME[0.0826s]
STDOUT[
mplsL3VpnVrfPerfRoutesAdded."VR_MGMT" = 0
mplsL3VpnVrfPerfRoutesAdded."default" = 0
mplsL3VpnVrfPerfRoutesAdded."VRF_IPSUBS" = 0
mplsL3VpnVrfPerfRoutesAdded."VR_INT_MGMT" = 0
mplsL3VpnVrfPerfRoutesAdded."VR_MFH_MGMT" = 0
mplsL3VpnVrfPerfRoutesAdded."VRF_INFRA_INT" = 0
mplsL3VpnVrfPerfRoutesAdded."VR_SMART-METER" = 0
mplsL3VpnVrfPerfRoutesDeleted."VR_MGMT" = 0
mplsL3VpnVrfPerfRoutesDeleted."default" = 0
mplsL3VpnVrfPerfRoutesDeleted."VRF_IPSUBS" = 0
mplsL3VpnVrfPerfRoutesDeleted."VR_INT_MGMT" = 0
mplsL3VpnVrfPerfRoutesDeleted."VR_MFH_MGMT" = 0
mplsL3VpnVrfPerfRoutesDeleted."VRF_INFRA_INT" = 0
mplsL3VpnVrfPerfRoutesDeleted."VR_SMART-METER" = 0
mplsL3VpnVrfPerfCurrNumRoutes."VR_MGMT" = 3
mplsL3VpnVrfPerfCurrNumRoutes."default" = 1085949
mplsL3VpnVrfPerfCurrNumRoutes."VRF_IPSUBS" = 55
mplsL3VpnVrfPerfCurrNumRoutes."VR_INT_MGMT" = 0
mplsL3VpnVrfPerfCurrNumRoutes."VR_MFH_MGMT" = 5
mplsL3VpnVrfPerfCurrNumRoutes."VRF_INFRA_INT" = 111
mplsL3VpnVrfPerfCurrNumRoutes."VR_SMART-METER" = 14
mplsL3VpnVrfPerfRoutesDropped."VR_MGMT" = 0
mplsL3VpnVrfPerfRoutesDropped."default" = 0
mplsL3VpnVrfPerfRoutesDropped."VRF_IPSUBS" = 0
mplsL3VpnVrfPerfRoutesDropped."VR_INT_MGMT" = 0
mplsL3VpnVrfPerfRoutesDropped."VR_MFH_MGMT" = 0
mplsL3VpnVrfPerfRoutesDropped."VRF_INFRA_INT" = 0
mplsL3VpnVrfPerfRoutesDropped."VR_SMART-METER" = 0
mplsL3VpnVrfPerfDiscTime."VR_MGMT" = 0:0:00:00.00
mplsL3VpnVrfPerfDiscTime."default" = 0:0:00:00.00
mplsL3VpnVrfPerfDiscTime."VRF_IPSUBS" = 0:0:00:00.00
mplsL3VpnVrfPerfDiscTime."VR_INT_MGMT" = 0:0:00:00.00
mplsL3VpnVrfPerfDiscTime."VR_MFH_MGMT" = 0:0:00:00.00
mplsL3VpnVrfPerfDiscTime."VRF_INFRA_INT" = 0:0:00:00.00
mplsL3VpnVrfPerfDiscTime."VR_SMART-METER" = 0:0:00:00.00
]
SNMP STATUS[TRUE]
Timeticks converted 0:0:00:16.72 -> 16
Timeticks converted 0:0:00:29.72 -> 29
Timeticks converted 0:0:00:00.00 -> 0
Timeticks converted 0:0:00:00.00 -> 0
Timeticks converted 0:0:00:16.72 -> 16
Timeticks converted 0:0:05:11.72 -> 311
Timeticks converted 0:0:00:16.72 -> 16
Timeticks converted 0:0:00:00.00 -> 0
Timeticks converted 0:0:00:16.72 -> 16
Timeticks converted 0:0:05:11.72 -> 311
Timeticks converted 0:0:00:16.72 -> 16
Timeticks converted 0:0:05:11.72 -> 311
Timeticks converted 0:0:00:16.72 -> 16
Timeticks converted 0:0:05:11.72 -> 311

CMD[/usr/bin/snmpbulkwalk -t '3' -v2c -c *** -Pud -OQUs -m MPLS-L3VPN-STD-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsL3VpnIfConfRowStatus]

CMD EXITCODE[0]
CMD RUNTIME[0.0683s]
STDOUT[
mplsL3VpnIfConfRowStatus."VR_MGMT".4 = active
mplsL3VpnIfConfRowStatus."VR_MGMT".5 = active
mplsL3VpnIfConfRowStatus."VRF_IPSUBS".55 = active
mplsL3VpnIfConfRowStatus."VR_MFH_MGMT".12 = active
mplsL3VpnIfConfRowStatus."VR_MFH_MGMT".61 = active
mplsL3VpnIfConfRowStatus."VRF_INFRA_INT".57 = active
mplsL3VpnIfConfRowStatus."VRF_INFRA_INT".58 = active
mplsL3VpnIfConfRowStatus."VR_SMART-METER".17 = active
]
SNMP STATUS[TRUE]

 o MPLS-VPN-MIB         
CMD[/usr/bin/snmpget -t '3' -v2c -c *** -Pud -OQUv -m MPLS-VPN-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'pop19-asr':'161' mplsVpnConfiguredVrfs.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0301s]
CMD EXITDELAY[10ms]
STDOUT[
No Such Object available on this agent at this OID
]
SNMP STATUS[FALSE]
SNMP ERROR[#1000 - Failed response]
Not found VRFs by MPLS-VPN-MIB.

vrf_last_change: 1605409139 - 1586321400 = 19087739

SQL[UPDATE `vrfs` set `vrf_last_change` ='1605409139' WHERE `vrf_id` = '161']
SQL RUNTIME[0.01025605s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '4' AND `deleted` = '0' LIMIT 1]
SQL RUNTIME[0.00055790s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '5441']
SQL RUNTIME[0.00045586s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '5441']
SQL RUNTIME[0.00029707s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '39']
SQL RUNTIME[0.00039101s]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '39']
SQL RUNTIME[0.00258398s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '5' AND `deleted` = '0' LIMIT 1]
SQL RUNTIME[0.00037217s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '5442']
SQL RUNTIME[0.00038314s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '5442']
SQL RUNTIME[0.00030589s]

SQL[INSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`)  VALUES ('5441','4','39','161'),('5442','5','39','161') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)]
SQL RUNTIME[0.01888585s]

SQL[INSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`)  VALUES ('39','MPLS-L3VPN-STD-MIB','default','','','1605409110','1605409110','down','down','0','0','0','0','1085949')]
SQL RUNTIME[0.01215720s]

SQL[INSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`)  VALUES ('39','MPLS-L3VPN-STD-MIB','VRF_IPSUBS','','15943:1007','1605409126','1605409421','up','up','1','1','0','0','55')]
SQL RUNTIME[0.01187396s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '55' AND `deleted` = '0' LIMIT 1]
SQL RUNTIME[0.00023818s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '72055']
SQL RUNTIME[0.00045586s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '72055']
SQL RUNTIME[0.00034308s]

SQL[INSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`)  VALUES ('72055','55','39','86157') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)]
SQL RUNTIME[0.01377988s]

SQL[INSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`)  VALUES ('39','MPLS-L3VPN-STD-MIB','VR_INT_MGMT','','','1605409126','1605409110','down','down','0','0','0','0','0')]
SQL RUNTIME[0.01192307s]

SQL[INSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`)  VALUES ('39','MPLS-L3VPN-STD-MIB','VR_MFH_MGMT','','15943:1009','1605409126','1605409421','up','up','2','2','0','0','5')]
SQL RUNTIME[0.01041913s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '12' AND `deleted` = '0' LIMIT 1]
SQL RUNTIME[0.00031281s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '5447']
SQL RUNTIME[0.00033593s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '5447']
SQL RUNTIME[0.00101399s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '61' AND `deleted` = '0' LIMIT 1]
SQL RUNTIME[0.00045300s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '92761']
SQL RUNTIME[0.00047088s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '92761']
SQL RUNTIME[0.00039411s]

SQL[INSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`)  VALUES ('5447','12','39','86159'),('92761','61','39','86159') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)]
SQL RUNTIME[0.00989103s]

SQL[INSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`)  VALUES ('39','MPLS-L3VPN-STD-MIB','VRF_INFRA_INT','','15943:1015','1605409126','1605409421','up','up','2','2','0','0','111')]
SQL RUNTIME[0.00799513s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '57' AND `deleted` = '0' LIMIT 1]
SQL RUNTIME[0.00133300s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '76702']
SQL RUNTIME[0.00407314s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '76702']
SQL RUNTIME[0.00056887s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '58' AND `deleted` = '0' LIMIT 1]
SQL RUNTIME[0.00030112s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '76703']
SQL RUNTIME[0.00037813s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '76703']
SQL RUNTIME[0.00052309s]

SQL[INSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`)  VALUES ('76702','57','39','86160'),('76703','58','39','86160') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)]
SQL RUNTIME[0.00596404s]

SQL[INSERT INTO `vrfs` (`device_id`,`vrf_mib`,`vrf_name`,`vrf_descr`,`vrf_rd`,`vrf_added`,`vrf_last_change`,`vrf_admin_status`,`vrf_oper_status`,`vrf_active_ports`,`vrf_total_ports`,`vrf_added_routes`,`vrf_deleted_routes`,`vrf_total_routes`)  VALUES ('39','MPLS-L3VPN-STD-MIB','VR_SMART-METER','','15943:999','1605409126','1605409421','up','up','1','1','0','0','14')]
SQL RUNTIME[0.00991583s]

SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '39' AND `ifIndex` = '17' AND `deleted` = '0' LIMIT 1]
SQL RUNTIME[0.00030994s]

SQL[SELECT * FROM `ports`  WHERE `ports`.`port_id` = '5452']
SQL RUNTIME[0.00038695s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '5452']
SQL RUNTIME[0.00034785s]

SQL[INSERT INTO `ports` (`port_id`,`ifIndex`,`device_id`,`ifVrf`)  VALUES ('5452','17','39','86161') ON DUPLICATE KEY UPDATE `ifVrf`=VALUES(`ifVrf`)]
SQL RUNTIME[0.01074219s]

SQL[SELECT COUNT(*) FROM `vrfs` WHERE `device_id` = '39' AND `vrf_name` NOT IN ('VR_MGMT','default','VRF_IPSUBS','VR_INT_MGMT','VR_MFH_MGMT','VRF_INFRA_INT','VR_SMART-METER')]
SQL RUNTIME[0.00127411s]

SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '39' AND `ifVrf` IS NOT NULL AND `port_id` NOT IN ('5441','5442','72055','5447','92761','76702','76703','5452')]
SQL RUNTIME[0.00387096s]

 o Changes              6 added, 1 updated
 o Duration             0.7338s

SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`)  VALUES ('39','39','device',NOW(),'6','VRF: 6 added, 1 updated.')]
SQL RUNTIME[0.01280785s]


SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='0.7588',`force_discovery` ='0' WHERE `device_id` = '39']
SQL RUNTIME[0.01183295s]
#####  pop19-asr [39] completed discovery modules at 2021-01-21 10:01:09  #####

 o Discovery time       0.7588 seconds


SQL[DELETE FROM `observium_processes` WHERE `process_pid` = '7765' AND `process_name` = 'discovery.php' AND `device_id` = '39' AND `poller_id` = '0']