User Report: Show me users that aren't in 2+ other groups

[JillAc]

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!

[NicholeVargas · Accepted solution]

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

[JillAc]

Thank you!!!

[LAM3]

I'm trying to figure out the text mode to show that users aren't in one of 2+ different groups. 

Text mode is showing me:

otherGroupIDs=666a12910042679c44c465408c8e95be	678939ab00023e398eb15a849993c7d0
otherGroupIDs_Mod=notin

And the report that shows me users that are in both groups. What is the text mode to show me users that aren't in group 1 or group 2? 

[skyehansen]

I think it would work to use the same code from here:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-to-find-all-users-who-do-no...

and then separate your two groupIDs with a tab.

[LAM3]

Thank you! I was missing the part about the tab to list all of the groups. Now it works!