ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 48302

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management 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

Release: UAPMAC990JPP-12.9-Asset Portfolio Management-Asset Configuration
Component:

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.

Additional Information

Article ID: 15278 - Is there an easy way to determine which CA Service Desk (CA SDM) Access Types a Role is a member of and who is using that Role?