This would set the Asset Type of all Assets you import to Lansweeper Assets (if it exists). In this example, AssetTypename would be your Asset Type key field. For example, SELECT 'Lansweeper Assets' as FROM Table. Tip: If you do not wish to select an actual Asset Type field in your Lansweeper query, or you wish to import all Assets into the same Asset Type, you can hardcode a value in your query. If a value is returned that does not equal the name of an Asset Type, then the Asset will fail to import. The value that is returned from the query for this field must match the name of an Asset Type in Halo. The field you choose here should contain the name of the Asset Type of the Asset in Lansweeper. The next key field is the name of the Asset Type field.
It is important that this field holds a unique value that does not change, otherwise duplicate Assets will be created during subsequent syncs, or the incorrect Asset may be updated. This field will be used to match existing records to records that are being imported, so that you do not get duplicated Assets when the importer is run for a second time. The first option available for you to specify is the name of the Unique Asset Identifier field from your query. 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.
#Lansweeper change log how to#
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
Manage your MSP business with our all-in-one platform and transform how you deliver services to customers.
#Lansweeper change log software#
Manage your Facilities department with our all-in-one software for resource booking, maintenance, asset management and much more.Įxtend service management throughout the organisation. Reduce overheads and deliver an intuitive experience for your users.ĭeliver an exceptional service experience to students, faculty and staff.ĭeliver secure, auditable IT Service Management throughout the organisation.Ĭentralise and streamline your processes.Įmpower your IT team to deliver rapid, efficient ITIL-aligned service.Īutomate, connect and improve your HR service delivery.
0 kommentar(er)
