CREATE TABLE EMS_CONNECTIONS (
    ID NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    NODE_TYPE VARCHAR2(100),
    NE_TYPE VARCHAR2(200),
    VENDOR VARCHAR2(100),
    EMS_NAME VARCHAR2(200)
);
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'BTS3900A Ver.D', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'Ericsson RanBs_2G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'RBS6601_GSM1', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', '2G Role Type # 1404897781030', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'OMB', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'Virtual Cabinet', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'RBS 6601', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'BTS3900E', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'BTS Ericsson', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'BTS3900_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'BTS5900', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'BTS3900L_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'BTS3900', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'DBS3900_GSM', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'SUP 6601_2G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'BTS5900L', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'BTS3900_GSM', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'BTS3900L_GSM1', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'DBS3900_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'BTS3900A_MS1', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'BTS3900L', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'BTS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'RBS 6101_2G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'RBS6201_2G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', '333333333333_2G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'RBS6201L_2G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'RBS6601L_2G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'RBS6201 V2_2G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'BTS3900A_GSM', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'GSMBTS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BTS', 'BTS3900E_GSM', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'RBS6101W_2G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role2G', 'RBS6101_GSM1', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'Copper Distribution Frame Type Default MDF', '', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'MDFV', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'EXTERNAL CABINET', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'MDFH_Siemens_V', 'Siemens', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'INTERNAL CABINET', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'MDFH_Alcatel', 'Alcatel', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'MDFH_Huawei_2', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'MDFH_Ericsson', 'Ericsson', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'IDF', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'MDFH_Huawei_1', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'DIRECT CABINET', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'MDFH_Siemens', 'Siemens', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'MDFH_Siemens_H', 'Siemens', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'PABX CABINET', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'INTERNAL TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'WALL TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'PILLAR TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'PCM TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'POLE TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'DP', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDF', 'TIE CABLE DP''S', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN 910C-K', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CX600-X2-M16', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN 950D', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN 910C-G', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN910', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN 910B-D DC', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN950B', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', '2811', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CX300B', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NetEngine 8000 M14', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NetEngine 8000 M8', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN 910C-D', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CX600-X8', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CX300A', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S3328TP-EI Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'm320', 'JUNIPER NETWORKS', 'JUNIPER');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NE40E-X16', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'Cisco Catalyst 6509', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CX200B', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN 950C', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN910B', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ISR4321/K9', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CX200C', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'WS-C4507R', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN 910I-TC DC', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', '2901/K9', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ATN950', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S5310-28C-EI Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S5328C-EI Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CX600-X16', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S5328C-SI Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S9303 Terabit Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S3352P-EI Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ISR4431/K9', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'C8200L-1N-4T', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'AR29-21', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'AR6121E', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', '3925-CHASSIS', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', '2911/K9', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'AR2220E Router', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ASR1002-X', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'AR2220E', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'C8300-1N1S-6T', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S5328C-HI-24S Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'AR2220 Router', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ASR-903', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'C2691', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ASR 9010', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'AR6121E Router', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'ASR-920-4SZ-A', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'mx960', 'JUNIPER NETWORKS', 'JUNIPER');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'WS-C4507R+E', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'SFP-10G-LR-S', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'AR6120-VW', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'mx104', 'JUNIPER NETWORKS', 'JUNIPER');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S5331-S24T4X-D Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S9306 Terabit Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S5331-S24T4X-A Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'PT-FR-5', 'Imagine', 'IMAGINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'PT-FR-15', 'Imagine', 'IMAGINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'PT-FR-9', 'Imagine', 'IMAGINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'Cisco C8200L-1N-4T', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'WS-C6513', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NE40E-X16A', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'C10008', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', '2801', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CX600-X2-M16A', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', '3725', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NE9000', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'Eudemon1000E-G55', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CE6863E-48S6CQ', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CE6881-48S6CQ', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CE6863-48S6CQ', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'Eudemon9000E-X8', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NE40E-X8A', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CE16804', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'MultiserviceEngine 60-X16A', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'Eudemon8000E-X8', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'S5328C-EI-24S Routing Switch', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'MultiserviceEngine 60-X3', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'CX600-X16A', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'mx480', 'JUNIPER NETWORKS', 'JUNIPER');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'AR28-11', 'Huawei', 'IP-U2000');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', '2921/K9', 'Cisco', 'CISCO');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NCA-1515A', 'Lanner', 'SDWAN');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NCA-5520C', 'Lanner', 'SDWAN');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NCA-1515B', 'Lanner', 'SDWAN');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NCA-4010Y', 'Lanner', 'SDWAN');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'FWA-1012VC-8C', 'Advantec', 'SDWAN');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NCA-5510A', 'Lanner', 'SDWAN');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'NCA4010D', 'Lanner', 'SDWAN');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Router', 'VMware Virtual Platform', 'VMware Inc', 'VMWARE INC');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'BTS3900A Ver.D', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'RBS6601', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'RBS 6601', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'OMB', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'DBS3900_UMTS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'RBS 6201', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'TMC', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'BTS3900_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'RBS6201', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'BTS5900', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'BTS3900L_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'BTS3900L_UMTS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'BTS3900', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'VIRTUAL_MICRO', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'BTS3900A_UMTS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'BTS3900_UMTS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'BTS5900L', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'BTS3900L_UMTS1', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'DBS3900_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'BTS3900A_MS1', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'BTS3812E_UMTS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'OMB', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'APM100_NodeB', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'RBS6201 V2', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', '3G Role Type # 1404897782095', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'RBS6201L', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('NodeB', 'RBS66014', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'RBS6201_3G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role3G', 'Ericsson RanBs_3G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'BTS3900A Ver.D', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'Ericsson RanBs_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS6601_LTE1', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS6201_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS 6601_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('eNodeB', 'DBS3900_LTE', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'OMB', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'TMC', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'BTS3900_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('eNodeB', 'RBS 6601', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'BTS5900', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('eNodeB', 'BTS3900L_LTE', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'BTS3900L_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'BTS3900', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS6201_4G_SRAN', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', '4G Role Type # 1686051837008', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('eNodeB', 'RBS 6201', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'SUP 6601_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS6201L_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'BTS5900L', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS 6101_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', '333333333333_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS6601L_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS6201 V2_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS6318_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('eNodeB', 'BTS3900A_LTE', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'BTS3900AL', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'DBS3900_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS 6201V2W_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS6101W_4G', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'RBS6101_LTE1', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Role4G', 'BTS3900A_MS1', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS3900A Ver.D', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'Ericsson RanBs', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS6601', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS 6201', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS 6601', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'OMB', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'TMC', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS3900_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS5900', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS3900L', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS3900', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS6201', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'VIRTUAL_MICRO', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'SUP 6601', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS6201L', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS5900L', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS3900L_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'DBS3900_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS3900A_MS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS 6101', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'APM100', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS59005G', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', '333333333333', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS6601L', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS6201 V2', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS6318', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'BTS3900AL', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS 6201V2W', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS6101W', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RanBs', 'RBS6101', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BSC', 'BSC6900_GSM', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BSC', 'BSC6910GSM', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('BSC', 'AXE', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RNC', 'BSC6900_UMTS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RNC', 'BSC6910UMTS', 'Huawei', 'U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('RNC', 'Ericsson RNC', 'Ericsson', 'Ericsson RAN ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'UMG8900', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'ORACLE_DRA', 'Oracle', 'ORACLE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'OSS', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'Selenio X100', 'Imagine', 'IMAGINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', '6800+', 'Imagine', 'IMAGINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'SelenioSystem', 'Imagine', 'IMAGINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'Quidway SessionEngine2300 SBC', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'CSCF', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'SPG', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'CCF', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'AGCF', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'UIM', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'vEPSN', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'IMS', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'vUGW', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'UDM', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'UPCF', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'vCG', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'MRP6600', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'CloudSE2980', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'EIR', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'ATS9900', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'vePDG', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'vUSN', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'CGP', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'vISBC', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'UGW9811', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'UPCC', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'SoftX3000', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'USN9810', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'UPORTAL', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'SE2900', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'ATS', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'Huawei DNS', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'SessionEngine2600', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'MRFP', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'UGC', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'USCDB', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'MEDIAX', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'ViewPoint', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'ENS', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'Eagle', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'FMCMGW', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'SHLR9200', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'MRS6100', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'ICS', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'SBC', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'vEIR', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'PCRF', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('COREELEMENT', 'Voice Switch', 'Siemens', 'SIEMENS');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MSS', 'MSC9880', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MGW', 'MGW', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('HSS', 'HSS9860', 'Huawei', 'Core U2020');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IPCLK', 'OSCILLOQUARTZ 5548C SSU', 'ADVA', 'ADVA OSCILLOQUARTZ');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IPCLK', 'PRS 5585', 'ADVA', 'ADVA OSCILLOQUARTZ');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IPCLK', 'OSA-3230B', 'ADVA', 'ADVA OSCILLOQUARTZ');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDU', 'MA5616', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDU', 'MA5818', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MDU', 'MA5811S', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'MA5600T', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'MA5800-X17', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'UA5000(IPMB)', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'UA5000(PVMV1)', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'MA5603T', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'AN5116-06B', 'Fiber Home', 'Fiberhome');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'AN6000-17', 'Fiber Home', 'Fiberhome');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'AN6000-7', 'Fiber Home', 'Fiberhome');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'MA5800-X7', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('MultiTechnologyAccess', 'MA5801-GP16', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RTN380AX', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RTN950II', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RTN380AXH', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'HT2010', 'HUGHES', 'JUPITER');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'MINI-LINK 6691', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'MINI-LINK 6693', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'AMM6PC', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'Default_Model_Hughes', 'HUGHES', 'JUPITER');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RDL3000 Edge', 'REDLINE', 'REDLINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'MINI-LINK 6352', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'OPTIX RTN 980', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'AMM20PB', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'MINI-LINK 6692', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'AMM 2P B', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'OPTIX RTN 950', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RDL3000 generic', 'REDLINE', 'REDLINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'HT2300', 'HUGHES', 'JUPITER');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RTN380', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'Nera Evolution Series-Metro', 'Nera', 'INVENDIS');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RDL3000 Ellipse', 'REDLINE', 'REDLINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RTN380 H', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'AMM20p', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RDL3000 Enterprise SU IA', 'REDLINE', 'REDLINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'OPTIX RTN 620', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'MINI-LINK 6366/4', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'HT2500', 'HUGHES', 'JUPITER');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RTG Connect', 'REDLINE', 'REDLINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'OPTIX RTN 980 L', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'XQI', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'MDRS 155EC', 'Ericsson', 'Ericsson MW ENM');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RDL2000', 'REDLINE', 'REDLINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'VSAT-iDirect Evolution_X3', 'iDirect', 'IMONITOR');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'B5x', 'AIRSPAN', 'AIRSPAN UNLICENSED MICROWAVE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'C5x', 'AIRSPAN', 'AIRSPAN UNLICENSED MICROWAVE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RDL3000 Elte MT IA', 'REDLINE', 'REDLINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'Default_VSAT', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'Paradise PD 10', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'Comtech 625', 'Generic', 'COMTECH');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'Comtech 625A', 'Generic', 'COMTECH');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'Paradise PD 25', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'HT2000', 'HUGHES', 'JUPITER');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('IDU', 'RDL3000 Enterprise SU', 'REDLINE', 'REDLINE');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'OSN6800', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'M6040V2', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'OSN8800', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'OSN8800P', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'M6100V1E', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'OSN1800VPro', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'M6100', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'OSN9800M24', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'OSN9800M12', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'WDM_OIS', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'WDM_OAS', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'WDM_OCS', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'OSN9800U32', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'M6100+', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'OSN9800P', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('WDM', 'Ciena6500', 'Ciena', 'CIENA');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', 'OSN2500', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', 'OSN1500', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', 'OSN3500', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', 'M3100', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', 'VNE', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', '155/622', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', 'M1000V3', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', 'M1050', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', '155/622H', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', 'OSN7500', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', '10G_MADM', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ADM', 'OSN9500', 'Huawei', 'U2000-TX');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:128', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:4', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:2', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:10', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32_8', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32_9', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32_4', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32_16', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32_1', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32_2', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32_3', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32_10', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('Optical_Splitter', 'Optical_Splitter_1:32_5', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ONT', 'MA5612', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ONT', 'AN5231-F24', 'Fiber Home', 'Fiberhome');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ONT', 'AN5006-20', 'Fiber Home', 'Fiberhome');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ONT', 'B650G', 'Huawei', 'U2000-Access');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ONT', 'AN550607', 'Fiber Home', 'Fiberhome');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'ODF', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'PILLAR TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'INTERNAL TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'OBC TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'WALL TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'PCM TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'TIE CABLE DP''S', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'AP', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'INTERNAL_32', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'POLE TYPE', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', '0', 'Generic', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('ODF', 'FTP', 'Huawei', '');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('DXX', '8150 Basic', 'Tellabs', 'TELLABS');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('DXX', '8120 Mini', 'Tellabs', 'TELLABS');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('DXX', '8170 Cluster', 'Tellabs', 'TELLABS');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('DXX', '8130 Micro', 'Tellabs', 'TELLABS');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('DXX', '8615 Smart Router', 'Tellabs', 'TELLABS');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('DXX', '8184 Access Switch', 'Tellabs', 'TELLABS');
INSERT INTO EMS_CONNECTIONS (NODE_TYPE, NE_TYPE, VENDOR, EMS_NAME) VALUES ('DXX', '8188 Access Switch', 'Tellabs', 'TELLABS');