This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Need to create a report for SSID and total clients count.

Hi All,

We need your support to modify the below-mentioned script. We need to generate a report for the Access point and the total clients connected to these access points. We have created a custom property for all stadiums. so, Need to add a custom property to the below script.

SELECT DateTrunc('Minute',${FromTimeUTC}) as UTCDay, IsNull(SSID, 'N/A') as SSID, COUNT(DISTINCT MAC) AS MACCount
FROM Orion.Packages.Wireless.HistoricalClients
WHERE ((ToUtc(FirstUpdate)>=${FromTimeUTC}) AND (ToUtc(FirstUpdate)<${ToTimeUTC})) OR ((ToUtc(LastUpdate)>=${FromTimeUTC}) AND (ToUtc(LastUpdate)<${ToTimeUTC}))
GROUP BY IsNull(SSID, 'N/A')

Please do the needful on priority .