[OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR] [OR]
Questa regola genera un avviso in caso di aumento allarmante di errori delle prestazioni della shell in qualsiasi tipo di computer all'interno dell'azienda
Calo delle prestazioni della shell
Target | Microsoft.SystemCenter.DataWarehouse | ||
Category | EventCollection | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Warning | ||
Alert Priority | Normal | ||
Remotable | True | ||
Alert Message |
|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.Windows.Client.Vista.SQLProvider | Default |
GenerateAlert | WriteAction | System.Health.GenerateAlert | Default |
<Rule ID="Microsoft.Windows.Client.Vista.ComputerGroup.ShellPerfTrends" 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.vShellPerfAggregationComputer AS Result
JOIN Vista.ComputerData ON (Vista.ComputerData.ComputerDataRowId = Result.ComputerDataRowId)
WHERE (SELECT SUM(NumComputers)
FROM Vista.vShellPerfAggregationComputer AS ThisWeek
WHERE ThisWeek.ComputerDataRowId = Result.ComputerDataRowId
AND DATEDIFF(day, ThisWeek.DateTime, GETUTCDATE()) <= 7
GROUP BY ThisWeek.ComputerDataRowId
)
>= 1.2 *
(SELECT SUM(NumComputers)
FROM Vista.vShellPerfAggregationComputer AS LastWeek
WHERE LastWeek.ComputerDataRowId = Result.ComputerDataRowId
AND DATEDIFF(day, LastWeek.DateTime, GETUTCDATE()) <= 14
AND DATEDIFF(day, LastWeek.DateTime, GETUTCDATE()) > 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.ShellPerfTrends.AlertMessage"]$</AlertMessageId>
<AlertParameters/>
<Suppression>
<SuppressionValue/>
</Suppression>
</WriteAction>
</WriteActions>
</Rule>