vendredi 19 février 2010

Search SCOM Database for MOMUIGeneratedRule entries

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%’

Aucun commentaire:

Enregistrer un commentaire