These key fields have already been setup to work with the default query provided to you, and will not need adjusting unless you make changes to the query.

Next you are given the option to choose some key fields for the import. This query can be adjusted if you have additional information that you would like to retrieve from Lansweeper, however, the default query will likely retrieve all of the information that you need. You should ensure that any information you would like importing into Halo is selected in this SQL query.īy default, a SQL query has already been provided for you, and the majority of other configuration options have been already completed to work with this default query. Later in the integration setup, you have the option to match fields from the Lansweeper database to Asset fields in Halo. The Halo Integrator will attempt to import any record that is returned via the SQL query. Under the SQL Connection header in the Lansweeper module, there are five options that allow you to specify connection details for your SQL Server where the Lansweeper database is held, and also the query that should be run against the Lansweeper database for the import. This integration is an import from one SQL database into another, and the Halo Integrator will need details of how to connect to your Lansweeper database.

More details will be given regarding the Halo Integrator later in this guide.īoth Lansweeper and Halo have a SQL database. This means there is no import facility within the web application itself, and instead, a separate tool called the Halo Integrator must be downloaded. Once the module has been enabled, click the menu icon for the module to begin configuring it.Īs the Lansweeper integration is effectively an import from one SQL database to another, access to the Lansweeper database is required. To enable the Lansweeper integration in Halo, go to Configuration > Integrations, and enable the module. If your Lansweeper database is a SQL Server Compact database, you will need to convert this into a Standard SQL database before continuing. Your Lansweeper database must be in SQL Server Standard format to use this integration.

Guides > Lansweeper Integration Lansweeper Integration

Lansweeper sccm