Creating Reports for SCOM and SCVMM - Microsoft System Center Reporting - page 196

There's more...
You have additional report data filter options available to you based on your requirements.
Rules and monitors
When authoring reports for Operations Manager, you might want to filter data in your re-
port by rules or monitors. For instance, you might want to retrieve a list of alerts that were
raised by a particular rule or monitor or filter performance data by a certain rule.
The vRule and vMonitor views contain information for all rules and monitors, respect-
ively. You can join the vRule view on the RuleRowId column and the vMonitor view
on the MonitorRowId column to the views in the different datasets available in the data-
base.
If you want to further filter rules and monitors by the management packs they are defined
in, you can establish a join between vRule and vMonitor to the vManagementPack
view on the ManagementPackRowId column.
You can use the following query to retrieve a list of all the rules defined in Active Direct-
ory Server Common Library:
SELECT
R.RuleRowId,
R.RuleDefaultName
FROM
vRule R
INNER JOIN vManagementPack MP ON
R.ManagementPackRowId = MP.ManagementPackRowId
WHERE
MP.ManagementPackSystemName =
'Microsoft.Windows.Server.AD.Library'