Wireless Client Report?

martek01

We have the Wireless add on package for Orion and via the interface, I can see how many clients are connected to individual APs. One of our departments needs to know how many clients attached to each AP in the last 30 days. Has anyone had any luck pulling this kind of info from the tables?

Thanks,
Evans Martin

---
Evans L. Martin - IS Analyst
Metro Govt. of Nashville, TN & Davidson County
615.862.4066 Office 615.862.6288 Fax AOL AIM: Martek01

zhct1

I have been working on a similar query. It's not perfect, and it's difficult to decide what constitutes a new connection (attachment to an AP). The way I have looked at it is to measure the number of different clients connecting to each AP, rather than the number of sessions, as each client produced many sessions per day.

The code counts reverse DNS for ease of modifying the query for other info. Strictly speaking this should be measuring MAC addresses. The column for this is ClientMacAddress if you want to change it.

The only other problem I found is that I can only look at one day, not 30 as I use the distinct rows function to count the different clients. However, if the date is extended beyond a day it either misses the same client connecting each day, or if you add dates back in it creates a report showing all the sessions again.

The date needs to be separated from the time, but I'm not sure how to do that. Might be useful, might not, but here it is anyway.

SELECT DISTINCT dbo.Nodes.SysName, COUNT(DISTINCT dbo.WirelessSessions.ReverseDNS) AS Expr2
FROM dbo.Nodes INNER JOIN
dbo.WirelessSessions ON dbo.Nodes.NodeID = dbo.WirelessSessions.NodeID INNER JOIN
dbo.WirelessClientStatistics ON dbo.Nodes.NodeID = dbo.WirelessClientStatistics.NodeID
WHERE (dbo.WirelessClientStatistics.DateTime > CONVERT(DATETIME, '2006-03-23 00:00:00', 102)) AND
(dbo.WirelessClientStatistics.DateTime < CONVERT(DATETIME, '2006-03-24 00:00:00', 102))
GROUP BY dbo.Nodes.SysName