I found the following SWQL in this thread. I am able to use it as advertised but would like to be able toad the LastUpdate column from the same table (Orion.Wireless.Clients) and can't seem to get the right command. If I run SELECT LastUpdate as [LastUpdate] FROM Orion.Wireless.Clients by itself it runs fine. This would allow me to make a custom chart that shows SSID usage over time. I have googled and searched THWACK to no end. Can someone assist?
SELECT
c.SSID, count(ssid) as [Client Count]
FROM Orion.Wireless.Clients c
join orion.wireless.accesspoints ap on ap.id=c.accesspointid
join orion.nodes n on n.nodeid=c.nodeid
group by
c.ssid
order by c.ssid
