Comments
-
Glad to see we are not the only people trying to monitor this. My current report has the Max Daily, Min Daily, and the UtilizationPercent, but the powers about want the MaxUtilizationPercent and all of them for a 7 day period. I have yet find a way to do this on a report, especially with so many connections to monitor
-
Finally got to give this a run in the live system and it worked perfectly. Thank you so much. The engineers are now able to see the last date a report was used. This allows them to know which live port is actually free and available to be reused.
-
So believe it or not the last update to 2020.2 broke this report again. This time however, I am not getting any information from Solarwinds on what is causing the issue. Below is what worked until the upgrade. Now it simply times out and says: There was an error processing the request. Any help is appreciated, especially…
-
I have been able to create the utilization, maxin, maxout report like you mentioned. The missing key we need is whether or not we can see a Max utilization for a week. I cannot find that information anywhere.
-
Super helpful. Thank you for sharing. You have saved me hours of work and helped me understand a few things
-
This is the one that is currently in place. It times out 9 out of 10 times. SELECT W.APName, min(W.FirstUpdate) as FirstUpdate, max(W.LastUpdate) as LastUpdate, W.Name as AccessID, W.MAC, W.IPAddress, W.SSID, N.Caption as Controller FROM Orion.Wireless.ClientsSessionHistory W LEFT JOIN Orion.Nodes N on W.NodeID = N.NodeID…