Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
Create a report showing average availability of your nodes during your business hours. Use a SolarWinds Query Language (SWQL) query to customize the report.
You can also create custom reports with SolarWinds SAM. See the SolarWinds SAM Getting Started Guide for an example.
Create a daily custom service level agreement (SLA) report that shows device availability during business hours, and reports node availability as an uptime percentage.
The report will look like this:
In this scenario, the business hours are called
time_from (start time) and
time_to (end time). Custom properties help specify different business hours for different nodes. These business hours are also included in the report.
time_from), and select Reports in the Usage area.
Add a description that specifies the intended use of the property.
You have created the custom property and are returned to the Manage Custom Properties view.
After you have created custom properties for the start and end time of your business hours, specify the business hours for your nodes.
This scenario uses the Custom Property Editor to define business hour values so that you can also view monitored nodes and their custom properties.
The start and end times are applied on the selected nodes. Develop the query, and create the report.
For more information about custom properties, see:
Use the SolarWinds Query Language (SWQL) to get data for the report from the SolarWinds Information Service (SWIS). SolarWinds strongly recommends against using SQL to access the Orion platform database directly. SWQL and SWIS provide the following advantages:
The following SWQL query retrieves the data needed for the report. If you are not interested in using SWQL Studio to further develop the SWQL query, copy the following code, and continue to Specify the report layout.
SELECT n.Caption, sub_query.sla_day, sub_query.sla_availability, n.CustomProperties.time_from, n.CustomProperties.time_to FROM ( SELECT avg(Availability) AS sla_availability, datetrunc('day',datetime) AS sla_day, r.NodeID FROM Orion.ResponseTime r WHERE hour(datetime) >= r.Node.customproperties.time_from AND hour(datetime)<= r.Node.customproperties.time_to GROUP BY datetrunc('day',datetime), r.NodeID ) AS sub_query INNER JOIN Orion.Nodes n ON n.NodeID=sub_query.NodeID
To learn how this SWQL query works, see the Understanding the Custom SLA Reports SWQL query KB article. Suitable for beginners and advanced users alike, it provides a detailed explanation of the query presented in this article and shows how to develop it further.
C:\Program Files (x86)\SolarWinds\Orion SDK\SWQL Studio\SwqlStudio.exe
SWQL Studio opens. Note that the tree on the left side shows the structure Orion uses for viewing data, not the SQL server structure.
When you defined the data for the report, specify what you want to see in the report and how the data should be sorted.
The default columns are specified in the query:
For more details about reports, see:
You have created a custom SWQL-based report that provides the average availability of nodes during business hours.
For more information, see Create and view reports.