Event activity dates in audit tables
Article ID: 145343
CA Identity Manager
CA Identity Governance
CA Identity Portal
CA Identity Suite
Can you please let us know whether IDM audit database has timestamp updated whenever user password gets updated and if so what is the query to get that info?
The IMSAUDIT* tables all use the AUDIT_TIME column to store the timestamp of the event being audited.
We don't provide any sql statements, however, as the customer is responsible for all queries and reporting against the audit tables.
The schema definitions for the audit tables are documented in IM_R12.5_DB_schema_descriptions.doc available in the "tools" directory on your IM server here.