Exporting a List Of Reports from Reports Servlet

[cspadola]

I was wondering if there is a way of exporting a list of reports run during a particular day / time period from the Reports Servlet window or from somewhere within the DB directly?

I can view a list of Current and Past reports that have been run but I need to browse through pages of results (10 at a time) and need something more efficient. I would like to export a list of reports for specific time periods (eg. by date or date range) so I can do some daily and weekly monitoring. Currently, the only way I see to do this is to manually create my list based on what I see in the Reports Servlet window. Not really what I would like to spend my time doing.

Thanks

[Srivathsana]

Re: Exporting a List Of Reports from Reports Servlet

Hi,

The below chunk of sql should help you in listing reports run,by date:

SELECT * FROM REPORT_LOG WHERE RUN_DATE='DATE'

[cspadola]

Re: Exporting a List Of Reports from Reports Servlet

Hi Srivathsana...this SQL works but it looks like the report_log table is not being updated. I only have a few rows of data and they are from a couple of years ago. I'll check this on my side...could be that they disabled this logging.

Thanks for the info.