Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

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,234 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