All installed Software + license keys

[NoZart]

I need to do a report containing Asset name, SoftwareName, Softwareversion, Installdate and License key per Software.

I got as far as

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.Installdate,
tblSoftware.softwareVersion,
tblSerialnumber.ProductKey
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID


The report looks fine so far, but the license keys are all over the place instead of just next to their respective software

[RCorbeil · Accepted solution]

You're trying to reach an unreachable destination. The best you can do is run two reports: one of software, one of license keys.

Software is uniquely associated with a particular asset.

License keys are associated with a particular asset.

There is no way to uniquely link records in the license table to records in the software table, however. Browse the contents of the license key table and see for yourself.

Unfortunately, there is no standard method of license key storage, so LANSweeper has to work through a list of known registry locations to retrieve what it can. What is stored in the registry is in no standardised format, so the best that LANSweeper can do is pull what it finds and record it as associated with the asset where it was found. (In LANSweeper, go to Configuration > Product Keys to find the list of locations searched for keys.)