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 ALARM |
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 ALARM |
Indicates whether or not the query was successfully executed. Value set by dbQueryColl. Type: Availability |
Search Results for {{siteSearch | truncate:'50'}}
{{resultArray.length}}
No results.