Geeks With Blogs

News My Blog has been MOVED to
Michael Freidgeim's OLD Blog My Blog has been MOVED to

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: