2 of 2 people found this helpful
tmcurry it is possible to use case keyword in SWQL from EOC Instance - here is a basic example:
SELECT TOP 1000
WHEN n.IP like '10.%' then 'Local 10.'
WHEN n.IP like '192.%' then 'Local 192.'
WHEN n.IP like '172.%' then 'Local 172.'
END AS IpAddressType
FROM Orion.Nodes n
Hopefully that helps.
Thank you for your response I used this baseline. Sorry for the late kudos operator head space error with applying the correct answer.