Find User with only the specified roles
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-17-2014 07:23 AM
I need to find the users in my system that only has the 2 roles am interested in and nothing else. The report system only lets you find either one role or the other role but I would like to know how to get users with 2 roles that I need (Ex: Admin,itil...and no other roles). Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-17-2014 08:14 AM
try this and do a group by
instanceurl/sys_user_has_role_list.do?sysparm_query=role.nameINit_ess%2Cit_requestor&sysparm_view=
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-17-2014 08:31 AM
No, still the same as above. It returns to me the users that have those roles but also have the other roles. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-17-2014 09:14 AM
so you want users that have only these roles and not the others ????
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2018 09:53 AM
Hi David,
I'm looking for the same thing here. I need to know who have NO Roles except for one of two specific Roles.
The solutions presented below seem to be missing the critical piece, which is that the Users HAVE NO ROLES OTHER THAN THE ONES SPECIFIED.
Were you able to find a way to do this?
Thanks,
Robert
