Ok I was able to find a simple solution using some of the methods you suggested.
select OH_Name, OH_Otype, OH_CrDate
from OH
where OH_CrDate > '2021-01-01'
and OH_OType in ('JOBS', 'JOBP', 'JOBF', 'SCRI', 'EVNT')
and OH_Client = 100
and OH_DeleteFlag = 0
order by OH_Name, OH_CrDate;
Thanks you all for your help.
Original Message:
Sent: 10-19-2021 11:45 AM
From: Rahul
Subject: How to find all changes that took place in Automation Engine in a year
We have a requirement to find out all changes that were made in the Automation Engine in the past year.
1) Is there a way we can get a list of objects that were moved to our production environment(xml imports)?
2) Is there a query that can be used to find out all the objects which were either created or changed over the course of the year?
Thanks.
------------------------------
Regards,
Kumar
------------------------------