Dynamic Group to User report
We have RBP User to Group table report available to check on users inside a permission group. However we don’t have one for User to Dynamic Group. Let us create a report to check the users inside a specific Dynamic Group or to check in which dynamic groups one user belongs to. We will use Canvas reporting for this purpose.
Navigate to Report Centre > Click on New > select Canvas.
Add Component Table > List Report.
Move to Edit Component and click on Edit Query.
Select Advanced Reporting and click on “New” to create a new query.
Select User > Users Group as starting table and select Users Group Name field.
Select User Sys Id from Usrgrp Map as below.
Add “ectworkflow” as the static filter for User Group Subtype field from Manage Query Filter option.
Add Group Name and User Id as run time filters.
That’s it, save the query and return. Update style settings if required.
1. DG to User Report.
Go back to Report Centre and run the report. Select the required Dynamic Group(DG) name, here I have selected “Talent Approval” as the DG name.
As you can see below, 2 users are there in the Talent Approval Dynamic Group.
Verify the report result with DG members.
2. User to DG Report.
If you are looking to find the Dynamic Groups in which specific user belongs, then pass the required user id as filter value.
Now we get the Dynamic Groups in which user “82094” belongs .
This way you will be able to review the Dynamic Groups in which an employee belongs before terminating that employee, review and add a replacement if required. Have you came across this requirement? Add comments and feedbacks.