Friday 20 June 2014

SQL Query for the FIM2010 admin account

Recently, I came across a FIM2010 deployment that wasn't very well documented. My task was to review the deployment but how could I get admin access to the FIM Portal if I didn't know which account to use? The answer is in the FIMService database and this query will get it for you:

  SELECT Distinct a.AttributeName,p.[ValueString]
  FROM [FIMService].[fim].[ObjectValueString] as p JOIN [FIMService].[fim].[Objects] as o ON p.ObjectKey = o.ObjectKey
  JOIN [FIMService].[fim].[BindingInternal] as a on p.AttributeKey = a.AttributeKey
  Where o.ObjectID ='7fb2b853-24f0-4498-9534-4e10589723c4'

Reset the password of the account and I could proceed with my review. Hope this helps.