Wireless Client Chart

Here is a quick one - Thought it would be interesting to see a chart on the number of wireless clients across various APs on a controller.

SELECT

      wav.controllername [Controller]

  ,wav.name [AP Name]

      ,Wireless_AccessPointsHistory.[LastUpdate]

      ,Wireless_AccessPointsHistory.[Clients]

      ,[InBytes]

      ,[OutBytes]

      ,Wireless_AccessPointsHistory.[InBps]

      ,Wireless_AccessPointsHistory.[OutBps]

  FROM [L1SOrion].[dbo].[Wireless_AccessPointsHistory]

join [Wireless_AccessPoints_View] wav on wav.[Index]=Wireless_AccessPointsHistory.[index]

  where wav.controllername='xxx2504' and

   datediff(dd,Wireless_AccessPointsHistory.lastupdate,getdate()) <=7

-Thanks

Amit