Creating Custom SQL Sensors for Database agents

The query should return the numeric data.

Add SQL Sensor

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

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

3. All the database agents will be loaded in the server drop-down. Select the agent.

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 which we are going to add it as a 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.

For Example:

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.

For Example:

Database Name: testdb

Table Name: login

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

select count(*) from testdb.dbo.login

Note:

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.

Note:

From Applicare 8.7.0 Test SQL button and Test Result text box is removed. Because for auto add agents controller will not send request to agent.

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. Enter 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 displayed 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 configuration is configured and 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