Lansweeper data source
Data Manager is included in all Service Collection Premium and Enterprise plans.
Lansweeper is an asset management tool. Data can be consumed from either an on‑prem or a cloud instance. Two connection methods are available:
API connection
SQL query
This task requires Data Manager & Adapters admin permissions to complete. See how permissions and roles work in Data Manager.
Prerequisites:
Lansweeper source enabled
Relevant firewall rules configured
Credentials provided
Correct privileges for API or SQL
How to connect Lansweeper to Data Manager
Gather all of the Data Manager type information, including the data source name, short display name, and the data source type.
Gather the Lansweeper fields – this may require consultation with the Lansweeper subject matter expert (SME).
In Data Manager, add a new data source by selecting the tool you which to connect and configure with all the gathered information.
Each time this data source is fetched the data becomes raw data.
Data Manager fields
You need to specify the following information from Data Manager:
Data source name – the name of the data source used to run, transform, map, cleanse, and import the data.
Short display name – a unique name as a data source label.
Data source type – what type of data the tool is providing. For example, Assets, CMDB, user location.
Lansweeper fields
Source type – select API or SQL.
For API:
API token – application identity code used for authentication.
For SQL:
Username – must have data privacy set to none (full access) and Finder access enabled.
Password – password for that user.
Authentication and authorization – API
In Lansweeper, open your profile and select Developer tools.
Select All applications.
Select Add new application and choose Personal application.
After creating the application, open it in EDIT APPLICATION.
Use Authorize to:
choose the token expiration time
select the site(s) to grant access
click ALLOW
An application identity code is generated; this is the API token.
Authentication and authorization – SQL
Provision the user with read‑only access to the Lansweeper database.
Ensure the Lansweeper database is reachable (firewalls, network).
API call
getAssetResources
Fields retrieved – API
The following fields are retrieved with the API response:
assetBasicInfo.name
assetCustom.serialNumber
assetBasicInfo.domain
assetBasicInfo.ipAddress
assetBasicInfo.fqdn
assetCustom.department
assetCustom.manufacturer
assetCustom.model
assetBasicInfo.mac
assetCustom.warrantyDate
assetBasicInfo.lsAgentVersion
assetBasicInfo.lsPushVersion
assetBasicInfo.type
assetCustom.dnsName
assetCustom.deviceVersion
assetBasicInfo.lastActiveScan
assetBasicInfo.lastChanged
assetBasicInfo.lastIpScan
assetBasicInfo.lastSeen
assetBasicInfo.upTime
assetCustom.lastChanged
assetCustom.lastPatched
assetBasicInfo.lastSccmScan
assetCustom.stateName
assetCustom.location
assetBasicInfo.userDomain
assetBasicInfo.userName
operatingSystem.version
operatingSystem.caption
operatingSystem.buildNumberFields retrieved – SQL
The following fields are retrieved with the below SQL query:
SQL query: tblassets.AssetID = tblOperatingsystem.AssetID
Select tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblassetcustom.Serialnumber,
tblassets.Domain,
tblassets.FQDN,
tblassetcustom.Department,
tblassetcustom.Manufacturer,
tblassetcustom.Model,
tblassets.Mac,
tblassetcustom.Warrantydate,
tblassetcustom.DNSName,
tblassetcustom.DeviceVersion,
tblassets.LastActiveScan,
tblassets.LastIPScan,
tblassets.LastChanged,
tblassets.Uptime,
tblassetcustom.Lastchanged As Lastchanged1,
tblassetcustom.LastPatched,
tblassets.LastSccmScan,
tblassetcustom.State,
tblState.Statename,
tblassetcustom.Location,
tblassets.Userdomain,
tblassets.Username,
tblassets.LsAgentVersion,
tblassets.LsPushVersion,
tblOperatingsystem.Caption,
tblOperatingsystem.Version,
tblOperatingsystem.BuildType
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join tblState On tblassetcustom.State = tblState.State
Inner Join tblOperatingsystem OWas this helpful?