delete from tDataCollection where ServiceID = "D8843-DESKTOP01" insert into tDataCollection values (47, "D8843-DESKTOP01", null, null, null, null, null, null, null, null, "0", null, "Y", "2.27", "0.23", "2.50", "01-Oct-15 00:00", "01-Oct-15 16:33", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:33", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "DR_VMS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-DESKTOP02" insert into tDataCollection values (18, "D8843-DESKTOP02", null, null, null, null, null, null, null, null, "0", null, "Y", "2.27", "0.23", "2.50", "01-Oct-15 00:00", "01-Oct-15 16:33", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:33", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "DR_VMS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-DESKTOP03" insert into tDataCollection values (19, "D8843-DESKTOP03", null, null, null, null, null, null, null, null, "0", null, "Y", "2.27", "0.23", "2.50", "01-Oct-15 00:00", "01-Oct-15 16:34", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:34", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "DR_VMS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-DESKTOP04" insert into tDataCollection values (20, "D8843-DESKTOP04", null, null, null, null, null, null, null, null, "0", null, "Y", "2.27", "0.23", "2.50", "01-Oct-15 00:00", "01-Oct-15 16:34", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:34", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "DR_VMS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-DMZSVAUD01" insert into tDataCollection values (34, "D8843-DMZSVAUD01", null, null, null, null, null, null, null, null, "0", null, "Y", "1.18", "0.12", "1.30", "01-Oct-15 00:00", "01-Oct-15 08:36", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "08:36", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "ETOOLBOX", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-DMZSVIMSS01" insert into tDataCollection values (26, "D8843-DMZSVIMSS01", null, null, null, null, null, null, null, null, "0", null, "Y", "4.45", "0.45", "4.90", "01-Oct-15 00:00", "01-Oct-15 16:12", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:12", "Memory (GB)", "28.100", "1.000", "8.00", "MONTHLY", "DMZ", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-DMZSVNS01" insert into tDataCollection values (3, "D8843-DMZSVNS01", null, null, null, null, null, null, null, null, "0", null, "Y", "1.11", "0.11", "1.22", "01-Oct-15 00:00", "01-Oct-15 16:12", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:12", "Memory (GB)", "28.100", "1.000", "2.00", "MONTHLY", "DMZ", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-DMZSVPXY01" insert into tDataCollection values (37, "D8843-DMZSVPXY01", null, null, null, null, null, null, null, null, "0", null, "Y", "2.23", "0.22", "2.45", "01-Oct-15 00:00", "01-Oct-15 16:12", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:12", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "DMZ", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-DRDTVM001" insert into tDataCollection values (38, "D8843-DRDTVM001", null, null, null, null, null, null, null, null, "0", null, "Y", "0.38", "0.04", "0.42", "07-Oct-15 10:02", "07-Oct-15 15:39", "47547", "106", null, "07-Oct-15", "10:02", "07-Oct-15", "15:39", "Memory (GB)", "28.100", "1.000", "2.00", "MONTHLY", "DR_VMS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-ELIZABETH" insert into tDataCollection values (24, "D8843-ELIZABETH", null, null, null, null, null, null, null, null, "0", null, "Y", "1.13", "0.11", "1.24", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "2.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-JUNIPER_VSRX_CORE" insert into tDataCollection values (2, "D8843-JUNIPER_VSRX_CORE", null, null, null, null, null, null, null, null, "0", null, "Y", "0.03", "0.00", "0.03", "01-Oct-15 00:00", "01-Oct-15 10:49", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "10:49", "Storage (GB)", "0.150", "1.000", "16.00", "MONTHLY", "VAPP_SYSTEM_JUNIPER_VSRX", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-JUNIPER_VSRX_CORE2" insert into tDataCollection values (13, "D8843-JUNIPER_VSRX_CORE2", null, null, null, null, null, null, null, null, "0", null, "Y", "0.03", "0.00", "0.03", "01-Oct-15 00:00", "01-Oct-15 10:49", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "10:49", "Storage (GB)", "0.150", "1.000", "16.00", "MONTHLY", "VAPP_SYSTEM_VSRX2", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-JUNIPERVIRTUALSRX" insert into tDataCollection values (22, "D8843-JUNIPERVIRTUALSRX", null, null, null, null, null, null, null, null, "0", null, "Y", "0.00", "0.00", "0.00", "01-Oct-15 00:00", "01-Oct-15 16:52", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:52", "Storage (GB)", "0.150", "0.666", "1.80", "MONTHLY", "DRCRITICALVMS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVAPP01" insert into tDataCollection values (1, "D8843-MELSVAPP01", null, null, null, null, null, null, null, null, "0", null, "Y", "1.13", "0.11", "1.24", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "2.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVAPP07" insert into tDataCollection values (43, "D8843-MELSVAPP07", null, null, null, null, null, null, null, null, "0", null, "Y", "1.77", "0.18", "1.95", "01-Oct-15 00:00", "01-Oct-15 08:36", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "08:36", "Memory (GB)", "28.100", "1.000", "6.00", "MONTHLY", "ETOOLBOX", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVAPP09" insert into tDataCollection values (4, "D8843-MELSVAPP09", null, null, null, null, null, null, null, null, "0", null, "Y", "4.53", "0.45", "4.98", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "8.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVAPP10" insert into tDataCollection values (28, "D8843-MELSVAPP10", null, null, null, null, null, null, null, null, "0", null, "Y", "2.26", "0.23", "2.49", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVDBP01" insert into tDataCollection values (7, "D8843-MELSVDBP01", null, null, null, null, null, null, null, null, "0", null, "Y", "2.26", "0.23", "2.49", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVDBP02" insert into tDataCollection values (9, "D8843-MELSVDBP02", null, null, null, null, null, null, null, null, "0", null, "Y", "3.38", "0.34", "3.72", "08-Oct-15 09:56", "08-Oct-15 16:06", "47547", "106", null, "08-Oct-15", "09:56", "08-Oct-15", "16:06", "Memory (GB)", "28.100", "1.000", "16.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVDBP04" insert into tDataCollection values (10, "D8843-MELSVDBP04", null, null, null, null, null, null, null, null, "0", null, "Y", "4.53", "0.45", "4.98", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "8.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVDBP06" insert into tDataCollection values (44, "D8843-MELSVDBP06", null, null, null, null, null, null, null, null, "0", null, "Y", "7.09", "0.71", "7.80", "01-Oct-15 00:00", "01-Oct-15 08:36", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "08:36", "Memory (GB)", "28.100", "1.000", "24.00", "MONTHLY", "ETOOLBOX", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVDBP07" insert into tDataCollection values (11, "D8843-MELSVDBP07", null, null, null, null, null, null, null, null, "0", null, "Y", "4.53", "0.45", "4.98", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "8.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVDBP09" insert into tDataCollection values (39, "D8843-MELSVDBP09", null, null, null, null, null, null, null, null, "0", null, "Y", "9.04", "0.91", "9.95", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "16.00", "MONTHLY", "TRIM", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVDC01" insert into tDataCollection values (29, "D8843-MELSVDC01", null, null, null, null, null, null, null, null, "0", null, "Y", "2.20", "0.22", "2.42", "01-Oct-15 00:00", "01-Oct-15 16:00", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:00", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "DOMAINCONTROLLERS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVDC02" insert into tDataCollection values (30, "D8843-MELSVDC02", null, null, null, null, null, null, null, null, "0", null, "Y", "2.20", "0.22", "2.42", "01-Oct-15 00:00", "01-Oct-15 16:01", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:01", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "DOMAINCONTROLLERS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVDC03" insert into tDataCollection values (31, "D8843-MELSVDC03", null, null, null, null, null, null, null, null, "0", null, "Y", "2.20", "0.22", "2.42", "01-Oct-15 00:00", "01-Oct-15 16:00", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:00", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "DOMAINCONTROLLERS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVGPA01" insert into tDataCollection values (27, "D8843-MELSVGPA01", null, null, null, null, null, null, null, null, "0", null, "Y", "1.69", "0.17", "1.86", "08-Oct-15 09:56", "08-Oct-15 16:06", "47547", "106", null, "08-Oct-15", "09:56", "08-Oct-15", "16:06", "Memory (GB)", "28.100", "1.000", "8.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVINM09" insert into tDataCollection values (46, "D8843-MELSVINM09", null, null, null, null, null, null, null, null, "0", null, "Y", "1.11", "0.11", "1.22", "01-Oct-15 00:00", "01-Oct-15 16:12", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:12", "Memory (GB)", "28.100", "1.000", "2.00", "MONTHLY", "SYSTEM", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVINP05" insert into tDataCollection values (15, "D8843-MELSVINP05", null, null, null, null, null, null, null, null, "0", null, "Y", "0.28", "0.03", "0.31", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "0.50", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVINP22" insert into tDataCollection values (17, "D8843-MELSVINP22", null, null, null, null, null, null, null, null, "0", null, "Y", "2.23", "0.22", "2.45", "01-Oct-15 00:00", "01-Oct-15 16:12", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:12", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "SYSTEM", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVINP27" insert into tDataCollection values (6, "D8843-MELSVINP27", null, null, null, null, null, null, null, null, "0", null, "Y", "4.54", "0.46", "5.00", "01-Oct-15 00:00", "01-Oct-15 16:33", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:33", "Memory (GB)", "28.100", "1.000", "8.00", "MONTHLY", "MELFILE", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVINP34" insert into tDataCollection values (45, "D8843-MELSVINP34", null, null, null, null, null, null, null, null, "0", null, "Y", "6.84", "0.68", "7.52", "01-Oct-15 00:00", "01-Oct-15 16:35", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:35", "Memory (GB)", "28.100", "1.000", "12.00", "MONTHLY", "EXCHANGE", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVITP07" insert into tDataCollection values (12, "D8843-MELSVITP07", null, null, null, null, null, null, null, null, "0", null, "Y", "2.23", "0.22", "2.45", "01-Oct-15 00:00", "01-Oct-15 16:12", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:12", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "DMZ", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVITP09" insert into tDataCollection values (14, "D8843-MELSVITP09", null, null, null, null, null, null, null, null, "0", null, "Y", "1.18", "0.12", "1.30", "01-Oct-15 00:00", "01-Oct-15 08:36", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "08:36", "Memory (GB)", "28.100", "1.000", "4.00", "MONTHLY", "ETOOLBOX", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVITP10" insert into tDataCollection values (41, "D8843-MELSVITP10", null, null, null, null, null, null, null, null, "0", null, "Y", "0.11", "0.01", "0.12", "01-Oct-15 00:00", "01-Oct-15 08:36", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "08:36", "Memory (GB)", "28.100", "1.000", "0.38", "MONTHLY", "ETOOLBOX", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVITP15" insert into tDataCollection values (42, "D8843-MELSVITP15", null, null, null, null, null, null, null, null, "0", null, "Y", "1.77", "0.18", "1.95", "01-Oct-15 00:00", "01-Oct-15 08:36", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "08:36", "Memory (GB)", "28.100", "1.000", "6.00", "MONTHLY", "ETOOLBOX", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-MELSVTRIMP02" insert into tDataCollection values (25, "D8843-MELSVTRIMP02", null, null, null, null, null, null, null, null, "0", null, "Y", "4.53", "0.45", "4.98", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "8.00", "MONTHLY", "TRIM", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-RATHDOWNE" insert into tDataCollection values (32, "D8843-RATHDOWNE", null, null, null, null, null, null, null, null, "0", null, "Y", "2.15", "0.22", "2.37", "01-Oct-15 00:00", "01-Oct-15 16:28", "47547", "106", null, "01-Oct-15", "00:00", "01-Oct-15", "16:28", "Memory (GB)", "28.100", "1.000", "3.81", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-VBAFWTEST1" insert into tDataCollection values (21, "D8843-VBAFWTEST1", null, null, null, null, null, null, null, null, "0", null, "Y", "0.24", "0.02", "0.26", "01-Oct-15 10:57", "01-Oct-15 14:21", "47547", "106", null, "01-Oct-15", "10:57", "01-Oct-15", "14:21", "Memory (GB)", "28.100", "1.000", "2.00", "MONTHLY", "APPS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-VBAFWTEST2" insert into tDataCollection values (33, "D8843-VBAFWTEST2", null, null, null, null, null, null, null, null, "0", null, "Y", "0.28", "0.03", "0.31", "01-Oct-15 10:58", "01-Oct-15 15:06", "47547", "106", null, "01-Oct-15", "10:58", "01-Oct-15", "15:06", "Memory (GB)", "28.100", "1.000", "2.00", "MONTHLY", "DRCRITICALVMS", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-VSRX" insert into tDataCollection values (40, "D8843-VSRX", null, null, null, null, null, null, null, null, "0", null, "Y", "2.18", "0.22", "2.40", "01-Oct-15 00:00", "31-Oct-15 23:59", "47547", "106", null, "01-Oct-15", "00:00", "31-Oct-15", "23:59", "Storage (GB)", "0.150", "1.000", "16.00", "MONTHLY", "MEDIAANDTEMPLATEFILES", null, null, null, null, null, null, "0", null) delete from tDataCollection where ServiceID = "D8843-WIN7PRO-DR.ISO" insert into tDataCollection values (5, "D8843-WIN7PRO-DR.ISO", null, null, null, null, null, null, null, null, "0", null, "Y", "1.13", "0.11", "1.24", "01-Oct-15 00:00", "31-Oct-15 23:59", "47547", "106", null, "01-Oct-15", "00:00", "31-Oct-15", "23:59", "Storage (GB)", "0.150", "1.000", "8.26", "MONTHLY", "MEDIAANDTEMPLATEFILES", null, null, null, null, null, null, "0", null)