Skip to Content
0

Query builder query to find the path of the report

Nov 24, 2017 at 08:54 AM

66

avatar image
Former Member

Hi All,

Can somebody please suggest me to write a query using query builder for getting the following details,

Webi Report Path

Frequency of report run(daily/weekly/monthly)

Export Format

Would be great if somebody help me with this query!!

thanks in advance for u r help

Regards,

AA

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Joe Peters Nov 27, 2017 at 01:15 PM
1

There is an SI_PATH property, but it's only present on folders. To get the path of a WebI report, you either need to walk up the hierarchy, by re-querying on the SI_PARENTID property, or at least walk up until you get to a folder, at which point you can use SI_PATH.

Share
10 |10000 characters needed characters left characters exceeded
Jawahar Konduru Nov 26, 2017 at 11:26 PM
0

You can get schedule reports information using below query

SELECT SI_ID, SI_NAME, SI_KIND, SI_NEXTRUNTIME, SI_SCHEDULEINFO FROM CI_INFOOBJECTS WHERE SI_RECURRING = 1

Getting path is not possible if you are using query builder. You need to use SDK to extract this information.

Using this 3rd party tool, to export to excel.

http://bukhantsov.org/2012/03/query-builder-with-export-to-excel/

Share
10 |10000 characters needed characters left characters exceeded