Question
What are the options for synchronizing Mac, Linux and Windows OS and OS version from Lansweeper Cloud?
Answer
Below you can see the various choicelist options for each setting and an explanation for each one.
-
Operating System Source Preference is provided for defining the preference of the os and os_version values:
-
Operating System Caption (only) - reads the operating system and version values from the operatingSystem object only.
-
OS Metadata (only)- reads the operating system and version values from the osMetadata object only.
-
Operating System Caption or OS Metadata - reads the values from the operatingSystem object if values are present, otherwise reads the values from the osMetadata obect.
-
OS Metadata or Operating System Caption - reads the values from the osMetadata object if values are present, otherwise reads the values from the operatingSystem object.
-
-
Mac OS Format - composes the os value based on the selected option:
-
Raw - reads the operating system value from the operatingSystem.caption or osMetadata.fullName.
-
OS & Version - combines the operatingSystem.name and operatingSystem.version or osMetadata.name and osMetadata.version.
-
OS & Friendly Version - combines the operatingSystem.name and looks up the Mac OS friendly version name (e.g. “Tahoe”) using the Darwin version from the operatingSystem.fullName or osMetadata.name and extracts the Mac OS friendly version from the osMetadata.fullName.
-
-
Convert Mac OS Version to Friendly Format - if enabled, converts the Mac OS version to friendly format. e.g. 15.7.7 is converted to Sequoia
-
Windows OS Format - composes the os value based on the selected option:
-
Raw - reads the operating system value from the operatingSystem.caption or osMetadata.fullName.
-
OS & Version - combines the operatingSystem.name and operatingSystem.version or osMetadata.name and osMetadata.version
-
OS & YYH1/2 Version- combines the operatingSystem.name and looks up the Windows YYH1/w formatted version using the Release version from the operatingSystem.version or osMetadata.name and extracts the Windows OS friendly version from the osMetadata.build.
-
-
Convert Windows OS Version to YYH1/2 format - If enabled, the OS version will be converted to the Windows YYH1/2 format
Examples
Below you can see some sample source data in Lansweeper Cloud for 6 different Apple Mac, Linux and Windows records.
Then follow 7 examples of the transformed data after making different selections in the Lansweeper Cloud source connector.
Given the following Lansweeper Cloud record values in the table below:
|
Record |
Recordset |
operatingSystem.caption |
operatingSystem.name |
operatingSystem.version |
osMetadata.fullName |
osMetadata.name |
osMetadata.version |
osMetadata.build |
|---|---|---|---|---|---|---|---|---|
|
1 |
Apple Mac |
|
|
|
macOS |
macOS |
|
|
|
2 |
Linux |
Amazon Linux 2023.10.20260202 |
Amazon Linux 2023.10.20260202 |
6.1.161-183.298.amzn2023.x86_64 |
|
Amazon Linux |
2023.10.20260202 |
|
|
3 |
Linux |
Ubuntu 20.04.3 LTS |
Ubuntu 20.04.3 LTS |
5.4.0-122-generic |
Ubuntu 20.04.3 LTS |
Linux Ubuntu |
20.04.3 LTS |
|
|
4 |
Windows |
Microsoft Windows Server 2019 Datacenter Evaluation |
Microsoft Windows Server 2019 Datacenter Evaluation |
10.0.17763 |
Windows Server 2019 Datacenter Evaluation (1809) |
Windows |
Server 2019 Datacenter Evaluation |
17763.3650 |
|
5 |
Windows |
Microsoft Windows 10 Pro |
Microsoft Windows 10 Pro |
10.0.19045 |
Windows 10 Pro Version 22H2 |
Windows |
10 Pro |
19045.4780 |
|
6 |
Windows |
|
|
|
Windows |
Windows |
|
|
Given the sample source data in the table above the 7 examples below show the output expected depending on which settings are selected.
NB: If the operating system value in Lansweeper is null, the asset type (“Apple Mac”, “Linux”, “Unix”, “Windows”) will be set as the “os” field value in ServiceNow.
Example 1
Lansweeper Cloud connector settings:
-
Operating System Source Preference: Operating System Caption or OS Metadata
-
Mac OS Format: Raw
-
Convert Mac OS Version to Friendly Format: off
-
Windows OS Format: Raw
-
Convert Windows OS Version to YYH1/2 format: off
|
Record |
Recordset |
os |
os_version |
|---|---|---|---|
|
1 |
Apple Mac |
macOS |
|
|
2 |
Linux |
Amazon Linux 2023.10.20260202 |
6.1.161-183.298.amzn2023.x86_64 |
|
3 |
Linux |
Ubuntu 20.04.3 LTS |
5.4.0-122-generic |
|
4 |
Windows |
Microsoft Windows Server 2019 Datacenter Evaluation |
10.0.17763 |
|
5 |
Windows |
Microsoft Windows 10 Pro |
10.0.19045 |
|
6 |
Windows |
Windows |
|
Example 2
Lansweeper Cloud connector settings:
-
Operating System Source Preference: OS Metadata or Operating System Caption
-
Mac OS Format: Raw
-
Convert Mac OS Version to Friendly Format: off
-
Windows OS Format: Raw
-
Convert Windows OS Version to YYH1/2 format: off
|
Record |
Recordset |
os |
os_version |
|---|---|---|---|
|
1 |
Apple Mac |
macOS |
|
|
2 |
Linux |
Amazon Linux |
2023.10.20260202 |
|
3 |
Linux |
Linux Ubuntu |
20.04.3 LTS |
|
4 |
Windows |
Windows Server 2019 Datacenter Evaluation (1809) |
Server 2019 Datacenter Evaluation |
|
5 |
Windows |
Windows 10 Pro Version 22H2 |
10 Pro |
|
6 |
Windows |
Windows |
|
Example 3
Lansweeper Cloud connector settings:
-
Operating System Source Preference: Operating System Caption (only)
-
Mac OS Format: Raw
-
Convert Mac OS Version to Friendly Format: off
-
Windows OS Format: Raw
-
Convert Windows OS Version to YYH1/2 format: off
|
Record |
Recordset |
os |
os_version |
|---|---|---|---|
|
1 |
Apple Mac |
Apple Mac |
|
|
2 |
Linux |
Amazon Linux 2023.10.20260202 |
6.1.161-183.298.amzn2023.x86_64 |
|
3 |
Linux |
Ubuntu 20.04.3 LTS |
5.4.0-122-generic |
|
4 |
Windows |
Microsoft Windows Server 2019 Datacenter Evaluation |
10.0.17763 |
|
5 |
Windows |
Microsoft Windows 10 Pro |
10.0.19045 |
|
6 |
Windows |
Windows |
|
Example 4
Lansweeper Cloud connector settings:
-
Operating System Source Preference: OS Metadata (only)
-
Mac OS Format: Raw
-
Convert Mac OS Version to Friendly Format: off
-
Windows OS Format: Raw
-
Convert Windows OS Version to YYH1/2 format: off
|
Record |
Recordset |
os |
os_version |
|---|---|---|---|
|
1 |
Apple Mac |
macOS |
|
|
2 |
Linux |
Amazon Linux |
2023.10.20260202 |
|
3 |
Linux |
Linux Ubuntu |
20.04.3 LTS |
|
4 |
Windows |
Windows Server 2019 Datacenter Evaluation (1809) |
Server 2019 Datacenter Evaluation |
|
5 |
Windows |
Windows 10 Pro Version 22H2 |
10 Pro |
|
6 |
Windows |
Windows |
|
Example 5
-
Lansweeper Cloud connector settings:
-
Operating System Source Preference: Operating System Caption or OS Metadata
-
Mac OS Format: OS & Version
-
Convert Mac OS Version to Friendly Format: on
-
Windows OS Format: OS & Version
-
Convert Windows OS Version to YYH1/2 format: on
-
|
Record |
Recordset |
os |
os_version |
|---|---|---|---|
|
1 |
Apple Mac |
macOS |
|
|
2 |
Linux |
Amazon Linux 2023.10.20260202 |
6.1.161-183.298.amzn2023.x86_64 |
|
3 |
Linux |
Ubuntu 20.04.3 LTS |
5.4.0-122-generic |
|
4 |
Windows |
Microsoft Windows Server 2019 Datacenter Evaluation 10.0.17763 |
1809 |
|
5 |
Windows |
Microsoft Windows 10 Pro 10.0.19045 |
22H2 |
|
6 |
Windows |
Windows |
|
Example 6
Lansweeper Cloud connector settings:
-
Operating System Source Preference: Operating System Caption or OS Metadata
-
Mac OS Format: OS & Friendly Version
-
Convert Mac OS Version to Friendly Format: on
-
Windows OS Format: OS & YYH1/2 Version
-
Convert Windows OS Version to YYH1/2 format: on
|
Record |
Recordset |
os |
os_version |
|---|---|---|---|
|
1 |
Apple Mac |
macOS |
|
|
2 |
Linux |
Amazon Linux 2023.10.20260202 |
6.1.161-183.298.amzn2023.x86_64 |
|
3 |
Linux |
Ubuntu 20.04.3 LTS |
5.4.0-122-generic |
|
4 |
Windows |
Microsoft Windows Server 2019 Datacenter Evaluation 1809 |
1809 |
|
5 |
Windows |
Microsoft Windows 10 Pro 22H2 |
22H2 |
|
6 |
Windows |
Windows |
|
Example 7
Lansweeper Cloud connector settings as:
-
Operating System Source Preference: OS Metadata or Operating System Caption
-
Mac OS Format: OS & Friendly Version
-
Convert Mac OS Version to Friendly Format: on
-
Windows OS Format: OS & YYH1/2 Version
-
Convert Windows OS Version to YYH1/2 format: on
|
Record |
Recordset |
os |
os_version |
|---|---|---|---|
|
1 |
Apple Mac |
macOS |
|
|
2 |
Linux |
Amazon Linux |
2023.10.20260202 |
|
3 |
Linux |
Linux Ubuntu |
20.04.3 LTS |
|
4 |
Windows |
Windows Server 2019 Datacenter Evaluation 1809 |
1809 |
|
5 |
Windows |
Windows 10 Pro 22H2 |
22H2 |
|
6 |
Windows |
Windows |
|