FIM2010R2 Custom Reports

I’ve played around for a while now with different reporting solution for FIM2010R2. I crawled all over Google hoping to find some samples on custom reports using FIM`s default reporting capabilities SSRS and SCSM. I didn`t find _anything_, so I filled up a big mug of coffee and refused to leave my desk before it got something custom going on 😀

I have not yet decided if im really happy with the way reporting in FIM is done, but SSRS and SCSM reporting is not that bad, it is actually quite powerful when you get the hang of it.

So I`ll show you an example on how to create a simple custom report for FIM. After creating your first report you should be able to extend it a lot!

Create the first dataset for users and groups

Its a good idea to create a new folder where you put all your custom reports. Create a folder named Custom Reports.

First we have to create a new dataset to retrieve all users group memberships. For this we`r gonna use the built-in Reporting Builder.

Choose the DWDataMart as connection.

Now you should see all the views, like this

Start by selecting the following attributes from FIMEntityDimvwEntityDimKey
FIMDisplayName
FIMEntityDimKey

Select the following attributes from FIMGroupDimvwFIMDisplayName
FIMGroupAccountName
FIMGroupDimKey
FIMGroupType
If you need more information from the Group objects in your report you can choose more attributes.

End results

Share this:

Thanks for this, it has helped a lot. Sadly thought when I run through it I cannot get the distribution groups to show up at all.

Guy Horn

Hi,
First of all a compliment. That’s exactly what I was looking for. MIM Reporting is poorly documented.
What do you mean by Active Group Membership? Computed Member? Manually Managed? PAM Role Active?