Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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.

0 Replies

Avatar

Employee

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