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

Document ID : KB000016334
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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

Answer:

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 as test 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. It would also be an enhancement request to add this functionality into the probe by default. I also apologize for the inconvenience for having to perform a workaround to accomplish this.