ITAM Software Usage Linking Framework Configuration Manager Data Consumer

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

ITAM Software Usage Linking Framework Configuration Manager Data Consumer class
Element properties:

Type	System.LinkingFramework.DataConnector.Projection
Type
System.LinkingFramework.DataConnector.Projection
Source Code:

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

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

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

  <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/SolutionName$">SCCM-SoftwareUsage</Property>

  <Property Path="$Context/Property[Type='LFX!System.LinkingFramework.DataConnector']/EntryPoint$">Microsoft.EnterpriseManagement.ServiceManager.Linking.Consumer.OperationalStore.OperationalStoreConsumer</Property>

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

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

        &lt;Script&gt;

        if not object_id('[LFXSTG].[v_MeteredProductRuleTx]') is null

        drop view [LFXSTG].[v_MeteredProductRuleTx];

        exec ('

        CREATE VIEW [LFXSTG].[v_MeteredProductRuleTx] AS

        SELECT  S.Lfx_RowId AS Lfx_RowId,

        S.Lfx_SourceId,

        S.Lfx_Timestamp,

        S.Lfx_Status,

        S.SecurityKey,

        S.ProductName,

        S.OriginalFileName,

        S.Comment,

        S.FileName,

        S.FileVersion,

        S.LanguageID,

        S.SiteCode

        FROM [LFXSTG].stg_MeteredProductRule S

        ');



        if not object_id('[LFXSTG].[v_MonthlyUsageSummaryTx]') is null

        drop view [LFXSTG].[v_MonthlyUsageSummaryTx];

        exec ('

        CREATE VIEW [LFXSTG].[v_MonthlyUsageSummaryTx] AS

        SELECT  S.Lfx_RowId AS Lfx_RowId,

        S.Lfx_SourceId,

        S.Lfx_Timestamp,

        S.Lfx_Status,

        S.TimeKey,

        S.ResourceID,

        S.FileID,

        S.MeteredUserID,

        S.UsageCount,

        S.TSUsageCount AS ''TerminalServiceUsageCount'',

        S.UsageTime,

        S.LastUsage,

        S.PrincipalName,

        S.Domain,

        S.UserName,

        S.SecurityKey

        FROM [LFXSTG].stg_MonthlyUsageSummary S

        ');



        &lt;/Script&gt;

      </Property>

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

        &lt;Script&gt;

        if not object_id('[LFXSTG].[v_MeteredProductRuleTx]') is null

        drop view [LFXSTG].[v_MeteredProductRuleTx];



        if not object_id('[LFXSTG].[v_MonthlyUsageSummaryTx]') is null

        drop view [LFXSTG].[v_MonthlyUsageSummaryTx];



        &lt;/Script&gt;

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

          MeteredProductRulesView

        </Property>

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

          C.Lfx_Timestamp

        </Property>

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

          0

        </Property>

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

          C.Lfx_RowId

        </Property>

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

          0

        </Property>

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

          500

        </Property>

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

          False

        </Property>

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

          select C.* from [LFXSTG].v_MeteredProductRuleTx C

        </Property>

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

          MeteredProductRulesConsumerCollection

        </Property>

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

          dbo.v_MeteredProductRule

        </Property>

  </Object>

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

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

          MonthlyUsageSummaryView

        </Property>

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

          E.Lfx_Timestamp

        </Property>

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

          0

        </Property>

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

          E.Lfx_RowId

        </Property>

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

          0

        </Property>

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

          500

        </Property>

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

          False

        </Property>

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

          SELECT E.Lfx_Timestamp,

          E.Lfx_RowId,

          E.Lfx_SourceId,

          E.Lfx_Status,

          E.TimeKey,

          E.UsageCount,

          E.TerminalServiceUsageCount,

          E.UsageTime,

          E.LastUsage,

          E.ResourceID,

          E.FileID,

          E.MeteredUserID

          FROM [LFXSTG].v_MonthlyUsageSummaryTx E

        </Property>

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

          MonthlyUsageSummaryConsumerCollection

        </Property>

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

          dbo.v_MonthlyUsageSummary

        </Property>

  </Object>

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

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

          MonthlySoftwareUsageIsForUserView

        </Property>

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

          E.Lfx_Timestamp

        </Property>

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

          0

        </Property>

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

          E.Lfx_RowId

        </Property>

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

          0

        </Property>

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

          500

        </Property>

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

          False

        </Property>

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

          SELECT E.Lfx_Timestamp,

          E.Lfx_RowId,

          E.Lfx_SourceId,

          E.Lfx_Status,

          E.ResourceID,

          E.FileID,

          E.MeteredUserID,

          E.Domain,

          E.UserName

          FROM [LFXSTG].v_MonthlyUsageSummaryTx E

        </Property>

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

          MonthlySoftwareUsageIsForUserCollection

        </Property>

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

          dbo.v_MonthlyUsageSummary

        </Property>

  </Object>

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

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

          MonthlySoftwareUsageIsForComputerView

        </Property>

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

          E.Lfx_Timestamp

        </Property>

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

          0

        </Property>

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

          E.Lfx_RowId

        </Property>

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

          0

        </Property>

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

          500

        </Property>

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

          False

        </Property>

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

          SELECT E.Lfx_Timestamp,

          E.Lfx_RowId,

          E.Lfx_SourceId,

          E.Lfx_Status,

          E.ResourceID,

          E.FileID,

          E.MeteredUserID,

          E.PrincipalName

          FROM [LFXSTG].v_MonthlyUsageSummaryTx E

        </Property>

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

          MonthlySoftwareUsageIsForComputerCollection

        </Property>

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

          dbo.v_MonthlyUsageSummary

        </Property>

  </Object>

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

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

          MonthlySoftwareUsageIsForMeteringRuleView

        </Property>

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

          E.Lfx_Timestamp

        </Property>

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

          0

        </Property>

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

          E.Lfx_RowId

        </Property>

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

          0

        </Property>

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

          500

        </Property>

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

          False

        </Property>

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

          SELECT E.Lfx_Timestamp,

          E.Lfx_RowId,

          E.Lfx_SourceId,

          E.Lfx_Status,

          E.ResourceID,

          E.FileID,

          E.MeteredUserID,

          E.SecurityKey

          FROM [LFXSTG].v_MonthlyUsageSummaryTx E

        </Property>

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

          MonthlySoftwareUsageIsForMeteringRuleCollection

        </Property>

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

          dbo.v_MonthlyUsageSummary, dbo.v_MeteredProductRule

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

          MeteredProductRulesConsumerCollection

        </Property>

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

          MeteredProductRulesView

        </Property>

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

          &lt;TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.Itam.SoftwareUsage.SoftwareMeteringRule&lt;/TypeName&gt;

          &lt;MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.ServiceManager.Itam.SoftwareUsage.Library.V2&lt;/MPName&gt;

          &lt;MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;1.1.2226.0&lt;/MPVersion&gt;

          &lt;MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;7c0e08a556dae555&lt;/MPToken&gt;

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

          MonthlyUsageSummaryConsumerCollection

        </Property>

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

          MonthlyUsageSummaryView

        </Property>

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

          &lt;TypeName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.Itam.SoftwareUsage.MonthlySoftwareUsage&lt;/TypeName&gt;

          &lt;MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.ServiceManager.Itam.SoftwareUsage.Library.V2&lt;/MPName&gt;

          &lt;MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;1.1.2226.0&lt;/MPVersion&gt;

          &lt;MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;7c0e08a556dae555&lt;/MPToken&gt;

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

          MonthlySoftwareUsageIsForUserCollection

        </Property>

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

          MonthlySoftwareUsageIsForUserView

        </Property>

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

          &lt;RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.Itam.SoftwareUsage.MonthlySoftwareUsageIsForUser&lt;/RelationshipName&gt;

          &lt;MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.ServiceManager.Itam.SoftwareUsage.Library.V2&lt;/MPName&gt;

          &lt;MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;1.1.2226.0&lt;/MPVersion&gt;

          &lt;MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;7c0e08a556dae555&lt;/MPToken&gt;

          &lt;SourceType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.Itam.SoftwareUsage.MonthlySoftwareUsage&lt;/SourceType&gt;

          &lt;SourceMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.ServiceManager.Itam.SoftwareUsage.Library.V2&lt;/SourceMPName&gt;

          &lt;SourceMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;1.1.2226.0&lt;/SourceMPVersion&gt;

          &lt;SourceMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;7c0e08a556dae555&lt;/SourceMPToken&gt;

          &lt;TargetType xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;System.Domain.User&lt;/TargetType&gt;

          &lt;TargetMPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;System.Library&lt;/TargetMPName&gt;

          &lt;TargetMPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;7.0.5000.0&lt;/TargetMPVersion&gt;

          &lt;TargetMPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;31bf3856ad364e35&lt;/TargetMPToken&gt;

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

          MonthlySoftwareUsageIsForComputerCollection

        </Property>

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

          MonthlySoftwareUsageIsForComputerView

        </Property>

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

          &lt;RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.Itam.SoftwareUsage.MonthlySoftwareUsageIsForComputer&lt;/RelationshipName&gt;

          &lt;MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.ServiceManager.Itam.SoftwareUsage.Library.V2&lt;/MPName&gt;

          &lt;MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;1.1.2226.0&lt;/MPVersion&gt;

          &lt;MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;7c0e08a556dae555&lt;/MPToken&gt;

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

          MonthlySoftwareUsageIsForMeteringRuleCollection

        </Property>

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

          MonthlySoftwareUsageIsForMeteringRuleView

        </Property>

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

          &lt;RelationshipName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.Itam.SoftwareUsage.MonthlySoftwareUsageIsForMeteringRule&lt;/RelationshipName&gt;

          &lt;MPName xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;Provance.ServiceManager.Itam.SoftwareUsage.Library.V2&lt;/MPName&gt;

          &lt;MPVersion xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;1.1.2226.0&lt;/MPVersion&gt;

          &lt;MPToken xmlns="http://schemas.microsoft.com/sdm/servicedesk/linking/2005/09"&gt;7c0e08a556dae555&lt;/MPToken&gt;

        </Property>

  </Object>

</ObjectTemplate>