I created a query where I can see all alarms with the error message “Failed to connect to computer”:

Now I want to show it in SquaredUp.

The only Problem I have is that the ResolutionState is shown as “255”. Is there a way to show it as “closed” (text)?



Tom79 selected answer
    • Resolution state names are stored in 'dbo.ResolutionState' - a join to this should allow you to do what you need