I need to identify groups where the group manager is NOT a group member

[Ken61]

Hello All,

I'm trying to retrieve a list of all groups where the group manager is not a member of the group. However, I am unable to get this done.

I even came across below solution from the community, but it's not working. 

How to identify groups where the group manager is NOT a group member

I would appreciate your guidance on how to proceed with this.

Thank You.

[Chaz]

Hello! The script shown in the other post should work. Can you share what you're trying?

[Ken61]

Below are my script include and filter that was ran using the script include name.

[Chaz]

Thanks for the follow up. You'd want to create a report on the "sys_user_group" table because those are the sysIDs being returned. Additionally, you can do what @sunil maddheshi  mentioned to make sure the script is properly returning sysIDs as well.

[Ken61]

Hi Chaz,

What is the next step after creating the script? I created a report on sys_user_grmember but no result.