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.
Identifying with your business
