Back to the list of classes

Studio Database Query

PATROL Class: X_DBQUERY - Monitor Type: MONITOR - Monitor Category: Application
No CDM Class defined.

This Monitor queries a database with an SQL statement through supported JDBC drivers.

The result of the SQL query can be parsed with String Searches, Numeric Value Extractions, Value Maps, Text Pre-Processing or Dynamic Object Builders.

Attributes (Parameters)

Name PATROL Name Units Default Thresholds Description
Execution Time ExecutionTime seconds

 WARN
if ∈ [15 seconds, 60 seconds]

 ALARM
if ≥ 60 seconds

Time taken by the database query to run.

Value set by dbQueryColl.

Type:  KPI - Response Time - Spikes expected - Default graph

Result Result None None

Output of the database query execution.

Value set by dbQueryColl.

Type: Text

Status Status 0 = OK
1 = Suspicious
2 = Failed

 WARN
if = 1 (Suspicious)

 ALARM
if = 2 (Failed)

Indicates whether or not the query was successfully executed.

Value set by dbQueryColl.

Type: Availability

Infoboxes (PATROL Console Only)

Name Description
ID PATROL internal identifier of the Database Query instance.
Parent ID PATROL internal identifier of the parent Database Query instance.
Database Type Displays the database type.
Database Name Displays the database name.
Connect as Login used to connect to the database server.
SQL Query Displays the SQL query that will be executed.
Menu Command Description
Refresh Parameters Refreshes all instance parameters of the X_DBQUERY application class.