Node Group Level avg resource utilization

techieteam

Dear Experts,
We have multiple network groups based on location, and the requirement is to display the average CPU and memory utilization at the group level (not per node).

I was able to include the group name in a custom report but could not add CPU or memory utilization metrics.

Kindly confirm if this is achievable in SolarWinds and suggest the recommended approach.

naveensingh43

Go to Reports → Create New Report.
Choose Custom Table.
In “I want to report on”, choose Nodes.
In Filters, add:

Node Group → is equal to → select your node group.

Add utilization fields:

CPU Load (Average)
Memory Used % (Average)
Under Grouping, choose Node Group so results roll up by group.
Save & run the report.

If above do not work, try the below query

SELECT
c.Name AS NodeGroupName,
AVG(n.CPULoad) AS AvgCPU,
AVG(n.PercentMemoryUsed) AS AvgMemory
FROM Orion.Containers c
JOIN Orion.ContainerMembers cm ON c.ContainerID = cm.ContainerID
JOIN Orion.Nodes n ON cm.EntityID = n.NodeID
WHERE c.Type = 'NodeGroup'
GROUP BY c.Name
ORDER BY c.Name