Home
  •  

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>