Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > Create web-based reports using SWQL

Create web-based reports using SWQL

Table of contents

Updated April 7th, 2016 

Overview

This article provides steps on how to define objects you want to report on using the Semantic Web Query Language.

Semantic Web Query Language (SWQL) is a proprietary, read-only subset of SQL. Similar to SQL, you can use SWQL to query your SolarWinds database for specific network information.

Environment

NPM version 11.5.x

Steps

  1. Log in to your Orion Web Console.
  2. Go to Home > Reports and click Manage Reports.
  1. Click Create New Report. 
  2. Select Custom Table and click Select and Continue. 
  3. Define what objects you want to query:
    1. In the Select objects you want to report on, go to the Selection method drop-down list and select Advanced Database Query (SQL or SWQL). 
    2. Select SWQL as the Query Type and enter the code.
      • Note: For more information about the SWQL supported by Orion, consult the section "Using SWQL" in the SolarWinds Network Performance Monitor WebHelp.
      • Note: If you need to find out table and fields names in your database, you can use the Orion Software Development Kit (SDK) API, available in the Orion SDK forum on thwack.com.
  4. Define columns that will present the data gathered by your SWQL query, and click Submit.
  5. Add the report to your reports.
    1. Define the report layout, preview the report, and define the report properties.
    2. Click Submit to add the report.
  • Note: For more information about creating web-based reports, see the SolarWinds Orion Web-Based Reports technical reference.

 

Last modified

Tags

Classifications

Public