Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Wireless SSID Report

Wireless SSID Report

Table of contents
Created by John Salvani, last modified by Aileen de Lara_ret on Jul 19, 2016

Views: 1,363 Votes: 0 Revisions: 2

Updated July 19, 2016

Overview

This article provides steps to create custom report using SQL query to show the clients connected to a SSID.

Environment

NPM version 12

Steps

  1. Open the Database Manager in Solarwinds Orion folder. Go to Start > Solarwinds Orion > Advanced Features > Database Manager.
  2. Click Add Server (add the Orion Server).
  3. Log in using your SQL Orion account.
  4. Right-click SolarWindsOrion Database, and then select New Query.
  5. Copy and Paste the following query:
    SELECT * FROM [dbo].[Wireless_Clients]
    Where SSID ='<SSID NAME HERE>
    '
  6. Press Execute Query.

 

You can also export this via .CSV or create a report using the SQL query commands above.

 

 

Last modified

Tags

Classifications

Public