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!

(You should also look into Splunk for FIM as a “quick” supplement).

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.
0

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.
1

Choose the DWDataMart as connection.
2

3

Now you should see all the views, like this
4

Start by selecting the following attributes from FIMEntityDimvw
EntityDimKey
FIMDisplayName
FIMEntityDimKey

5

Select the following attributes from FIMGroupDimvw
FIMDisplayName
FIMGroupAccountName
FIMGroupDimKey
FIMGroupType

If you need more information from the Group objects in your report you can choose more attributes.

6

Select the following attributes from FIMGroupHasComputedMembersFactsvw
CreatedDate
DateKey
DeletedDate
FIMCreatedDate
FIMCreatedRequestID
FIMDeletedDate
FIMDeletedRequestID
FImGroupDimKey
FImGroupHasComputedMembers_FIMEntityDimKey

7

Select the following from FIMPersonDimvw
FIMPersonAccountName
FIMPersonDepartment

If you need more information from the Person objects in your report you can choose more attributes.

8

Hit Auto Detect to de-select auto assignment.
9

Click to create a new Join criteria.
10

Do the following joins
11

Filter out all distribution groups.
12

Try running the report to see if there is any results 🙂
13

Yey!
14

Filters out all person <-> group relationship that is no longer active. (Member left the group).
15

Save the dataset in Custom Reports folder
16

Create the second dataset for all departments

We gonna use this to make a parameter in the report so that it is possible to filter by Users Departments.
17

Select the following attributes from FIMEntityDimvw
EntityDimKey

19

Select the following attributes from FIMPersonDimvw
FIMPersonAccountName
FIMPersonDepartment

20

Select Count on EntityDimKey and FImPersonAccountName and Grouped By FIMPersonDepartment
21

Do the following joins
22

You should see something like this, only with your departments. (If your users have the Department attribute assigned in FIM).
23

Now save it to the Custom Reports folder.
24

Create the actual report

Lets start by creating it through the Table or Matrix Wizard
25

Browse and select the first dataset we made. (AllActiveSECGroupMemberships)
26

Select FIMPersonAccountName as Row groups, and FIMGroupDimvw_FIMDisplayName as Values.
27

Lets just continue with the defaults.
28

Lets just continue with the defaults.
29

The defaults should look like this.
30

If we try to run the report, it looks like this.
31

Right click on Dataset (left) and Add Dataset.
32

Browse and select the AllDepartments dataset we created in step two.
33

Right click Parameters and select Add Parameter.
This will create a drop down with departments.
34

Give it a reasonable name and prompt.
35

Go to Available Values and do the following
36

We need to make the parameter as a filter on the dataset. Right click AllActiveSECGropMemberships dataset select Dataset Properties.
37

Select Filters and do the following
38

Run your report!
39

End results

40

With just a little bit of brushing!
41

  • adam bazley (Sparahawk)

    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?