1 Reply Latest reply on Mar 1, 2016 6:45 AM by antonis.athanasiou

    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

        • Re: How can I create a "25 Worst site average response time"?
          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

          facebook_icon.jpglinkedin.pngblogger.pngtwitter-icon.jpg