How to correlate IM task information for audit purposes

Products

• CA Identity Suite
• CA Identity Manager

Issue/Introduction

Main task information is provided in three tables tasksession12_5, event12_5 and runtimestatusdetail12.

If query would be run based on tasksession12_5.tasksessionid how can related information in other two tables be found?

 

Environment

14.X

Resolution

These three tables are connected as such:

tasksession12_5.tasksessionid = event12_5.tasksessionid 

tasksession12_5.tasksessionid = runtimestatusdetail12.eventid

event12_5.eventid = runtimestatusdetail12.eventid

So any query/report would need to query them based on that relation.