Here is an example from my co-worker, but I do not know if it will do what you want. We were having a problem when the End Date/Time for a scheduled report was close to the current date.
Something like this, but they should add other fields to help identify the report and location.
select top 10000
SI_NAME,
SI_PARENT_FOLDER,
SI_LAST_RUN_TIME,
SI_SCHEDULEINFO.SI_ENDTIME,
SI_SCHEDULEINFO.SI_STARTTIME,
SI_SCHEDULEINFO.SI_RUN_ON_TEMPLATE
from CI_INFOOBJECTS
where SI_KIND='CrystalReport'
and SI_INSTANCE=0
and SI_SCHEDULEINFO.SI_ENDTIME<='2020-12-31'
Here is a little better version. FYI: It just searches for Crystal Reports.
select top 10000
SI_ID,
SI_NAME,
SI_PARENT_FOLDER,
SI_LAST_RUN_TIME,
SI_SCHEDULEINFO.SI_ENDTIME,
SI_SCHEDULEINFO.SI_STARTTIME,
SI_SCHEDULEINFO.SI_RUN_ON_TEMPLATE
from CI_INFOOBJECTS
where SI_KIND='CrystalReport'
and SI_SCHEDULE_STATUS=9
and SI_SCHEDULEINFO.SI_ENDTIME<='2020-12-31'
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.