Or everything you always wanted to know about Orion reports but were afraid to ask.
This post is meant for everyone who would like to create his/her own Orion report but is not sure how to start. We have collected a few useful resources that can help you start creating basic reports and also provide technical reference for future enhancements.
The Big Picture
A predefined set of reports is available in the Orion Web Console (HOME -> Reports).
Although the predefined reports are useful and easily accessible, you may sometimes find yourself in need of customization. In that case, there is the Orion Report Writer application that can be found on your Orion server under Start -> All Programs -> SolarWinds Orion -> Alerting, Reporting, and Mapping -> Report Writer.
Using the Report Writer, you can easily create your own Orion reports either from scratch or by editing an existing report. If you want, you can even directly enter the SQL commands implementing the desired report functionality.
And there is more. You can use the Orion Report Scheduler (Start -> All Programs -> SolarWinds Orion -> Alerting, Reporting, and Mapping -> Orion Report Scheduler) to schedule report-related actions. For example, you could create a job that would automatically e-mail you a report every Monday morning that included any significant network events that occurred over the weekend.
Do You Have a Tutorial?
As a quick start guide, you can use Video Tutorial: Using Report Writer within Orion NPM.
- Report Writer overview
- Report creation and customization
- Exporting reports
Advanced topics on reports from SolarWinds’ NPM network monitor are included in Video Tutorial: Orion Network Performance Monitor (NPM) v10 Customer Training - Level II.
- Orion reporting overview
- Reporting architecture
- Report types and customization
- Report delivery options
- A lot of hands-on examples
An exhaustive source of information is Customer Training: NPM Level 2 - Reporting - A Webcast from SolarWinds.
- Introductions and Housekeeping
- Top Report Features
- Working with Existing Reports
- Examining the Resulting SQL Queries
- Filtering and Date Formats
- A bit About SQL
- Report Scheduler
- Including Charts
I Want to Know More!
Then please refer to SolarWinds Technical Reference: Understanding Orion Report Writer.
Other Useful Links
Reports on Orion NPM thwack Content Exchange – what you need may already exist here