I created a User Parameter that runs a query against a SQL server. Select top 1 seconds, server, database, id from table
I am getting the result Tab separated. 4 columns
Seconds - servername - databasename - Id
I created an Item that catch the information correct
My question is how to use each column in the response to create a useful trigger.
I need to alert when column Seconds reach 100 and create an alert that shows me the Seconds, the server name and the database name.
I could not fin a way to capture the values in the columns and pass them to the alert
It should look like:
I receive the value 123 (tab) server01 (tab) database01 (tab) 20
the alert should show as "Database database01 on server Server01 proces with ID 20 has reached 100 seconds"
I am getting the result Tab separated. 4 columns
Seconds - servername - databasename - Id
I created an Item that catch the information correct
My question is how to use each column in the response to create a useful trigger.
I need to alert when column Seconds reach 100 and create an alert that shows me the Seconds, the server name and the database name.
I could not fin a way to capture the values in the columns and pass them to the alert
It should look like:
I receive the value 123 (tab) server01 (tab) database01 (tab) 20
the alert should show as "Database database01 on server Server01 proces with ID 20 has reached 100 seconds"