Network Management

Wireless SSID Report

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

First published date

10/12/2018 4:35 PM

Last published date

10/12/2018 4:35 PM

Overview

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

Product section

Network Performance Monitor

Resolution

  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.
 

Scripts are not supported under any SolarWinds support program or service. Scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.