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.
Thank you
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.
Thank you
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.
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.