Share via

FIM 2010 WMI Provider flakiness

  • Article

It looks like FIM 2010 WMI provider does not process the equality ( = ) operator in WQL query’s where clause correctly. The behavior is flaky at the best meaning it may or may not work on different machines even though they have same OS and Sync Service builds.

 

On my machine following PowerShell query returns no records:

 

PS C:\> Get-WmiObject -Query "SELECT * FROM MIIS_RunHistory WHERE RunStatus = 'success'" -Namespace root/MicrosoftIdentityIntegrationServer

 

The WQL query without the WHERE clause or with any other operator seems to work correctly across different machine and builds. The work around is to use the LIKE operator which works in most case or and AND <= and >= operators as in the below query:

 

PS C:\> Get-WmiObject -Query "Select * from MIIS_RunHistory Where RunStatus <= 'success' AND RunStatus >= 'success' " -Namespace root/MicrosoftIdentityIntegrationServer

 

This query always returns the correct results.