5 Replies Latest reply on Sep 2, 2009 4:22 AM by jan

    Creating wireless client reports

    BonjiMoo

      I need to create some reports that give me information about my wireless clients and their signal strength.  However, the report writer does not show me any fields that relate to any wireless client data.

      The wireless monitor addon is installed and functional.

        • Re: Creating wireless client reports
          bshopp

          You will need to use the Advanced SQL option to create this report. 

          • Re: Creating wireless client reports
            jan

            You can use this SQL query in Advanced SQL report. It shows you wireless clients, IP, MAC address and signal strength for the last 7 days:

            SELECT
             cl.NodeID,
             ap.AP_Name,
             cl.Client_Name,
             cl.Client_IPAddress,
             cl.Client_MAC,
             AVG(cl.Client_SignalStrength) AS Client_SignalStrength
            FROM NPM_NV_WL_CLIENTS_STATS cl
            LEFT JOIN NPM_NV_WL_INTERFACES_STATS i ON (i.ID = cl.ParentID AND i.GroupID = cl.GroupID)
            LEFT JOIN NPM_NV_WL_APS_STATS ap ON (ap.ID = i.ParentID AND ap.GroupID = i.GroupID)
            INNER JOIN Nodes ON Nodes.NodeID = cl.NodeID
            WHERE (cl.LastUpdate BETWEEN DATEADD(day, -7, getdate()) AND getdate())
            GROUP BY cl.NodeID, ap.AP_Name, cl.Client_MAC, cl.Client_IPAddress, cl.Client_Name

            Let me know if you need any additional info.

            Jan