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.