Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA 4.2.3 Administrator Guide > NTA reports > Create a report using SWQL

Create a report using SWQL

Table of contents
No headers
Created by Lori Krell_ret, last modified by Alexandra.Nerpasova on Oct 24, 2016

Views: 86 Votes: 1 Revisions: 4

You can define the objects you want to report on using the Semantic Web query language (SWQL).

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.

  1. Click Reports > All Reports.
  2. Click Manage Reports.
  3. Click Create New Report.
  4. Click Custom Table, and then click Select and Continue.
  5. Define the objects to query:
    1. Under Selection Method, select Advanced Database Query (SQL, SWQL).
    2. Click SWQL as the Query Type and enter the code.

      For more information about the SWQL supported by Orion, see Using SWQL.

      To discover table and field names in your database, use the Orion SDK API, available in the Orion SDK forum on thwack.com.

       

      Log in to the Orion SDK

      • Download and install the Orion SDK on the same server as you run SolarWinds NTA. For more information about downloading and using the Orion SDK, see Orion SDK Information.
      • Start the SWQL Studio in your program folder.
      • Enter information to connect to the SolarWinds Information Service:
        • Server Name: localhost
        • Server Type: Orion (v3)
        • User Name and Password: Use the same credentials that you use to log on to the Orion Web Console.
  6. Define columns that will present the data gathered by your SWQL query, and click Submit.
  7. Add the report.
    1. Define the report layout, preview the report, and define the report properties.
    2. Click Submit.
 
Last modified

Tags

Classifications

Public