Is there a simple way to get Report data into a CSV file? My boss like Excel and doesn't want a PDF...
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
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
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
Obviously the
&dataformat=xls
or
&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.
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.