Skip to content

Instantly share code, notes, and snippets.

@mmarchand
Created May 8, 2015 15:57
Show Gist options
  • Save mmarchand/c7b143aa4351dfcd3bf9 to your computer and use it in GitHub Desktop.
Save mmarchand/c7b143aa4351dfcd3bf9 to your computer and use it in GitHub Desktop.
LibreNMS 2014.master Discovery
DEBUG!
SQL[SELECT version FROM `dbSchema` ORDER BY version DESC LIMIT 1]
SQL[SELECT revision FROM `dbSchema`]
SQL[SELECT * FROM `devices` WHERE status = 1 AND disabled = 0 AND `hostname` LIKE 'a9k1.adm.dc3' ORDER BY device_id DESC]
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '1'] a9k1.adm.dc3 1 iosxr (cisco)
BGP Sessions : DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -Oqvn -m BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 .1.3.6.1.2.1.15.2
65500
AS65500 DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -Oq -m BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 BGP4-MIB::bgpPeerRemoteAs
BGP4-MIB::bgpPeerRemoteAs.5.23.24.5 6453
BGP4-MIB::bgpPeerRemoteAs.37.49.236.10 6939
BGP4-MIB::bgpPeerRemoteAs.37.49.236.24 35625
BGP4-MIB::bgpPeerRemoteAs.37.49.236.27 42456
BGP4-MIB::bgpPeerRemoteAs.37.49.236.32 34177
BGP4-MIB::bgpPeerRemoteAs.37.49.236.40 39605
BGP4-MIB::bgpPeerRemoteAs.37.49.236.42 8560
BGP4-MIB::bgpPeerRemoteAs.37.49.236.58 8220
BGP4-MIB::bgpPeerRemoteAs.37.49.236.60 8426
BGP4-MIB::bgpPeerRemoteAs.37.49.236.61 8426
BGP4-MIB::bgpPeerRemoteAs.37.49.236.63 5410
BGP4-MIB::bgpPeerRemoteAs.37.49.236.68 20562
BGP4-MIB::bgpPeerRemoteAs.37.49.236.72 8304
BGP4-MIB::bgpPeerRemoteAs.37.49.236.85 42473
BGP4-MIB::bgpPeerRemoteAs.37.49.236.86 33930
BGP4-MIB::bgpPeerRemoteAs.37.49.236.96 41690
BGP4-MIB::bgpPeerRemoteAs.37.49.236.111 43142
BGP4-MIB::bgpPeerRemoteAs.37.49.236.118 16509
BGP4-MIB::bgpPeerRemoteAs.37.49.236.120 52075
BGP4-MIB::bgpPeerRemoteAs.37.49.236.121 0
BGP4-MIB::bgpPeerRemoteAs.37.49.236.153 8304
BGP4-MIB::bgpPeerRemoteAs.37.49.236.154 29169
BGP4-MIB::bgpPeerRemoteAs.37.49.236.156 15547
BGP4-MIB::bgpPeerRemoteAs.37.49.236.168 20940
BGP4-MIB::bgpPeerRemoteAs.37.49.236.174 32934
BGP4-MIB::bgpPeerRemoteAs.37.49.236.175 32934
BGP4-MIB::bgpPeerRemoteAs.37.49.236.178 8966
BGP4-MIB::bgpPeerRemoteAs.37.49.236.193 33930
BGP4-MIB::bgpPeerRemoteAs.37.49.236.228 24482
BGP4-MIB::bgpPeerRemoteAs.37.49.236.232 0
BGP4-MIB::bgpPeerRemoteAs.37.49.236.250 51706
BGP4-MIB::bgpPeerRemoteAs.37.49.236.251 51706
BGP4-MIB::bgpPeerRemoteAs.37.49.237.3 13285
BGP4-MIB::bgpPeerRemoteAs.37.49.237.25 46489
BGP4-MIB::bgpPeerRemoteAs.37.49.237.26 46489
BGP4-MIB::bgpPeerRemoteAs.37.49.237.29 15133
BGP4-MIB::bgpPeerRemoteAs.37.49.237.43 2906
BGP4-MIB::bgpPeerRemoteAs.37.49.237.49 13335
BGP4-MIB::bgpPeerRemoteAs.37.49.237.50 2906
BGP4-MIB::bgpPeerRemoteAs.37.77.36.6 44530
BGP4-MIB::bgpPeerRemoteAs.46.33.93.89 3257
BGP4-MIB::bgpPeerRemoteAs.62.115.40.77 1299
BGP4-MIB::bgpPeerRemoteAs.62.210.17.31 65500
BGP4-MIB::bgpPeerRemoteAs.62.210.18.21 65500
BGP4-MIB::bgpPeerRemoteAs.62.210.175.209 65500
BGP4-MIB::bgpPeerRemoteAs.130.117.20.1 174
BGP4-MIB::bgpPeerRemoteAs.149.11.115.9 174
BGP4-MIB::bgpPeerRemoteAs.195.154.0.14 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.3 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.5 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.7 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.37 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.39 64999
BGP4-MIB::bgpPeerRemoteAs.195.154.1.155 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.3.249 21502
BGP4-MIB::bgpPeerRemoteAs.213.242.120.145 3356
Peers : BGP4-MIB::bgpPeerRemoteAs.5.23.24.5 6453
BGP4-MIB::bgpPeerRemoteAs.37.49.236.10 6939
BGP4-MIB::bgpPeerRemoteAs.37.49.236.24 35625
BGP4-MIB::bgpPeerRemoteAs.37.49.236.27 42456
BGP4-MIB::bgpPeerRemoteAs.37.49.236.32 34177
BGP4-MIB::bgpPeerRemoteAs.37.49.236.40 39605
BGP4-MIB::bgpPeerRemoteAs.37.49.236.42 8560
BGP4-MIB::bgpPeerRemoteAs.37.49.236.58 8220
BGP4-MIB::bgpPeerRemoteAs.37.49.236.60 8426
BGP4-MIB::bgpPeerRemoteAs.37.49.236.61 8426
BGP4-MIB::bgpPeerRemoteAs.37.49.236.63 5410
BGP4-MIB::bgpPeerRemoteAs.37.49.236.68 20562
BGP4-MIB::bgpPeerRemoteAs.37.49.236.72 8304
BGP4-MIB::bgpPeerRemoteAs.37.49.236.85 42473
BGP4-MIB::bgpPeerRemoteAs.37.49.236.86 33930
BGP4-MIB::bgpPeerRemoteAs.37.49.236.96 41690
BGP4-MIB::bgpPeerRemoteAs.37.49.236.111 43142
BGP4-MIB::bgpPeerRemoteAs.37.49.236.118 16509
BGP4-MIB::bgpPeerRemoteAs.37.49.236.120 52075
BGP4-MIB::bgpPeerRemoteAs.37.49.236.121 0
BGP4-MIB::bgpPeerRemoteAs.37.49.236.153 8304
BGP4-MIB::bgpPeerRemoteAs.37.49.236.154 29169
BGP4-MIB::bgpPeerRemoteAs.37.49.236.156 15547
BGP4-MIB::bgpPeerRemoteAs.37.49.236.168 20940
BGP4-MIB::bgpPeerRemoteAs.37.49.236.174 32934
BGP4-MIB::bgpPeerRemoteAs.37.49.236.175 32934
BGP4-MIB::bgpPeerRemoteAs.37.49.236.178 8966
BGP4-MIB::bgpPeerRemoteAs.37.49.236.193 33930
BGP4-MIB::bgpPeerRemoteAs.37.49.236.228 24482
BGP4-MIB::bgpPeerRemoteAs.37.49.236.232 0
BGP4-MIB::bgpPeerRemoteAs.37.49.236.250 51706
BGP4-MIB::bgpPeerRemoteAs.37.49.236.251 51706
BGP4-MIB::bgpPeerRemoteAs.37.49.237.3 13285
BGP4-MIB::bgpPeerRemoteAs.37.49.237.25 46489
BGP4-MIB::bgpPeerRemoteAs.37.49.237.26 46489
BGP4-MIB::bgpPeerRemoteAs.37.49.237.29 15133
BGP4-MIB::bgpPeerRemoteAs.37.49.237.43 2906
BGP4-MIB::bgpPeerRemoteAs.37.49.237.49 13335
BGP4-MIB::bgpPeerRemoteAs.37.49.237.50 2906
BGP4-MIB::bgpPeerRemoteAs.37.77.36.6 44530
BGP4-MIB::bgpPeerRemoteAs.46.33.93.89 3257
BGP4-MIB::bgpPeerRemoteAs.62.115.40.77 1299
BGP4-MIB::bgpPeerRemoteAs.62.210.17.31 65500
BGP4-MIB::bgpPeerRemoteAs.62.210.18.21 65500
BGP4-MIB::bgpPeerRemoteAs.62.210.175.209 65500
BGP4-MIB::bgpPeerRemoteAs.130.117.20.1 174
BGP4-MIB::bgpPeerRemoteAs.149.11.115.9 174
BGP4-MIB::bgpPeerRemoteAs.195.154.0.14 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.3 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.5 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.7 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.37 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.1.39 64999
BGP4-MIB::bgpPeerRemoteAs.195.154.1.155 65500
BGP4-MIB::bgpPeerRemoteAs.195.154.3.249 21502
BGP4-MIB::bgpPeerRemoteAs.213.242.120.145 3356
Found peer 5.23.24.5 (AS6453)
Found peer 37.49.236.10 (AS6939)
Found peer 37.49.236.24 (AS35625)
Found peer 37.49.236.27 (AS42456)
Found peer 37.49.236.32 (AS34177)
Found peer 37.49.236.40 (AS39605)
Found peer 37.49.236.42 (AS8560)
Found peer 37.49.236.58 (AS8220)
Found peer 37.49.236.60 (AS8426)
Found peer 37.49.236.61 (AS8426)
Found peer 37.49.236.63 (AS5410)
Found peer 37.49.236.68 (AS20562)
Found peer 37.49.236.72 (AS8304)
Found peer 37.49.236.85 (AS42473)
Found peer 37.49.236.86 (AS33930)
Found peer 37.49.236.96 (AS41690)
Found peer 37.49.236.111 (AS43142)
Found peer 37.49.236.118 (AS16509)
Found peer 37.49.236.120 (AS52075)
Found peer 37.49.236.121 (AS0)
Found peer 37.49.236.153 (AS8304)
Found peer 37.49.236.154 (AS29169)
Found peer 37.49.236.156 (AS15547)
Found peer 37.49.236.168 (AS20940)
Found peer 37.49.236.174 (AS32934)
Found peer 37.49.236.175 (AS32934)
Found peer 37.49.236.178 (AS8966)
Found peer 37.49.236.193 (AS33930)
Found peer 37.49.236.228 (AS24482)
Found peer 37.49.236.232 (AS0)
Found peer 37.49.236.250 (AS51706)
Found peer 37.49.236.251 (AS51706)
Found peer 37.49.237.3 (AS13285)
Found peer 37.49.237.25 (AS46489)
Found peer 37.49.237.26 (AS46489)
Found peer 37.49.237.29 (AS15133)
Found peer 37.49.237.43 (AS2906)
Found peer 37.49.237.49 (AS13335)
Found peer 37.49.237.50 (AS2906)
Found peer 37.77.36.6 (AS44530)
Found peer 46.33.93.89 (AS3257)
Found peer 62.115.40.77 (AS1299)
Found peer 62.210.17.31 (AS65500)
Found peer 62.210.18.21 (AS65500)
Found peer 62.210.175.209 (AS65500)
Found peer 130.117.20.1 (AS174)
Found peer 149.11.115.9 (AS174)
Found peer 195.154.0.14 (AS65500)
Found peer 195.154.1.3 (AS65500)
Found peer 195.154.1.5 (AS65500)
Found peer 195.154.1.7 (AS65500)
Found peer 195.154.1.37 (AS65500)
Found peer 195.154.1.39 (AS64999)
Found peer 195.154.1.155 (AS65500)
Found peer 195.154.3.249 (AS21502)
Found peer 213.242.120.145 (AS3356)
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '5.23.24.5']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='6453',`astext` ='AS6453 - TATA COMMUNICATIONS (AMERICA) INC,US' WHERE device_id='1' AND bgpPeerIdentifier='5.23.24.5'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.5.23.24.5
cbgpPeerAddrFamilyName.5.23.24.5.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.5.23.24.5.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '5.23.24.5', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','5.23.24.5','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '5.23.24.5']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.10']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='6939',`astext` ='HURRICANE - Hurricane Electric, Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.10'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.10
cbgpPeerAddrFamilyName.37.49.236.10.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.10.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.10', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.10','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.10']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.24']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='35625',`astext` ='ATE Avenir Telematique S.A.S.,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.24'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.24
cbgpPeerAddrFamilyName.37.49.236.24.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.24.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.24', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.24','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.24']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.27']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='42456',`astext` ='CHMURTZ-AS CHMURTZ SARL,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.27'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.27
cbgpPeerAddrFamilyName.37.49.236.27.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.27.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.27', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.27','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.27']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.32']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='34177',`astext` ='CELESTE-AS CELESTE - Internet services provider,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.32'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.32
cbgpPeerAddrFamilyName.37.49.236.32.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.32.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.32', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.32','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.32']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.40']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='39605',`astext` ='IGUANESOLUTIONS Iguane Solutions SAS,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.40'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.40
cbgpPeerAddrFamilyName.37.49.236.40.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.40.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.40', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.40','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.40']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.42']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='8560',`astext` ='ONEANDONE-AS 1&1 Internet AG,DE' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.42'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.42
cbgpPeerAddrFamilyName.37.49.236.42.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.42.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.42', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.42','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.42']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.58']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='8220',`astext` ='COLT COLT Technology Services Group Limited,GB' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.58'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.58
cbgpPeerAddrFamilyName.37.49.236.58.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.58.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.58', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.58','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.58']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.60']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='8426',`astext` ='CLARANET-AS ClaraNET LTD,GB' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.60'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.60
cbgpPeerAddrFamilyName.37.49.236.60.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.60.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.60', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.60','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.60']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.61']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='8426',`astext` ='CLARANET-AS ClaraNET LTD,GB' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.61'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.61
cbgpPeerAddrFamilyName.37.49.236.61.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.61.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.61', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.61','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.61']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.63']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='5410',`astext` ='ASN-BOUYGTEL-ISP Bouygues Telecom S.A.,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.63'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.63
cbgpPeerAddrFamilyName.37.49.236.63.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.63.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.63', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.63','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.63']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.68']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='20562',`astext` ='OPEN-PEERING-AS Open Peering Initiative, Amsterdam, The Netherlands,NL' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.68'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.68
cbgpPeerAddrFamilyName.37.49.236.68.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.68.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.68', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.68','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.68']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.72']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='8304',`astext` ='ECRITEL-FRANCE ECRITEL Company,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.72'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.72
cbgpPeerAddrFamilyName.37.49.236.72.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.72.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.72', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.72','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.72']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.85']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='42473',`astext` ='ANEXIA-AS ANEXIA Internetdienstleistungs GmbH,AT' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.85'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.85
cbgpPeerAddrFamilyName.37.49.236.85.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.85.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.85', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.85','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.85']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.86']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='33930',`astext` ='INTRINSEC-AS INTRINSEC,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.86'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.86
cbgpPeerAddrFamilyName.37.49.236.86.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.86.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.86', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.86','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.86']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.96']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='41690',`astext` ='DAILYMOTION Dailymotion S.A.,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.96'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.96
cbgpPeerAddrFamilyName.37.49.236.96.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.96.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.96', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.96','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.96']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.111']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='43142',`astext` ='ADELINOVIUS ADELI SAS,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.111'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.111
cbgpPeerAddrFamilyName.37.49.236.111.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.111.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.111', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.111','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.111']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.118']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='16509',`astext` ='AMAZON-02 - Amazon.com, Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.118'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.118
cbgpPeerAddrFamilyName.37.49.236.118.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.118.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.118', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.118','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.118']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.120']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='52075',`astext` ='WIFIRST Wifirst S.A.S.,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.120'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.120
cbgpPeerAddrFamilyName.37.49.236.120.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.120.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.120', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.120','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.120']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.121']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='0',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.121'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.121
cbgpPeerAddrFamilyName.37.49.236.121.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.121.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.121', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.121','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.121']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.153']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='8304',`astext` ='ECRITEL-FRANCE ECRITEL Company,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.153'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.153
cbgpPeerAddrFamilyName.37.49.236.153.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.153.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.153', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.153','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.153']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.154']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='29169',`astext` ='GANDI-AS Gandi SAS,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.154'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.154
cbgpPeerAddrFamilyName.37.49.236.154.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.154.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.154', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.154','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.154']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.156']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='15547',`astext` ='NETPLUS netplus.ch SA,CH' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.156'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.156
cbgpPeerAddrFamilyName.37.49.236.156.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.156.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.156', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.156','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.156']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.168']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='20940',`astext` ='AKAMAI-ASN1 Akamai International B.V.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.168'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.168
cbgpPeerAddrFamilyName.37.49.236.168.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.168.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.168', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.168','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.168']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.174']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='32934',`astext` ='FACEBOOK - Facebook, Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.174'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.174
cbgpPeerAddrFamilyName.37.49.236.174.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.174.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.174', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.174','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.174']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.175']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='32934',`astext` ='FACEBOOK - Facebook, Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.175'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.175
cbgpPeerAddrFamilyName.37.49.236.175.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.175.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.175', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.175','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.175']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.178']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='8966',`astext` ='ETISALAT-AS Emirates Telecommunications Corporation,AE' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.178'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.178
cbgpPeerAddrFamilyName.37.49.236.178.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.178.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.178', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.178','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.178']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.193']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='33930',`astext` ='INTRINSEC-AS INTRINSEC,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.193'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.193
cbgpPeerAddrFamilyName.37.49.236.193.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.193.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.193', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.193','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.193']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.228']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='24482',`astext` ='SGGS-AS-AP SG.GS,SG' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.228'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.228
cbgpPeerAddrFamilyName.37.49.236.228.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.228.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.228', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.228','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.228']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.232']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='0',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.232'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.232
cbgpPeerAddrFamilyName.37.49.236.232.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.232.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.232', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.232','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.232']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.250']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='51706',`astext` ='FRANCE-IX-AS France IX Services SASU,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.250'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.250
cbgpPeerAddrFamilyName.37.49.236.250.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.250.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.250', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.250','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.250']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.251']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='51706',`astext` ='FRANCE-IX-AS France IX Services SASU,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.49.236.251'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.236.251
cbgpPeerAddrFamilyName.37.49.236.251.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.236.251.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.236.251', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.236.251','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.236.251']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.3']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='13285',`astext` ='OPALTELECOM-AS TalkTalk Communications Limited,GB' WHERE device_id='1' AND bgpPeerIdentifier='37.49.237.3'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.237.3
cbgpPeerAddrFamilyName.37.49.237.3.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.237.3.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.3', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.237.3','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.237.3']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.25']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='46489',`astext` ='JUSTINTV - Justin.tv, Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.237.25'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.237.25
cbgpPeerAddrFamilyName.37.49.237.25.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.237.25.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.25', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.237.25','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.237.25']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.26']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='46489',`astext` ='JUSTINTV - Justin.tv, Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.237.26'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.237.26
cbgpPeerAddrFamilyName.37.49.237.26.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.237.26.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.26', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.237.26','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.237.26']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.29']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='15133',`astext` ='EDGECAST - EdgeCast Networks, Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.237.29'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.237.29
cbgpPeerAddrFamilyName.37.49.237.29.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.237.29.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.29', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.237.29','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.237.29']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.43']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='2906',`astext` ='AS-SSI - Netflix Streaming Services Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.237.43'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.237.43
cbgpPeerAddrFamilyName.37.49.237.43.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.237.43.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.43', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.237.43','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.237.43']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.49']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='13335',`astext` ='CLOUDFLARENET - CloudFlare, Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.237.49'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.237.49
cbgpPeerAddrFamilyName.37.49.237.49.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.237.49.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.49', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.237.49','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.237.49']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.50']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='2906',`astext` ='AS-SSI - Netflix Streaming Services Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='37.49.237.50'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.49.237.50
cbgpPeerAddrFamilyName.37.49.237.50.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.49.237.50.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.49.237.50', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.49.237.50','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.49.237.50']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '37.77.36.6']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='44530',`astext` ='HOPUS HOPUS SAS,FR' WHERE device_id='1' AND bgpPeerIdentifier='37.77.36.6'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.37.77.36.6
cbgpPeerAddrFamilyName.37.77.36.6.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.37.77.36.6.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '37.77.36.6', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','37.77.36.6','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '37.77.36.6']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '46.33.93.89']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='3257',`astext` ='TINET-BACKBONE Tinet SpA,DE' WHERE device_id='1' AND bgpPeerIdentifier='46.33.93.89'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.46.33.93.89
cbgpPeerAddrFamilyName.46.33.93.89.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.46.33.93.89.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '46.33.93.89', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','46.33.93.89','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '46.33.93.89']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '62.115.40.77']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='1299',`astext` ='TELIANET TeliaSonera International Carrier,SE' WHERE device_id='1' AND bgpPeerIdentifier='62.115.40.77'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.62.115.40.77
cbgpPeerAddrFamilyName.62.115.40.77.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.62.115.40.77.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '62.115.40.77', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','62.115.40.77','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '62.115.40.77']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '62.210.17.31']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='65500',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='62.210.17.31'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.62.210.17.31
cbgpPeerAddrFamilyName.62.210.17.31.ipv4.unicast = IPv4 Unicast
cbgpPeerAddrFamilyName.62.210.17.31.ipv6.unicast = IPv6 Unicast
afi data :: cbgpPeerAddrFamilyName.62.210.17.31.ipv4.unicast = IPv4 Unicast
cbgpPeerAddrFamilyName.62.210.17.31.ipv6.unicast = IPv6 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '62.210.17.31', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','62.210.17.31','ipv4','unicast')] AFISAFI = ipv6.unicast = IPv6 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '62.210.17.31', AND afi='ipv6' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','62.210.17.31','ipv6','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '62.210.17.31']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '62.210.18.21']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='65500',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='62.210.18.21'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.62.210.18.21
cbgpPeerAddrFamilyName.62.210.18.21.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.62.210.18.21.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '62.210.18.21', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','62.210.18.21','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '62.210.18.21']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '62.210.175.209']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='65500',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='62.210.175.209'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.62.210.175.209
cbgpPeerAddrFamilyName.62.210.175.209.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.62.210.175.209.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '62.210.175.209', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','62.210.175.209','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '62.210.175.209']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '130.117.20.1']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='174',`astext` ='COGENT-174 - Cogent Communications,US' WHERE device_id='1' AND bgpPeerIdentifier='130.117.20.1'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.130.117.20.1
cbgpPeerAddrFamilyName.130.117.20.1.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.130.117.20.1.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '130.117.20.1', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','130.117.20.1','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '130.117.20.1']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '149.11.115.9']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='174',`astext` ='COGENT-174 - Cogent Communications,US' WHERE device_id='1' AND bgpPeerIdentifier='149.11.115.9'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.149.11.115.9
cbgpPeerAddrFamilyName.149.11.115.9.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.149.11.115.9.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '149.11.115.9', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','149.11.115.9','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '149.11.115.9']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.0.14']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='65500',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='195.154.0.14'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.195.154.0.14
cbgpPeerAddrFamilyName.195.154.0.14.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.195.154.0.14.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.0.14', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','195.154.0.14','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '195.154.0.14']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.3']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='65500',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='195.154.1.3'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.195.154.1.3
cbgpPeerAddrFamilyName.195.154.1.3.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.195.154.1.3.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.3', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','195.154.1.3','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '195.154.1.3']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.5']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='65500',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='195.154.1.5'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.195.154.1.5
cbgpPeerAddrFamilyName.195.154.1.5.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.195.154.1.5.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.5', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','195.154.1.5','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '195.154.1.5']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.7']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='65500',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='195.154.1.7'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.195.154.1.7
cbgpPeerAddrFamilyName.195.154.1.7.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.195.154.1.7.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.7', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','195.154.1.7','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '195.154.1.7']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.37']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='65500',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='195.154.1.37'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.195.154.1.37
cbgpPeerAddrFamilyName.195.154.1.37.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.195.154.1.37.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.37', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','195.154.1.37','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '195.154.1.37']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.39']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='64999',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='195.154.1.39'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.195.154.1.39
cbgpPeerAddrFamilyName.195.154.1.39.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.195.154.1.39.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.39', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','195.154.1.39','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '195.154.1.39']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.155']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='65500',`astext` ='' WHERE device_id='1' AND bgpPeerIdentifier='195.154.1.155'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.195.154.1.155
cbgpPeerAddrFamilyName.195.154.1.155.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.195.154.1.155.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.1.155', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','195.154.1.155','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '195.154.1.155']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.3.249']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='21502',`astext` ='ASN-NUMERICABLE NUMERICABLE is a cable network operator in France, offering TV,VOICE and Internet services,FR' WHERE device_id='1' AND bgpPeerIdentifier='195.154.3.249'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.195.154.3.249
cbgpPeerAddrFamilyName.195.154.3.249.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.195.154.3.249.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '195.154.3.249', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','195.154.3.249','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '195.154.3.249']
SQL[SELECT COUNT(*) from `bgpPeers` WHERE device_id = '1' AND bgpPeerIdentifier = '213.242.120.145']
SQL[UPDATE `bgpPeers` set `bgpPeerRemoteAs` ='3356',`astext` ='LEVEL3 - Level 3 Communications, Inc.,US' WHERE device_id='1' AND bgpPeerIdentifier='213.242.120.145'] .DEBUG: SNMP Auth options = -v2c -c snmpcommunity
/usr/bin/snmpbulkwalk -v2c -c snmpcommunity -OsQ -m CISCO-BGP4-MIB -M /opt/librenms/mibs udp:a9k1.adm.dc3:161 cbgpPeerAddrFamilyName.213.242.120.145
cbgpPeerAddrFamilyName.213.242.120.145.ipv4.unicast = IPv4 Unicast
afi data :: cbgpPeerAddrFamilyName.213.242.120.145.ipv4.unicast = IPv4 Unicast
AFISAFI = ipv4.unicast = IPv4 Unicast
SQL[SELECT COUNT(*) from `bgpPeers_cbgp` WHERE device_id = '1' AND bgpPeerIdentifier = '213.242.120.145', AND afi='ipv4' AND safi='unicast']
SQL[INSERT INTO `bgpPeers_cbgp` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`) VALUES ('1','213.242.120.145','ipv4','unicast')]
SQL[SELECT * FROM bgpPeers_cbgp WHERE `device_id` = '1' AND bgpPeerIdentifier = '213.242.120.145']
SQL[SELECT * FROM bgpPeers AS B, devices AS D WHERE B.device_id = D.device_id AND D.device_id = '1']
SQL[UPDATE `devices` set `last_discovered` =NOW(),`type` ='network',`last_discovered_timetaken` ='6.737' WHERE `device_id` = '1'] Discovered in 6.737 seconds
SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('discover','a9k1.adm.dc3','1431100357.851','6.752','1')] ./discovery.php a9k1.adm.dc3 2015-05-08 17:52:44 - 1 devices discovered in 6.752 secs
MySQL: Cell[58/0.06s] Row[57/0.68s] Rows[1/0s] Column[0/0s] Update[57/0.88s] Insert[58/0.1s] Delete[0/0s]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment