Event activity dates in audit tables

book

Article ID: 145343

calendar_today

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