 ('MGSB901', NULL, 'SNB', 'Jawa Timur', 'Ericsson', NULL, 'In Service', '2015-07-27', '7421 (dual stack)\r\n7422 (triple stack)'),
 ('MGSB902', NULL, 'SNB', 'Jawa Timur', 'Ericsson', NULL, 'In Service', '2015-07-27', '7501 (dual stack)\r\n7502 (triple stack)'),
 ('MGSD101', NULL, 'Situbondo', 'Jawa Timur', 'Ericsson', NULL, 'In Service', '2015-07-27', '7528 (dual stack)\r\n7529 (triple stack)'),
+('MGSG101', NULL, 'Not Set', 'Lain-lain', 'Not Set', NULL, 'In Service', '2015-07-31', ''),
 ('MGSG102', NULL, 'Ampenan (Senggigi)', 'NTB', 'Ericsson', NULL, 'In Service', '2015-07-27', '7433 (dual stack)\r\n7434 (triple stack)'),
 ('MGSG201', '62818445647', 'Senggigi MGSG201', 'not set', 'Not Set', NULL, 'In Service', NULL, NULL),
 ('MGSG202', NULL, 'Pengambengan', 'not set', 'Not Set', NULL, 'In Service', NULL, NULL),

('BJKT33', NULL, 'Supernode Kalideres', 'DKI Jakarta', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BJKT34', NULL, 'Supernode Cempaka Putih', 'DKI Jakarta', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BJKT35', NULL, 'Senen Supernode (Existing)', 'DKI Jakarta', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BKBM04', NULL, 'HUT Prembun', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BKBM05', NULL, 'HUT Prembun', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BKBM1', NULL, 'HUT Kebumen', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BKBM2', NULL, 'HUT Kebumen', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BKBM3', NULL, 'HUT Prembun', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BKRW02', NULL, 'HUT Karawang', 'Jawa Barat', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BKRW1', NULL, 'HUT Karawang', 'Jawa Barat', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BLBA03', NULL, 'HUT Labuan', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BLBA1', NULL, 'HUT Labuan', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BLBA2', NULL, 'HUT Labuan', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BLBK1', NULL, 'HUT Kethug', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BMGL1', NULL, 'HUT Magelang', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BNN', NULL, 'not set', 'not set', 'Not Set', NULL, 'In Service', NULL, NULL),
('BPKL1', NULL, 'HUT Pekalongan', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BPKL2', NULL, 'HUT Pekalongan', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BPML1', NULL, 'HUT Pemalang', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BPML2', NULL, 'HUT Pemalang', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BPWD1', NULL, 'HUT Purwodadi', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BPWD2', NULL, 'HUT Purwodadi', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BPWT1', NULL, 'HUT Porwokerto', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BPWT2', NULL, 'HUT Purwokerto', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSKB1', NULL, 'HUT Sukabumi', 'Jawa Barat', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSKB2', NULL, 'HUT Sukabumi', 'Jawa Barat', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSMG05', NULL, 'SN Gombel', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSMG2', NULL, 'HUT Poncol', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSMG3', NULL, 'HUT Alas Tuo', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSMG4', NULL, 'HUT Alas Tuo', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSOL04', NULL, 'SN Solo', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSOL1', NULL, 'HUT Solo', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSOL2', NULL, 'HUT SOLO', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSOL3', NULL, 'HUT Sukorjo', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSRG03', NULL, 'HUT Serang', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSRG1', NULL, 'HUT Serang', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSRG2', NULL, 'HUT Serang', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BSRP1', NULL, 'HUT Puspitek', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', '\r\n'),
('BSRP2', NULL, 'HUT Puspitek', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BTGL1', NULL, 'HUT Tegal', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BTGL2', NULL, 'HUT Tegal', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BTGR1', NULL, 'HUT Kampung Koang', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BTGR2', NULL, 'HUT Kampung Koang', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BTR-MMX10', '62818445766', 'not set', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', '25/08/2009 (changed from STP33)'),
('BTR-MMX11', '62818445762', 'not set', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', '25/08/2009 (changed from STP29)'),
('BTR-MMX12', '62818445763', 'not set', 'not set', 'Not Set', '62818445131', 'In Service', '0000-00-00', '25/08/2009 (changed from STP30)'),
('BTR-MMX13', '62818445764', 'not set', 'not set', 'Not Set', NULL, 'In Service', '0000-00-00', '25/08/2009 (changed from STP31)'),
('BTR-MMX14', NULL, 'not set', 'not set', 'Not Set', NULL, 'In Service', NULL, NULL),
('BWLR1', NULL, 'HUT Weleri', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BWLR2', NULL, 'HUT Weleri', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('BWNS1', NULL, 'HUT wonosari', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),

('RNSMG04', NULL, 'HUT Alas Tuo', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('RNSMG05', NULL, 'HUT Poncol', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('RNSRG01', NULL, 'HUT Serang', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('RNSRG02', NULL, 'HUT Serang', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', '');
INSERT INTO `network_element` (`network_element_id`, `gt_address`, `location`, `provinsi`, `vendor`, `gtt`, `status`, `log_date`, `remark`) VALUES
('RNTGL02', NULL, 'HUT Tegal', 'Jawa Tengah', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('RNTGR01', NULL, 'HUT Kampung Koang', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
('RNTGR02', NULL, 'Supernode Raya Bitung', 'Banten', 'Ericsson', NULL, 'In Service', '2015-07-28', ''),
