Can sql_response return values from other columns in the alarm message, not just the one it matches?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Can sql_response return values from other columns in the alarm message, not just the one it matches?

Environment

Release: UIM 8.x
Component: UIMSQR

Resolution

The only way to alarm on multiple columns within the sql_response probe is to create a query similar to the following: 

select name + <ip> from cm_computer_system 

The above query will allow two columns to be added into one.

This will allow you to alarm on the two columns simultaneously. Unfortunately, there is no other way of performing this.