Microsoft.Exchange.2010.Reports.TenantMapping.WriteAction (WriteActionModuleType)

Element properties:

Member Modules:

Source Code:

<WriteActionModuleType ID="Microsoft.Exchange.2010.Reports.TenantMapping.WriteAction" Accessibility="Internal" Batching="false">

  <Configuration/>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

        <WriteAction ID="WA" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.BulkInsertBulkDataWriter">

          <ManagementGroupId>$Target/ManagementGroup/Id$</ManagementGroupId>

          <DataSetId>$MPElement[Name='Microsoft.Exchange.2010.Reports.Dataset.TenantMapping']$</DataSetId>

          <DataRoutingKey/>

          <BulkInsertBatchSize>5000</BulkInsertBatchSize>

          <MaxBatchesToProcessBeforeMaintenanceCount>50</MaxBatchesToProcessBeforeMaintenanceCount>

          <TableName>Exchange2010.TenantMappingRawStagingV14</TableName>

          <MaxExecutionAttemptCount>0</MaxExecutionAttemptCount>

          <ExecutionAttemptTimeoutIntervalSeconds>0</ExecutionAttemptTimeoutIntervalSeconds>

          <TableColumns>

            <Column>

              <Name>DateTime</Name>

              <Type>DateTime</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='DateTime']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

              <AdditionalProcessing>

                <DateTimeToSqlFormat/>

              </AdditionalProcessing>

            </Column>

            <Column>

              <Name>TenantName</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='TenantName']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TenantGuid</Name>

              <Type>Guid</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='TenantGuid']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TenantReseller</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='TenantReseller']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TenantServicePlan</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='TenantServicePlan']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TenantWhenCreated</Name>

              <Type>DateTime</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='TenantWhenCreated']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

              <AdditionalProcessing>

                <DateTimeToSqlFormat/>

              </AdditionalProcessing>

            </Column>

            <Column>

              <Name>TenantDomain</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='TenantDomain']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TenantAdminEmail</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='TenantAdminEmail']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TenantDLCount</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='TenantDLCount']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TenantContactCount</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='TenantContactCount']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MdbName</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='MdbName']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MdbGuid</Name>

              <Type>Guid</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='MdbGuid']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MdbAllMailboxCount</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='MdbAllMailboxCount']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MdbActiveMailboxCount</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='MdbActiveMailboxCount']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>HostServerAndDagPairs</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='HostServerAndDagPairs']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Forest</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='Forest']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>ADSite</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Property[@Name='ADSite']</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

          </TableColumns>

          <SqlAuthentication>

            <Login>$RunAs[Name='SCDW!Microsoft.SystemCenter.DataWarehouse.SqlAuthenticationActionAccount']/UserName$</Login>

            <Password>$RunAs[Name='SCDW!Microsoft.SystemCenter.DataWarehouse.SqlAuthenticationActionAccount']/Password$</Password>

          </SqlAuthentication>

        </WriteAction>

      </MemberModules>

      <Composition>

        <Node ID="WA"/>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <InputType>System!System.PropertyBagData</InputType>

</WriteActionModuleType>