So you want to base an Alert off an Event Log message in a Clustered Environment?

So you've got a shiny new installation System Center Operations Manager (SCOM) 2007 and some SQL Servers that are Clustered. One might think it would be a simple matter of creating a rule and targeting the cluster.

One would be wrong.

The xml of the management pack has to be edited to include the 1 element added to the configuration of the datasource for the rule. For example:

.
.
.
<DataSource ID="DS" TypeID="Windows!Microsoft.Windows.EventProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<LogName>Application</LogName>
<AllowProxying>1</AllowProxying> <!-- This is it here -->
<Expression>
.
.
.