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: