Home > SQL Queries > Find a Custom Rule that is causing a problem

Find a Custom Rule that is causing a problem

You can tell if a rule is a custom rule – the description will include the parameter “MOMUIGeneratedRule”

If a custom rule is causing a problem, you can run the following script against the operationsmanager database:

select *
from rules r
join managementpack mp
on r.managementpackid = mp.managementpackid
where r.rulename like ‘%MomUIGeneratedRulee8c779c3eb7f43e18da1e5a0cdf23c4%&’

This will give you details about the rule so that you can troubleshoot it.

Advertisements
Categories: SQL Queries
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: