FIM2010 Database cleanup
Hi ...
I have FIM2010 in my production environment with over 70 000 (users) objects in the portal.
What is the best way to "clean up" the portal... I want to delete users, delete the ERE's and DRE's.
I want to back up my VM in a initial stage.
Thanks,***** Paulo H. Campos - So Paulo/Brasil ***** http://identitypedia.blogspot.com (in PT-BR)
May 24th, 2010 12:19am
I posted a script in the script box a while back which you can use to delete users from a test environment. I'm not sure about the ere's and dre's.http://www.wapshere.com/missmiis
Free Windows Admin Tool Kit Click here and download it now
May 24th, 2010 11:07am
"A method to remove orphaned ExpectedRuleEntry objects from your environment" explains how to delete orphaned EREs.
You can use the same logic to delete orphaned DREs.
In general, you are better off using database backups of certain states.
See "Using PowerShell to manage multiple FIM scenarios on a lab computer" for more details on this.
Cheers,
Markus
Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation
May 25th, 2010 7:13pm
Also of interest, here is a discussion on SQL Backups including Transaction Log backups and how to restore them using StopAT to restore back to a particular moment
Restoring your FIM databases to the moment before oops
David Lundell www.ilmBestPractices.com
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2010 4:37am
Thanks...
I will use it in my production environment... in Lab works 100%!!!!
Cheers,***** Paulo H. Campos - So Paulo/Brasil ***** http://identitypedia.blogspot.com (in PT-BR)
May 29th, 2010 5:42pm