INSERT [ManagedElementType] ([ManagedElementTypeGuid], [TypeName], [IsSingleInstance], [TableName], [ManagedElementGuidColumnName], [ME2CategoryID]) SELECT N'438190c4-f004-4071-9418-7e2df9d650a3', N'BitlockerRecoveryKey',0, 'Asset_BitlockerRecoveryKey', 'BitlockerRecoveryKeyGuid', 6 WHERE NOT EXISTS (SELECT * FROM [ManagedElementType] WHERE [ManagedElementTypeGuid] = '438190c4-f004-4071-9418-7e2df9d650a3')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'406df701-a85a-48d7-ac41-aff6c6c66cb6', N'438190c4-f004-4071-9418-7e2df9d650a3', N'DriveLetter', 1, 1, N'System.String', 0, N'nvarchar(1000)' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = '406df701-a85a-48d7-ac41-aff6c6c66cb6')
GO
INSERT [ManagedElementAttributeType] ([ManagedElementAttributeTypeGuid], [ManagedElementTypeGuid],[AttributeName], [IsKey], [IsMonitored], [DataType], [IsArray], [SqlDataType]) SELECT N'c74ec341-5bba-445e-9e47-bf42d21c5135', N'438190c4-f004-4071-9418-7e2df9d650a3', N'BitlockerRecoveryKey', 0, 1, N'System.String', 0, N'nvarchar(1000)' WHERE NOT EXISTS (SELECT * FROM [ManagedElementAttributeType] WHERE [ManagedElementAttributeTypeGuid] = 'c74ec341-5bba-445e-9e47-bf42d21c5135')
GO