Skip to Content
0
Aug 20, 2022 at 10:28 PM

List of Destination path of Scheduled Webi reports to File System

760 Views

destination-path-bo.png

Hi All,

I am using BO 4.3 and tried to find out list of destination path of scheduled Webi reports to file system in different formats using query builder.

I am writing below query in query builder and found destination path with other details but I need only Webi report name & destination path.

SELECT TOP 10000 SI_SCHEDULEINFO.SI_DESTINATIONS, SI_NAME, SI_ID FROM CI_INFOOBJECTS WHERE SI_KIND IN ('CRYSTALREPORT','pdf','excel') AND SI_SCHEDULEINFO.SI_DESTINATIONS LIKE '%CRYSTALENTERPRISE.DISKUNMANAGED%' AND SI_INSTANCE = 1

Please find attachment where I have marked destination path which I want with report name.

Anyone can help on it please.

Thanks.

Attachments