SW_DB_QUERIES

Name	Description	Units	Default Alert Conditions	Type
ConnectionStatus*	State of the server connection. Value set by DbQueryColl every 2 minutes	{0 = Successful ; 1 = Connection failed}	Alarm = 1	Availability
ExecutionTime*	Displays the SQL query execution time. Value set by DbQueryColl every 2 minutes	seconds	Warning ≥ 15 Alarm ≥ 60	Response Time
QueryStatus	Displays whether or not the query was successfully executed; Value set by DbQueryColl every 2 minutes	{0 = Successful ; 1 = Execution failed}	Alarm = 1	Availability
ReturnOutput	Displays the output of the Database query execution; Value set by DbQueryColl every 2 minutes	n/a	None	--

* This parameter is used by default when visualizing the corresponding monitor instance in BPPM.

Name	Description
ID	PATROL internal identifier of the Database query analysis
Parent ID	PATROL internal identifier of the parent application
Application ID	PATROL internal identifier of the Database query’s root application
Database Type	Displays the Database type
Connection Type	Displays the connection type
Hostname	Display the name of the host machine
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
New > String search	Creates a new String search for this Database Query analysis
New > Numeric Value Extraction	Creates a new Numeric Value extraction for this Database Query analysis
New > Text Pre-Processing	Creates a new Text pre-processing for this Database Query analysis
New > Dynamic Object Builder	Creates a new Dynamic Object Builder for this Database Query analysis
Edit	Edits the Database Query monitoring settings
Set Thresholds	Allows you to set or edit the thresholds
Set Polling Interval	Sets the polling interval for this Database Query analysis monitoring
Set Alert actions	Adds specific Alert Actions to the Database Query analysis monitoring
Display Object Configuration	Displays the Monitoring Studio configuration report of this Database Query object and all dependent objects
Cut	Cuts this object
Copy	Copies this object
Paste	Pastes a previously copied or cut Database Query analysis object
Delete	Deletes the Database Query analysis monitoring and all its dependent objects
Rename	Allows you to rename this Database Query analysis monitoring
Acknowledge Alerts	Acknowledges all alerts and reset parameters to zero.
Pause monitoring	Pauses the monitoring of this Database Query analysis object
Resume monitoring	Resumes the monitoring of this Database Query analysis object
Refresh Parameters	Refreshes all instance parameters of the Database Query analysis monitoring