BusinessObjects Board

report schedule inventory

Hi All,

I want to a list all schedule report and its scheduled Time, Day details. Please let me know how to get the above information.

Something like

  • Report Name
  • Schedule day (Monday,…) if several days–> several lines
  • Schedule Time (08h00 AM)
  • Type (PDF, Excel, WEBI)

Regards,
Anil


anilb (BOB member since 2008-09-22)

Hi Anil,

You can use “Instance Manager” in CMC area.

The “Instance Manager” lets you view all of the instances in
your BusinessObjects Enterprise deployment from one location.

-Satish


forgotUN (BOB member since 2006-12-13)

Hi Sathish,

Thanks for your reply…

Using instance Manager we can view the report which are successful, pending and running.

But, here my requirement is I need to prepare a list of reports and its schedule details like as below mentioned.

Something like

  • Report Name
  • Schedule day (Monday,…) if several days–> several lines
  • Schedule Time (08h00 AM)
  • Type (PDF, Excel, WEBI)

Do you have any idea, how to write QUERY in QUERY builder to the above details.

Regards,
Anil


anilb (BOB member since 2008-09-22)

Hi Anil,

The following code may be a good start for you. I have written this to show how can you get information from infoobjects.



Select 
SI_NAME,
SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_NDAYS,
SI_NEXTRUNTIME,
SI_ProcessInfo.SI_FORMAT_INFO 
From CI_INFOOBJECTS 
where 
SI_RECURRING=1
AND SI_INSTANCE=1

-Satish


forgotUN (BOB member since 2006-12-13)

Hi Anil,

Have a look also at this utility:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Hi,

Thanks for the information…it is very useful.

Regards,
Anil


anilb (BOB member since 2008-09-22)

Where do you run the code/script that you listed for the query ?


Stehlik (BOB member since 2009-03-27)

Welcome to B:bob:B!

Run the query posted by forgotUN in Query Builder.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Thanks for your help.

Dave


Stehlik (BOB member since 2009-03-27)