Version 1

    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