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?

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

Is there an easy way to determine which CA Service Desk (CA SDM) Access Types a Role is a member of and which CA SDM users are using that Role and Access Type?

Environment:
CA Service Desk Manager 12.9, 14.1 and 17.0All Supported Operating Systems
Answer:

From the CA SDM web interface, out of the box there is no mechanism to list all CA SDM Access Types a Role is a member of and which CA SDM contacts are using that Role or Access Type.

The following sample SQL query can be used to provide a list of all CA SDM Access Types a Role is a member of and who is using that Role

select acc.SYM, role.NAME from USP_ACCTYP_ROLE acc_role join USP_ROLE role on acc_role.ROLE_OBJ = role.ID join ACCTYP_V2 acc on acc_role.ACCESS_TYPE = acc.ID

The above SQL query can be modified to revise to meet business requirements as needed.

Additional Information:

https://docops.ca.com/ca-service-management/17-0/en/reference/ca-service-desk-manager-reference-commands/data-element-dictionary/role-table#RoleTable-usp_acctyp_roleTable

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