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. |
Please note it may take a few moments for the agent to check in after installation. |
When the New window appears,Click integration to select SQL Agent , fill in the dataset Name and Description fields.
The most common SQL statement to use here is “select * from TABLENAME”.