System Center Operations Manager by Jonathan Hambrook

August 13, 2007

Search SCOM Database for MOMUIGeneratedRule entries

Filed under: Issues, Microsoft, SCOM 2007 — opsmgr @ 9:08 pm

If you are getting MOMUIGeneratedRule descriptions in your reports here is an SQL Query that will list all of them and their descriptions.

select distinct
               r.RuleID,
               r.RuleName,
               lt.ElementName,
               lt.LTValue,
               r.ManagementPackId,
               mp.MPFriendlyName
from rules r
join LocalizedText lt on lt.LTStringID = r.RuleID
join ManagementPack mp on mp.ManagementPackID = r.ManagementPackID
where rulename like ‘MOMUIGeneratedRule%’

No Comments Yet »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.