OPSMGR 2007 R2 Workflow failures. how do I find the rule

A lot of time you would encounter workflow failures , specially around custom created rules. At times it becomes difficult to find out where the rule resides , which class it was targetted to,   you would simply like to relate the Workflow Name to the Rule/Monitor in the UI.

 

 

We can use inbuilt View for Rules called Ruleview, here a query which will give you the details like, RuleName, which class it is targetted and which MP it resides in.

=======================================================

select Rules.Name as WorkflowId,Rules.DisplayName as RuleName, TargetClass.TypeName as Class, ManagementPack.MPFriendlyName as MP from ruleview  as Rules

join ManagedType as TargetClass

on

Rules.TargetMonitoringClassId = TargetClass.ManagedTypeId  join ManagementPack

on

Rules.ManagementPackId = ManagementPack.ManagementPackId

where Name like 'MOmUIxxxxxxxxxxxxxxxx%'

=======================================================

Sample result is given below

 

Hope you find this information useful.
Cheers !!

Jeevan S Bisht