Network Management

Create web-based reports using SWQL in the SolarWinds platform

Semantic Web Query Language is the best approach for customize report. This article will provide guidance on how to do it step by step.

First published date

11/29/2018 10:47 PM

Last published date

6/26/2025 8:38 PM

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.

Product section

Network Performance Monitor

Cause

Needs report using SWQL

Resolution

  1. Log in to your SolarWinds Platform Web Console.
  2. Go to Home > Reports and click Manage Reports.
  3. Click Create New Report. 
  4. Select Custom Table and click Select and Continue. 
  5. 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 the SolarWinds Platform, 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.
  6. Define columns that will present the data gathered by your SWQL query, and click Submit.
  7. 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.