Where to single out a specific Component and or application in this code and then results.

Question

Here is the code below and just want be able to query for a specific Example: Node like contains "ENAC" or "Applications" Contain "ENAC"?

Any help with this would be appreciated since I am not even close to being a programmer..

SELECT TOP 10 s.Component.Status as ComponentStatus, s.Component.DetailsUrl as CDetailsUrl, s.Component.Name as [Component Name]
, s.Component.Application.Status as ApplicationStatus, s.Component.Application.DetailsUrl as ADetailsUrl, s.Component.Application.Name as [Application Name]
, s.Component.Application.Node.Status as NodeStatus, s.Component.Application.Node.DetailsUrl as NDetailsUrl, s.Component.Application.Node.Caption as [Node Name]
, ROUND(ComponentPercentCPU,2) as [CPU Usage]
FROM Orion.APM.CurrentStatistics s
WHERE ComponentPercentCPU >=0
ORDER BY ComponentPercentCPU desc

I want to break it out by either the Component Name or preferably just get a specific node or selections of nodes queried results.

Thanks

-Freddie

bobmarley · Accepted Answer

Change the Where to this and fill in the items that are all caps.

WHERE ComponentPercentCPU >=0 AND s.Component.Application.Node.Caption LIKE '%YOURNODENAME%' AND s.Component.Application.Name LIKE '%YOURAPPLICATIONNAME%'

SalemTech · Accepted Answer

Thanks I will give it shot now...