From the CA SDM web interface, out of the box there is no mechanism to list all CA SDM users assigned to a particular CA SDM role (outside of the Access
Type - Role association).
Is there an easy way to determine which CA Service Desk (CA SDM) users are assigned to a specific CA SDM role?
The following sample SQL query can be used to provide a list of all CA SDM users assigned to a particular CA SDM role.
In the following example, all CA SDM users assigned to the OOTB 'Administrator' role:
SELECT userid, first_name, last_name FROM ca_contact
where contact_uuid in (SELECT contact FROM usp_cnt_role A INNER JOIN usp_role B ON B.ID = A.ROLE_OBJ WHERE b.name='ADMINISTRATOR'
The above SQL query can be modified to revise to meet business requirements as needed.