How can I create a "25 Worst site average response time"?

Nhicks

I have one from the old Report Writer, but as far as I can tell, I cannot create that same report under the web gui. I cant post teh screen shots, but it works great the old way.  I need to convert it to the new web gui to add additional people and functions.  Basically I have 800+ nodes. About 100 of them are non-stable wireless modems. I want to take the top 10 or top 25, WORST performing nodes over a period of X days.. right now, 7 days. I also want to create one for 30 days. Right now I sort it from worst on top to best on bottom.  I'm lost.

Below is what we have in the old report writer:

Telecom – 20 worst transceivers:

SELECT TOP 20

1. Nodes.NodeID AS NodeID,
2. Nodes.Caption AS NodeName,

AVG(ResponseTime.Availability) AS AVERAGE_of_Availability

FROM

Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

WHERE

( DateTime BETWEEN 41783 AND 41876 )

AND 

(

  (Nodes.Caption LIKE '%trans%')

)

GROUP BY Nodes.NodeID, Nodes.Caption

ORDER BY 3 ASC

Then top 20 records

Over last 3 months

antonis.athanasiou

Hi,

you can still create this report using the web-reporting engine:

1. Create new report, select "custom table" on the "add content" window

2. see screenshot below for selection method:

3.Select NodeID and Caption from the "Add Column" window, then  navigate all the way down to "Response Time History" to add the "Availability" column to the display:

4.Make sure your results are sorted by the "Availability" column, ascending order, and check the "Show only the top XX records" (change that to 20):

5.Click on "Submit", then don't forget to set the time period on the datasource to match your needs:

That's it, you are all set!

Antonis Athanasiou

Prosperon - UK SolarWinds Partners

Installation | Consultancy | Training | Licenses