Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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
10:11, 30 Mar 2017

Tags

Classifications

Public