Understanding Orion Report Writer¤ 1
Orion gives you the option of using built-in reports or creating custom reports. More than one hundred
built-in reports are available in Orion NPM. These reports allow you to access and distribute tabular and
chart-based reports on a variety of information, such as top N utilization for interfaces, memory CPU,
NetFlow top N, applications, inventory, compliance, node status, events, and virtual servers.
The Orion Report Writer is used for creating custom reports or for applying or modifying built-in reports.
Report Writer allows the user to select report parameters, using the Report Writer GUI, or enter a
complete SQL query. When the GUI is used, a SQL query is created in the background. This query can
be viewed for all reports, but can only be edited in custom SQL reports. Both built-in reports and Report
Writer-created reports are executed by querying the Orion SQL database, giving unfettered access to any
data stored in the database.
Several components work together to allow for built-in reporting, custom report creation, and report
Acts as a framework for report structure
Contains the main interface for configuring, creating, and editing reports
Runs queries against the Orion database when requested
Calculate values as required, such as 95
SQL Database - Stores and delivers information for Orion
Orion Core - Provides Web Console, report delivery, and other core functions
Windows Event Scheduler - Provides regularly scheduled report actions
Email - Provides a delivery mechanism for reports
Working with Report Writer
You can open and modify any of the built-in reports in Report Writer. When modifying an existing report, it
is best to find a report that already has most of the elements you require and start from there. Doing so
will help to minimize the time and complexity of creating your custom report. For example there is a
prebuilt NetFlow report
for “Top 10 Traffic Destinations by Domain”. The Top N domains resource in Orion
NetFlow Traffic Analyzer is one of many top N resources including Endpoints, Applications,
Conversations, and Countries. So, if we want to create a report for the Top N traffic by Country, it is
reasonable to start with a similar report, such as the domain report.