Linking Framework Configuration Manager Data Provider

DataProvider.Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms (ObjectTemplate)

Linking Framework Configuration Manager Data Provider class

Element properties:

Source Code:

<ObjectTemplate ID="DataProvider.Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms" TypeID="LFX!System.LinkingFramework.DataConnector.Projection">

  <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/DataConnectorName$">Microsoft_EnterpriseManagement_ServiceManager_Connector_Sms</Property>

  <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/IsProvider$">True</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.Connector.Sms.SmsConnector</Property>

  <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/EntryAssembly$">Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</Property>

  <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/WinFormUIAssembly$">Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms.SmsConnector, Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</Property>

  <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/InstallSQLScripts$">&lt;Script&gt;

                        IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_CIID_TypeID_v5')

                            DROP INDEX IX_TypeID_v5 ON LFXSTG.CMv5_CONFIGURATIONITEMS 

                        

                        CREATE NONCLUSTERED INDEX IX_TypeID_v5 ON LFXSTG.CMv5_CONFIGURATIONITEMS 

                            (ModelId, CIType_ID, Lfx_SourceId) INCLUDE([CI_UniqueID], [CI_ID]);  

                        &lt;/Script&gt;&lt;Script&gt;

                        IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_RowId_Timestamp_Status_v5')

                            DROP INDEX [IX_RowId_Timestamp_Status_v5] ON [LFXSTG].[CMv5_UPDATECOMPLIANCESTATUS]

                        CREATE NONCLUSTERED INDEX [IX_RowId_Timestamp_Status_v5] ON [LFXSTG].[CMv5_UPDATECOMPLIANCESTATUS] 

                        (

	                        [Lfx_RowId] ASC,

	                        [Lfx_Timestamp] ASC,

	                        [Lfx_SourceId] ASC,

	                        [Status] ASC

                        )

                        &lt;/Script&gt;&lt;Script&gt;

                        IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_ComplianceState_v5')

                            DROP INDEX IX_ComplianceState_v5 ON [LFXSTG].[CMv5_CICURRENTCOMPLIANCESTATUS]

                            

                        CREATE NONCLUSTERED INDEX IX_ComplianceState_v5 ON [LFXSTG].[CMv5_CICURRENTCOMPLIANCESTATUS] 

                            ([ComplianceState],[Lfx_Timestamp])

                        INCLUDE ([Lfx_SourceId], [ModelID], [ResourceID], [MaxNoncomplianceCriticality])

                        &lt;/Script&gt;&lt;Script&gt;

                        IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_CatID_Status_Source_v5')

                            DROP INDEX IX_CatID_Status_Source_v5 ON [LFXSTG].[CMv5_CICATEGORIES_ALL] 

                        CREATE NONCLUSTERED INDEX [IX_CatID_Status_Source_v5] ON [LFXSTG].[CMv5_CICATEGORIES_ALL] 

                        (

	                        [CategoryInstanceID] ASC,

	                        [Lfx_SourceId] ASC,

	                        [Lfx_Status] ASC

                        )

                        INCLUDE ( [CI_ID])

                        &lt;/Script&gt;&lt;Script&gt;

                        IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_COMPUTER_SYSTEM_ComputerFQDN_v5')

                            DROP INDEX IX_COMPUTER_SYSTEM_ComputerFQDN_v5 ON [LFXSTG].[CMv5_COMPUTER_SYSTEM] 

                        CREATE NONCLUSTERED INDEX [IX_COMPUTER_SYSTEM_ComputerFQDN_v5] ON [LFXSTG].[CMv5_COMPUTER_SYSTEM] 

                        (

	                        [ResourceID] ASC,

                            [Lfx_SourceId] ASC,

	                        [Lfx_Status] ASC

                        )

                        INCLUDE ( [Name0], [Domain0])

                        &lt;/Script&gt;&lt;Script&gt;

                        IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_System_ComputerFQDN_v5')

                            DROP INDEX [IX_System_ComputerFQDN_v5] ON [LFXSTG].[CMv5_SYSTEM]

                        CREATE NONCLUSTERED INDEX [IX_System_ComputerFQDN_v5] ON [LFXSTG].[CMv5_SYSTEM] 

                        (

	                        [ResourceID] ASC,

	                        [Netbios_Name0] ASC,

	                        [Resource_Domain_OR_Workgr0] ASC,

	                        [Lfx_SourceId] ASC

                        )

                        &lt;/Script&gt;</Property>

  <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/DisableParallelProcess$">true</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$">CMv5_PACKAGE</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_PACKAGE</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">P.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">P.[PackageID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">4</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT P.ChangeAction AS Lfx_Status,

                                   P.PackageID,

                                   P.BatchingKey,

                                   P.Name,

                                   P.Version,

                                   P.Language,

                                   P.Manufacturer,

                                   P.Description,

                                   P.SourceSite

                            FROM SCCM_Ext.vex_Package P

                            WHERE ((P.PackageType NOT IN (3, 4, 5, 256, 257, 258, 259)) OR (P.ChangeAction = 'D'))

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_PACKAGE</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_PACKAGE]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">PackageID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">8</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">8</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Name</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Version</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">64</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Language</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">64</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Manufacturer</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">64</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Description</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">512</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SourceSite</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">3</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_PROGRAM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_PROGRAM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">P.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">P.[Name]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">4</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                           -- Get only default programs. ProgramFlags 0x00000010 - DEFAULT_PROGRAM

                            SELECT P.ChangeAction AS Lfx_Status,

                                   P.ProgramID,

                                   P.PackageID,

                                   P.Name,

                                   P.BatchingKey,

                                   P.Comment,

                                   P.Command,

                                   P.Description,                                   

                                   P.MSIFilePath,

                                   P.SourceSite

                            FROM SCCM_Ext.vex_Program P                            

                            WHERE                              

                            ((P.ProgramFlags &amp; 0x00000010 = 0) OR (P.ChangeAction = 'D'))

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_PROGRAM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_PROGRAM]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ProgramID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">PackageID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">8</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Name</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">100</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Comment</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Command</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">max</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Description</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">MSIFilePath</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">max</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SourceSite</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">3</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_SYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_SYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">S.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">S.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT S.ResourceID, 

                                S.ChangeAction as Lfx_Status, 

                                S.Netbios_Name0,

                                S.Resource_Domain_OR_Workgr0,

                                S.Operating_System_Name_and0,

                                S.Name0, 

                                S.Hardware_ID0, 

                                S.SMBIOS_GUID0,

                                S.AD_Site_Name0,

                                S.SMS_Unique_Identifier0,

                                S.Previous_SMS_UUID0,

                                S.FQDN,

                                E.EAS_Identity AS EAS_DeviceID0,

                                S.Client_Type0,

                                S.CPUType0

                            FROM SCCM_Ext.vex_R_System S

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON S.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID

                            LEFT JOIN SCCM_Ext.vex_EAS_PROPERTY E 

                                ON E.EAS_Identity = S.EAS_DeviceID

                            /*grab computers that are alive and their membership is also alive

                              or if they are deleted, then their membership will also be deleted

                              the condition below will not generate deletes for computers that move out of a collection*/

                            WHERE ((S.ChangeAction = 'U' AND CM.ChangeAction='U')

                                  OR S.ChangeAction = 'D')

                                  AND $COLLECTIONLIST AND C.ChangeAction = 'U'

                            ORDER BY S.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DEVICESANDCOMPUTERS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_SYSTEM]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Netbios_Name0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Resource_Domain_OR_Workgr0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Operating_System_Name_and0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Name0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Hardware_ID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SMBIOS_GUID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">AD_Site_Name0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SMS_Unique_Identifier0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Previous_SMS_UUID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">FQDN</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">446</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">EAS_DeviceID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">450</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Client_Type0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CPUType0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_WORKSTATION_STATUS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_WORKSTATION_STATUS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">S.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">S.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                      SELECT S.ChangeAction as Lfx_Status,

                      S.ResourceID,

                      S.BatchingKey,

                      S.GroupKey,

                      S.TimeStamp,

                      S.LastHWScan,

                      S.SystemDefaultLCID,

                      S.TimezoneOffset,

                      S.LastReportVersion

                      FROM SCCM_Ext.vex_GS_WORKSTATION_STATUS S

                      INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                        ON S.ResourceID = CM.ResourceID

                      INNER JOIN SCCM_Ext.vex_Collection C

                        ON C.CollectionID = CM.CollectionID

                      WHERE S.LastHWScan IS NOT NULL 

                        AND C.ChangeAction = 'U' and CM.ChangeAction = 'U'

                        AND $COLLECTIONLIST

                      ORDER BY S.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DEVICESANDCOMPUTERS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_WORKSTATION_STATUS]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ResourceID]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">GroupKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">TimeStamp</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">LastHWScan</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SystemDefaultLCID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">TimezoneOffset</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">LastReportVersion</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">18</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_COMPUTER_SYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_COMPUTER_SYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">CS.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">CS.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT CS.ResourceID, 

                                    CS.GroupKey,

                                    CS.ChangeAction as Lfx_Status, 

                                    CS.[TimeStamp], 

                                    CS.Name0,

                                    CS.Domain0,

                                    CS.Model0, 

                                    CS.NumberOfProcessors0,

                                    CS.Manufacturer0,

                                    CS.SystemType0, 

                                    CS.CurrentTimeZone0

                            FROM SCCM_Ext.vex_GS_COMPUTER_SYSTEM CS 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON CS.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE $COLLECTIONLIST

                            ORDER BY CS.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DEVICESANDCOMPUTERS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_COMPUTER_SYSTEM]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ResourceID]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[GroupKey]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[TimeStamp]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[Name0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[Domain0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Model0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Manufacturer0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">NumberOfProcessors0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SystemType0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CurrentTimeZone0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_SYSTEM_ENCLOSURE</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_SYSTEM_ENCLOSURE</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">E.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">E.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT E.ResourceID, 

                                    E.GroupKey,

                                    E.ChangeAction as Lfx_Status, 

                                    E.[TimeStamp], 

                                    E.SMBIOSAssetTag0,

                                    E.Manufacturer0, 

                                    E.ChassisTypes0, 

                                    (CASE WHEN B.SerialNumber0 IS NULL or RTRIM(B.SerialNumber0)='' THEN E.SerialNumber0

                                          ELSE B.SerialNumber0 END) AS SerialNumber0, 

                                    E.Tag0

                            FROM SCCM_Ext.vex_GS_SYSTEM_ENCLOSURE E 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON E.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            LEFT JOIN SCCM_Ext.vex_GS_PC_BIOS B

                                ON E.ResourceID = B.ResourceID

                            WHERE $COLLECTIONLIST

                            ORDER BY E.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DEVICESANDCOMPUTERS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_SYSTEM_ENCLOSURE]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ResourceID]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[GroupKey]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[TimeStamp]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SMBIOSAssetTag0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[Manufacturer0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ChassisTypes0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[SerialNumber0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[Tag0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_EAS_PROPERTY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_EAS_PROPERTY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">-1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">-1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT E.EAS_Identity, 

                                   E.ChangeAction as Lfx_Status, 

                                   E.DeviceImei,

                                   E.DeviceOS,

                                   E.DevicePhoneNumber,

                                   E.DeviceMobileOperator,

                                   E.DeviceModel,

                                   E.ExchangeServer

                            FROM SCCM_Ext.vex_EAS_Property E

                            INNER JOIN SCCM_Ext.vex_R_System S

                                ON E.EAS_Identity = S.EAS_DeviceID

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON S.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE $COLLECTIONLIST

                            --ORDER BY E.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DEVICESANDCOMPUTERS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_EAS_PROPERTY]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">EAS_Identity</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">450</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DeviceImei</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DeviceOS</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">64</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DevicePhoneNumber</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">32</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DeviceMobileOperator</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DeviceModel</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">64</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ExchangeServer</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">256</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_DEVICE_COMPUTERSYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_DEVICE_COMPUTERSYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">CS.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">CS.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT CS.ChangeAction AS Lfx_Status, 

                                   CS.ResourceID,

                                   CS.GroupKey,

                                   CS.DeviceManufacturer0,

                                   CS.FirmwareVersion0,

                                   CS.HardwareVersion0,

                                   CS.OEM0

                            FROM SCCM_Ext.vex_GS_DEVICE_COMPUTERSYSTEM CS

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON CS.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE $COLLECTIONLIST

                            ORDER BY CS.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DEVICESANDCOMPUTERS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_DEVICE_COMPUTERSYSTEM]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">GroupKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DeviceManufacturer0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">FirmwareVersion0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">HardwareVersion0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">OEM0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_DEVICE_OPERATING_SYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_DEVICE_OPERATING_SYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">OS.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">OS.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT OS.ResourceID, 

                                    OS.GroupKey,

                                    OS.ChangeAction as Lfx_Status, 

                                    OS.[TimeStamp], 

                                    OS.Version0,

                                    OS.Language0,

                                    OS.Platform0

                            FROM SCCM_Ext.vex_GS_DEVICE_OSINFORMATION OS 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON OS.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE $COLLECTIONLIST

                            ORDER BY OS.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_DEVICE_OPERATING_SYSTEM]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_SYSTEM</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">GroupKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">TimeStamp</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Version0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Platform0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Language0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_OPERATING_SYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_OPERATING_SYSTEM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">OS.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">OS.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT OS.ResourceID, 

                                    OS.GroupKey,

                                    OS.ChangeAction as Lfx_Status, 

                                    OS.[TimeStamp], 

                                    OS.Caption0,

                                    OS.Version0,

                                    OS.BuildNumber0, 

                                    OS.CSDVersion0,

                                    OS.InstallDate0,

                                    OS.WindowsDirectory0,

                                    OS.SystemDirectory0,

                                    OS.CountryCode0,

                                    OS.Locale0,

                                    OS.Manufacturer0,

                                    OS.OSLanguage0,

                                    OS.TotalVisibleMemorySize0

                            FROM SCCM_Ext.vex_GS_OPERATING_SYSTEM OS 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON OS.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE $COLLECTIONLIST

                            ORDER BY OS.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_OPERATING_SYSTEM]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">GroupKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">TimeStamp</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Caption0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Version0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BuildNumber0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CSDVersion0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">InstallDate0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">WindowsDirectory0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SystemDirectory0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CountryCode0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Locale0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Manufacturer0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">OSLanguage0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">TotalVisibleMemorySize0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_LOGICAL_DISK</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_LOGICAL_DISK</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">LD.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">LD.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT LD.ResourceID, 

                                    LD.GroupKey,

                                    LD.ChangeAction as Lfx_Status, 

                                    LD.[TimeStamp],

                                    LD.Name0,

                                    LD.DeviceID0,

                                    LD.Description0,

                                    LD.VolumeName0,

                                    LD.FileSystem0,

                                    LD.Compressed0,

                                    LD.Size0,

                                    LD.FreeSpace0,

                                    LD.DriveType0

                            FROM SCCM_Ext.vex_GS_LOGICAL_DISK LD 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON LD.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE C.ChangeAction = 'U' AND CM.ChangeAction = 'U'

                            -- inventory from computers not in collection, or if collection is deleted is not interesting

                                AND $COLLECTIONLIST

                            ORDER BY LD.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_LOGICAL_DISK]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ResourceID]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[GroupKey]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[TimeStamp]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Name0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DeviceID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">VolumeName0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Description0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">FileSystem0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Compressed0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Size0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">FreeSpace0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DriveType0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_DISK</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_DISK</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">D.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">D.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT D.ResourceID, 

                                    D.GroupKey,

                                    D.ChangeAction as Lfx_Status, 

                                    D.[TimeStamp],

                                    D.Name0,

                                    D.DeviceID0,

                                    D.Description0,

                                    D.MediaType0,

                                    D.PNPDeviceID0,

                                    D.Index0,

                                    D.InterfaceType0,

                                    D.Manufacturer0,

                                    D.Model0,

                                    D.SCSIBus0,

                                    D.SCSILogicalUnit0,

                                    D.SCSIPort0,

                                    D.SCSITargetId0,

                                    D.Size0

                            FROM SCCM_Ext.vex_GS_DISK D 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON D.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE C.ChangeAction = 'U' AND CM.ChangeAction = 'U'

                            -- inventory from computers not in collection, or if collection is deleted is not interesting

                                AND $COLLECTIONLIST

                            ORDER BY D.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_DISK]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ResourceID]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[GroupKey]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[TimeStamp]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Name0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DeviceID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Description0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">MediaType0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">PNPDeviceID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[Index0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">InterfaceType0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Manufacturer0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Model0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[SCSIBus0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[SCSILogicalUnit0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[SCSIPort0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[SCSITargetId0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[Size0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_PROCESSOR</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_PROCESSOR</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">P.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">P.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT P.ResourceID, 

                                    P.GroupKey,

                                    P.ChangeAction as Lfx_Status, 

                                    P.[TimeStamp],

                                    P.Name0,

                                    P.DeviceID0,

                                    P.Family0,

                                    P.MaxClockSpeed0,

                                    P.ProcessorType0,

                                    P.BrandID0,

                                    P.PCache0,

                                    P.CPUKey0,

                                    P.IsMobile0,

                                    (CASE WHEN COALESCE(P.NumberOfCores0, 0) = 0 THEN 0 ELSE 1 END) AS IsMulticore0,

                                    P.Manufacturer0,

                                    P.NormSpeed0,

                                    P.DataWidth0,

                                    P.Revision0,

                                    P.Version0

                            FROM SCCM_Ext.vex_GS_PROCESSOR P 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON P.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE C.ChangeAction = 'U' AND CM.ChangeAction = 'U'

                                -- inventory from computers not in collection, or if collection is deleted is not interesting

                                AND $COLLECTIONLIST

                            ORDER BY P.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_PROCESSOR]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ResourceID]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[GroupKey]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[TimeStamp]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Name0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DeviceID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[Family0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[MaxClockSpeed0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ProcessorType0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[BrandID0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[PCache0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[CPUKey0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[IsMobile0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[IsMulticore0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Manufacturer0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[NormSpeed0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[DataWidth0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[Revision0]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Version0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_NETWORK_ADAPTER</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_NETWORK_ADAPTER</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">N.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">N.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT N.ResourceID, 

                                    N.GroupKey,

                                    N.ChangeAction as Lfx_Status, 

                                    N.[TimeStamp],

                                    N.Name0,

                                    N.DeviceID0,

                                    N.Description0,

                                    N.Speed0,

                                    N.MaxSpeed0,

                                    N.ProductName0,

                                    N.AdapterType0,

                                    N.Manufacturer0,

                                    N.MACAddress0,

                                    N.ServiceName0

                            FROM SCCM_Ext.vex_GS_NETWORK_ADAPTER N 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON N.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE C.ChangeAction = 'U' AND CM.ChangeAction = 'U'

                                -- inventory from computers not in collection, or if collection is deleted is not interesting

                                AND $COLLECTIONLIST

                            ORDER BY N.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_NETWORK_ADAPTER]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ResourceID]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[GroupKey]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[TimeStamp]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Name0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DeviceID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Description0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Speed0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">MaxSpeed0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ProductName0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">AdapterType0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Manufacturer0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">MACAddress0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ServiceName0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_NETWORK_ADAPTER_CONFIGUR</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_NETWORK_ADAPTER_CONFIGUR</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">N.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">N.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT N.ResourceID, 

                                    N.GroupKey,

                                    N.ChangeAction as Lfx_Status, 

                                    N.[TimeStamp],

                                    N.DefaultIPGateway0,

                                    N.IPEnabled0,

                                    N.Index0,

                                    N.DHCPEnabled0,

                                    N.DHCPServer0,

                                    N.DNSDomain0,

                                    N.IPAddress0,

                                    N.IPSubnet0,

                                    N.MACAddress0,

                                    N.ServiceName0

                            FROM SCCM_Ext.vex_GS_NETWORK_ADAPTER_CONFIGURATION N 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON N.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE C.ChangeAction = 'U' AND CM.ChangeAction = 'U'

                                -- inventory from computers not in collection, or if collection is deleted is not interesting

                                AND $COLLECTIONLIST

                            ORDER BY N.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_NETWORK_ADAPTER_CONFIGUR]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ResourceID]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[GroupKey]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[TimeStamp]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DefaultIPGateway0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">IPEnabled0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Index0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DHCPEnabled0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DHCPServer0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DNSDomain0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">IPAddress0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">IPSubnet0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">MACAddress0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ServiceName0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_INSTALLED_SOFTWARE</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_INSTALLED_SOFTWARE</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">SW.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">SW.[ResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT SW.ResourceID, 

                                    SW.GroupKey,

                                    SW.ChangeAction as Lfx_Status, 

                                    SW.[TimeStamp],

                                    SW.SoftwareCode0,

                                    SW.SoftwarePropertiesHash0,

                                    SW.ProductName0,

                                    SW.ProductVersion0,

                                    SW.Publisher0,

                                    SW.InstallDate0, 

                                    SW.InstalledLocation0,

                                    SW.RegisteredUser0,

                                    SW.ProductID0,

                                    SW.Language0, 

				                    SW.InstallType0

                            FROM SCCM_Ext.vex_GS_INSTALLED_SOFTWARE SW 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON SW.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE C.ChangeAction = 'U' AND CM.ChangeAction = 'U'

                                -- inventory from computers not in collection, or if collection is deleted is not interesting

                                AND $COLLECTIONLIST

                            ORDER BY SW.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_INSTALLED_SOFTWARE]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[ResourceID]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[GroupKey]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">[TimeStamp]</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SoftwareCode0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SoftwarePropertiesHash0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ProductName0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ProductVersion0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Publisher0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">InstallDate0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">InstalledLocation0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RegisteredUser0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ProductID0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">255</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Language0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">InstallType0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_USERMACHINERELATION</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_USERMACHINERELATION</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">U.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">U.[RelationshipResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT U.ChangeAction as Lfx_Status, 

                                   U.RelationshipResourceID,

                                   U.UniqueUserName,

                                   U.MachineResourceID,

                                   U.RelationActive,

                                   U.CreationTime

                            FROM SCCM_Ext.vex_UserMachineRelation U 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON U.MachineResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE C.ChangeAction = 'U' AND CM.ChangeAction = 'U'

                                -- inventory from computers not in collection, or if collection is deleted is not interesting

                                AND $COLLECTIONLIST

                            ORDER BY U.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_USERMACHINERELATION]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RelationshipResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">MachineResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">UniqueUserName</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">128</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RelationActive</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CreationTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_USERMACHINETYPERELATION</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_USERMACHINETYPERELATION</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">U.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">U.[RelationshipResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT U.ChangeAction as Lfx_Status, 

                                   U.RelationshipResourceID,

                                   U.TypeID,

                                   U.CreationTime

                            FROM SCCM_Ext.vex_UserMachineTypeRelation U 

                            ORDER BY U.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_USERMACHINETYPERELATION]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RelationshipResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">TypeID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CreationTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_USERMACHINESOURCERELATION</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_USERMACHINESOURCERELATION</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">U.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">U.[RelationshipResourceID]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT U.ChangeAction as Lfx_Status, 

                                   U.RelationshipResourceID,

                                   U.SourceID,

                                   U.CreationTime,

                                   U.CreatedBy

                            FROM SCCM_Ext.vex_UserMachineSourceRelation U 

                            ORDER BY U.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_USERMACHINESOURCERELATION]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RelationshipResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CreationTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CreatedBy</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarchar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">128</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_CATEGORYINSTANCES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_CATEGORYINSTANCES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">CI.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">CI.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT CI.ChangeAction as Lfx_Status,

                                CI.BatchingKey,

                                CI.CategoryInstanceID,

                                CI.CategoryInstance_UniqueID,

                                CI.CategoryTypeName

                            FROM SCCM_Ext.vex_CategoryInstances CI

                            ORDER BY CI.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_UPDATES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_CATEGORYINSTANCES]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_USERMACHINESOURCERELATION</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CategoryInstanceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CategoryInstance_UniqueID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">512</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CategoryTypeName</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">64</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_LOCALIZEDCATEGORYINSTANCES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_LOCALIZEDCATEGORYINSTANCES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">LCI.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">LCI.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT LCI.ChangeAction as Lfx_Status,

                                   LCI.BatchingKey,

                                   LCI.CategoryInstanceID,

                                   LCI.CategoryInstanceName,

                                   LCI.LocaleID

                            FROM SCCM_Ext.vex_LocalizedCategoryInstances LCI 

                            ORDER BY LCI.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_UPDATES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_LOCALIZEDCATEGORYINSTANCES]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CategoryInstanceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CategoryInstanceName</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">512</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">LocaleID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

    </Object>

  </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$">CMv5_CICATEGORIES_ALL</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_CICATEGORIES_ALL</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">CIC.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">CIC.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">3</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">20000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT CIC.ChangeAction as Lfx_Status,

                            CIC.RelationID,

                            CIC.BatchingKey,

                            CIC.CI_ID,

                            CIC.CategoryInstanceID

                            FROM SCCM_Ext.vex_CICategories_All CIC

                            ORDER BY CIC.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_UPDATES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_CICATEGORIES_ALL]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RelationID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">bigint</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">bigint</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CI_ID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CategoryInstanceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_CICATEGORIES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_CICATEGORIES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">CIC.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">CIC.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">3</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">20000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT CIC.ChangeAction as Lfx_Status,

                                CIC.RelationID,

                                CIC.CI_ID,

                                CIC.BatchingKey,

                                CIC.CategoryInstanceID

                            FROM SCCM_Ext.vex_CICategories CIC 

                            ORDER BY CIC.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_UPDATES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_CICATEGORIES]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RelationID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">bigint</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">bigint</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CI_ID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CategoryInstanceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_UPDATECIS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_UPDATECIS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">UCI.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">UCI.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT UCI.ChangeAction as Lfx_Status,

                                UCI.CI_ID,

                                UCI.BatchingKey,

                                UCI.BulletinID,

                                UCI.ArticleID

                            FROM SCCM_Ext.vex_UpdateCIs UCI 

                            ORDER BY UCI.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_UPDATES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_UPDATECIS]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CI_ID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BulletinID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">64</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ArticleID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">64</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_UPDATECOMPLIANCESTATUS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_UPDATECOMPLIANCESTATUS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">UCS.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">UCS.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT UCS.ChangeAction as Lfx_Status,

                                UCS.CI_ID,

                                UCS.BatchingKey,

                                UCS.ResourceID,

                                UCS.Status,

                                UCS.LastStatusCheckTime --best approximation to install time

                            FROM SCCM_Ext.vex_UpdateComplianceStatus UCS

                            INNER JOIN SCCM_Ext.vex_R_System S 

                                ON UCS.ResourceID = S.ResourceID 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON UCS.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID  

                            WHERE S.ChangeAction = 'U' AND UCS.ChangeAction = 'U'

                                AND C.ChangeAction = 'U' AND CM.ChangeAction = 'U'

                                -- inventory from computers not in collection, or if collection is deleted is not interesting

                                AND $COLLECTIONLIST

                            ORDER BY UCS.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_UPDATES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_UPDATECOMPLIANCESTATUS]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CI_ID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Status</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">LastStatusCheckTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_LOCALIZEDCIPROPERTIES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_LOCALIZEDCIPROPERTIES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">LC.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">LC.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT  LC.BatchingKey, 

                                    LC.ChangeAction as Lfx_Status,

                                    LC.CI_ID,

                                    LC.LocaleID,

                                    LC.DisplayName,

                                    LC.Description,

                                    LC.CIInformativeURL

                            FROM SCCM_Ext.vex_LocalizedCIProperties LC

                            ORDER BY LC.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DCM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_LOCALIZEDCIPROPERTIES]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/DependOnDataTable$">CMv5_UPDATECOMPLIANCESTATUS</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CI_ID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">LocaleID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">1</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">DisplayName</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">513</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">Description</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">3000</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CIInformativeURL</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">512</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_CONFIGURATIONITEMS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_CONFIGURATIONITEMS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">CI.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">CI.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">0</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">100</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT  CI.BatchingKey, 

                                    CI.ChangeAction as Lfx_Status,

                                    CI.CI_ID,

                                    CI.ModelId,

                                    CI.CI_UniqueID,

                                    CI.CIType_ID,

                                    CI.SDMPackageDigest

                            FROM SCCM_Ext.vex_ConfigurationItems CI 

                            ORDER BY CI.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DCM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_CONFIGURATIONITEMS]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CI_ID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ModelId</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CI_UniqueID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">NVarChar</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Size$">300</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CIType_ID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">SDMPackageDigest</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">xml</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_CONFIGURATIONITEMRELATIONS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_CONFIGURATIONITEMRELATIONS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">CIR.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">CIR.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">3</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">2000</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">2</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT  CIR.RelationID,

                                    CIR.BatchingKey, 

                                    CIR.ChangeAction as Lfx_Status,

                                    CIR.FromCI_ID,

                                    CIR.ToCI_ID,

                                    CIR.RelationType,

                                    CIR.RelationDepth

                            FROM SCCM_Ext.vex_ConfigurationItemRelations CIR 

                            ORDER BY CIR.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DCM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_CONFIGURATIONITEMRELATIONS]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RelationID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">bigint</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyAcs$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">bigint</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">FromCI_ID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ToCI_ID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RelationType</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">RelationDepth</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_CICURRENTCOMPLIANCESTATUS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/StageTableName$">CMv5_CICURRENTCOMPLIANCESTATUS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkField$">CCS.[rowversion]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/WatermarkType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdField$">CCS.[BatchingKey]</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdType$">3</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/BatchIdSize$">100</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/UseCache$">true</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/GroomType$">1</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/QueryString$">

                            SELECT CCS.BatchingKey, 

                                    CCS.ChangeAction as Lfx_Status,

                                    CCS.CI_CurrentComplianceStatusID,

                                    CCS.ModelID,

                                    CCS.ResourceID,

                                    CCS.ComplianceState,

                                    CONVERT(int, CCS.IsDetected) AS IsDetected,

                                    CCS.MaxNoncomplianceCriticality,

                                    CCS.LastComplianceScanTime,

                                    CCSD.ComplianceStatusDetails

                            FROM SCCM_Ext.vex_CICurrentComplianceStatus CCS 

                            INNER JOIN SCCM_Ext.vex_CICurrentComplianceStatusDetails CCSD

                                ON CCS.CI_CurrentComplianceStatusID = CCSD.CurrentComplianceStatusID

                            INNER JOIN SCCM_Ext.vex_R_System S 

                                ON CCS.ResourceID = S.ResourceID 

                            INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM

                                ON CCS.ResourceID = CM.ResourceID

                            INNER JOIN SCCM_Ext.vex_Collection C

                                ON C.CollectionID = CM.CollectionID

                            WHERE S.ChangeAction = 'U' AND CCS.ChangeAction = 'U'

                                AND C.ChangeAction = 'U' AND CM.ChangeAction = 'U'

                                -- inventory from computers not in collection, or if collection is deleted is not interesting

                                AND $COLLECTIONLIST

                            ORDER BY CCS.rowversion

                        </Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/CollectionName$">CMv5_DCM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataTable']/PrimaryKeyName$">[PK_CMv5_CICURRENTCOMPLIANCESTATUS]</Property>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">CI_CurrentComplianceStatusID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">bigint</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/PrimaryKeyPosition$">0</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">BatchingKey</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">bigint</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">false</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ModelID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ResourceID</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ComplianceState</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">IsDetected</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">MaxNoncomplianceCriticality</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">Int</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">LastComplianceScanTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">DateTime</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

    <Object Path="$Context/Path[Relationship='LFX!System.LinkingFramework.TableEmbedsFields' SeedRole='Source' TypeConstraint='LFX!System.LinkingFramework.Field']$">

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Name$">ComplianceStatusDetails</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/Type$">xml</Property>

      <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.Field']/AllowNull$">true</Property>

    </Object>

  </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$">CMv5_PACKAGE</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/StagingName$">DefaultCache</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">CMv5_PACKAGE</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$">CMv5_PROGRAM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/StagingName$">DefaultCache</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">CMv5_PROGRAM</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$">CMv5_DEVICESANDCOMPUTERS</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/StagingName$">DefaultCache</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">CMv5_SYSTEM,CMv5_COMPUTER_SYSTEM,CMv5_SYSTEM_ENCLOSURE,CMv5_WORKSTATION_STATUS,CMv5_EAS_PROPERTY,CMv5_DEVICE_COMPUTERSYSTEM</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$">CMv5_INVENTORY</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/StagingName$">DefaultCache</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">CMv5_DEVICE_OPERATING_SYSTEM,CMv5_OPERATING_SYSTEM,CMv5_LOGICAL_DISK,CMv5_DISK,CMv5_PROCESSOR,CMv5_NETWORK_ADAPTER,CMv5_NETWORK_ADAPTER_CONFIGUR,CMv5_INSTALLED_SOFTWARE,CMv5_USERMACHINERELATION,CMv5_USERMACHINETYPERELATION,CMv5_USERMACHINESOURCERELATION</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$">CMv5_UPDATES</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/StagingName$">DefaultCache</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">CMv5_CATEGORYINSTANCES,CMv5_LOCALIZEDCATEGORYINSTANCES,CMv5_CICATEGORIES_ALL,CMv5_CICATEGORIES,CMv5_UPDATECIS,CMv5_UPDATECOMPLIANCESTATUS</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$">CMv5_DCM</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/StagingName$">DefaultCache</Property>

    <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataCollection']/DataTables$">CMv5_LOCALIZEDCIPROPERTIES,CMv5_CONFIGURATIONITEMS,CMv5_CONFIGURATIONITEMRELATIONS,CMv5_CICURRENTCOMPLIANCESTATUS</Property>

  </Object>

</ObjectTemplate>