1 Reply Latest reply on Apr 1, 2016 3:07 AM by orbit17

    “Repeat offenders” Top XX Nodes by...


      Hi all,


      Would like some assistance in writing a report please – that uses the built in Top 10 lists.


      I would like to have a report that shows which devices keep making their way into this Memory and CPU view.


      I also think this would be a nice default report to be included – perhaps as a feature request?


      Thank you

        • Re: “Repeat offenders” Top XX Nodes by...

          I have managed to get something together which is proving very useful to me in my environment.


          I dubbed it repeat offenders as I have a need to know which machines are continually hitting high on memory and CPU usage, as this helps me identify which machines are under continuous load - the report identifies how many times a machine exceeds a threshold set on CPU and Memory, and reports on the amount of counts (Hits).


          SELECT C.NodeID, N.IP_Address, N.Caption, N.SysName, N.MachineType, COUNT(1) AS [Hits], COUNT(1) * 10 AS [MinutesOnLoad],

          MIN(C.DateTime) AS [FirstHit], MAX(C.DateTime) AS [LastHit]

          FROM dbo.CPULoad_Detail_20160331 AS C WITH (NOLOCK)

          INNER JOIN dbo.Nodes AS N WITH (NOLOCK)

          ON C.NodeID = N.NodeID

          WHERE C.AvgLoad >= 80

          GROUP BY C.NodeID, N.IP_Address, N.Caption, N.SysName, N.MachineType

          HAVING COUNT(1) > 2

          ORDER BY COUNT(1) DESC


          Remember to change the date - FROM dbo.CPULoad_Detail_20160331 AS C WITH (NOLOCK)

          Also if you would like to change this to report on Memory - change: WHERE AvgPercentMemoryUsed >= 80 And you can change the threshold in my case, I am using 80% on both Memory and CPU.


          Perhaps this will be useful for some of you, and I think this would be nice to have built in.

          Thanks Craig