when save report output on connection, the output is saved in content store, is there a way to find the output location in content store DB tables? can I query content store database and see the output? what format the output is in DB tables, is it readable?
thanks a lot for your help.
Scheduled reports should be in table CMDATA.
Hi Smiley, Scheduled report and run on demand report saved in different location? if I get access to content store database, can I query table to get report output?
thank you.
yes, you can define an output location for the content store. (Check the manual for details)
That way such stuff will be stored on a drive, accessible by the content store logic. (see it as an extension for the database)
In the database scheduled reports are stored in a blob format. I don´t know if it is accessible via a query.
thanks a lot !