Vista 聚合磁盘趋势计算机

Microsoft.Windows.Client.Vista.ComputerGroup.DiskTrendsComputer (Rule)

Knowledge Base article:

摘要

当企业中任何给定计算机类型的磁盘故障增加趋势令人担忧时,此规则会生成一个警报

原因

磁盘故障

Element properties:

TargetMicrosoft.SystemCenter.DataWarehouse
CategoryEventCollection
EnabledTrue
Alert GenerateTrue
Alert SeverityWarning
Alert PriorityNormal
RemotableTrue
Alert Message
企业中特定计算机类型的磁盘本周遇到的磁盘故障比上周多 20\%
在特定计算机类型中检测到的磁盘故障有增多的趋势。请在“警报上下文”部分查看以查明有关遇到问题的计算机类型的更多信息。要更好地了解磁盘运行状况状态,请查看 Windows Vista 磁盘运行状况报告;要获得遇到问题的计算机列表,请查看 Windows Vista 磁盘故障报告。

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.Windows.Client.Vista.SQLProvider Default
GenerateAlert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.Windows.Client.Vista.ComputerGroup.DiskTrendsComputer" Target="SCDW!Microsoft.SystemCenter.DataWarehouse" Enabled="true" ConfirmDelivery="true" DiscardLevel="60" Remotable="true" Priority="Normal">
<Category>EventCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.Windows.Client.Vista.SQLProvider">
<Query>
SELECT 1, Vista.ComputerData.Manufacturer + ' ' + Vista.ComputerData.Model
FROM Vista.vDiskFailureAggregationComputer AS Result
JOIN Vista.ComputerData ON (Vista.ComputerData.ComputerDataRowId = Result.ComputerDataRowId)
WHERE (SELECT SUM(NumDrives)
FROM Vista.vDiskFailureAggregationComputer AS ThisWeek
WHERE ThisWeek.ComputerDataRowId = Result.ComputerDataRowId
AND DATEDIFF(day, ThisWeek.DateTime, GETUTCDATE()) &lt;= 7
GROUP BY ThisWeek.ComputerDataRowId
)
&gt;= 1.2 *
(SELECT SUM(NumDrives)
FROM Vista.vDiskFailureAggregationComputer AS LastWeek
WHERE LastWeek.ComputerDataRowId = Result.ComputerDataRowId
AND DATEDIFF(day, LastWeek.DateTime, GETUTCDATE()) &lt;= 14
AND DATEDIFF(day, LastWeek.DateTime, GETUTCDATE()) &gt; 7
GROUP BY LastWeek.ComputerDataRowId
)
GROUP BY Vista.ComputerData.Manufacturer + ' ' + Vista.ComputerData.Model
</Query>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="GenerateAlert" TypeID="SystemHealth!System.Health.GenerateAlert">
<Priority>1</Priority>
<Severity>1</Severity>
<AlertMessageId>$MPElement[Name="Microsoft.Windows.Client.Vista.ComputerGroup.DiskTrendsComputer.AlertMessage"]$</AlertMessageId>
<AlertParameters/>
<Suppression>
<SuppressionValue/>
</Suppression>
</WriteAction>
</WriteActions>
</Rule>