Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

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