SEN_MS_DBQUERY

Home

Previous

Next

Icon

Parameters

Name	Description	Units	Default Alert Conditions	Type
ExecutionTime*	Time taken by the query to run. Value set by dbQueryColl every 2 minutes.	Seconds	Warning ≥ 15 Alarm ≥ 60	Response Time
Result	Displays the output of the database query execution. Value set by dbQueryColl every 2 minutes.	n/a	None	--
Status	Indicates whether or not the query was successfully executed. Value set by dbQueryColl every 2 minutes.	{0 = OK ; 1 = Suspicious ; 2 = Failed}	Warning = 1 Alarm = 2	Availability

* Parameters marked with an asterisk are used by default when visualizing the corresponding monitor instance in BMC TrueSight Operations Management.

Infobox

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 Commands

Menu Command	Description
New > String Search	Creates a new String Search instance for the Database Query instance.
New > Numeric Value Extraction	Creates a new Numeric Value Extraction for the Database Query instance.
New > Text Pre-Processing	Creates a new Text Pre-Processing instance for the Database Query instance.
New > Dynamic Object Builder	Creates a new Dynamic Object Builder for the Database Query instance.
Edit	Allows editing the settings for the Database Query instance
Thresholds	Sets or edits the thresholds.
Polling Interval	Allows setting the polling interval for the monitoring of the Database Query instance .
Alert Actions	Adds specific Alert Actions to the Database Query instance monitoring.
Properties	Displays all available information for the Database Query instance.
Cut	Cuts the Database Query instance.
Copy	Copies the Database Query instance..
Paste	Pastes a previously copied or cut Database Query instance.
Delete	Deletes the Database Query instance and all its related Monitor instances and parameters.
Rename	Allows renaming the label (Display Name) of the Database Query instance.
Acknowledge Alerts	Deactivates and reactivates the parameters to acknowledge the alert.
Pause Monitoring	Pauses the monitoring of this Database Query instance as well as all its related Monitor instances and parameters.
Resume Monitoring	Resumes the monitoring of this Database Query instance as well as all its related Monitor instances and parameters.
Refresh Parameters	Refreshes all instance parameters of the SEN_MS_DBQUERY application class.