We have a report called Unique Wireless Clients last 7 days that displays the info that I am looking for but on the Meraki devices we monitor in Solarwinds. We are using the API and have a unique API set up for each of the unique groups we have. I can see all devices in the wireless view but am not able to figure out how I would pull the unique clients connected to each. Any help would be much appreciated.
This is the report that shows the non-Meraki client info.
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')</pre>
