Is there an easy way to determine which CA Service Desk (CA SDM) users are assigned to a specific CA SDM role?

Document ID : KB000048302
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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?

Solution:

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.