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 クエリ

The API connection caters for two data sets (hardware and software); whilst the SQL query focuses on hardware alone.

This task requires Data Manager & Adapters admin permissions to complete. See how permissions and roles work in Data Manager.

Please note that this data source is cloud enabled where Source type - API, therefore the fetch can be run from within the Data Manager UI fetching data without the need of the Data Manager Adapters client.

前提条件:

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 wish to connect and configure with all the gathered information.

Each time this data source is fetched the data becomes raw data.

データマネージャーフィールド

You need to specify the following information from Data Manager:

Mode of connection - Set whether you want to consume data using a cloud to cloud fetch or using the Data Manager adapters client.
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 フィールド

Source type – select API or SQL.
Dataset - For API you can have either Hardware or Software and for SQL → Hardware. Note: That once your configuration is saved, the dataset can not be changed.

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
- [許可] をクリックする
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 呼び出し

ハードウェア

getAssetResources

Fields retrieved – API

以下のフィールドは API レスポンスを使用して取得されます。

assetBasicInfo.key
assetBasicInfo.name
assetCustom.serialNumber
assetBasicInfo.domain
assetBasicInfo.ipAddress
assetBasicInfo.fqdn
assetCustom.manufacturer
assetCustom.model
assetBasicInfo.mac
assetCustom.warrantyDate
assetBasicInfo.type
assetBasicInfo.subType
assetBasicInfo.scannerType
assetCustom.deviceVersion
assetBasicInfo.lastChanged
assetBasicInfo.lastSeen
assetBasicInfo.upTime
assetCustom.stateName
assetCustom.location
assetBasicInfo.userDomain
assetBasicInfo.userName
assetBasicInfo.cloudProvider
assetBasicInfo.cloudResourceId
assetBasicInfo.cloudEnvId
assetBasicInfo.cloudEnvName
assetBasicInfo.cloudTags
assetBasicInfo.url
operatingSystem.version
operatingSystem.caption
operatingSystem.buildNumber

Software:

softwareListWithCursor

Fields retrieved – API

以下のフィールドは API レスポンスを使用して取得されます。

software
publisher
type
category
unspsc
languages
editions
architectures
versions
installType
installDate
relatedSoftwareNames
operatingSystems
assets

Fields retrieved – SQL

以下のフィールドは、以下の SQL クエリを使用して取得されます。

SQL クエリ:

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 On tblassets.AssetID = tblOperatingsystem.AssetID

Atlassian vendor mappings

When you connect a Lansweeper data source, Data Manager applies the following Atlassian vendor mappings. These source attributes are mapped to a destination attribute automatically; you can review or override any of them on the Attribute Mapping screen.

Source attribute	移動先属性	タイプ	主キー
部署	部署	文字列	いいえ
ドメイン	ドメイン名	文字列	いいえ
IP アドレス	IP アドレス	文字列	いいえ
LastSeen	前回スキャン日	日時	いいえ
場所	場所	文字列	いいえ
製造元	製造元	文字列	いいえ
モデル	ModelName	文字列	いいえ
名前	名前	文字列	はい
OsCaption	オペレーティングシステム	文字列	いいえ
Serial Number	Serial Number	文字列	いいえ
タイプ	デバイスタイプ	文字列	いいえ
WarrantyDate	WarrantyEndDate	日時	いいえ

この内容はお役に立ちましたか?

正確ではなかった明確ではなかった関係なかった

さらにヘルプが必要ですか?

アトラシアンコミュニティをご利用ください。

コミュニティに質問