Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Reports in CSV format?

ken_cohen

Is there a simple way to get Report data into a CSV file? My boss like Excel and doesn't want a PDF...

Find more posts tagged with

Accepted answers

vinay.by

if this is what you were looking for mark the answer as correct once you have tested it , have a great day

All comments

neomatrix1217

Maybe I'm missing something but have you selected CSV as file type in the schedule report?

Create, assign and edit report schedules for NPM - SolarWinds Worldwide, LLC. Help and Support

ken_cohen

That’s available in the scheduler but not in on-demand? Say it isn’t so…

Kenneth W. Cohen

Network Analyst

Global Technical Services, IT

Office: 470-448-5870

Mobile: 678-428-9875

kenneth.cohen@hyh.com<mailto:kenneth.cohen@hyh.com>

Halyardhealth.com

image001.jpg

rschroeder

That info might be dependent on the type of Report, or how the Report was created (via Report Writer or via Web-based).

I see an option to export to Excel in some reports:

vinay.by

Hi ken_cohen

Probably when you say on demand if I am not wrong this is what you mean as illustrated on the image you dont see an excel or csv option

There's always a workaround for such things in Solarwinds

Now say suppose the URL of this report on Solarwinds GUI is as mentioned below when you pull the report:

https://<SolarwindsIP>/Orion/Report.aspx?Report=Australia_Disk_Report&ReturnTo=a0cHM6Ly9n9iY

Modify your URL and Just append '&dataformat=xls or &dataformat=csv' at the end of the url to extract it in the format you want <HIT ENTER> and then <SAVE>

Example 1 - Pull the on demand report in xls format

https://<SolarwindsIP>/Orion/Report.aspx?Report=Australia_Disk_Report&ReturnTo=a0cHM6Ly9n9iY&dataformat=xls

Example 2 - Pull the on demand report in csv format

https://<SolarwindsIP>/Orion/Report.aspx?Report=Australia_Disk_Report&ReturnTo=a0cHM6Ly9n9iY&dataformat=csv

Hope it helps

ken_cohen

Wow – Thank you!

Kenneth W. Cohen

Network Analyst

Global Technical Services, IT

Office: 470-448-5870

Mobile: 678-428-9875

kenneth.cohen@hyh.com<mailto:kenneth.cohen@hyh.com>

Halyardhealth.com

image001.jpg

vinay.by

if this is what you were looking for mark the answer as correct once you have tested it , have a great day

rschroeder

I never knew that was an option. Thanks for expanding my knowledge, Vinay!

vinay.by

d09h

Obviously the

&dataformat=xls

&dataformat=csv

could indicate a different format, although it should be one your browser is configured to work with (IE will inherit somewhat, others may need explicit configuration per format). And this export functionality is not necessarily just useful for SolarWinds.

dc4networks

Vinay,

I hope this is what
I am looking for as I would like to export a *.xls Report via the SolarWinds
Orion Web Gui and not have to use the Report Writer on the SolarWinds Orion VM.

Just to clarify the
items within the =xls https:// line.

https://<SolarwindsIP>/Orion/Report.aspx?Report=Australia_Disk_Report&ReturnTo=a0cHM6Ly9n9iY&dataformat=xls

https://<SolarwindsIP>/Orion/Report.aspx?Report=<REPORT_NAME>&ReturnTo=<What
and Where do we get this ID? “a0cHM6Ly9n9iY”>&dataformat=xls

Please excuse my ignorance, what
is the and where do we get the equivalent ID; a0cHM6Ly9n9iY ?

Is this a Value that we find somewhere
within the SolarWinds SQL Database Manager?

Thank you in advance for your
clarification.

Kind Regards

Dan

DC4Networks

dgsmith80

This feature no longer works, is there a workaround to get these without having to log in and click on Export to Excel each time?