BusinessObjects Board

Automate query builder output

Hi,

I have the following query

SELECT TOP 10000 SI_FILES, SI_NAME  FROM CI_INFOOBJECTS WHERE SI_KIND = 'Webi' ORDER BY SI_NAME

Which is the only way I know of generating a list of the SI_Filename and SI_Path, which I need as the back up of the frs is just copying that frs structure to another location and therefore I need to know the filename and path.

My question is, is there a way of automating the above code to produce a text file?

I have been unable to find this question in BOB so far.


Paul.OSullivan (BOB member since 2013-03-28)