Skip to Content
avatar image
Former Member

Query builder query to find the path of the report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 27, 2017 at 01:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 26, 2017 at 11:26 PM

    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/

    Add comment
    10|10000 characters needed characters exceeded