Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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_ret on Jul 19, 2016

Views: 102 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