Event activity dates in audit tables
Article ID: 145343
Updated On:
Products
CA Identity Manager
CA Identity Governance
CA Identity Portal
CA Identity Suite
Issue/Introduction
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?
Resolution
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.
/opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/db
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.
/opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/db
Feedback
Yes
No
Powered by
