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
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?
I havent seen anything improve in the inbuilt sw functionality that would allow this. Appears it is not on SW priority list.
I've marked this for the PMs to check out since it's an older thread.
Bump. I've also been asked to provide this type of report.
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?
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:
You may want to create a UnDP to poll this MIB.
The MIB is not a Cisco MIB. The MIB with all the information is an airespace MIB for the WLC-5508. Here is the one 220.127.116.11.4.1.14179.2 after running a walk you will find a lot of information. The full details can be found here http://www.oidview.com/mibs/14179/AIRESPACE-WIRELESS-MIB.html.