Hot to get tsysOS.OSname through GraphQL

[-gytis-]

Hi guys,

Could someone point me to the right direction how to find what field must be used in GraphQL getAssetResources query to get values of the field OSname in the table tsysOS (Win 2012 R2, Win 2016, etc.).

Currently we are using the following query but none of the listed fields have these values:

query getAssetResources {
  site(id: "{{site_id}}") {
    assetResources(
      assetPagination: 
      {
        limit: 100, 
        page: FIRST, 
        cursor: ""
      }
      fields: [
        "key", 
        "url", 
        "assetCustom.stateName",
        "assetBasicInfo.name", 
        "assetBasicInfo.type", 
        "assetBasicInfo.mac", 
        "assetBasicInfo.scannerType", 
        "assetBasicInfo.userDomain", 
        "assetCustom.manufacturer", 
        "assetCustom.model", 
        "networkAdapters.macAddress", 
        "networks.ipAddressV4",
        "operatingSystem.osType"
        "operatingSystem.caption",
        "operatingSystem.name",
        "operatingSystem.codeset",
        "operatingSystem.buildNumber",
        "operatingSystem.buildRevNumber",
        "operatingSystem.hostName",
        "operatingSystem.organization",
        "operatingSystem.osProductSuite"
      ]
      filters: {
        conjunction: AND, 
        conditions: 
        [
            {
                operator: EQUAL, 
                path: "assetCustom.stateName", 
                value: "Active"
            },
            {
                operator: LIKE, 
                path: "assetCustom.manufacturer", 
                value: "VMware"
            }
        ]
      }
    )
    {
      items
      pagination {
        next
      }
    }
  }
}

[Jacob_H]

Hey GY -  I'm not official support, nor an expert in the API -   but I think you can query a report (make note of the ID)  and get results -  meaning, you can make what you need in a report, (its called windowsName in the report builder)...  and go from there perhaps:

query {
  site(id: "aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee") {
    id
    name
    reportExecutionResults(reportId: "1234567890abcdef09876543") {
      url
    }
  }
}

[EthanBills]

Hi, 

operatingSystem.name will get you the name of the OS. For example, in the attached image, Fedora 27 (Server Edition) will be returned when you query operatingSystem.name. Please make sure the assets you are querying have this field filled in your Lansweeper Site as this is where the API would be pulling from. Furthermore, please make sure that the assets you are querying do have this field filled in and that your filter is not filtering them out.

Finally, if you are having issues finding a specific field or if a specific field does not appear that it can be queried, please feel free to contact support. 

Thanks!

[-gytis-]

Hi Ethan,

Thank you for your quick response.
However your answer is not exactly matching the same observations as we can see on our system.

When we look at the column tsysOS.OSname (on-premisses Lansweeper instance) it displays shortened symbolic version of operating system: Win 2012 R2, Win 2016, etc.
But when we get data through API the field operatingSystem.name displays full name of operating system: Microsoft Windows Server 2022 Datacenter, Debian GNU/Linux 12 (bookworm) Version 12.8, etc.

[EthanBills]

Hi,

The API would be calling the information from your cloud site, so what is important is the information that is stored there and not the on-prem information. If this information is different from what you have in your on-prem version, then I would recommend opening a support ticket as you might be experiencing a syncing issue.