SWQL Case statement used in EOC

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

Top Replies

  • 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…

Parents Reply Children
No Data