Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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: 1,021 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