AnsweredAssumed Answered

Scheduler Modifications - DB Query

Question asked by reddy.bharathkumar.626978 on Mar 9, 2018
Latest reply on Mar 10, 2018 by reddy.bharathkumar.626978
I'm trying to find a way to check all the modifications that are made to a Scheduler. No versions are stored in Documentation Tab(They might have got deleted!!).

I am using the below query but it's giving me the last modified time and user who modified it. Is there anyway to found what changes are made by that user at that time?

select oh.OH_name, TO_CHAR(oh.oh_moddate,'DD-MM-YYYY HH:MM')as oh_moddate,usr.USR_FIRSTNAME, usr.USR_LASTNAME from uc4.oh, uc4.usr where oh_name = 'TEST_JSCH' and usr.usr_oh_idnr=oh.oh_moduseridnr;

Outcomes