You will need to use the Advanced SQL option to create this report.
Is there a list of the fields to look at for wireless information or do I just have to look at the database and figure it out?
Did you get any further information about fields in the database to use for a report like that? I need to do the same thing.
Well, SW didn't respond with anything to assist, and I haven't had time yet to tear apart their wireless tables to base a report on.
I hope to get to this in the near future as my traveling requirements have died down for the next month or so. If I get something palatable, I'll post a brief synopsis of the info.
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:
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.