Lansweeper

Lansweeper is an IT asset management and Network Inventory software tool for Windows, Linux, Mac, and Network devices.

Adapter Parameters

1. MSSQL Server (required) - The DNS / IP Address of the Microsoft SQL Server your Lansweeper instance is using.
   • To use a specific named instance, the value supplied should be in the following format: {server_host}\{instance_name}.
   • If no instance is supplied, the default instance will be used.
2. Port (optional, default: 1433) - The port used for the connection.
3. Database (required) - The name of the database inside the SQL Server (Usually starts with "CM_").
4. User Name (required) - A user name with read-only permissions.
   Important Notes:
   • The best practice is to create a dedicated SQL local user for Axonius usage. For details, see Creating a Local Read-Only User for Microsoft SQL Server.
   • If you are using a domain user, specify the domain and the user name in the following format: domain\username.
5. Password (required) - The user's password. The password must not include ";".

Advanced Settings

1. SQL pagination (required, default: 1000) - Set the number of results per page received for a given SQL query, to gain better control on the performance of all connections of for this adapter.
2. Do not fetch devices with no MAC address - Select whether to not fetch devices that don't have a MAC address.
3. Display only fetched Windows assets - Select to only fetch devices having a Windows asset type.

Required Ports

Axonius must be able to communicate with the MSSQL Server via the following ports:

• Microsoft SQL Server discovery port - 1433.
• The specific port for the supplied named instance, if relevant.

Troubleshooting

• "Login failed" - If you are using a domain user, in the User Name field, specify the domain and the user name in the following format: domain\username.