INSERT [ManagedElementType] ([ManagedElementTypeGuid], [TypeName], [IsSingleInstance], [TableName], [ManagedElementGuidColumnName], [ME2CategoryID]) SELECT N'48ED14A8-7271-428D-8781-5EABBADE92D4', N'Win32_EncryptableVolume',0, 'Asset_Win32_EncryptableVolume', 'Win32_EncryptableVolumeGuid', 6 WHERE NOT EXISTS (SELECT * FROM [ManagedElementType] WHERE [ManagedElementTypeGuid] = '48ED14A8-7271-428D-8781-5EABBADE92D4')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'4EEE2E10-F43A-4A01-9199-E442F7578399', N'48ED14A8-7271-428D-8781-5EABBADE92D4', N'DeviceID', 1, 1, N'System.String', 0, N'nvarchar(1000)' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '4EEE2E10-F43A-4A01-9199-E442F7578399')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'70521403-8BB3-41C6-8BE9-19029125CFE3', N'48ED14A8-7271-428D-8781-5EABBADE92D4', N'PersistentVolumeID', 0, 1, N'System.String', 0, N'nvarchar(1000)' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '70521403-8BB3-41C6-8BE9-19029125CFE3')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'E3D4A949-9F4D-40D1-A1F4-E7511E5BFBDC', N'48ED14A8-7271-428D-8781-5EABBADE92D4', N'DriveLetter', 0, 1, N'System.String', 0, N'nvarchar(1000)' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = 'E3D4A949-9F4D-40D1-A1F4-E7511E5BFBDC')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'A5BF8E38-A3E2-48BD-9A37-695B73122C4F', N'48ED14A8-7271-428D-8781-5EABBADE92D4', N'ProtectionStatus', 0, 1, N'System.UInt32', 0, N'int' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = 'A5BF8E38-A3E2-48BD-9A37-695B73122C4F')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'446CFFB7-D26C-4E48-BC2C-09AD8436CBFC', N'48ED14A8-7271-428D-8781-5EABBADE92D4', N'ConversionStatus', 0, 1, N'System.UInt32', 0, N'int' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '446CFFB7-D26C-4E48-BC2C-09AD8436CBFC')
GO


INSERT [ManagedElementType] ([ManagedElementTypeGuid], [TypeName], [IsSingleInstance], [TableName], [ManagedElementGuidColumnName], [ME2CategoryID]) SELECT N'E895B890-94F7-4B61-B787-33F411A002CE', N'Win32_Tpm', 1, 'Asset_Win32_Tpm', 'Win32_TpmGuid', 6 WHERE NOT EXISTS (SELECT * FROM [ManagedElementType] WHERE [ManagedElementTypeGuid] = 'E895B890-94F7-4B61-B787-33F411A002CE')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'85064471-556B-401A-891D-F6BD40BABF03', N'E895B890-94F7-4B61-B787-33F411A002CE', N'IsActivated', 0, 1, N'System.Boolean', 0, N'bit' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '85064471-556B-401A-891D-F6BD40BABF03')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'9024BAE2-3AA2-4DA7-95EA-FFDBBB764D3A', N'E895B890-94F7-4B61-B787-33F411A002CE', N'IsEnabled', 0, 1, N'System.Boolean', 0, N'bit' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '9024BAE2-3AA2-4DA7-95EA-FFDBBB764D3A')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'569CC019-0A6D-47E8-BFF3-FD290AAAFE72', N'E895B890-94F7-4B61-B787-33F411A002CE', N'IsOwned', 0, 1, N'System.Boolean', 0, N'bit' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '569CC019-0A6D-47E8-BFF3-FD290AAAFE72')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'05B9ECF2-9090-4C0C-ABF8-2F9966473668', N'E895B890-94F7-4B61-B787-33F411A002CE', N'SpecVersion', 0, 1, N'System.String', 0, N'nvarchar(500)' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '05B9ECF2-9090-4C0C-ABF8-2F9966473668')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'4C2B3A69-613B-461E-BBD0-2DCFAE4A7351', N'E895B890-94F7-4B61-B787-33F411A002CE', N'ManufacturerVersion', 0, 1, N'System.String', 0, N'nvarchar(500)' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '4C2B3A69-613B-461E-BBD0-2DCFAE4A7351')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'76F7470F-86D4-4162-B8D5-450D139EB468', N'E895B890-94F7-4B61-B787-33F411A002CE', N'ManufacturerVersionInfo', 0, 1, N'System.String', 0, N'nvarchar(500)' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '76F7470F-86D4-4162-B8D5-450D139EB468')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'422FAA90-6879-46EF-AE0F-6038CE8A6782', N'E895B890-94F7-4B61-B787-33F411A002CE', N'ManufacturerId', 0, 1, N'System.UInt32', 0, N'bigint' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '422FAA90-6879-46EF-AE0F-6038CE8A6782')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'0ED964F0-417A-41B8-B960-98F81E4E17E2', N'E895B890-94F7-4B61-B787-33F411A002CE', N'PhysicalPresenceVersionInfo', 0, 1, N'System.String', 0, N'nvarchar(500)' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '0ED964F0-417A-41B8-B960-98F81E4E17E2')
GO