Welcome to Aquilaweb

MVP David Allen's weblog advising on
System Center Operations Manager

Identify UIGenerated Rules & Monitors

If you have tried reporting on a custom rule or get an error relating to a custom monitor you should have noticed that you do not see the pretty display name you gave the rule or monitor when creating it, you get something like MOMUIGeneratedRule or UIGeneratedMonitor. This can cause all sorts of issues when you have lots of custom rules and monitors as you do not know which is which. To figure help figure this out the two scripts below will show the "UIGenerated" name and the associated display name.


Rule SQL Query:
select distinct
            rule.RuleID,
            rule.RuleName,
            rule.ManagementPackId,
            local.ElementName,
            local.LTValue,
            mp.MPFriendlyName
from Rules rule
join LocalizedText local on local.LTStringID = rule.RuleID
join ManagementPack mp on mp.ManagementPackID = rule.ManagementPackID
where RuleName like '%UIGenerated%'


Monitor SQL Query:
select distinct
            monitor.MonitorID,
            monitor.MonitorName,
            monitor.ManagementPackId,
            local.ElementName,
            local.LTValue,
            mp.MPFriendlyName
from Monitor monitor
join LocalizedText local on local.LTStringID = monitor.MonitorID
join ManagementPack mp on mp.ManagementPackID = monitor.ManagementPackID
where MonitorName like '%UIGenerated%'

18 Feb, 2008 | David

Comments

No comments yet. You can be the first!

Leave comment