FIM Run History Statistics with fancy Excel Layout

When conducting a FIM Health Check , the FIM Run Profile statistics are one of the parameters to assess the FIM performance.
Putting the numbers in a table is nice but for a quick overview, some color grading in an Excel sheet helps a lot.

So I extended the script that Adam Weigert has posted on his blog (

Take Adam’s script, and just before the closing bracket you add:

| convertto-csv -notypeinformation `
| out-file FIMRunProfilesStats.csv 

The result is a CSV file like :

“FIM”,”Full Import”,”2″,”00:00:00.6380000″,”00:00:00.4630000″,”00:00:00.8130000″
“FIM”,”Delta Sync”,”1″,”00:00:13.5870000″,”00:00:13.5870000″,”00:00:13.5870000″
“ADLDS”,”Full Import”,”2″,”00:00:00.1085000″,”00:00:00.0300000″,”00:00:00.1870000″
“FIM”,”Full Sync”,”1″,”00:00:11.7870000″,”00:00:11.7870000″,”00:00:11.7870000″
“Adatum AD”,”Export”,”1″,”00:00:32.4470000″,”00:00:32.4470000″,”00:00:32.4470000″
“Adatum AD”,”Delta Sync”,”2″,”00:00:08.3850000″,”00:00:01.0530000″,”00:00:15.7170000″
“HR Data”,”Full Import”,”1″,”00:00:00.4000000″,”00:00:00.4000000″,”00:00:00.4000000″
“Adatum AD”,”Full Import”,”4″,”00:00:00.5615000″,”00:00:00.2970000″,”00:00:01.2030000″
“Adatum AD”,”Delta Import”,”2″,”00:00:00.0545000″,”00:00:00.0460000″,”00:00:00.0630000″
“ADLDS”,”Delta Import”,”3″,”00:00:00.1086667″,”00:00:00.0160000″,”00:00:00.2830000″
“Adatum AD”,”Full Sync”,”1″,”00:00:01.5870000″,”00:00:01.5870000″,”00:00:01.5870000″
“ADLDS”,”Delta Sync”,”2″,”00:00:06.9930000″,”00:00:01.0500000″,”00:00:12.9360000″

Next, open this file in Excel.

You’ll need to tweak the data a bit, making sure the decimals of miliseconds are set correctly.
And also check the format of the number colums (using the hh:mm:ss,000;@ format).

Add filtering to the header row.

Excel 2010 has a nice feature of conditional formatting that allows you to set automatic grading.




You could take it a step further, using PivotTables.

Select exact the same data range (your initial table).

Put the data fields in the right spot… like :

Probably, the averages are the interesting part, but adding the PivotTable for Min and Max values is seconds of work.


The major advantage of this PivotTable is that you get you immediately see what run profiles are missing/ not used.



Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s