×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

search Enterprise based on scheduled dates

search Enterprise based on scheduled dates

search Enterprise based on scheduled dates

(OP)
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

RE: search Enterprise based on scheduled dates

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.

RE: search Enterprise based on scheduled dates

(OP)
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

RE: search Enterprise based on scheduled dates

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'

RE: search Enterprise based on scheduled dates

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'

RE: search Enterprise based on scheduled dates

(OP)
Worked perfect ! Thank you and your co-worker !

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close