EREs DREs and SQL Jobs
Hi,
So there are powershell scripts to removed orphaned EREs and DREs.
Does the FIM_DeleteExpiredSystemObjectsJob clean these up too?
If not, how have people automated this process?
Regards,
SK
May 18th, 2012 12:55am
That one doesn't no - however if you have installed FIM 2010 Update 2 (http://support.microsoft.com/kb/2520954) there is a new stored procedure that will do the trick
DeleteOrphanedRulesByType.
From the link above under the heading Fixed issues in FIM Service
(Issue 4)- there is an explanation of the procedure and how to use it.
Andrew.
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 1:34am
Thank you, how do I turn these into something that will run and execute say once a week?
May 18th, 2012 1:59am
Create a SQL Agent job to execute the SP and have it run as often as desired.Frank C. Drewes III - Senior Consultant: Oxford Computer Group
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 3:01pm
Create a SQL Agent job to execute the SP and have it run as often as desired.Frank C. Drewes III - Senior Consultant: Oxford Computer Group
May 18th, 2012 3:06pm
Thank you - what would be a recommended schedule for clearing EREs and DREs?
once a week? once a month?
Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2012 7:43pm
There is no recommended schedule.
Ideally, you shouldn't have to worry about them at all.
Orphaned can be an indicator for a design issue - unless, you know where you are generating them and you are accepting the fact that your design generates them.
Cheers,
Markus Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation
May 31st, 2012 8:47pm


