Knock, knock! Who's there?

Dealing with OS and Identity

Browse by Tags

Related Posts
  • Blog Post: SQL Script: Delete Run History

    Unsupported: Use at your own risk These three simple lines allow you to clear the Run History. You can use this when admin client does not allow you to clear the history through the UI. I've seen this a couple of times when History is huge. TRUNCATE TABLE FIMSynchronizationService . dbo . mms_run_history...
  • Blog Post: SQL Script: Delete all CS and MV data

    Unsupported: Use at your own risk This script will delete all the records from FIM Sync database tables without affecting the MAs. It is useful when you have lots of MAs and export srvconfig/restore empty db/import srvconfig means painful enter of login data against all data sources. TRUNCATE TABLE FIMSynchronizationService...
  • Blog Post: SQL Script: Finding duplicates on supposedly unique values

    Unsupported: Use at your own risk Sometimes you load data into metaverse that is supposed to be unique and you do not want to use FindMVEntries technique due to performance impact. This SQL scripts allow you to find out directly from DB if you have unexpected duplicates so you can talk to data store...