1 Reply Latest reply on Nov 30, 2012 1:57 PM by mharvey

    Wireless AP reports

    dpeterson87

      Hello,

       

      Are there any SQL guru's that could help with a report I am trying to get.

       

      What we want is a report that shows the number of clients connected to each access point we have for each site in 5 minute intervals.


      The stock reports don't seem to allows us to get this info and I have tried some thing's with the SQL reports but they aren't working.

       

      Thanks for any help in advance,

       

      -Dustin

        • Re: Wireless AP reports
          mharvey

          This is something that should get you started in the right direction:

           

          select NPM_NV_WL_APS.AP_Name as AP_Name, Count(NPM_NV_WL_CLIENTS.ID) as Client_Count, Datepart(minute, NPM_NV_WL_APS.LastUpdate)/5 as Interval

          From NPM_NV_WL_CLIENTS

          Join NPM_NV_WL_APS on NPM_NV_WL_APS.NodeID = NPM_NV_WL_APS.NodeID

          Where NPM_NV_WL_CLIENTS.Available = 1

           

           

          Group by NPM_NV_WL_APS.AP_Name, Datepart(minute,NPM_NV_WL_APS.LastUpdate)/5

           

          Regards,

          Matthew Harvey

          Loop1 Systems

          http://www.loop1systems.com