DB Query Sensor

The query must return numeric data.

To add a SQL Sensor

1. Go to Sensor Analyzer > Configure Sensors button on right (wheel).

2. Select DB Query Sensors from the drop-down.

3. All the database agents will be appear in the server drop-down menu. Choose the desired agent from the list.

4. The JDBC URL which we configured in the overview screen for that agent will be loaded in the DB URL drop-down.

For Oracle

a. Select the URL and enter the SQL query that you want to use for the sensor.

For MySQL

a. Select the URL and enter the SQL which we are going to add it as a sensor.

The database name must be appended with the table name.

e.g.

Database Name: testdb

Table Name: login

Syntax: select count(*) from databasename.tablename

select count(*) from testdb.login

For MSSQL

a. Select the URL and enter the SQL which we are going to add it as a sensor.

The database name must be appended with the table name with dbo. in the middle.

e.g.

Database Name: testdb

Table Name: login

Syntax: select count(*) from databasename.dbo.tablename

select count(*) from testdb.dbo.login

To add the SQL as a custom sensor the SQL result should return a numeric value.

6. Save Sensor configuration.
a. Enter the Dashboard Name.
b. select the chart type.
c. By default the time interval is 10 minutes. we can change the interval value.

d. Enter the Sensor Name.
e. Click the Add Sensors button.

7. The added sensor will be displayed in the grid.

8. Click the back arrow to go to the Manage sensors screen.

From Applicare 8.7.0 Test SQL button and Test Result text box is removed.

9. Search the dashboard name and select the dashboard.

10. The dashboard will be displayed.

Add SQL Sensor Alert

1. Select Alert > Configure Alert button on right (wheel).

2. Select DB Query Sensor Alert on the drop-down.

3. Save Alert configuration.

a. Enter the Name in the name field.
b. We can enter the Description but it is not mandatory.
c. Select the Server from the server drop-down.
d. Select the Query from the query drop-down.
e. Select the Condition.
f. Enter the Warning/Critical and Consecutive check and interval values.
g. Click the Save button to save the alert.

4. Type the server name in the server search box and click the search icon. It will display the alerts added for that server.

5. Click the back arrow to go to the Alerts screen.

6. The triggered alerts will be appeared on this screen. Select the alert from the grid to view the details.

Critical Alert

Warning Alert

Critical Alert Cleared

Warning Alert Cleared

7. If the Email/SMTP Server is configured and the Alert ON option is enabled in the Applicare Advanced Options screen then the alerts will be sent to the configured mails.

Email/Smtp configuration
https://helpdesk.arcturustech.com/hc/en-us/community/posts/360050531732-Email-Smtp-configuration-in-applicare