Data Quality Script

Check-DataQuality.ps1

Runs checks on data quality on FIM Portal objects and repairs where possible. Example checks are:

• A string value matches one on a referenced object,
• A boolean value is set correctly,
• The correct value is set on an object based on the state of a referring object,
• A value is correct based on the object being a member of a Set.

When checks find an invalid object they may be fixed by:

• Copying a nominated attribute from a referenced object to the invalid object,
• Deleting a particular attribute value,
• Setting an attribute to a specified value,
• Expiring an object,
• Forcing a Set re-transition (criteria sets only).

The Checks are defined in the $Checks hashtable which is contained in a separate script - see Checks-Test.ps1 for examples and explanation. To allow different scheduling options this hashtable is defined in a separate file and then passed in as a parameter, allowing different Checks files to be run on different schedules, depending on their load and importance.

BEFORE USING

1. You must have FIMPowerShell.ps1 from http://technet.microsoft.com/en-us/library/ff720152(v=ws.10).aspx
2. Define your Checks. See explanation in the sample Checks-Test.ps1 file.
3. Modify the default settings for script parameters and the location of the FIMPowerShell.ps1 script (below) to match your environment.

SCRIPT PARAMETERS

• ChecksFile (Required) The full path to the script containing the $Checks hashtable.
• RepairsLogFolder (Required) The folder to use in creating a log of any repairs done.
• VerboseLogFile (Optional) Logs errors and information about the script run. This is different to repair logs and should be used if troubleshooting this script.

Downloads

Check-DataQuality.ps1
Checks-Test.ps1