This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Modern Dashboards - Top 10 Monitored Processes Conversion from Classic

I'm trying to recreate the following dashboards from Classic:

  • Top 10 Monitored Processes by CPU Load
  • Top 10 Monitored Processes by Physical Memory
  • Top 10 Monitored Processes by Virtual Memory
  • Top 10 Monitored Processes by I/O Total Operations/s
  • Top 10 Monitored Processes by I/O Reads/s
  • Top 10 Monitored Processes by I/O Write/s

Can someone tell me the SWQL querie(s) that are needed to pull these results?  
Fields needed are ProcessName, Application Name, Network Node, NodeID

  • I found this out myself.  Trying to put some weight into it also so it bubble up high io and cpu to the top:

    SELECT TOP 25 cs.NodeID, n.Caption, cs.ApplicationID, cs.ApplicationAvailability, cs.ComponentID, cs.ComponentName, cs.ComponentType, cs.ComponentAvailability, cs.ComponentErrorCode, cs.ComponentPortNumber, cs.ComponentResponseTime, cs.ComponentStatisticData, cs.ComponentPID, cs.ComponentProcessName, cs.ComponentPercentCPU, cs.ComponentPercentMemory, cs.ComponentMemoryUsed, cs.ComponentPercentVirtualMemory, cs.ComponentVirtualMemoryUsed, cs.ComponentIOReadOperationsPerSec, cs.ComponentIOWriteOperationsPerSec, cs.ComponentIOTotalOperationsPerSec, cs.InstanceCount, cs.ErrorMessage, cs.Description, cs.ComponentPercentCPU + cs.ComponentIOTotalOperationsPerSec as Weight
    FROM Orion.APM.CurrentStatistics cs
    Join Orion.Nodes n on n.NodeID = cs.NodeID
    order by weight desc