search Enterprise based on scheduled dates

[Creamac]

Hi,
Today I found a report on Enterprise that isn't running anymore because the scheduled end date has passed.

Is there a way to find all the reports with scheduled end date < current date ?

thanks

 

[kray4660]

I know that a co-worker used query builder to do it once (we had the same issue before). I will ask him if he remembers how he did it.

 

[Creamac]

Great ! Thanks. I used query builder too, but I can't find the scheduled end date, it's not SI_ENDTIME and I can't see it in SI_SCHEDULEINFO

 

[kray4660]

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'

 

[kray4660]

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'

 

[Creamac]

Worked perfect ! Thank you and your co-worker !