Task is to get this data from CA PIM - Account name, endpoint, Requestor, Approver
1) I wrote a SQL Query to get the Account name and endpoint name from database
2) I am looking at the report SAM users by Shared Account which gives me the Requestors
I am yet to explore getting the approvers.
Is there a single query or a report
Please see the following report if it will provide the information you are looking for:
here is related documentation:
Standard Reports - CA Privileged Identity Manager - 12.9.01 - CA Technologies Documentation