top 10 CPU % Load

Question

where can i add cusom property location

SELECT TOP 10 n.CPULoad,n.Caption,n.Status,n.CustomProperties.Locations AS CustomProperties_Locations,n.DetailsUrl 
FROM Orion.Nodes n order by n.CPULoad descending

CustomProperties.Locations AS [CustomProperties Location]

KMSigma.SWI · Answer

What type of limitation?  How is it defined?  There are dozens and dozens of limitations available.

sadiqsul · Answer

it is working thank you brother . but there is a problem when i put account limitation the red bar not showing

KMSigma.SWI · Answer

This is what worked for me:

SELECT TOP 10 [N].CPULoad
            , [N].Caption
            , [N].Status
--            , [N].CustomProperties.Locations AS [CustomProperties_Locations]
            , [N].DetailsUrl
            , [N].CustomProperties.Comments AS [CP_Comments]
            , [N].CustomProperties.City AS [CP_City]
FROM Orion.Nodes AS [N]
ORDER BY [N].CPULoad DESC

(Your CP is commented out because I don't have that Node Custom Property in my environment)