Event activity dates in audit tables
search cancel

Event activity dates in audit tables


Article ID: 145343


Updated On:


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.