How to get detailed Time Stamp info on Eurekify.cfg when saved to the Oracle DB?

Products

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

Issue/Introduction

We are looking to retrieve the detailed time stamp (not just the date, but also the time of day) of when Eurekify.cfg was last saved to the Oracle DB. Is it possible to retrieve this information from either the IG logs or 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';