nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Query: NPM:: Wireless Report - Clients by SSID

Miron

Hi,

Is it possible to graph or create a report which shows the number of clients associated to the various SSID's?

Regards

Miron

Find more posts tagged with

orion_wireless_wifi_network_ssid_client_report_npm

ssid

Accepted answers

All comments

bshopp

I believe you should be able to do this in report writer using advanced SQL, maybe one of the SQL gurus here on thwack can help you out

rmck2011

I also have the same requirement to be able to run a report that shows clients by SSID.

We are in the process of migrated to a more secure WPA2/PEAP solution and need to be able to report on clients by SSID to track the progress of the migration and to target systems that need to be updated with the new wireless profile.

This is the only post I have found relating to this query, but I do not see a solution posted.

Has anyone been able to configure a report to accomplish this? If so, would you mind sharing the report or the steps needed to configure the report?

Thank you.

Miron

Hi,

I havent seen anything improve in the inbuilt sw functionality that would allow this. Appears it is not on SW priority list.

Miron

kennes913

Hi Miron:

I've marked this for the PMs to check out since it's an older thread.

bakinbits

Bump. I've also been asked to provide this type of report.

mcbridea

Just to clarify, SolarWinds does not create custom SQL reports but we encourage our SQL saavy members to help out if they can. Any SQL gurus need some good karma?

bakinbits

Here's a rough stab at it. I have zero SQL knowledge so this might be an abomination.

SELECT TOP 500
rc.Client_MAC AS MAC_Address,
rc.NodeID as NodeID,
rc.Client_SSID AS SSID,
rc.FirstUpdate AS FirstUpdate,
rc.LastUpdate AS LastUpdate,
SUM((rc.Client_TotalBytesRxDiff + rc.Client_TotalBytesTxDiff)) AS SUM_of_Total_Bytes_Rx_Tx,
SUM(rc.Client_TotalBytesRxDiff) AS SUM_of_Total_Bytes_Rx,
SUM(rc.Client_TotalBytesTxDiff) AS SUM_of_Total_Bytes_Tx
From NPM_NV_WL_CLIENTS_DETAIL rc
INNER JOIN Nodes on Nodes.NodeID = rc.NodeID
WHERE rc.Client_SSID = 'Pipeline' <--- the SSID I care about reporting on
GROUP BY rc.Client_SSID, rc.Client_MAC, rc.NodeID, rc.FirstUpdate, rc.LastUpdate
ORDER BY 1 DESC

The output gets me about halfway to usable data. It looks like 'FirstUpdate' is when the client connects and 'LastUpdate' is an update of that connection. What I'm trying to figure out is:

-how to group/add up the values of a connection so it only shows a single connection OR
-how to group/add up the values for a single day
-specify date ranges and/or include/exclude business hours

Sample output. I have it grouping by MAC and 'FirstUpdate' within Report Writer: