Find User with only the specified roles

david_hreben
Giga Expert

‎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!

  • 5,345 Views
8 REPLIES 8

Michael Fry1
Kilo Patron

‎10-17-2014 07:30 AM

Run a report on the User Role [sys_user_has_role) table adding your 2 roles to the criteria.


0 Helpfuls

david_hreben
Giga Expert
In response to Michael Fry1

‎10-17-2014 07:34 AM

I did but those user have also other roles which am not interested. I just need to find the user with the roles I specified and nothing else.


0 Helpfuls

Michael Fry1
Kilo Patron
In response to david_hreben

‎10-17-2014 07:42 AM

Try this:


2.jpg



add your two roles and it should show you the users with those 2 roles.


Preview file
13 KB
0 Helpfuls

david_hreben
Giga Expert
In response to Michael Fry1

‎10-17-2014 07:55 AM

I had my hopes it would but it did not. just need the users with it_ess & it_requestor...if it has anything else it does not work. let me show you the result your conditions gave me (name, role):



X Guytemplate_editor
X Guyit_ess
X Guyit_requestor
X Guyitil
X Guyreport_group
X Guyit_ess
X Guyit_requestor
X Guyitil
X Guytemplate_editor
X Guyreport_group
X Guysurvey_reader
X Guyit_ess
X Guyit_ess
X Guytemplate_editor
X Guyreport_group
X Guyreport_group
X Guyit_requestor
X Guyitil
X Guyit_requestor
X Guytemplate_editor
X Guyitil
X Guyrm_task_admin
X Guyscrum_user
X Guyrm_product_admin
X Guytask_editor
X Guyrm_epic_admin
X Guyrm_doc_admin
X Guyrm_story_admin
X Guyrm_sprint_admin
X Guyscrum_admin
X Guyproject_user
X Guytask_editor
X Guyrm_test_admin
X Guytask_editor
X Guyproject_manager
X Guyproject_portfolio_user
X Guyrm_release_scrum_admin
X Guyit_ess


get the idea?


0 Helpfuls