How to build a report to find out if the Group manager is also a group member of the same group.

[tengkuzul]

Hi Everybody,

Context: Group management is a mess and we are doing some data clean up.

I work with reporting and would like to make a report to find if the group manager is also in the same group member list.

I have tried in tables below but cant find any result

[sys_user_group]
[sys_user_grmember]

Many thanks for any idea.

[Tai Vu · Accepted solution]

Hi @tengkuzul 

It will be all of the remaining groups when you compare to this list.

URL: https://<instance_name>/sys_user_grmember_list.do?sysparm_query=userSAMEASgroup.manager

Just filter out the groups you find with above query, you'll have the list of the remaining groups.

[tengkuzul]

Thanks for the help @Tai Vu