Wireless Clients History Report

Looking to create a unique wireless clients history (last 7/30 days) report using either a DB query or dynamic query builder for all access points and for a specific SSID.

I made an attempt using resource as custom table - dynamic query builder but the outcome has multiple entries for the same MAC address and with identical first and last connected time.

If I choose the resource as History Wireless Clients/Wireless Controllers, it will only let me choose one Access Point, however has the data I exactly want.

Has anyone worked on a similar report successfully? We're on the 2020.2.5 version.

Thank you.

Find more posts tagged with

wireless clients

wireless clients history

Accepted answers

All comments

sunvad

Bump!

stuartd

You may want to raise a support case to get their input, but I suspect you will need to go down the route of creating an advanced SWQL/SQL query:

On the yellow Conditions line, click the arrow on the right hand side and choose 'show SWQL' and then copy/paste that here, and I'll take a look at my end and see what I can find out ...

sunvad

Thanks for your help Stuart. Here is the query from "Show SWQL"

SELECT [data].[WirelessInterfaces].[WirelessClients].[DisplayName] AS [DisplayName],[data].[WirelessInterfaces].[DisplayName] AS [DisplayName1],[data].[DisplayName] AS [DisplayName2],[data].[Node].[DisplayName] AS [DisplayName3],[data].[WirelessInterfaces].[WirelessClients].[HistoricalClients].[ObservationTimestamp] AS [ObservationTimestamp],[data].[InstanceSiteId] AS [InstanceSiteId]
FROM orion.packages.wireless.accesspoints AS data
WHERE
((([data].[WirelessInterfaces].[WirelessClients].[HistoricalClients].[SSID]) = ('AIAS')))
WITH NOLOCK

Table Layout:

Result for one of the MAC IDs - there are several others with multiple entries:

bijuk

Instead Creating as a report please try the steps as follows

Manage report --> create report --> select TOP XX LISTS -> there choose “History of wireless clients-last 7 days”--> change Group by as “Node” and choose your Access Point. Then you can change the Interval from Last 7 days to 1 year as per your need