<ObjectTemplate ID="DataConsumer.Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms" TypeID="LFX!System.LinkingFramework.DataConnector.Projection">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/DataConnectorName$">MomStore</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/IsProvider$">False</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/SolutionName$">SCCM-v5-Inventory</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/EntryPoint$">Microsoft.EnterpriseManagement.ServiceManager.Linking.Consumer.OperationalStore.OperationalStoreConsumer</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/EntryAssembly$">Microsoft.EnterpriseManagement.ServiceManager.Linking.Consumer.OperationalStore, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/InstallSQLScripts$"><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_LogicalDevices]') is null
drop view [LFXSTG].[v_Cached_CMv5_LogicalDevices];
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_LogicalDevices] AS
SELECT D.Lfx_RowId,
D.Lfx_SourceID,
(CASE
WHEN ISNULL(E.Lfx_Timestamp,''1900-01-01'') > ISNULL(CS.Lfx_Timestamp,''1900-01-01'')
AND ISNULL(E.Lfx_Timestamp,''1900-01-01'') > ISNULL(D.Lfx_Timestamp,''1900-01-01'')
THEN E.Lfx_Timestamp
WHEN ISNULL(CS.Lfx_Timestamp,''1900-01-01'') > ISNULL(E.Lfx_Timestamp,''1900-01-01'')
AND ISNULL(CS.Lfx_Timestamp,''1900-01-01'') > ISNULL(D.Lfx_Timestamp,''1900-01-01'')
THEN CS.Lfx_Timestamp
ELSE D.Lfx_Timestamp END) AS Lfx_Timestamp,
D.Lfx_Status,
D.Name0 AS ''DisplayName'',
COALESCE(D.SMS_Unique_Identifier0, D.EAS_DeviceID0) AS ''Id'',
E.DeviceImei,
COALESCE(D.Operating_System_Name_and0, E.DeviceOS) AS ''DeviceOS'',
E.DevicePhoneNumber,
E.DeviceMobileOperator,
E.DeviceModel,
E.ExchangeServer,
CS.DeviceManufacturer0 AS ''DeviceManufacturer'',
CS.FirmwareVersion0 AS ''FirmwareVersion'',
CS.HardwareVersion0 AS ''HardwareVersion'',
CS.OEM0 AS ''OEM'',
D.CPUType0 AS ''ProcessorType''
FROM LFXSTG.CMv5_SYSTEM D
LEFT JOIN LFXSTG.CMv5_EAS_PROPERTY E
ON D.EAS_DeviceID0 = E.EAS_Identity AND D.Lfx_SourceId = E.Lfx_SourceId
LEFT JOIN LFXSTG.CMv5_DEVICE_COMPUTERSYSTEM CS
ON D.ResourceID = CS.ResourceID AND D.Lfx_SourceId = CS.Lfx_SourceId
WHERE (D.Client_Type0 = 3 OR D.EAS_DeviceID0 IS NOT NULL)
');
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_DeviceOperatingSystems]') is null
drop view [LFXSTG].[v_Cached_CMv5_DeviceOperatingSystems]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_DeviceOperatingSystems] AS
SELECT OS.Lfx_RowId AS Lfx_RowId,
OS.Lfx_SourceId,
(case
when isnull(OS.Lfx_Timestamp,''1900-01-01'') > isnull(S.Lfx_Timestamp,''1900-01-01'')
then OS.Lfx_Timestamp
else S.Lfx_Timestamp end) AS Lfx_Timestamp,
OS.[Lfx_Status] as Lfx_Status,
COALESCE(S.SMS_Unique_Identifier0, S.EAS_DeviceID0) AS ''Id'',
COALESCE(OS.Platform0, S.Operating_System_Name_and0) AS ''DisplayName'',
COALESCE(OS.Platform0, S.Operating_System_Name_and0) AS ''Name'',
COALESCE(OS.Version0, '''') AS ''Version'',
COALESCE(OS.Platform0, '''') AS ''Publisher'',
COALESCE(OS.Language0, '''') AS ''Language''
FROM [LFXSTG].CMv5_DEVICE_OPERATING_SYSTEM OS
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON OS.ResourceID=S.ResourceID AND OS.Lfx_SourceId = S.Lfx_SourceId
WHERE (S.Client_Type0 = 3 OR S.EAS_DeviceID0 IS NOT NULL)
AND S.Lfx_Status = ''U''
')
</Script><Script>
--- Processing for computers
if not object_id('[LFXSTG].[fn_CheckCMv5CachedComputers]') is null
drop function [LFXSTG].[fn_CheckCMv5CachedComputers];
exec ('
CREATE FUNCTION LFXSTG.fn_CheckCMv5CachedComputers(
@sourceID AS INT,
@resourceID AS INT,
@sms_identifier AS NVARCHAR(255),
@lfx_Status AS nvarchar(1)
)
RETURNS @LogicalComputers TABLE
(
Lfx_Status nvarchar(1),
Name0 nvarchar(64),
Domain0 nvarchar(255),
CurrentTimeZone0 int,
IsVirtualMachine bit
)
AS
BEGIN
-- implement detailed checking for deletion cases
-- if v_R_System has an update for ResourceID process the join unchanged.
-- In case of rename, the join on ResourceID will return two rows, one will be an update
-- representing the renamed computer, one will be a delete for the original computer
-- The two rows have same resource id but different group key.
IF (@lfx_Status = ''U'')
BEGIN
INSERT @LogicalComputers (Lfx_Status, Name0, Domain0,
CurrentTimeZone0, IsVirtualMachine)
SELECT CS.Lfx_Status,
CS.Name0,
CS.Domain0,
CS.CurrentTimeZone0,
(CASE WHEN COALESCE(CS.Model0,'''')=''Virtual Machine''
OR COALESCE(CS.Model0,'''')=''VMware Virtual Platform''
THEN ''True''
WHEN COALESCE(CS.Manufacturer0, '''')=''Microsoft Corporation''
OR COALESCE(CS.Manufacturer0, '''') = ''VMware, Inc.''
THEN ''True''
ELSE ''False''
END)
FROM LFXSTG.CMv5_COMPUTER_SYSTEM CS
WHERE CS.ResourceID = @resourceID
AND CS.Lfx_SourceID = @sourceID
END
ELSE
BEGIN
-- Process a deletion in v_R_System.
-- Check if there is a live computer with same previous SMS_UUID. If there is,
-- drop the delete if FQDN is the same as that of live computer.
DECLARE @liveComputerFQDN NVARCHAR(256)
-- get fields for current passed in computer
SELECT @deadComputerFQDN = FQDN,
@deadComputerHWID = Hardware_ID0,
@deadComputerSMBIOSGUID = SMBIOS_GUID0
FROM LFXSTG.CMv5_SYSTEM
WHERE ResourceID = @resourceID AND Lfx_SourceId = @sourceID
-- get FQDN for any live computer with same previous SMS_UUID OR
-- if the SMBIOSGUID and HWID are the same. In some reimage cases, the
-- previous SMS_UUID may not populated at the time we run the query (because
-- Delete Aged Discovery hasnt run?) there is another row with same HWID and SMBIOSGUID.
-- That should indicate there is a live computer, hence check if name is same
SELECT @liveComputerFQDN = FQDN
FROM LFXSTG.CMv5_SYSTEM
WHERE ((Previous_SMS_UUID0 = @sms_identifier)
OR (Hardware_ID0 = @deadComputerHWID AND SMBIOS_GUID0 = @deadComputerSMBIOSGUID))
AND Lfx_SourceId = @sourceID
AND ResourceID != @resourceID
AND Lfx_Status = ''U''
IF (@liveComputerFQDN IS NOT NULL)
BEGIN
IF (@liveComputerFQDN = @deadComputerFQDN)
BEGIN
-- status changed to skip this delete. Outer query filters by this
SET @lfx_Status = ''I''
END
END
-- prepare the deletion row to be inserted, either we permit the delete or place
-- a dummy status to filter it out. The status from v_R_System overrides any status
-- in V_GS_COMPUTER_SYSTEM in case of delete.
INSERT @LogicalComputers (Lfx_Status, Name0, Domain0,
CurrentTimeZone0, IsVirtualMachine)
SELECT @lfx_Status,
CS.Name0, -- name of deleted computer
CS.Domain0, -- domain of deleted computer
CS.CurrentTimeZone0,
(CASE WHEN COALESCE(CS.Model0,'''')=''Virtual Machine''
OR COALESCE(CS.Model0,'''')=''VMware Virtual Platform''
THEN ''True''
WHEN COALESCE(CS.Manufacturer0, '''')=''Microsoft Corporation''
OR COALESCE(CS.Manufacturer0, '''') = ''VMware, Inc.''
THEN ''True''
ELSE ''False''
END)
FROM LFXSTG.CMv5_COMPUTER_SYSTEM CS
WHERE CS.ResourceID = @resourceID
AND CS.Lfx_SourceId = @sourceID
END
RETURN
END
');
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_PhysicalComputers]') is null
drop view [LFXSTG].[v_Cached_CMv5_PhysicalComputers];
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_PhysicalComputers] AS
SELECT S.Lfx_RowId AS Lfx_RowId,
S.Lfx_SourceId,
(case
when isnull(S.Lfx_Timestamp,''1900-01-01'') > isnull(CS.Lfx_Timestamp,''1900-01-01'')
then S.Lfx_Timestamp
else CS.Lfx_Timestamp end) AS Lfx_Timestamp,
S.Lfx_Status,
CS.Name0 AS ''DisplayName'',
CS.Model0 AS ''Model'',
CS.NumberOfProcessors0 AS ''NumberOfProcessors'',
CS.SystemType0 AS ''SystemType'',
S.Hardware_ID0 AS ''HardwareId'',
S.SMBIOS_GUID0 AS ''SMBIOS_UUID'',
COALESCE(E.SMBIOSAssetTag0,'''') AS ''SMBIOSAssetTag'',
CS.Manufacturer0 AS ''Manufacturer'',
E.ChassisTypes0 AS ''ChassisType'',
E.SerialNumber0 AS ''SerialNumber''
FROM [LFXSTG].CMv5_SYSTEM S
LEFT JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
AND CS.Lfx_Status = ''U''
LEFT JOIN LFXSTG.CMv5_SYSTEM_ENCLOSURE E
ON E.ResourceID=S.ResourceID
AND E.Lfx_SourceId = S.Lfx_SourceId
AND E.Lfx_Status = ''U''
WHERE S.Hardware_ID0 IS NOT NULL
');
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_LogicalComputers]') is null
drop view [LFXSTG].[v_Cached_CMv5_LogicalComputers];
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_LogicalComputers] AS
SELECT S.Lfx_RowId,
S.Lfx_SourceID,
S.Lfx_Timestamp,
CCX.Lfx_Status,
CCX.Name0 AS ''DisplayName'',
COALESCE(CCX.Name0, S.Netbios_Name0)
+ ''.'' + COALESCE(CCX.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
S.Netbios_Name0 AS ''NetbiosComputerName'',
S.Resource_Domain_OR_Workgr0 AS ''NetbiosDomainName'',
CCX.CurrentTimeZone0 AS ''OffsetInMinuteFromGreenwichTime'',
CCX.IsVirtualMachine,
W.LastHWScan AS ''LastInventoryDate'',
S.AD_Site_Name0 AS ''ActiveDirectorySite''
FROM LFXSTG.CMv5_SYSTEM S
CROSS APPLY
LFXSTG.fn_CheckCMv5CachedComputers(S.Lfx_SourceID, S.ResourceID, S.SMS_Unique_Identifier0, S.Lfx_Status) AS CCX
LEFT JOIN LFXSTG.CMv5_WORKSTATION_STATUS W
ON S.ResourceID = W.ResourceID AND S.Lfx_SourceId = W.Lfx_SourceId
WHERE S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CCX.Lfx_Status != ''I''
');
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_LogicalComputersOnPhysicalComputer]') is null
drop view [LFXSTG].[v_Cached_CMv5_LogicalComputersOnPhysicalComputer]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_LogicalComputersOnPhysicalComputer] AS
SELECT S.Lfx_RowId AS Lfx_RowId,
S.Lfx_SourceId,
(case
when isnull(S.Lfx_Timestamp,''1900-01-01'') > isnull(CS.Lfx_Timestamp,''1900-01-01'')
then S.Lfx_Timestamp
else CS.Lfx_Timestamp end) AS Lfx_Timestamp,
S.Lfx_Status as Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
S.Hardware_ID0 AS ''HardwareId'',
COALESCE(E.SMBIOSAssetTag0,'''') AS ''SMBIOSAssetTag''
FROM LFXSTG.CMv5_COMPUTER_SYSTEM CS
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON S.ResourceID=CS.ResourceID AND S.Lfx_SourceId = CS.Lfx_SourceId
LEFT JOIN LFXSTG.CMv5_SYSTEM_ENCLOSURE E
ON E.ResourceID=CS.ResourceID AND E.Lfx_SourceId = CS.Lfx_SourceId
WHERE S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND S.Hardware_ID0 IS NOT NULL
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_OperatingSystems]') is null
drop view [LFXSTG].[v_Cached_CMv5_OperatingSystems]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_OperatingSystems] AS
SELECT OS.Lfx_RowId AS Lfx_RowId,
OS.Lfx_SourceId,
(case
when isnull(OS.Lfx_Timestamp,''1900-01-01'') > isnull(S.Lfx_Timestamp,''1900-01-01'')
then OS.Lfx_Timestamp
else S.Lfx_Timestamp end) AS Lfx_Timestamp,
OS.[Lfx_Status] as Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
OS.Caption0 AS ''DisplayName'',
OS.Version0 AS ''OSVersion'',
OS.BuildNumber0 AS ''BuildNumber'',
OS.InstallDate0 AS ''InstallDate'',
OS.WindowsDirectory0 AS ''WindowsDirectory'',
OS.SystemDirectory0 AS ''SystemDrive'',
OS.CountryCode0 AS ''CountryCode'',
OS.Locale0 AS ''Locale'',
OS.Manufacturer0 AS ''Manufacturer'',
OS.OSLanguage0 AS ''OSLanguage'',
OS.TotalVisibleMemorySize0 AS ''PhysicalMemory'',
CS.NumberOfProcessors0 AS ''LogicalProcessors''
FROM LFXSTG.CMv5_OPERATING_SYSTEM OS
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON OS.ResourceID=S.ResourceID AND OS.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_LogicalDisks]') is null
drop view [LFXSTG].[v_Cached_CMv5_LogicalDisks]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_LogicalDisks] AS
SELECT (LD.Lfx_RowId) AS Lfx_RowId,
LD.Lfx_SourceId,
LD.Lfx_Timestamp AS Lfx_Timestamp,
LD.Lfx_Status AS Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
LD.Name0 AS ''DisplayName'',
LD.DeviceID0 AS ''DeviceID'',
LD.Name0 AS ''Name'',
LD.Description0 AS ''Description'',
LD.VolumeName0 AS ''VolumeName'',
LD.FileSystem0 AS ''FileSystem'',
LD.Compressed0 AS ''Compressed'',
LD.Size0 AS ''Size'',
LD.FreeSpace0 AS ''FreeSpace'',
LD.DriveType0 AS ''DriveType''
FROM LFXSTG.CMv5_LOGICAL_DISK LD
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON LD.ResourceID=S.ResourceID AND LD.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_PhysicalDisks]') is null
drop view [LFXSTG].[v_Cached_CMv5_PhysicalDisks]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_PhysicalDisks] AS
SELECT D.Lfx_RowId AS Lfx_RowId,
D.Lfx_SourceId,
D.Lfx_Timestamp AS Lfx_Timestamp,
D.Lfx_Status as Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
D.Name0 AS ''DisplayName'',
D.DeviceID0 AS ''DeviceID'',
D.Name0 AS ''Name'',
D.Description0 AS ''Description'',
D.MediaType0 AS ''MediaType'',
D.PNPDeviceID0 AS ''PNPDeviceId'',
D.Description0 AS ''Caption'',
D.Index0 AS ''Index'',
D.InterfaceType0 AS ''InterfaceType'',
D.Manufacturer0 AS ''Manufacturer'',
D.Model0 AS ''Model'',
D.SCSIBus0 AS ''SCSIBus'',
D.SCSILogicalUnit0 AS ''SCSILogicalUnit'',
D.SCSIPort0 AS ''SCSIPort'',
D.SCSITargetId0 AS ''SCSITargetID'',
D.Size0 AS ''Size''
FROM LFXSTG.CMv5_DISK D
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON D.ResourceID=S.ResourceID AND D.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_Processors]') is null
drop view [LFXSTG].[v_Cached_CMv5_Processors]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_Processors] AS
SELECT P.Lfx_RowId AS Lfx_RowId,
P.Lfx_SourceId,
P.Lfx_Timestamp AS Lfx_Timestamp,
P.Lfx_Status as Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
P.Name0 AS ''DisplayName'',
P.DeviceID0 AS ''DeviceID'',
P.Name0 AS ''Name'',
P.Name0 AS ''Description'',
P.Family0 AS ''Family'',
P.MaxClockSpeed0 AS ''MaxClockSpeed'',
P.ProcessorType0 AS ''Type'',
P.BrandID0 AS ''BrandId'',
P.PCache0 AS ''PCache'',
P.CPUKey0 AS ''CPUKey'',
(CASE WHEN ISNULL(P.IsMobile0, 0) = 0 THEN ''False''
ELSE ''True'' END) AS ''IsMobile'',
(CASE WHEN ISNULL(P.IsMultiCore0, 0) = 0 THEN ''False''
ELSE ''True'' END) AS ''IsMulticore'',
P.Manufacturer0 AS ''Manufacturer'',
P.NormSpeed0 AS ''Speed'',
P.DataWidth0 AS ''DataWidth'',
P.Revision0 AS ''Revision'',
P.Version0 AS ''Version''
FROM LFXSTG.CMv5_PROCESSOR P
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON P.ResourceID=S.ResourceID AND P.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_NetworkAdapters]') is null
drop view [LFXSTG].[v_Cached_CMv5_NetworkAdapters]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_NetworkAdapters] AS
SELECT N.Lfx_RowId AS Lfx_RowId,
N.Lfx_SourceId,
(case
when isnull(N.Lfx_Timestamp,''1900-01-01'') > isnull(NC.Lfx_Timestamp,''1900-01-01'')
then N.Lfx_Timestamp
else NC.Lfx_Timestamp end) AS Lfx_Timestamp,
N.Lfx_Status as Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
N.Name0 AS ''DisplayName'',
N.DeviceID0 AS ''DeviceID'',
N.Name0 AS ''Name'',
N.Description0 AS ''Description'',
ISNULL(N.Speed0, 0) AS ''Bandwidth'',
ISNULL(N.MaxSpeed0, 0) AS ''MaxSpeed'',
N.ProductName0 AS ''ProductName'',
NC.DefaultIPGateway0 AS ''DefaultIPGateway'',
NC.DHCPServer0 AS ''DHCPHostname'',
(CASE WHEN ISNULL(NC.IPEnabled0, 0) = 0 THEN ''False''
ELSE ''True'' END) AS ''IPEnabled'',
N.AdapterType0 AS ''AdapterType'',
NC.Index0 AS ''Index'',
N.Manufacturer0 AS ''Manufacturer'',
N.MACAddress0 AS ''MACAddress'',
N.ServiceName0 AS ''ServiceName'',
NC.DHCPEnabled0 AS ''DHCPEnabled'',
NC.DHCPServer0 AS ''DHCPServer'',
NC.DNSDomain0 AS ''DNSDomain'',
NC.IPAddress0 AS ''IPAddress'',
NC.IPSubnet0 AS ''IPSubnet''
FROM LFXSTG.CMv5_NETWORK_ADAPTER N
INNER JOIN LFXSTG.CMv5_NETWORK_ADAPTER_CONFIGUR NC
ON N.MACAddress0 = NC.MACAddress0
AND N.ServiceName0 = NC.ServiceName0
AND N.ResourceID = NC.ResourceID
AND N.Lfx_SourceId = NC.Lfx_SourceId
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON N.ResourceID=S.ResourceID AND N.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE N.MACAddress0 IS NOT NULL
AND N.ServiceName0 != ''RasPppoe'' AND N.ServiceName0 != ''PptpMiniport''
AND NC.IPEnabled0 != 0
AND S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_DeviceHasSoftwareItemsInstalled]') is null
drop view [LFXSTG].[v_Cached_CMv5_DeviceHasSoftwareItemsInstalled]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_DeviceHasSoftwareItemsInstalled] AS
SELECT SW.Lfx_RowId AS Lfx_RowId,
SW.Lfx_SourceId,
SW.Lfx_Timestamp,
SW.Lfx_Status as Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
ISNULL(SW.ProductName0, '''') AS ''ProductName'',
ISNULL(SW.ProductVersion0, '''') AS ''VersionString'',
ISNULL(SW.Publisher0, '''') AS ''Publisher'',
ISNULL(SW.Language0, 0) AS ''LocaleID'',
SW.ProductName0 AS ''SoftwareDisplayName'',
SW.InstallDate0 AS ''InstalledDate'',
SW.InstalledLocation0 AS ''InstalledPath'',
SW.ProductID0 AS ''SerialNumber'',
(CASE WHEN SW.InstallType0 = 1 THEN ''True'' ELSE ''False'' END) AS ''IsVirtualApplication'',
SW.SoftwareCode0 AS ''ProductCode''
FROM LFXSTG.CMv5_INSTALLED_SOFTWARE SW
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON SW.ResourceID=S.ResourceID AND SW.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE ((SW.ProductName0 IS NOT NULL)
OR (SW.ProductVersion0 IS NOT NULL)
OR (SW.Publisher0 IS NOT NULL))
AND S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_AdminCategories]') is null
drop view [LFXSTG].[v_Cached_CMv5_AdminCategories]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_AdminCategories] AS
SELECT LCI.Lfx_RowId AS Lfx_RowId,
LCI.Lfx_SourceId,
LCI.Lfx_Timestamp,
LCI.Lfx_Status as Lfx_Status,
COALESCE(LCI.CategoryInstanceName, '''') AS ''Name'',
LCI.LocaleID
FROM LFXSTG.CMv5_LOCALIZEDCATEGORYINSTANCES LCI
INNER JOIN [LFXSTG].CMv5_CATEGORYINSTANCES CI
ON LCI.CategoryInstanceID = CI.CategoryInstanceID
AND LCI.Lfx_SourceId = CI.Lfx_SourceId
WHERE CI.CategoryTypeName = ''AppCategories''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_DCMConfigItems]') is null
drop view [LFXSTG].[v_Cached_CMv5_DCMConfigItems]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_DCMConfigItems] AS
SELECT CI.Lfx_RowId,
CI.Lfx_SourceId,
(CASE WHEN ISNULL(CI.Lfx_Timestamp,''1900-01-01'') > ISNULL(LOC.Lfx_Timestamp,''1900-01-01'')
THEN CI.Lfx_Timestamp
WHEN ISNULL(LOC.Lfx_Timestamp,''1900-01-01'') > ISNULL(CI.Lfx_Timestamp,''1900-01-01'')
THEN LOC.Lfx_Timestamp
ELSE ISNULL(CI.Lfx_Timestamp,''1900-01-01'') END) AS ''Lfx_Timestamp'',
CI.Lfx_Status,
CI.CI_UniqueID AS ''UniqueID'',
COALESCE(LOC.DisplayName, ELOC.DisplayName) AS ''DisplayName'',
COALESCE(LOC.Description, ELOC.Description) AS ''Description'',
CI.SDMPackageDigest,
(CASE WHEN CI.CIType_ID = 2 THEN ''True'' ELSE ''False'' END) AS ''IsBaseline''
FROM LFXSTG.CMv5_CONFIGURATIONITEMS CI
INNER JOIN LFXSTG.CMv5_LOCALIZEDCIPROPERTIES ELOC
ON CI.CI_ID = ELOC.CI_ID
AND ((ELOC.LocaleID & 0x00FF) = 0x0009)
AND CI.Lfx_SourceId = ELOC.Lfx_SourceId
LEFT JOIN LFXSTG.CMv5_LOCALIZEDCIPROPERTIES LOC
ON CI.CI_ID = LOC.CI_ID
AND LOC.LocaleID = $SMLOC
AND LOC.Lfx_Status = ''U''
AND CI.Lfx_SourceId = LOC.Lfx_SourceId
WHERE CI.CIType_ID in (2, 3, 4, 5)
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_DCMConfigItemRelations]') is null
drop view [LFXSTG].[v_Cached_CMv5_DCMConfigItemRelations]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_DCMConfigItemRelations] AS
SELECT CIR.Lfx_RowId,
CIR.Lfx_SourceId,
CIR.Lfx_Timestamp,
CIR.Lfx_Status,
SRC.CI_UniqueID AS ''FromCI_UniqueID'',
TAR.CI_UniqueID AS ''ToCI_UniqueID'',
CIR.RelationType AS ''RelType''
FROM LFXSTG.CMv5_CONFIGURATIONITEMRELATIONS CIR
INNER JOIN LFXSTG.CMv5_CONFIGURATIONITEMS SRC
ON CIR.FromCI_ID = SRC.CI_ID AND CIR.Lfx_SourceId = SRC.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_CONFIGURATIONITEMS TAR
ON CIR.ToCI_ID = TAR.CI_ID AND CIR.Lfx_SourceId = TAR.Lfx_SourceId
WHERE SRC.Lfx_Status = ''U''
AND SRC.CIType_ID in (2, 3, 4, 5)
AND TAR.CIType_ID in (2, 3, 4, 5)
AND TAR.Lfx_Status = ''U''
AND CIR.RelationType IN (1,2,3,4)
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_DCMNonCompliantConfigItems]') is null
drop view [LFXSTG].[v_Cached_CMv5_DCMNonCompliantConfigItems]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_DCMNonCompliantConfigItems] AS
SELECT BNC.Lfx_RowId,
BNC.Lfx_SourceId,
BNC.Lfx_Timestamp,
''U'' AS Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
BCI.CI_UniqueID AS ''Baseline_UniqueID'',
CI.CI_UniqueID AS ''CI_UniqueID'',
CS.Name0 AS ''ComputerName'',
BNC.MaxNoncomplianceCriticality AS ''MaxNonComplianceCriticality'',
CNC.ComplianceStatusDetails,
CNC.LastComplianceScanTime
FROM LFXSTG.CMv5_CICURRENTCOMPLIANCESTATUS BNC
INNER JOIN LFXSTG.CMv5_CONFIGURATIONITEMS BCI
ON BNC.ModelID = BCI.ModelId AND BNC.Lfx_SourceId = BCI.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_CONFIGURATIONITEMRELATIONS REL
ON BCI.CI_ID = REL.FromCI_ID
AND REL.RelationDepth = 1 -- pick first child ci
AND BCI.Lfx_SourceId = REL.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_CONFIGURATIONITEMS CI
ON CI.CI_ID = REL.ToCI_ID AND CI.Lfx_SourceId = REL.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_CICURRENTCOMPLIANCESTATUS CNC
ON CI.ModelId = CNC.ModelID
AND CNC.ResourceID = BNC.ResourceID
AND CNC.Lfx_SourceId = BNC.Lfx_SourceId
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON BNC.ResourceID=S.ResourceID AND BNC.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE BCI.CIType_ID = 2 and BNC.ComplianceState = 2 --non compliant baselines
AND CI.CIType_ID IN (3, 4, 5) AND
( (REL.RelationType=2 AND (CNC.ComplianceState = 2 OR CNC.IsDetected=0))
OR (REL.RelationType=4 AND (CNC.IsDetected=1 AND CNC.ComplianceState=2))
OR (REL.RelationType=3 AND CNC.IsDetected=1)
OR (REL.RelationType=1 AND (CNC.ComplianceState=2 OR CNC.IsDetected=0))
)
AND S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_DeviceHasWSUSUpdates]') is null
drop view [LFXSTG].[v_Cached_CMv5_DeviceHasWSUSUpdates]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_DeviceHasWSUSUpdates] AS
SELECT UCS.Lfx_RowId,
UCS.Lfx_SourceId,
UCS.Lfx_Timestamp,
''U'' AS Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
COALESCE(COALESCE(LOC.DisplayName, ELOC.DisplayName),'''') AS Title,
COALESCE(COALESCE(LOC1.CategoryInstanceName, ELOC1.CategoryInstanceName),'''') AS Vendor,
(CASE WHEN ELOC2.CategoryInstanceName = ''Applications'' THEN ''Classification.Applications''
WHEN ELOC2.CategoryInstanceName = ''Critical Updates'' THEN ''Classification.CriticalUpdates''
WHEN ELOC2.CategoryInstanceName = ''Definition Updates'' THEN ''Classification.DefinitionUpdates''
WHEN ELOC2.CategoryInstanceName = ''Drivers'' THEN ''Classification.Drivers''
WHEN ELOC2.CategoryInstanceName = ''Feature Packs'' THEN ''Classification.FeaturePacks''
WHEN ELOC2.CategoryInstanceName = ''Security Updates'' THEN ''Classification.SecurityUpdates''
WHEN ELOC2.CategoryInstanceName = ''Service Packs'' THEN ''Classification.ServicePacks''
WHEN ELOC2.CategoryInstanceName = ''Tools'' THEN ''Classification.Tools''
WHEN ELOC2.CategoryInstanceName = ''Update Rollups'' THEN ''Classification.UpdateRollups''
WHEN ELOC2.CategoryInstanceName = ''Updates'' THEN ''Classification.Updates''
WHEN ELOC2.CategoryInstanceName = ''WSUS Infrastructure Updates'' THEN ''Classification.WSUSInfrastructureUpdates''
ELSE ''Classification.Updates'' END) AS Classification,
UCI.BulletinID AS BulletinID,
UCI.ArticleID AS ArticleID,
(CASE WHEN UCS.Status=3 THEN ''InstallStatus.Installed''
WHEN UCS.Status =2 THEN ''InstallStatus.Missing''
ELSE ''InstallStatus.Unknown'' END) AS InstallStatus,
COALESCE(LOC.CIInformativeURL, ELOC.CIInformativeURL) AS SupportString
FROM LFXSTG.CMv5_UPDATECOMPLIANCESTATUS UCS WITH(INDEX(IX_RowId_Timestamp_Status_v5))
INNER JOIN LFXSTG.CMv5_CONFIGURATIONITEMS ci
ON UCS.CI_ID = ci.CI_ID AND UCS.Lfx_SourceId = ci.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_UPDATECIS UCI
ON UCI.CI_ID=ci.CI_ID AND UCI.Lfx_SourceId = ci.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_LOCALIZEDCIPROPERTIES ELOC
ON ELOC.CI_ID=ci.CI_ID AND ELOC.Lfx_SourceId = ci.Lfx_SourceId
LEFT JOIN LFXSTG.CMv5_LOCALIZEDCIPROPERTIES LOC
ON LOC.CI_ID=ci.CI_ID AND LOC.Lfx_SourceId = ci.Lfx_SourceId
AND LOC.LocaleID=$SMLOC
AND LOC.Lfx_Status=''U''
INNER JOIN LFXSTG.CMv5_CICATEGORIES_ALL cicatall1
ON cicatall1.CI_ID=ci.CI_ID AND cicatall1.Lfx_SourceId = ci.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_CATEGORYINSTANCES cinst1
on cicatall1.CategoryInstanceID=cinst1.CategoryInstanceID
AND cinst1.CategoryTypeName=''Company''
AND cinst1.Lfx_SourceId = cicatall1.Lfx_SourceId
LEFT JOIN LFXSTG.CMv5_LOCALIZEDCATEGORYINSTANCES LOC1
ON cinst1.CategoryInstanceID = LOC1.CategoryInstanceID
AND LOC1.LocaleID=$SMLOC
AND LOC1.Lfx_Status=''U''
AND cinst1.Lfx_SourceId = LOC1.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_LOCALIZEDCATEGORYINSTANCES ELOC1
ON cinst1.CategoryInstanceID = ELOC1.CategoryInstanceID
AND cinst1.Lfx_SourceId = ELOC1.Lfx_SourceId
INNER JOIN
(SELECT cicatall2.CI_ID,
MIN(cinst2.CategoryInstanceID) AS CategoryInstanceID,
cicatall2.Lfx_SourceId
FROM LFXSTG.CMv5_CICATEGORIES_ALL cicatall2
INNER JOIN LFXSTG.CMv5_CATEGORYINSTANCES cinst2
ON cicatall2.CategoryInstanceID=cinst2.CategoryInstanceID
AND cicatall2.Lfx_SourceId = cinst2.Lfx_SourceId
WHERE cicatall2.Lfx_Status = ''U''
AND cinst2.CategoryTypeName=''UpdateClassification''
AND cinst2.Lfx_Status = ''U''
GROUP BY cicatall2.CI_ID, cicatall2.Lfx_SourceId
) X
ON X.CI_ID = ci.CI_ID AND X.Lfx_SourceId = ci.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_LOCALIZEDCATEGORYINSTANCES ELOC2
ON ELOC2.CategoryInstanceID=X.CategoryInstanceID
AND ELOC2.Lfx_SourceId = X.Lfx_SourceId
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON UCS.ResourceID=S.ResourceID AND UCS.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE UCS.Lfx_Status=''U'' AND ci.Lfx_Status=''U'' AND UCI.Lfx_Status=''U''
AND ELOC.Lfx_Status = ''U'' AND ELOC.LocaleID & 0x00FF = 0x0009
AND ELOC1.Lfx_Status = ''U'' AND ELOC1.LocaleID & 0x00FF = 0x0009
AND ELOC2.Lfx_Status = ''U'' AND ELOC2.LocaleID & 0x00FF = 0x0009
AND cicatall1.Lfx_Status = ''U'' AND cinst1.Lfx_Status = ''U''
AND ci.CIType_ID IN (1, 8)
--AND ci.IsHidden = 0
AND ((UCS.Status=2) or (UCS.Status=3))
AND S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_TopComputerUser]') is null
drop view [LFXSTG].[v_Cached_CMv5_TopComputerUser]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_TopComputerUser] AS
SELECT UMR.Lfx_RowId,
UMR.Lfx_SourceId,
UMR.Lfx_Timestamp,
(CASE WHEN UMR.RelationActive = 1 THEN ''U'' ELSE ''D'' END) AS ''Lfx_Status'',
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
(CASE WHEN CHARINDEX(''\'', UMR.UniqueUserName, 0) > 0
THEN SUBSTRING(UMR.UniqueUserName, 0, CHARINDEX(''\'', UMR.UniqueUserName, 0))
ELSE '''' END) AS ''Domain'',
(CASE WHEN CHARINDEX(''\'', UMR.UniqueUserName, 0) > 0
THEN SUBSTRING(UMR.UniqueUserName, CHARINDEX(''\'', UMR.UniqueUserName)+1, LEN(UMR.UniqueUserName))
ELSE UMR.UniqueUserName END) AS ''UserName''
FROM [LFXSTG].CMv5_USERMACHINERELATION UMR
INNER JOIN [LFXSTG].CMv5_USERMACHINETYPERELATION UMTR
ON UMR.RelationshipResourceID = UMTR.RelationshipResourceID
AND UMR.Lfx_SourceId = UMTR.Lfx_SourceId
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON UMR.MachineResourceID=S.ResourceID AND UMR.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN [LFXSTG].CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE UMTR.TypeID=1
AND S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND S.Client_Type0 != 3 AND S.EAS_DeviceID0 IS NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_ComputerOwnedByUser]') is null
drop view [LFXSTG].[v_Cached_CMv5_ComputerOwnedByUser]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_ComputerOwnedByUser] AS
SELECT UMR.Lfx_RowId,
UMR.Lfx_SourceId,
UMR.Lfx_Timestamp,
(CASE WHEN UMR.RelationActive = 1 THEN ''U'' ELSE ''D'' END) AS ''Lfx_Status'',
COALESCE(CS.Name0, S.Netbios_Name0) + ''.'' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS ''PrincipalName'',
(CASE WHEN CHARINDEX(''\'', UMR.UniqueUserName, 0) > 0
THEN SUBSTRING(UMR.UniqueUserName, 0, CHARINDEX(''\'', UMR.UniqueUserName, 0))
ELSE '''' END) AS ''Domain'',
(CASE WHEN CHARINDEX(''\'', UMR.UniqueUserName, 0) > 0
THEN SUBSTRING(UMR.UniqueUserName, CHARINDEX(''\'', UMR.UniqueUserName)+1, LEN(UMR.UniqueUserName))
ELSE UMR.UniqueUserName END) AS ''UserName''
FROM [LFXSTG].CMv5_USERMACHINERELATION UMR
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON UMR.MachineResourceID=S.ResourceID AND UMR.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN [LFXSTG].CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
AND S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND S.Client_Type0 != 3 AND S.EAS_DeviceID0 IS NULL
AND CS.Lfx_Status = ''U''
')
</Script><Script>
if not object_id('[LFXSTG].[v_Cached_CMv5_DeviceOwnedByUser]') is null
drop view [LFXSTG].[v_Cached_CMv5_DeviceOwnedByUser]
exec ('
CREATE VIEW [LFXSTG].[v_Cached_CMv5_DeviceOwnedByUser] AS
SELECT UMR.Lfx_RowId,
UMR.Lfx_SourceId,
UMR.Lfx_Timestamp,
(CASE WHEN UMR.RelationActive = 1 THEN ''U'' ELSE ''D'' END) AS ''Lfx_Status'',
COALESCE(S.SMS_Unique_Identifier0, S.EAS_DeviceID0) AS ''Id'',
(CASE WHEN CHARINDEX(''\'', UMR.UniqueUserName, 0) > 0
THEN SUBSTRING(UMR.UniqueUserName, 0, CHARINDEX(''\'', UMR.UniqueUserName, 0))
ELSE '''' END) AS ''Domain'',
(CASE WHEN CHARINDEX(''\'', UMR.UniqueUserName, 0) > 0
THEN SUBSTRING(UMR.UniqueUserName, CHARINDEX(''\'', UMR.UniqueUserName)+1, LEN(UMR.UniqueUserName))
ELSE UMR.UniqueUserName END) AS ''UserName''
FROM [LFXSTG].CMv5_USERMACHINERELATION UMR
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON UMR.MachineResourceID=S.ResourceID AND UMR.Lfx_SourceId = S.Lfx_SourceId
WHERE (S.Client_Type0 = 3 OR S.EAS_DeviceID0 IS NOT NULL)
')
</Script></Property>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_Packages</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">P.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">P.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select P.*, P.Name AS DisplayName from [LFXSTG].CMv5_PACKAGE P
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_Packages</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_PACKAGE,CMv5_CICURRENTCOMPLIANCESTATUS,CMv5_LOCALIZEDCIPROPERTIES,CMv5_CONFIGURATIONITEMS,CMv5_CONFIGURATIONITEMRELATIONS</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_Programs</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">P.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">P.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select P.Lfx_RowId,
P.Lfx_SourceId,
P.Lfx_Status,
P.Lfx_Timestamp,
P.ProgramId AS ProgramId,
P.PackageID,
P.Name AS ProgramName,
P.Name AS DisplayName,
P.Comment,
P.Command,
P.Description AS ProgramDescription,
P.MSIFilePath,
P.SourceSite AS SourceSiteCode
from [LFXSTG].CMv5_PROGRAM P
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_Programs</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_Packages,CMv5_PROGRAM</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_LogicalDevices</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">D.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">D.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
SELECT D.*
FROM [LFXSTG].v_Cached_CMv5_LogicalDevices D
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_LogicalDevices</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_SYSTEM,CMv5_EAS_PROPERTY,CMv5_DEVICE_COMPUTERSYSTEM,Cached_CMv5_Programs</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_DeviceOperatingSystems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">D.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">D.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select D.* from [LFXSTG].v_Cached_CMv5_DeviceOperatingSystems D
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_DeviceOperatingSystems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_DEVICE_OPERATING_SYSTEM,Cached_CMv5_LogicalDevices</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_PhysicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">E.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">E.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
SELECT E.Lfx_RowId,
E.Lfx_SourceId,
E.Lfx_Status,
E.DisplayName,
E.Model,
E.NumberOfProcessors,
E.SystemType,
E.HardwareId,
E.SMBIOS_UUID,
E.SMBIOSAssetTag,
E.Manufacturer,
E.ChassisType,
E.SerialNumber
FROM [LFXSTG].v_Cached_CMv5_PhysicalComputers E
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_PhysicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_SYSTEM_ENCLOSURE,CMv5_COMPUTER_SYSTEM,CMv5_SYSTEM,Cached_CMv5_DeviceOperatingSystems</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_LogicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">E.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">E.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
SELECT E.Lfx_RowId,
E.Lfx_SourceID,
E.Lfx_Status,
E.DisplayName,
E.PrincipalName,
E.NetbiosComputerName,
E.NetbiosDomainName,
E.OffsetInMinuteFromGreenwichTime,
E.IsVirtualMachine,
E.LastInventoryDate,
E.ActiveDirectorySite
from [LFXSTG].v_Cached_CMv5_LogicalComputers E
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_LogicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_PhysicalComputers</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_LogicalComputersOnPhysicalComputer</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">E.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">E.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
SELECT E.Lfx_RowId,
E.Lfx_SourceId,
E.Lfx_Status as Lfx_Status,
E.PrincipalName,
E.HardwareId,
E.SMBIOSAssetTag
FROM [LFXSTG].v_Cached_CMv5_LogicalComputersOnPhysicalComputer E
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_LogicalComputersOnPhysicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_PhysicalComputers,Cached_CMv5_LogicalComputers</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_OperatingSystems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">E.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">E.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select E.* from [LFXSTG].v_Cached_CMv5_OperatingSystems E
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_OperatingSystems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalComputers,CMv5_OPERATING_SYSTEM,Cached_CMv5_LogicalComputersOnPhysicalComputer</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_PhysicalDisks</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">E.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">E.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select E.* from [LFXSTG].v_Cached_CMv5_PhysicalDisks E
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_PhysicalDisks</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalComputers,CMv5_DISK,Cached_CMv5_OperatingSystems</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_LogicalDisks</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">E.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">E.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select E.* from [LFXSTG].v_Cached_CMv5_LogicalDisks E
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_LogicalDisks</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalComputers,CMv5_LOGICAL_DISK,Cached_CMv5_PhysicalDisks</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_Processors</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">E.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">E.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select E.* from [LFXSTG].v_Cached_CMv5_Processors E
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_Processors</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalComputers,CMv5_PROCESSOR,Cached_CMv5_LogicalDisks</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_NetworkAdapters</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">E.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">E.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select E.* from [LFXSTG].v_Cached_CMv5_NetworkAdapters E
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_NetworkAdapters</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalComputers,CMv5_NETWORK_ADAPTER,CMv5_NETWORK_ADAPTER_CONFIGUR,Cached_CMv5_Processors</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_DeviceHasSoftwareItemsInstalled</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">SW.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">SW.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
SELECT SW.Lfx_RowId,
SW.Lfx_SourceId,
SW.Lfx_Status as Lfx_Status,
SW.PrincipalName,
SW.ProductName,
SW.VersionString,
SW.Publisher,
SW.LocaleID,
SW.SoftwareDisplayName,
SW.InstalledDate,
SW.InstalledPath,
SW.SerialNumber,
SW.IsVirtualApplication,
SW.ProductCode
FROM [LFXSTG].v_Cached_CMv5_DeviceHasSoftwareItemsInstalled SW
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_DeviceHasSoftwareItemsInstalled</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalComputers,CMv5_INSTALLED_SOFTWARE,Cached_CMv5_NetworkAdapters</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_DeviceHasWSUSUpdates</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">SU.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">SU.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
SELECT SU.Lfx_RowId,
SU.Lfx_SourceId,
'U' AS Lfx_Status,
SU.PrincipalName,
SU.Title,
SU.Vendor,
SU.Classification,
SU.BulletinID,
SU.ArticleID,
SU.InstallStatus,
SU.SupportString
FROM [LFXSTG].v_Cached_CMv5_DeviceHasWSUSUpdates SU
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_DeviceHasWSUSUpdates</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalComputers,CMv5_UPDATECOMPLIANCESTATUS,Cached_CMv5_DeviceHasSoftwareItemsInstalled</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_AdminCategories</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">AC.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">AC.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select AC.* from [LFXSTG].v_Cached_CMv5_AdminCategories AC
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_AdminCategories</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_CATEGORYINSTANCES,CMv5_LOCALIZEDCATEGORYINSTANCES,Cached_CMv5_DeviceHasWSUSUpdates</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_TopComputerUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">U.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">U.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select U.* from [LFXSTG].v_Cached_CMv5_TopComputerUser U
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_TopComputerUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalComputers,CMv5_USERMACHINERELATION,CMv5_USERMACHINESOURCERELATION,CMv5_USERMACHINETYPERELATION,Cached_CMv5_AdminCategories</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_ComputerOwnedByUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">U.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">U.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select U.* from [LFXSTG].v_Cached_CMv5_ComputerOwnedByUser U
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_ComputerOwnedByUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalComputers,CMv5_USERMACHINERELATION,CMv5_USERMACHINETYPERELATION,Cached_CMv5_TopComputerUser</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_DeviceOwnedByUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">U.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">U.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select U.* from [LFXSTG].v_Cached_CMv5_DeviceOwnedByUser U
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_DeviceOwnedByUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_LogicalDevices,CMv5_USERMACHINERELATION,CMv5_USERMACHINETYPERELATION,Cached_CMv5_ComputerOwnedByUser</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_DCMConfigItems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">DC.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">DC.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select DC.* from [LFXSTG].v_Cached_CMv5_DCMConfigItems DC
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_DCMConfigItems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_CONFIGURATIONITEMS,CMv5_LOCALIZEDCIPROPERTIES,Cached_CMv5_DeviceOwnedByUser</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_DCMConfigItemRelations</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">DCR.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">DCR.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">500</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
select DCR.* from [LFXSTG].v_Cached_CMv5_DCMConfigItemRelations DCR
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_DCMConfigItemRelations</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_CONFIGURATIONITEMRELATIONS,Cached_CMv5_DCMConfigItems</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsTables' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataTable']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DataName$">Cached_CMv5_DCMNonCompliantConfigItems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">DC.Lfx_Timestamp</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">DC.Lfx_RowId</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">10</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">false</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">
SELECT DC.Lfx_RowId,
DC.Lfx_SourceId,
'U' AS Lfx_Status,
DC.PrincipalName,
DC.Baseline_UniqueID,
DC.CI_UniqueID,
DC.ComputerName,
DC.MaxNonComplianceCriticality,
DC.ComplianceStatusDetails,
DC.LastComplianceScanTime
FROM [LFXSTG].v_Cached_CMv5_DCMNonCompliantConfigItems DC
</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">Cached_CMv5_DCMNonCompliantConfigItems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">Cached_CMv5_DCMConfigItems,CMv5_CICURRENTCOMPLIANCESTATUS,Cached_CMv5_DCMConfigItemRelations</Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_Packages</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_Packages</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.Package</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_Programs</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_Programs</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.PackageContainsProgram</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><OmitSource xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">true</OmitSource></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_LogicalDevices</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_LogicalDevices</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.MobileDevice</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_DeviceOperatingSystems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_DeviceOperatingSystems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.MobileDeviceHasOperatingSystem</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><SourceType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.MobileDevice</SourceType><SourceMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</SourceMPName><SourceMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</SourceMPVersion><SourceMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</SourceMPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_PhysicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_PhysicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.DeployedComputer</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_LogicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_LogicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Computer</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_LogicalComputersOnPhysicalComputers</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_LogicalComputersOnPhysicalComputer</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.DeployedComputerRunsWindowsComputer</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><OmitSource xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">true</OmitSource><OmitTarget xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">true</OmitTarget></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_OperatingSystems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_OperatingSystems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.OperatingSystem</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_LogicalDisks</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_LogicalDisks</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Peripheral.LogicalDisk</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Peripheral.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_PhysicalDisks</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_PhysicalDisks</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Peripheral.PhysicalDisk</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Peripheral.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_Processors</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_Processors</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Peripheral.Processor</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Peripheral.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_NetworkAdapters</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_NetworkAdapters</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Peripheral.NetworkAdapter</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Peripheral.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_DeviceHasSoftwareItemsInstalled</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_DeviceHasSoftwareItemsInstalled</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.DeviceHasSoftwareItemInstalled</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Software.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><SourceType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Computer</SourceType><SourceMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Library</SourceMPName><SourceMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</SourceMPVersion><SourceMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</SourceMPToken><TargetPropertyName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">SoftwareDisplayName:DisplayName</TargetPropertyName><OmitSource xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">true</OmitSource></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_DeviceHasWSUSUpdates</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_DeviceHasWSUSUpdates</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.DeviceHasSoftwareUpdateInstalled</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Software.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><SourceType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Computer</SourceType><SourceMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Library</SourceMPName><SourceMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</SourceMPVersion><SourceMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</SourceMPToken><TargetType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.SoftwareUpdate</TargetType><TargetMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Library</TargetMPName><TargetMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</TargetMPVersion><TargetMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</TargetMPToken><OmitSource xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">true</OmitSource></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_TopComputerUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_TopComputerUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.ComputerPrimaryUser</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><SourceType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Computer</SourceType><SourceMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Library</SourceMPName><SourceMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</SourceMPVersion><SourceMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</SourceMPToken><TargetType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Domain.User</TargetType><TargetMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Library</TargetMPName><TargetMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</TargetMPVersion><TargetMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</TargetMPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_ComputerOwnedByUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_ComputerOwnedByUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.UserUsesDevice</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><SourceType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Domain.User</SourceType><SourceMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Library</SourceMPName><SourceMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</SourceMPVersion><SourceMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</SourceMPToken><TargetType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Computer</TargetType><TargetMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.Windows.Library</TargetMPName><TargetMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</TargetMPVersion><TargetMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</TargetMPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_DeviceOwnedByUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_DeviceOwnedByUser</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.UserUsesDevice</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Library</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><SourceType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Domain.User</SourceType><SourceMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">System.Library</SourceMPName><SourceMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.5.8501.0</SourceMPVersion><SourceMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</SourceMPToken><TargetType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.MobileDevice</TargetType><TargetMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</TargetMPName><TargetMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</TargetMPVersion><TargetMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</TargetMPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_AdminCategories</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_AdminCategories</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.CategoryInstance</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_DCMConfigItems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_DCMConfigItems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.DCM_CI</TypeName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_DCMConfigItemRelations</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_DCMConfigItemRelations</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.ConfigItemRefersConfigItem</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><SourcePropertyName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">FromCI_UniqueID:UniqueID</SourcePropertyName><TargetPropertyName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">ToCI_UniqueID:UniqueID</TargetPropertyName><OmitSource xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">true</OmitSource><OmitTarget xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">true</OmitTarget></Property>
</Object>
<Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.ConnectorEmbedsCollections' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.DataCollection']$">
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataCollectionName$">Cached_CMv5_DCMNonCompliantConfigItems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">Cached_CMv5_DCMNonCompliantConfigItems</Property>
<Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/Settings$"><RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager.NonComplianceRefersComputer</RelationshipName><MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">Microsoft.SystemCenter.ConfigurationManager</MPName><MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">7.7.16.0</MPVersion><MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">31bf3856ad364e35</MPToken><OmitTarget xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09">true</OmitTarget></Property>
</Object>
</ObjectTemplate>
Home
ENU