Detailed Time Stamp info on Eurekify.cfg when saved to Oracle DB

Products

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

Issue/Introduction

We are looking to retrieve the detail time stamp (not just the date, but also time of day) of when Eurekify.cfg was last saved to the Oracle DB. Is it possible to retrieve this information from either the GM logs or from Oracle?

 

 

Environment

Release:
Component: SGRM

Resolution

This can be accomplished by modify eurkeify_sdb date format attribute by 

 

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

 

and then run queried below

 

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