Moving child rule groups between parent groups in MOM 2005

Here’s a quick solution (offered up by Gerald Mims via MSMOM mailing list) I think some folks may not be aware of, so I thought it worth sharing…As noted, this is a direct database update to Onepoint, which is unsupported, but potentially a huge timesaver if tested / implemented with care in a lab or staging environment (never update Onepoint in production if you can help it), and then exporting the MP with the new rule structure for import into your production environment. If you want to move a rule group you can do it this way. Find the rule group in the MOM Administrator Console, right click on it then select delete. Choose to “delete the relationship with the parent group”. This does not delete the rules, but just makes it a top level rule group. If that's where you want it, then do nothing else, but if you want it to be a child of another rule group, you will have to run this update query on the Onepoint database. In these query below you will need to enter the Rule Group Guid of the new parent group where EnterParentGuidHere is listed. And then enter the Rule Group GUID of the new Child Group where EnterChildGUIDHere is listed. ---Moves Rule Group from root to below a parent insert into ProcessRuleMembership ---idProcessRuleGroup is the Parent. idProcessRuleMember is the Child (idProcessRuleGroup,idProcessRuleMember,Timeadded,isdeleted) values ('EnterParentGuidHere','EnterChildGUIDHere',getdate(),0) Check out Gerald’s other work on his gotdotnet page at http://www.gotdotnet.com/codegallery/codegallery.aspx?id=ada0df24-c103-42c0-9a70-3e805be003cd