Alert High CPU Load Top process by SQL

mookmanee.m

I want to pull the Top process component by CPU load. I try query SQL succeed.

But I ran in Alert Solarwinds error MACRO SQL ERROR - No column name was specified for column 1 of 'newmdsvu_geq'.

The CPU on ${N=SwisEntity;M=Caption} is currently running at ${N=SwisEntity;M=CPULoad;F=Percent}.

The top 10 processes running at the time of this poll are listed below:

${SQL: SELECT CAST(CONCAT(c.Name, ' - ',p.PercentCPU,'%',CHAR(10)) AS XML) AS Top_Process

FROM NodesData n
JOIN APM_Application a ON a.NodeID = n.NodeID
JOIN APM_Component c ON c.ApplicationID = a.ID and ISNULL(c.IsDisabled,0)=0
JOIN APM_Process_Detail p ON p.ComponentID = c.ID

WHERE n.NodeID = ${N=SwisEntity;M=NodeID}
AND p.PercentCPU > 0

ORDER BY p.PercentCPU desc
FOR XML PATH('') }

mesverrum

Ran into that recently when working with a new version, the format you have used to work but nothing I tried was able to trick the SQL variable thing into accepting it in the version I was working with. Will love to see if someone comes up with a solution that works in the latest releases because I smashed my head against this for several hours until I finally gave up and just swapped out my variable for a link to the relevant widgets in Orion.

I've seen a pretty steady pattern the last 2 years where SW has been tightening up the reigns on ways we could do potentially sketchy things in SQL, which I assume has been part of their efforts to secure the platform and prevent users from doing weird things in SQL.