Monitoraggio di processi: Azione di scrittura raccolta dello stato di integrità del processo
Microsoft.Windows.Server.10.0.Process.HealthStateDW.WriteAction (WriteActionModuleType)
Questa azione di scrittura scrive lo stato di integrità del processo nel data warehouse SCOM.
Element properties:
Member Modules:
Source Code:
<WriteActionModuleType ID="Microsoft.Windows.Server.10.0.Process.HealthStateDW.WriteAction" Accessibility="Internal">
<Configuration/>
<OverrideableParameters/>
<ModuleImplementation Isolation="Any">
<Composite>
<MemberModules>
<WriteAction ID="WA" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.BulkInsertBulkDataWriter">
<ManagementGroupId>$Target/ManagementGroup/Id$</ManagementGroupId>
<DataSetId>$MPElement[Name='Microsoft.Windows.Server.10.0.HealthStatesCollection.Dataset']$</DataSetId>
<DataRoutingKey/>
<BulkInsertBatchSize>5000</BulkInsertBatchSize>
<MaxBatchesToProcessBeforeMaintenanceCount>100</MaxBatchesToProcessBeforeMaintenanceCount>
<TableName>ProcessMonitoring.ProcesStateStaging</TableName>
<MaxExecutionAttemptCount>0</MaxExecutionAttemptCount>
<ExecutionAttemptTimeoutIntervalSeconds>0</ExecutionAttemptTimeoutIntervalSeconds>
<TableColumns>
<Column>
<Name>ManagedEntityGuid</Name>
<Type>Guid</Type>
<XPathExpression Target="DataItem">DataItem/MeId</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>CollectedDate</Name>
<Type>DateTime</Type>
<XPathExpression Target="DataItem">DataItem/Dt</XPathExpression>
<ValueProperty>Value</ValueProperty>
<AdditionalProcessing>
<DateTimeToSqlFormat/>
</AdditionalProcessing>
</Column>
<Column>
<Name>DateKey</Name>
<Type>Int</Type>
<XPathExpression Target="DataItem">DataItem/Dk</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>TimeKey</Name>
<Type>Int</Type>
<XPathExpression Target="DataItem">DataItem/Tk</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>ProcessId</Name>
<Type>Int</Type>
<XPathExpression Target="DataItem">DataItem/Pid</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>CpuHealthState</Name>
<Type>Int</Type>
<XPathExpression Target="DataItem">DataItem/CpuHs</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>MemoryHealthState</Name>
<Type>Int</Type>
<XPathExpression Target="DataItem">DataItem/MemHs</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>HandleCountHealthState</Name>
<Type>Int</Type>
<XPathExpression Target="DataItem">DataItem/HlcHs</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>AggregateHealthState</Name>
<Type>Int</Type>
<XPathExpression Target="DataItem">DataItem/aHs</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>CpuThreshold</Name>
<Type>Double</Type>
<XPathExpression Target="DataItem">DataItem/CpuThreshold</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>MemoryThreshold</Name>
<Type>Double</Type>
<XPathExpression Target="DataItem">DataItem/MemThreshold</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>HandleCountThreshold</Name>
<Type>Double</Type>
<XPathExpression Target="DataItem">DataItem/HlcThreshold</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>ProcessName</Name>
<Type>String</Type>
<XPathExpression Target="DataItem">DataItem/Name</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>Description</Name>
<Type>String</Type>
<XPathExpression Target="DataItem">DataItem/Desc</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>CommandLine</Name>
<Type>String</Type>
<XPathExpression Target="DataItem">DataItem/Cmd</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>CommandLineHash</Name>
<Type>String</Type>
<XPathExpression Target="DataItem">DataItem/Hash</XPathExpression>
<ValueProperty>Value</ValueProperty>
</Column>
<Column>
<Name>UserName</Name>
<Type>String</Type>
<XPathExpression Target="DataItem">DataItem/User</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>Microsoft.Windows.Server.10.0.DataItemProcessInfo.Type</InputType>
</WriteActionModuleType>