Add Custom property To SWQL

Question

Hi Guys,

Any idea how to add a customproperty to this swql Select Statement? I just need it to work as it currently is but only pick out the Nodes with customproperty as below.

Current Code Below....

var swql = "Select Count(n.status) AS Cnt,s.StatusName FROM Orion.Nodes n RIGHT Join Orion.StatusInfo s ON n.Status = s.StatusID WHERE s.StatusID IN (1,2,3,9) GROUP By n.Status,s.StatusName,s.StatusId ORDER By s.statusID ASC "

Custom property name would be CloudTeamDevice = 'Yes'

stuartd · Answer

[quote userid="296096" url="~/product-forums/network-performance-monitor-npm/f/forum/98316/add-custom-property-to-swql"]Custom property name would be CloudTeamDevice = 'Yes'[/quote]@bobmarley is on the money, but be aware that sometimes a Yes in SWQL is the same as a 1, so you might just need to amend the query fractionally.

bobmarley · Answer

Give this a try.

Select Count(n.status) AS Cnt, s.StatusName, [n].CustomProperties.CloudTeamDevice
FROM Orion.Nodes n 
RIGHT Join Orion.StatusInfo s ON n.Status = s.StatusID 
WHERE s.StatusID IN (1,2,3,9) AND [n].CustomProperties.CloudTeamDevice LIKE '%YES%'
GROUP By n.Status,s.StatusName,s.StatusId, [n].CustomProperties.CloudTeamDevice ORDER By s.statusID ASC