CA Event: SQL data level auditing template disabled

CA_Event_SQL_data_level_auditing_template_disabled_Rule (Rule)

Knowledge Base article:

Management Pack
External Knowledge Sources
http://documents.software.dell.com/change-auditor/6.7/event-reference-guide/?ParentProduct=941
 
© 2015 Dell Inc.
ALL RIGHTS RESERVED.

Element properties:

TargetChangeAuditor.Quest_ChangeAuditor_Installation
CategoryCustom
EnabledTrue
Alert GenerateTrue
Alert SeverityInformation
Alert PriorityNormal
RemotableTrue
Alert Message
CA Event: SQL data level auditing template disabled
Date/Time (GMT): {0}
Changed By: {1}
Changed On: {2}
SubSystem: {3}
Action: {4}
Event Type: {5}
Object Name: {6}
Description: {7}
From: {8}
To: {9}

Member Modules:

ID Module Type TypeId RunAs 
WMIDataSource DataSource Microsoft.Windows.WmiEventProvider.FilteredEventProvider Default
GenerateAlert WriteAction System.Health.GenerateAlert Default
WriteToDB WriteAction Microsoft.SystemCenter.CollectEvent Default
WriteToDW WriteAction Microsoft.SystemCenter.DataWarehouse.PublishEventData Default

Source Code:

<Rule ID="CA_Event_SQL_data_level_auditing_template_disabled_Rule" Enabled="true" Target="ChangeAuditor.Quest_ChangeAuditor_Installation" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>Custom</Category>
<DataSources>
<DataSource ID="WMIDataSource" TypeID="WindowsLibrary!Microsoft.Windows.WmiEventProvider.FilteredEventProvider">
<NameSpace>root\Dell\ChangeAuditor</NameSpace>
<Query>SELECT * FROM CAAD_AlertEvent</Query>
<PollInterval>15</PollInterval>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery>Property[@Name='EventClassID']</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value>c9390cfa-fba1-4565-aca5-ce2ca99b0688</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="WriteToDB" TypeID="SystemCenterLibrary!Microsoft.SystemCenter.CollectEvent"/>
<WriteAction ID="WriteToDW" TypeID="DataWarehouseLibrary!Microsoft.SystemCenter.DataWarehouse.PublishEventData"/>
<WriteAction ID="GenerateAlert" TypeID="HealthLibrary!System.Health.GenerateAlert">
<Priority>1</Priority>
<Severity>0</Severity>
<AlertName/>
<AlertDescription/>
<AlertOwner/>
<AlertMessageId>$MPElement[Name="CA_Event_SQL_data_level_auditing_template_disabled_Rule.AlertMessage"]$</AlertMessageId>
<AlertParameters/>
<Suppression/>
<Custom1/>
<Custom2/>
<Custom3/>
<Custom4/>
<Custom5/>
<Custom6/>
<Custom7/>
<Custom8/>
<Custom9/>
<Custom10/>
</WriteAction>
</WriteActions>
</Rule>