Month: October 2013

Note-to-self: Large, Extra large, Huge collection of Free Microsoft eBooks for you

Large collection of Free Microsoft eBooks for you, including: SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more.

Another large collection of Free Microsoft eBooks and Resource Kits for you, including: SharePoint 2013, Office 2013, Office 365, Duet 2.0, Azure, Cloud, Windows Phone, Lync, Dynamics CRM, and more.

Huge collection of Free Microsoft eBooks for you, including: Office, Office 365, SharePoint, SQL Server, System Center, Visual Studio, Web Development, Windows, Windows Azure, and Windows Server

New FIM Hotfix supersedes recent hotfix: Forefront Identity Manager 2010 R2 build 4.1.3479.0 released

(Thanks Paul Williams for keeping me on my toes… )

Just 10 days after the release of FIM 2010 R2  hotfix rollup package (build 4.1.3469.0), Microsoft has released a new hotfix that supersedes previous one.

Download available at: Hotfix Download Available

Replacement information

This update replaces the following updates:

2877254 (    A hotfix rollup package (build 4.1.3469.0) is available for Forefront Identity Manager 2010 R2
2870703 (    A hotfix rollup package (build 4.1.3461.0) is available for Forefront Identity Manager 2010 R2
2849119 (    A hotfix rollup package (build 4.1.3451.0) is available for Forefront Identity Manager 2010 R2
2832389 (    A hotfix rollup package (build 4.1.3441.0) is available for Forefront Identity Manager 2010 R2
2814853 (    A hotfix rollup package (build 4.1.3419.0) is available for Forefront Identity Manager 2010 R2
2772429 (    Service Pack 1 (build 4.1.3114.0) is available for Forefront Identity Manager 2010 R2
2750671 (    A hotfix rollup package (build 4.1.2548.0) is available for Forefront Identity Manager 2010 R2
2734159 (    A hotfix rollup package (build 4.1.2515.0) is available for Forefront Identity Manager 2010 R2

Issues that are fixed in this update

FIM Service Issue 1 When you have very long XPath   queries in the FIM Service, CPU usage may increase. This causes a decrease in   performance.
FIM Synchronization Service Issue 1 The Synchronization Service may   leak memory when you use an ECMA2 connector.
Issue 2 When an existing ECMA2 connector is   updated when a server configuration is moved between servers, the update is   unsuccessful. This problem occurs when the connector requires access to   encrypted parameters, such as a password, to complete the operation.
Issue 3 When an import is confirmed, a staging error may   occur in rare cases. When this problem occurs, you receive the   following error message:Cannot insert duplicate key row in   object ‘dbo.mms_cs_link’
Issue 4 If during a full import on the Active Directory management agent there   is a reference on an organizational unit (OU) to an OU two levels down, the   sync engine will crash.
Issue 5 When you select the option to abandon the key set in the   Synchronization Service Key Management Utility, the operation may be   unsuccessful. Additionally, you receive the following error message:Value is not in the expected range.
BHOLD suite Issue 1 The processing of BHOLD Queue entries takes a longer time than   expected to finish after an earlier hotfix is applied.
Issue 2 You cannot add a permission for a user by using the BHOLD connector if   the permission was ever denied for the user.
Issue 3 The removal of permissions from a personal role (prefixed with PR-)   does not trigger the removal of those permissions from the user.

Note-to-self: A hotfix rollup package (build 4.1.3469.0) is available for Forefront Identity Manager 2010 R2

Note to self: updating latest FIM build ….


“A hotfix rollup package (build 4.1.3469.0) is available for Microsoft Forefront Identity Manager (FIM) 2010 R2. This hotfix rollup package resolves some issues and adds some features that are described in the “More Information” section.”

Check the article, as there are important issues fixed.

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.