This guide will help you do the following steps for connecting the MSPbots SQL agent:
The following is required to connect the agent:
To get the internal IP:
Giving any account full DB access is not recommended. |
Last success auth shows the last time when the MSPbots Agent successfully pulled the database configuration information. By default, this process is set to occur every 5 minutes. |
If you have installed multiple MSPbots agents with different databases in different network segments, you have to select the device name where you manually installed the MSPbots Agent. You can find the device name in the Agent selection box. Select the one under the corresponding gateway of the database. |
When the New window appears, click Integration and select SQL Agent. Don't forget to fill in dataset Name and Description fields.
The most common SQL statement to use here is “select * from TABLENAME”.