Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!

How to find all users who do not belong to a specific group?

Avatar

Level 10

Hi

Is there a code for a report that someone can supply to find all active Users who don't belong to a specified group - whether it's their home group or other group? When I use "or" it doesn't work - because if they are in the Home Group and not Other Group it lists them.

Thanks!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Employee Advisor

Jill,

This is possible using an EXISTS filter within a User Report. You'll want to switch to text mode and replace ID HERE with the ID of the specific group. This will pull in a list of all active users who do not have that group listed as either their Home Team or under Other Teams.

EXISTS:A:$$EXISTSMOD=NOTEXISTS

EXISTS:A:$$OBJCODE=USRGPS

EXISTS:A:groupID=ID HERE

EXISTS:A:userID=FIELD:ID

isActive=true

isActive_Mod=eq

If this wasn't exactly what you were looking for, or have additional questions, let me know!

Nichole