Export Info from Identity Manager Database to see approval and rejection information

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

Can you provide a SQL query we can use to export information from an Identity Manager database, to show who approved or rejected a workflow request for an account? I believe the information must be available somewhere in some database because it shows up in View Submitted Tasks within the Identity Manager console, but I have not been able to find it within a database table.

 

Environment

Release : 14.2, 14.3, 14.4

Component : IdentityMinder(Identity Manager)

Resolution

Providing custom SQL queries is outside the scope of L1 support.  You can review reporting through Jasper.  Below is information regarding the DB that is provided "as is" on how to get approval and rejection information to build your own DB queries.

Information on requests exist in imsAuditTaskSession12 table.

linked it to the event12_5 table using tasksession_oid = tasksessionid. 

Review the 'decisionmaker' column to get the approver (and other columns like approvalstatus and approvaltime to find if it's pending, approved, or rejected).