Exporting Reports

Question

Good Day

Does anyone export reports from the orion reports?? What I am trying to do is find a way that an orion user can export report outputs to excel without copying the content from the printable version link off the web page.

Thank You

FormerMember · Answer

Thanks for your suggestion and help Steve.

I gave it a try but many of our reports are monthly reports and summarized by month (SummaryMonth) and custom SQL. The Excel MS Query doesn't like SummaryMonth (invalid column name) for some reason. I have a couple custom reports with a GO statement which MS Query and Report Writer doesn't like either (syntax error). I run the reports with GO statements using SQL Query Analyzer on the SQL Server and export to Excel (very time consuming). The Excel MS Query method works okay for some of our Report Writer generated reports but not the ones I really need in Excel format. I have 16 reports that I need Report Scheduler to create and distribute the reports to a couple managers that want them in Excel format on a monthly basis. Again, I appreciate your help.

Ron

sgreath · Answer

You can also run your SQL query in Excel.

What I did was setup the reports I wanted in Report writer, then displayed the SQL code and copied it.  I then opened up Excel, clicked on the DATA menu and selected Import External Data, then new database query.  From there you select your Solarwinds database and waalaa.  Paste your SQL code in that section and now you have your report directly in Excel.  This is an awesome way to create your custom charts also.

You can update that report anytime by right-clicking in any cell with the output data and choose refresh data.

FormerMember · Answer

&dataformat=XLS

Has anyone got this to work with Report Scheduler without having Excel installed on the Orion server?  It is my understanding a check is made to determine if Excel exists on the system so you need to burn a MS Office license to exploit the &dataformat=xls option.  Anybody come up with a workaround?