Studio - SQL Query

Home  Previous  Next

Applies to the following classes:

Studio - SQL Query (Microsoft SQL Server)
Studio - SQL Query (MySQL Server)
Studio - SQL Query (Oracle Database Server)

Parameters

Name

Type

Description

Alert Conditions

Connection Status

Text

Text parameter that reflects the connection status to the database.

“OK” indicates successful connection to the database.

“Failed” indicates connection failure. The possible causes will be stated.

Alarm or Warning

Alarm

By default Alarm is enabled for RegExp “Failed”

Execution Time

Numeric

Parameter shows the time taken to execute the query.

Unit: Seconds

Alarm or Warning

Alarm

No default thresholds or alerts set

Query Status

Text

Text parameter that shows the status of the database query executed.

“OK” indicates successful execution of the database query.

“Failed” indicates failure. The possible causes will be stated

Alarm or Warning

Alarm

By default Alarm is enabled for RegExp “Failed”

Return Output

Text

 

Successful execution of the database query displays the output returned on query execution. The result is formatted as follows:

One line per record of the result set
Semicolon-separated columns

“No data” displayed indicates no data is found. Possible causes are stated.

Alarm or Warning

Alarm

No default thresholds or alerts set

Thresholds can be set and modified on all parameters.