Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

search Enterprise based on scheduled dates

Status
Not open for further replies.

Creamac

Programmer
May 16, 2013
4
BE
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
 
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.
 
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
 
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'
 
Worked perfect ! Thank you and your co-worker !

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top