I want to know the reports that are executing first of every month in BO Server in excel format

[Former Member]

We are using BOE 4.0. is there any way to know the reports that are executing in BO server on 1st of every month.

Thank You.

[jyothirmayee_s]

Hi,

You can try below query in Query Builder

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND IN (‘FullClient’, ‘Txt’, ‘Excel’, ‘Webi’, ‘Analysis’, ‘Pdf’, ‘Word’, ‘Rtf’, ‘CrystalReport’, ‘Agnostic’) AND SI_KIND = 'Webi'

here are more examples

http://blogs.hexaware.com/business-objects-query-builder-part-ii/

https://blogs.sap.com/2012/10/11/businessobjects-query-builder-queries/

Thanks,

Jothi

[Former Member]

HI Jothi,

Thanks for the response. i am getting error with query you provided and moreover i need the reports that are executing on 1st of each month.(Ex:1st Aug 2017). Can you help me with the query please?

Thanks in advance

Chan

[Former Member · Accepted solution]

In Instance manager we can see the list of reports that are executing. But i want those list of reports in excel, word or pdf format.

can anyone suggest on this.

Thank You

[jyothirmayee_s · Accepted solution]

Looks like you figured out the solution to Query builder

If not, try something like this,

SELECT top 100000 * FROM CI_INFOOBJECTS WHERE SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_NDAYS = 30

Do you want logs of Instance Manager to export to excel?.

I'm sure it is not available right now. There is workaround, you can try by downloading excel workbook from below link.

http://www.forumtopics.com/busobj/viewtopic.php?t=168709

Thanks,

Jothi

[Former Member · Accepted solution]

No I did not get Answer to the question. Could you please give me the query that should give the result of "The reports that are executed on 1st of September 2017?