Since the release of web-based reports in 10.6, we've definitely heard from the community the desire to be able to share reports as can be done with Report Writer. That goes to show the involvedness of the Thwack community, and/or the desire to rack up buku Thwack points. In lieu of Import / Export functionality available through the UI (yet), we've put together a few quick steps on how to share reports: Export Open Database manager or SQL management studio Connect to Orion server Select report which you need to export for example: SELECT definition FROM [dbo].[ReportDefinitions] where reportid=129 Copy text from "definition" column to clipboard(ctrl-C) and save it as .xml file. Use UTF-8 encoding when you are saving it! (save as Encoding: UTF-8) Import Open URL your-Orion-SERVER/.../import.aspx Select file. Click import. Note: Did we mention don't skip the UTF-8 encoding?

This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

The secret lives of web-based reports

rob.hock over 10 years ago

Since the release of web-based reports in 10.6, we've definitely heard from the community the desire to be able to share reports as can be done with Report Writer. That goes to show the involvedness of the Thwack community, and/or the desire to rack up buku Thwack points.

In lieu of Import / Export functionality available through the UI (yet), we've put together a few quick steps on how to share reports:

Export

Open Database manager or SQL management studio
Connect to Orion server
Select report which you need to export for example: SELECT definition FROM [dbo].[ReportDefinitions] where reportid=129
Copy text from "definition" column to clipboard(ctrl-C) and save it as .xml file. Use UTF-8 encoding when you are saving it! (save as Encoding: UTF-8)

Import

Open URL your-Orion-SERVER/.../import.aspx
Select file.
Click import.

Note: Did we mention don't skip the UTF-8 encoding?

Top Replies

0 njoylif over 10 years ago

Rockin! thanks all
Cancel
Vote Up 0 Vote Down

Cancel
0 Sohail.Bhamani over 10 years ago

Awesome. I needed just this. Thanks for sharing!
Sohail Bhamani
http://www.loop1systems.com
Cancel
Vote Up 0 Vote Down

Cancel
0 deverts over 10 years ago

All,
Maybe the kind folks watching this post can help me on a related issue:
Web-reporting in 10.6 - Unexpected Website Error
Thoughts and ideas?
D
Cancel
Vote Up 0 Vote Down

Cancel
0 unclescar over 10 years ago

Is there any time-scale on an official import/export method being put in place? This method is fine at the moment but I'm curious as to when we may see a more permanent and end-user friendly version.
Cancel
Vote Up 0 Vote Down

Cancel
0 rob.hock over 10 years ago in reply to unclescar

Unfortunately our legal team is very prickly about communicating time frames. I can confirm it's not made an appearance in the 10.7 beta.
Cancel
Vote Up +1 Vote Down

Cancel
0 patriot over 10 years ago

I'm not even going to try to hide my ignorance here! What is meant by "sharing" a report in this context? And, how is it already possible in Report Writer? I think I missed something here. Thanks.
Cancel
Vote Up +1 Vote Down

Cancel
0 rob.hock over 10 years ago in reply to patriot

Not at all- keeping up with all of our features is a full-time job. In the old Report Writer you could save a report definition and send it to someone else. That person could then open the report definition and run it in their environment. See NODES_Currently_Down_with_Duration_.OrionReport for an example.
Cancel
Vote Up 0 Vote Down

Cancel
0 patriot over 10 years ago in reply to rob.hock

Rob, are you taking about the Report Scheduler?
Cancel
Vote Up +1 Vote Down

Cancel
0 rob.hock over 10 years ago in reply to patriot

Two different aspects:
Report Definition - Meta data defining layout and dataset you could save as a file and share on thwack
Report output - Scheduled report that would be emailed to stakeholder on a recurring basis.
Cancel
Vote Up +1 Vote Down

Cancel
0 ecklerwr1 over 10 years ago in reply to patriot

@patriot Simply the old Network Atlas allowed you to export and import reports so you could share them. This is not implemented in the new Web based reports yet so you have to do a work around.
Cancel
Vote Up +1 Vote Down

Cancel