Is there an easy way to determine which users are assigned to a specific role?

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

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?

 

Environment

CA Service Desk Manager 

All Supported Operating Systems and Database Management Systems

Resolution

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.