RESOLVED: Export A List Of All Reports To CSV

Reporting
1

I’ve been asked to provide a list of all custom reports our users have created for auditing. Thinking this would a straightforward task, I started looking for a way to capture the list of reports from the WebReports site, one problem. there doesn’t seem to be a way to do this that’s clearly visible. So I’m looking for your help.

Here’s my goal
Take a list of all reports from BES WebReports to an Excel spreadsheet

Must Haves: Minimum of Report Name, Author, and Last Modify Date
Nice to have: Related relevance (option to select columns)

Any assistance would be greatly appreciated.

Side Note: I am not looking to export the results of a report to CSV, I am looking to export a list of the reports themselves.

2

This information is available from within the BESReporting database. Something like the following query should return your must haves:

select ReportName, U.LoginName, IsPublic, IsVisible, LastModified 
from WEBREPORTS W
inner join USER_NAMES U on W.Creator = U.UserID
2 Likes
3

Exactly what I needed! Thanks Aram!