Report With System Product Field

[mlgreiner13]

Hello all:

We use predominantly Lenovo products and Lansweeper is highly effective in identifying these assets. One field that I would like to include my reporting is located under the SystemProduct, Version table entry, however when I try to add this to a report, I am not able to locate a field to add in? Example: Under SystemProduct, UUID: 5D978CD4-E382-11E2-A05-B 4EE32FB0Exxx Version: ThinkCentre M92p. It is this version info I really need.

Thanks _ Mark

[Daniel_B · Accepted solution]

This data is stored in tblComputerSystemProduct. Please find an example report below. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
- Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.Lastseen,
  tblComputerSystemProduct.UUID,
  tblComputerSystemProduct.Version
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblComputerSystemProduct On tblAssets.AssetID =
    tblComputerSystemProduct.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName