→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cerede2000
Engaged Sweeper
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 🙂
1 ACCEPTED SOLUTION
SyncMasta
Engaged Sweeper III
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.
Greeting, Syncmasta

View solution in original post

2 REPLIES 2
cerede2000
Engaged Sweeper
Great! This is exactly what I wanted 🙂
SyncMasta
Engaged Sweeper III
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.
Greeting, Syncmasta