[BO XI 3.1] List of all scheduled reports

[system]

Hi everyone,

From 2 days I’m traying to get information about which report is scheduled and with what frequency does the report refresh (for example: Monday, Friday at 9.00).

I looked for this information in Audit tables (Audit Event, Event Detail) but I didn’t find it. I can see only where the report is saved, name etc.

I looked for in CMS repository in SI_INFOOBJECTS but there is any name of report, only strange values

I’ve checked univers Activity also but without success

Do you have any idea where can I find it?

---

RaDoSZ (BOB member since 2011-03-03)

[system]

Hi,

Check utilities in the BOB’s Downloads section. For instance, All Scheduler List can be helpful:

All Scheduler List

Author: Sunder Ramani Hi All, Author notes Cheers, Sunder Ramani BO Schedulers.xls (313.0 KB) sunder.ramani (BOB member since 2009-05-27)

---

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

[system]

Hi Marek,

I’ve checked and I got error of course :?
I looked into VBA code and there are connection to tables which I have (but I have diffrence name). But the problem is for example: in ObjName field I have data in varbinary and I don’t know how it convert into varchar.
Another thing is: could I join for example: Audit_Detail.Object_ID = CI_INFOOBJECTS.ObjectID ? Of course I tried but without positive result

---

RaDoSZ (BOB member since 2011-03-03)

[system]

Hi RaDoSZ,

I am not an author of the utility, so can’t help you out.

Please post your questions to the original topic with the utility and someone might be able to help you there.

---

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