Entitlement usage report

Hi all,

Is there any way/report to get a the usage of entitlements in IIQ? Like how many have been assigned to how many users and if there are entitlements that are not assigned to any identity.

Thanks in advance

Hi @rishavghoshacc

You can execute Account Group Membership Totals Report report by choosing applications. It displays how many members are assigned to each groups.

You can also run Account Group Members Report report if you want to know which users are assigned to which groups.

1 Like

@Arpitha1
The total count of the Entitlements on the report seem to be less on the report than the Entitlement count on the Entitlement catalogue page.

Is there a reason behind this?

@rishavghoshacc Perhaps it is not including the entitlements where the member count is zero.

@rishavghoshacc “Account Group Membership Totals Report” this report gives all the information if there is zero member then also.as per below HQL filter
import java.util.*;

                      List applications = args.get("application");
                      if (applications != null && !applications.isEmpty()){
                        query = query + " and application.id in(:application) ";
                      }

                      //We wont have membership on indirect groups
                      query = query + " and attribute is not null ";

                      return query;

You can modify as per your requirement

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.