SWQL Case statement used in EOC

tmcurry​ it is possible to use case keyword in SWQL from EOC Instance - here is a basic example:

SELECT TOP 1000

CASE

WHEN n.IP like '10.%' then 'Local 10.'

WHEN n.IP like '192.%' then 'Local 192.'

WHEN n.IP like '172.%' then 'Local 172.'

ELSE 'Global'

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.

Thank you for your response I used this baseline. Sorry for the late kudos operator head space error with applying the correct answer.