Identity Manager audit table timestamp and schema location

Products

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

Issue/Introduction

Users often need to report on specific events, such as when a user password was last updated, using the Identity Manager (IDM) audit database. This article identifies the relevant timestamp columns and the location of the database schema documentation.

 

Environment

All Identity Manager

Resolution

 The Identity Manager audit system records event timestamps in a standardized column across all audit-related tables.

• Audit Timestamp Column: All IMSAUDIT* tables utilize the AUDIT_TIME column to store the precise timestamp of the event being audited.
• Reporting: Customers are responsible for developing and maintaining custom SQL statements for reporting against these tables.

Schema Documentation Detailed schema definitions, including table structures and column descriptions are located in the Identity Manager Identity Manager /tools/db directory