I'm trying to pull the "ICMP Status Only Nodes", from the "License Summary Report" via SWQL for part of an alert I'm trying to create. I used the following query in SWQL:
SELECT NodeID, Caption, IP_Address, ObjectSubType
FROM Orion.Nodes
WHERE ObjectSubType = 'ICMP'
It comes back with 293. When I go into the console and look at "Managed Nodes" and display only the ICMP nodes it shows 293. Yet the license report shows "231".
According to SolarWinds, the "ICMP Status Only Nodes" are the nodes that are not counted against for licensing. What SWQL query is being used to grab the "ICMP Status Only Nodes" value?