Has anyone successfully used case in SWQL in the EOC that is willing to share code snippet? My team has been struggling with this and I think this is the answer to one of my reporting problems.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK© online community. More than 180,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.