jaed

Remove the first CurrentValue. Or put a comma after it.

Did you try changing the "SELECT TOP 1000" to "SELECT TOP 1" And add "ORDER BY cps.DateTime DESC" to the bottom?

SELECT TOP 1 Message, NodeID, (CASE WHEN Message = 'ciscoExperiment.91.1.2.3.1.11.7 = ICMP to 8.8.8.8 ok' Then 'Up' ELSE 'Down' END) AS InternetStatus FROM Orion.Traps Where (NodeID = '123') ORDER BY TimeStamp DESC I cannot verify, but that's my best guess. The query definitely runs in the SWQL editor.

I was just giving you a query with the working case statement. Nothing at all to do with your internet query. I don't know how your existing query isn't working, so I was assuming it didn't execute at all.

I don't use traps myself, but I did a query in a different table using the same idea and it seems to work. SELECT TOP 1000 AlertDefID, ActiveObject, ObjectType, (Case When State=2 Then 'Down' Else 'Up-ish' End) AS State, WorkingState, ObjectName, AlertMessage, TriggerTimeStamp, TriggerTimeOffset, TriggerCount,…

Martin, No, unfortunately the issue exceeded my available time to work on it and I just don't look at the diagnostics any more. But if you do find anything and post it here I would definitely appreciate it and will try to implement any solutions! Thanks Jason