How to obtain detailed timestamp information for Eurekify.cfg when it is saved to the Oracle database?

Products

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

Issue/Introduction

 

We want to determine the exact timestamp (including both date and time) of when Eurekify.cfg was last saved to the Oracle database. Is this information available in the IG logs or retrievable directly from Oracle?

Environment

Release:
Component: IG

Resolution

This can be accomplished by modifying the eurkeify_sdb date format attribute by 

 

Alter session set nls_date_format=’dd-mm-yyyy hh24:mi:ss’;

 

and then run the query below to retrieve the information:

 

select to_date(modifydate,'dd-mm-yyyy hh24:mi:ss') from configurations where configurationname='Eurekify';