Why can't I select Group member [sys_user_grmember] table from 'related list conditions' on reports - need to report on users that are in more than one of a certain type of group...

[kristajw]

Hi,

I need to report on users that are in more than one group from a list of groups.

For example, any users that are in 'service desk' and also in another itil groups. 

I was going to report on the user table and then in 'Related list conditions' select the Group member table - but it is not available...

Any idea why it is not there, and also how I can achieve the report I require?

Kind regards

Krista

[Allen Andreas]

Hi,

It's not there because those tables aren't linked together. They are separate tables and only related by group to user...and not user to group. You can attempt to run a report against the sys_user_grmember or User Group Member table, instead.

Please mark reply as Helpful/Correct. Thanks!

[andersbogsjo]

Hi kristajw!

I did the selection in my devinstance and you can use the Related list condition Groups and Specify the Group. If you want more for your example simply add another Group with AND

Please mark reply as Helpful/Correct if this helps you. Thanks!

Regards

Anders

[Adam Stout]

There was another recent post that was similar to this.  There were a few examples of using a little bit of scripting to achieve this.  Not always ideal, but works for an infrequent cleanup.  I believe there were solutions to make it a dynamic filter option as well to make it more reusable.  

I would do a little more searching here.