CA Service Management

Dear Expert,

Please help me the extract the data like who is having which access (Catalog user, Request Manager, Service delivery Admin). Is this details will store in DB or we can pull out the details from somewhere. 

Thanks in Advance. 

I moved this from CA Privileged Access Management to CA Service Management.

This SQL query will show you all the users that you have given special roles in Service Catalog:

USE mdb
SELECT [domain]
      ,[role_id]
      ,[user_id]
      ,[last_name]
      ,[first_name]
  FROM [dbo].[usm_contact_domain_role]
  JOIN [dbo].[ca_contact] ON [ca_contact].[userid] = [usm_contact_domain_role].[user_id]

Good Afternoon Rajshree Sureshkumar.

In addition. other 'role' related tables in the mdb database are:
usm_role, usm_contact_domain_role, usm_role_user and usm_account_domain.

Kind regards, Louis.