How to query the database for additional details of a Certification run.

Products

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

Issue/Introduction

Is it possible to get additional details from a Certification campaign out of the database such as the specific resources updated, and the users that were affected so we can occasionally audit campaigns to ensure they updated everyone correctly?
 

Environment

Release:
Component: SGRM

Resolution

Campaign details are stored in the BusinessFlowEntities and can be queried for various details as follows:
Please find the queries, replace "?" with BusinessFlowId.


List of Users involved in the Certification:
select * from BusinessFlowEntities where BusinessFlowId = ? and EntityType = 1
 
List of Resources involved in the Certification:
select * from BusinessFlowEntities where BusinessFlowId = ? and EntityType = 2

List of Roles involved in the Certification:
select * from BusinessFlowEntities where BusinessFlowId = ? and EntityType = 3