Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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

Create web-based reports using SWQL

Table of contents

Updated April 7th, 2016 


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.


NPM version 11.5.x


  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
  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