Hi,
I have an application that collects Groups, and those groups then contain Application Roles and Resource : Action Entitlements.
I'm currently trying to write a report that would display as follows:
However, I can't find a view/table that provides details of the groups and a link to the entitlements contain within those groups.
Can anyone point me in the right direction?
Thanks,
Clive
Hi All,
Did anyone manage to create this report please? We are also looking to implement this report but could not find the tables with the correct relationships.
You would need break it down into two parts then join them together. First part is the account-to-group relation which can be easily retrieved from more than one view (V_ACCOUNTS_TO_GROUPS for example).
However the second part which is the Group-to-entitlements relations has to come from t_av_explodeduserentitlements table. You can use the view (V_USERENTS_TO_GROUPS) as reference to what filters you need for that.
Igone the striked out part as it is wrong, you would need to start with a basic filter of t_av_explodeduserentitlements where entitled_type='group' and deletion date is null
on Apr 24, 2018
You would need break it down into two parts then join them together. First part is the account-to-group relation which can be easily retrieved from more than one view (V_ACCOUNTS_TO_GROUPS for example).
However the second part which is the Group-to-entitlements relations has to come from t_av_explodeduserentitlements table. You can use the view (V_USERENTS_TO_GROUPS) as reference to what filters you need for that.
Igone the striked out part as it is wrong, you would need to start with a basic filter of t_av_explodeduserentitlements where entitled_type='group' and deletion date is null