→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
NoZart
Engaged Sweeper II
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

1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
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.)

View solution in original post

1 REPLY 1
RCorbeil
Honored Sweeper II
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.)