Exchange 2013: Mailbox statistics collection write action

Microsoft.Exchange.15.MailboxStats.WriteAction (WriteActionModuleType)

This write action writes the Exchange 2013 Mailbox statistics into SCOM data warehouse.
Element properties:

Show References:
- Rules (1)
Type	WriteActionModuleType
Isolation	Any
Accessibility	Internal
RunAs	Default
InputType	System.PropertyBagData
Member Modules:

ID	Module Type	TypeId	RunAs
WA	WriteAction	Microsoft.SystemCenter.DataWarehouse.BulkInsertBulkDataWriter	Default
Source Code:

<WriteActionModuleType ID="Microsoft.Exchange.15.MailboxStats.WriteAction" Accessibility="Internal">

  <Configuration/>

  <OverrideableParameters/>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

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

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

                <DataSetId>$MPElement[Name='Microsoft.Exchange.15.MailboxStatsCollection.Dataset']$</DataSetId>

                <DataRoutingKey />

                <StoredProcedureName>dbo.Exchange2013_MailboxStatsXmlStaging_Insert</StoredProcedureName>

                <MaxExecutionAttemptCount>6</MaxExecutionAttemptCount>

                <ExecutionAttemptTimeoutIntervalSeconds>600</ExecutionAttemptTimeoutIntervalSeconds>

                <XmlElements>

                  <XmlElement>

                    <Name>DataItem</Name>

                    <XPathExpression Target="DataItem">/DataItem</XPathExpression>

                    <ValueProperty>OuterXml</ValueProperty>

                  </XmlElement>

                </XmlElements>

              </WriteAction>-->

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

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

          <DataSetId>$MPElement[Name='Microsoft.Exchange.15.MailboxStatsCollection.Dataset']$</DataSetId>

          <DataRoutingKey/>

          <BulkInsertBatchSize>5000</BulkInsertBatchSize>

          <MaxBatchesToProcessBeforeMaintenanceCount>100</MaxBatchesToProcessBeforeMaintenanceCount>

          <TableName>Exchange2013.MailboxStatsStaging</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>Mailbox_ArchiveName</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_ArchiveState</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_ArchiveStatus</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute1</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute10</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute11</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute12</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute13</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute14</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute15</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute2</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute3</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute4</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute5</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute6</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute7</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute8</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_CustomAttribute9</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_Database</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_DistinguishedName</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_EmailAddresses</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_EmailAddressPolicyEnabled</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_ExchangeGuid</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_ExchangeVersion</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_Identity</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsExcludedFromServingHierarchy</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsLinked</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsMachineToPersonTextMessagingEnabled</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsMailboxEnabled</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsPersonToPersonTextMessagingEnabled</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsResource</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsRootPublicFolderMailbox</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsShared</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsSoftDeletedByDisable</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsSoftDeletedByRemove</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_IsValid</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_Name</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_ObjectCategory</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_ObjectClass</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_OrganizationalUnit</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_RecipientType</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_ServerName</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_UserPrincipalName</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Mailbox_WhenChangedUTC</Name>

              <Type>DateTime</Type>

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

              <ValueProperty>Value</ValueProperty>

              <AdditionalProcessing>

                <DateTimeToSqlFormat/>

              </AdditionalProcessing>

            </Column>

            <Column>

              <Name>Mailbox_WhenCreatedUTC</Name>

              <Type>DateTime</Type>

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

              <ValueProperty>Value</ValueProperty>

              <AdditionalProcessing>

                <DateTimeToSqlFormat/>

              </AdditionalProcessing>

            </Column>

            <Column>

              <Name>MailboxStatistics_AssociatedItemCount</Name>

              <Type>Long</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_DeletedItemCount</Name>

              <Type>Long</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_IsArchiveMailbox</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_IsMoveDestination</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_IsQuarantined</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_IsValid</Name>

              <Type>Boolean</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_ItemCount</Name>

              <Type>Long</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_LastLogoffTime</Name>

              <Type>DateTime</Type>

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

              <ValueProperty>Value</ValueProperty>

              <AdditionalProcessing>

                <DateTimeToSqlFormat/>

              </AdditionalProcessing>

            </Column>

            <Column>

              <Name>MailboxStatistics_LastLogonTime</Name>

              <Type>DateTime</Type>

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

              <ValueProperty>Value</ValueProperty>

              <AdditionalProcessing>

                <DateTimeToSqlFormat/>

              </AdditionalProcessing>

            </Column>

            <Column>

              <Name>MailboxStatistics_MailboxGuid</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_MailboxType</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_TotalDeletedItemSizeMB</Name>

              <Type>Double</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MailboxStatistics_TotalItemSizeMB</Name>

              <Type>Double</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>ManagedEntityGuid</Name>

              <Type>String</Type>

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

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>RawItem</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem</XPathExpression>

              <ValueProperty>OuterXml</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>