FAQ - What are the options for synchronizing Mac, Linux and Windows OS and OS version from Lansweeper Cloud

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.

  1. Operating System Source Preference is provided for defining the preference of the os and os_version values:

    1. Operating System Caption (only) - reads the operating system and version values from the operatingSystem object only.

    2. OS Metadata (only)- reads the operating system and version values from the osMetadata object only.

    3. 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.

    4. 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.

  2. Mac OS Format - composes the os value based on the selected option:

    1. Raw - reads the operating system value from the operatingSystem.caption or osMetadata.fullName.

    2. OS & Version - combines the operatingSystem.name and operatingSystem.version or osMetadata.name and osMetadata.version.

    3. 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.

  3. 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

  4. Windows OS Format - composes the os value based on the selected option:

    1. Raw - reads the operating system value from the operatingSystem.caption or osMetadata.fullName.

    2. OS & Version - combines the operatingSystem.name and operatingSystem.version or osMetadata.name and osMetadata.version

    3. 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.

  5. 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:

  1. Operating System Source Preference: Operating System Caption or OS Metadata

  2. Mac OS Format: Raw

  3. Convert Mac OS Version to Friendly Format: off

  4. Windows OS Format: Raw

  5. 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:

  1. Operating System Source Preference: OS Metadata or Operating System Caption

  2. Mac OS Format: Raw

  3. Convert Mac OS Version to Friendly Format: off

  4. Windows OS Format: Raw

  5. 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:

  1. Operating System Source Preference: Operating System Caption (only)

  2. Mac OS Format: Raw

  3. Convert Mac OS Version to Friendly Format: off

  4. Windows OS Format: Raw

  5. 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:

  1. Operating System Source Preference: OS Metadata (only)

  2. Mac OS Format: Raw

  3. Convert Mac OS Version to Friendly Format: off

  4. Windows OS Format: Raw

  5. 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

  1. Lansweeper Cloud connector settings:

    1. Operating System Source Preference: Operating System Caption or OS Metadata

    2. Mac OS Format: OS & Version

    3. Convert Mac OS Version to Friendly Format: on

    4. Windows OS Format: OS & Version

    5. 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:

  1. Operating System Source Preference: Operating System Caption or OS Metadata

  2. Mac OS Format: OS & Friendly Version

  3. Convert Mac OS Version to Friendly Format: on

  4. Windows OS Format: OS & YYH1/2 Version

  5. 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:

  1. Operating System Source Preference: OS Metadata or Operating System Caption

  2. Mac OS Format: OS & Friendly Version

  3. Convert Mac OS Version to Friendly Format: on

  4. Windows OS Format: OS & YYH1/2 Version

  5. 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