Skip to main content

Kaseya VSA On-Premise Integration Setup

Updated

Connecting MSPbots with Kaseya VSA lets you manage endpoints and automate tasks more efficiently with Business Intelligence (BI) solutions and real-time notifications. This article provides a step-by-step guide to establish this integration and start utilizing MSPbots' innovative automations for better IT management.  

Prerequisites 

You must have the following to ensure a successful connection between MSPbots and Kaseya VSA:

How to establish the MSPbots integration with Kaseya VSA 

1. Complete the prerequisites.

2. Connect the MSPbots agent. 

Use this integration setup option only if you are an advanced user with knowledge of SQL databases and scripts. For more information on connecting your software to MSPbots using API or SQL agent, refer to the article Reminders for Connecting to MSPbots via API or SQL Agent.

    1. Go to Integrations on the MSPbots app menu. 

    2. Find the Kaseya VSA On-Premise app and click the Config icon. 

      Kaseya VMS On-Premise MSPbots configuration

    3. Next, click the download icon for the MSPbots SQL Agent Client to start downloading the installer file.

      Kaseya VMS on-premise MSPbots SQL agent

    4. After the download completes, follow the prompts to install the MSPbots SQL Agent Client.

    5. During the setup, select Automatic Start and Create a Desktop Shortcut, then click Next. 

      setup

    6. In the last step, select the Launch MSPbotsAgentService checkbox and click Finish. The window will automatically close when the service starts. 

      finish setup

    7. Launch the MSPbots agent and log in using your MSPbots account. You can minimize or close the window after login but do not log out.

      login agent client

       

       

3. Set up the MSPbots Agent Connector.  

    1. Go to Integrations on the MSPbots app menu. 

      integrations

    2. Search for Kaseya VSA On-Premise and click it to open the connection settings. 

      Kaseya VSA On-Premise MSPbots integration
    3.  Click the +Add Connector button. 
      add Kaseya VSA On-Prem connector

      The last success auth shows the last time when the MSPbots Agent successfully pulled the database configuration information. This process is set to occur every 5 minutes by default.

       
    4. Fill in the following required fields.
      • Database Type - Select either SQL Server or MySQL.
      • Agent - This field is populated automatically with the name of the installed machine.
      • IP - Provide the internal IP address or FQDN of the SQL or MySQL server.
      • Database Name
      • Time Zone - Select the time zone used by the connected database.
      • User ID - This is the username of the user with read-only access to the database.
      • Password - This is the user's password with read-only access to the database.
        Kaseya VSA On-Premise SQL agent settings

        It may take a few moments for the agent to check in after installation. 

        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.

    5. Click Save and Sync.

4. Create a dataset and validate the data. 

    1. Go to Datasets on the MSPbots app menu and click the New Agent Dataset button. 

      new agent dataset

    2. When the New window appears, click Integration and select Kaseya VSA On-Premise. Don't forget to fill in the dataset Name and Description fields.

      Kaseya VSA On-Premise new dataset
    3. Next, go to the Data Cleaning tab to show the Validate SQL section below.
    4. Select a database from the DB dropdown list.

      data cleaning DB

    5. Scroll down to the Validate SQL section and fill in the SQL field. The most common SQL statement here is “select * from TABLENAME”. 
    6. Input your desired Sync Frequency in minutes.

      Sync Frequency is currently limited to 30 minutes and can only be decreased for smaller datasets. For larger datasets, the frequency may be limited due to a large amount of data ingestion and the constraints it would place on both your server and ours. 


      data cleaning sql
    7. Click Confirm when done. This will show a preview of the data for your validation. You can customize or use the default character length for string-type fields, and the time field can be set with a timezone.
      validate sql
    8. Confirm if the data is correct, then click OK to create and save the dataset. The data will be synchronized in 10 minutes.

5. Save the logs and send the file to the MSPbots Support Team. 

    1. Open the MSPbots Agent client and click the Save Log button on the upper right corner of the window. 

      save log
    2. Click Confirm in the Tips pop-up window.  

      tips 
    3. Next, select the location to save the logs, provide a filename, and click Save.
    4. Send the file to support@mspbots.ai.

 

Related articles