Licence by PC

[cerede2000]

Hi,

I want a report that lists the licenses related to a machine.

But I can't find link into tblSoftware and tblLicences table 😞

Thanks 🙂

[cerede2000]

Great! This is exactly what I wanted 🙂

[SyncMasta · Accepted solution]

Hi there,

i just had a question like this one.

This is the answer, the support gave me:

Hi,

information about product keys is not directly related to information about software installations. This is due to the fact how product keys are saved in the registry. But you can filter and read data out of tblSerialnumbers in order to list scanned product keys on your computers.

Please find a custom report below which will display scanned product keys for windows and office:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
OSKeys.Product As [OS Product],
OSKeys.OSKey As [OS Key],
OfficeKeys.Product As [Office Product],
OfficeKeys.OfficeKey As [Office Key]
From tblAssets

Left Join (Select Distinct Top 1000000 tblSerialnumber.AssetID,
tblSerialnumber.Product,
tblSerialnumber.ProductKey As OSKey
From tblSerialnumber
Where tblSerialnumber.Product Like '%Windows%') OSKeys On OSKeys.AssetID =
tblAssets.AssetID

Left Join (Select Distinct Top 1000000 tblSerialnumber.AssetID,
tblSerialnumber.Product,
tblSerialnumber.ProductKey As OfficeKey
From tblSerialnumber
Inner Join tblAssets On tblAssets.AssetID = tblSerialnumber.AssetID
Where tblSerialnumber.Product Like '%Office%') OfficeKeys
On OfficeKeys.AssetID = tblAssets.AssetID

Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Where tblAssets.Assettype = -1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName

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.