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?
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.