Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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

Wireless SSID Report

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

Views: 46 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
22:30, 18 Jul 2016

Tags

Classifications

Public