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?

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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.0.
All Supported Operating Systems

Resolution

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://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-1/reference/ca-service-desk-manager-reference-commands/data-element-dictionary/role-table.html

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