The most recent content from our members.
Hi All, No working knowledge of SWQL here - but I managed to cobble together a simple report within Orion Solarwinds where I can leverage a table of specific interfaces for the 90/95/99th percentile for 30days. I was looking if someone could point me in the right direction how to modify the SWQL query to instead look for a…
Example" Server max Memory Usage => 90% or 80% for 20 minutes on 1/1/2022. I am clueless on how to incorporate the time the max memory usage exceeding the threshold. Example? Select caption, location, max memory utilization where max memory utilization => 90%? Can you help me?
I have scoured the forums, I think, and I see lots of people asking this question, but no answer so far: There are several pre-canned reports for 95% percentile for Interfaces, but there doesn't seem to be a way to create a tabulated report (not a chart!) of CPU/Memory utilization for nodes. Am I missing something?
This is based on the the SWQL 95th Percentile Traffic Rate – Last Month report and now using SQL. I would like to be able to group the data by month summarizing all historical data. SELECT n.Caption as NodeName, format(DateTime,'MM/yyyy') as Report_Date, Max(In_Averagebps) as maxInMaxbps, Max(Out_Averagebps) as…
I've been stumbling around Thwack and everywhere else in the Google land and haven't yet been able to figure out how to run a report against a group of interfaces that I created using Dynamic Queries. It seems that I can only create a report that reports on the Interface status, description, etc. But nothing that allows me…
DECLARE @StartDate DateTime DECLARE @EndDate DateTime DECLARE @StartHour INT DECLARE @EndHour INT SET @StartDate = '2018-03-01' SET @EndDate = '2018-04-01' SET @StartHour = 6 SET @EndHour = 17 -- Putting @EndHour = 17 will include 17:59 or 5:59 PM SELECT @StartDate AS Start_Date, @EndDate AS End_Date,…
Hello Guys, I created one report from report manager. after download report showing the utilization can you tell me 95th and 90th percentile ?? Regards, kishore
It looks like you're new here. Sign in or register to get started.