SAM Node Count S(W)QL Query

Hi everyone,

Appologies if this is the wrong place to ask, however I'm looking for a bit of advice/help with the above topic.

Essentially, we have four pollers which we're trying to balance out. What we have found that is one of our pollers has a significantly higher component count, even though the node count against the four pollers are fairly evenly balanced!

I did reach out to support to see if they could provide me with a SWQL query to get the number of components each node within SAM has, but they advised that they couldnt and deferred me to Thwack.

Does anyone have a query or able to help me build a query in order to achieve this.

Cheers!

Find more posts tagged with

SAM 2025

sql

SWQL

SAM 2025.2

Accepted answers

RAJPAD

SELECT n.Nodeid, n.Caption, count(c.id) as Count
FROM nodes n
JOIN APM_Application a on n.nodeid=a.nodeid
JOIN APM_Component c on a.id=c.applicationid

where IsDisabled is NULL and a.Unmanaged = 0 and n.UnManaged = 0
GROUP by n.nodeid, n.caption

order by count desc

All comments

RAJPAD

SELECT n.Nodeid, n.Caption, count(c.id) as Count
FROM nodes n
JOIN APM_Application a on n.nodeid=a.nodeid
JOIN APM_Component c on a.id=c.applicationid

where IsDisabled is NULL and a.Unmanaged = 0 and n.UnManaged = 0
GROUP by n.nodeid, n.caption

order by count desc

CameronMG

Many thanks for sending this across, it is greatly appreciated!

The only issue i'm having with it is this error;

--
Msg 208, Level 16, State 1, Line 1
Invalid object name 'nodes'.

Appologies, I'm not great with this type of stuff!

CameronMG

Okay ignore me!

Turns out I forgot to change the Database the query is running against!