Geeks With Blogs

News My Blog has been MOVED to https://mfreidge.wordpress.com
Michael Freidgeim's OLD Blog My Blog has been MOVED to https://mfreidge.wordpress.com

In MOM 2000 there is no ability to quickly find which rules use the script.

I found a script in MOM/Rules/Advanced/Scripts/  ( or alternatively in DB one point Script table) and my question was which rules run the script.

Use [OnePoint].[dbo].[ProcessRuleToScript] table to find the rules.

 

select * from [OnePoint].[dbo].[ProcessRuleToScript]

where Idscript='5c4a58cf-709c-4a1f-895a-0aec79ff55a9'(this GUID is just example)

 

select * from [OnePoint].[dbo].[ProcessRule]

where idProcessRule in

(

select idProcessRule from [OnePoint].[dbo].[ProcessRuleToScript]

where Idscript='5c4a58cf-709c-4a1f-895a-0aec79ff55a9'

)

The SQL gives names of rules, but I wasn't able to find where ProcessingRulePath is stored, so I had to manually expand rules tree to find rules in MOM MMC console Posted on Thursday, July 10, 2008 1:28 AM MOM | Back to top

Related Posts on Geeks With Blogs Matching Categories

Comments on this post: Find which MOM rules use a script.

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Michael Freidgeim | Powered by: GeeksWithBlogs.net