Query Builder List of all reports scheduled daily

general discussion
1

Hi,

I am wondering if is possible to get the list of all reports scheduled daily from query builder. If yes does someone know how query will look like?

Thanks,

Lucq :poland: (BOB member since 2008-07-17)

2

hmm, what about this:
SELECT top 100000 * FROM CI_INFOOBJECTS WHERE SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_NDAYS = 1

Marfi :poland: (BOB member since 2006-12-18)

3

I’m working on this as well. I tried this and got what I think is close. Without the last 1 or 2 criteria i kept getting output instances as well.
This does not take into account weekly schedules where monday thru friday are concerned. I’m still working on this.

SELECT top 100000 si_name,SI_OWNER, SI_NEXTRuntime FROM CI_INFOOBJECTS WHERE SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_NDAYS = 1
and SI_schedule_status != 8 and SI_RECURRING = 1

Hope this helps.

tmcd :us: (BOB member since 2005-10-02)

4

tmcd your query is working as I needed.

Do how to get also path of daily scheduled reports?

Lucq :poland: (BOB member since 2008-07-17)

5

Add SI_PATH to the list of objects selected. There are some good documents on Query Builder SQL on SAP website -worth a good look.

tmcd :us: (BOB member since 2005-10-02)

6

Yes I tried to use SI_PATH but it gives me path to file/ folder on HDD.

I would like to have path to these reports in InfoView.

I was not able to find it…

Thanks

Lucq :poland: (BOB member since 2008-07-17)

7

Might be useful

arunmozhi :india: (BOB member since 2007-12-26)

8

We use the SDK. There is code around this but these two lines that bring it back. I would post the entire code but I don’t think my employer would appreciate that. :frowning:

Query folderPathQuery = new Query("SI_ID, SI_NAME, SI_PATH, SI_PROGID", "CI_INFOOBJECTS", "SI_ID IN(" + ids + ")", null);
                    IInfoObjects folders = traversal.getInfoObjects(ident.getInfoStore(), folderPathQuery);

tmcd :us: (BOB member since 2005-10-02)