The Orion family has some decent reporting options. Why can we NOT get a decent export of these reports? The current "Export to PDF" is a joke - its a SCREENSHOT in PDF format.
Please add Export to EXCEL or at the LEAST Export to CSV.
Please god put this one in!!! At the moment creating any valuable MI reports on the network performance/availability takes me a day, an export of the raw report data to CSV would allow me to do it in minutes (and graph the data, which is another thing sadly lacking from the reports on NPM).
You can turn any report into a CSV file easily. All you need to do is:
1.) Launch the report that you wish to see.
2.) Once the report opens, add the suffix &DataFormat=Excel to the end of the report's URL.
I do this all the time with my reports and it works great. I hope this helps.
That's all the more reason they should simply add the button to the page where they present the report. It's very frustrating to me that they won't make a simple change like this.
True it is simple that way, but it would be nice if they could add that functionality to the report scheduler.
Right click and > 'Export to Excel' works on any Report Writer report (using IE), but there are other pages that would benefit from this functionality, such as UnDP tables, Events, Syslog and Alerts pages.
Report Scheduler needs this!
This would definately be of great benefit for my operations team as they currently have to be cutting and pasting the PDF into an Excel file and massaging the data as required.
Can't believe this isn't a button.
Also, the fake exporting to Excel loses some formatting elements. All your hidden fields suddenly are back in your report. You know, the formatting you spent all that time on? Yeah, that isn't what exports into Excel format, you get all the extraneous extras you already filtered for display.
I find this infuriating.
desperately needed for IPAM, you will get one Excel spreadsheet per IP address, 2000 IP's? 2000 Excel spreadsheets...try adding suffix data to that...
I agree on adding the simple button to the Report views. It would also be very helpful to add an export to CSV/Excel option to the various table views such as Manage Nodes, which would be significantly more useful than the export to PDF option presently available.
new reporting in 10.6 can do exports to XLS files (tabular data)
Hooray. Almost makes me want to implement before testing...
That’s Awesome News….. Best news today… so far..
Craig
is this in a release later than 10.6 RC1?
Michal,
I have NPM v10.6 RC3 installed on our lab server, which I am told is identical as the GA version which just got released. However, I cannot find the feature for exporting to XLS. So, I would appreciate some clarification on your posting.
PS: I am not even sure how this is a new feature per se. After all, we have been able to save reports in XLS format in Orion for years, by adding the code &DataFormat=Excel to the end of the report's URL link. Anyway, I look forward to your reply with clarification. Thanks.
I just upgraded to 10.6 GA and have discovered the Export to Excel is not available as a link for Report Writer created reports. The link is only present for Web GUI created reports. SolarWinds didn't tell us the whole truth. VERY DISAPPOINTING!!!
RGWard,
I just re-read your post and noticed that you did find the Export to Excel on the web-based reports, so here is my revised feedback. For your legacy reports, you can still save those to Excel format by adding &DataFormat=Excel to the end of the legacy report's URL.
I hope this helps.
Good tip, but even after expanding the page size so that all the records show on one page, right clicking and selecting Export to Excel only converts one page. Thanks, though.
Thank you!!! I have a report that I needed in Excel format and this worked!
