ConfigMgr 2007 Consolidated Status: Database Notification Monitor failed to execute a Site Maintenance task

SMSv4_Consolidated_Status__Database_Notification_Monitor_failed_to_execute_a_Site_Maintenance_task_1_Rule (Rule)

Knowledge Base article:

Summary

This rule consolidates events for its companion event processing rule:

ConfigMgr Status: SQL Monitor failed to execute a database maintenance task.

Element properties:

TargetMicrosoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation
CategoryEventCollection
EnabledFalse
Alert GenerateFalse
RemotableTrue
CommentMom2005ID='{ABB91FD8-C14E-48F5-A8C9-5EABFEC8A1BB}';MOM2005ComputerGroupID={15348338-2E39-4B34-9DFF-4719AE7F1CCE}

Member Modules:

ID Module Type TypeId RunAs 
_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_ DataSource System.Mom.BackwardCompatibility.FilteredEvent.DataProvider Default
ConsolidatedEventWriteAction WriteAction System.Mom.BackwardCompatibility.ConsolidatedEventResponse Default

Source Code:

<Rule ID="SMSv4_Consolidated_Status__Database_Notification_Monitor_failed_to_execute_a_Site_Maintenance_task_1_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation" Enabled="false" ConfirmDelivery="false" Comment="Mom2005ID='{ABB91FD8-C14E-48F5-A8C9-5EABFEC8A1BB}';MOM2005ComputerGroupID={15348338-2E39-4B34-9DFF-4719AE7F1CCE}">
<Category>EventCollection</Category>
<DataSources>
<DataSource ID="_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_" Comment="{F320DA51-13BF-11D3-B2CD-00A0C92A28B4}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.FilteredEvent.DataProvider">
<Expression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value>2401</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="String">PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value>ConfigMgr 2007 Monitor SMS Status Messages</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</Expression>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="ConsolidatedEventWriteAction" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.ConsolidatedEventResponse">
<ConsolidationProperties>
<PropertyXPathQuery>EventDisplayNumber</PropertyXPathQuery>
<PropertyXPathQuery>PublisherName</PropertyXPathQuery>
<PropertyXPathQuery>EventDescription</PropertyXPathQuery>
</ConsolidationProperties>
<Interval>3600</Interval>
</WriteAction>
</WriteActions>
</Rule>