License Tracking and License Keys

[AnthelioHealth]

What is the point of entering license keys in the License Tracking module if LANSweeper is unable to provide a count of the devices using that key in the License Report? I have been told (and read) in previous posts that LANSweeper only looks at the software title and gives a total count. If successful scans capture the product/license key and that key is entered manually into the License tracking module, why can't LANSweeper perform a "comparison" and give a total count on devices where that key matches? Being able to perform this type of calculation would help tremendously; especially for those companies utilizing LANSweeper who need to track software for clients (which I have also been told is impossible with LANSweeper).

An example for clarification purposes:

2 installs of a Windows OS:
1) License for Windows 2008 R2 - Key #1 (1234567890) - MS Agreement #1
2) License for Windows 2008 R2 - Key #2 (0987654321) - MS Agreement #2

Both devices scanned successfully.

Create new OS license entry in License tracking module (include Agreement info, purchase info and Key #1) in appropriate fields and run report; report shows two installs and company is out of compliance by a count of one. This happens because LANSweeper only looks at the OS or software title, no comparison to the key is made (although it was captured by the successful scan).

Create second OS license entry (because it is a different MS Agreement and Key) include appropriate information (as shown above) and run report.

I now have 2 license entries (expected because I created them), both show 2 installs (incorrect); again because LANSweeper doesn't pay attention to the key (one scanned from the device and the second manually entered in the License module.

Don't get me wrong, I like LANSweeper, its a great tool. But I think this lack of functionality is really hampering the product. At this point I have to start looking to another tool to accomplish the license tracking. I'm not asking for LANsweeper to give me details about my license (usage right etc.), just give me a count of the devices using the License Report from the License tracking module.

ad

[AnthelioHealth]

That seems to work nicely. Thanks.

[Hemoco]

Eg for Office keys, in case you use sublicenses:

Select Top 1000000 Cast(tblSerialnumber.Product As nvarchar(50)) As Software,
Cast(tblSerialnumber.ProductKey As nvarchar(50)) As LicenseKey,
Count(tblSerialnumber.AssetID) As LicNr,
'Scanned' As LicType
From tblSerialnumber
Where tblSerialnumber.Product Like '%Microsoft office%'
Group By tblSerialnumber.ProductKey,
tblSerialnumber.Product
Union
Select Top 1000000 Cast(tblLicenses.softwareName As nvarchar(50)) As Software,
Cast(tblSublicensesOrders.Licensekey As nvarchar(50)) As Licensekey,
tblSublicensesOrders.Nrlicenses As LicNr,
'Manual input' As LicType
From tblLicenses
Inner Join tblSublicensesOrders On tblLicenses.LicenseidID =
tblSublicensesOrders.LicenseidID
Where tblLicenses.softwareName Like '%Microsoft Office%'

[Hemoco]

Hi, the license tracking module is designed to enter the number of licenses bought (without connecting them to any computer) and to compare this to the number of installations (disregarding the fact if they have a license key or not).

The license keys that are scanned in the registry are not added in the license tracking module automatically.

It is possible to enter the license keys in the License Tracking Module and list the number of computers that are using this license key (if this was scanned in the registry).
If you like we can make a custom report for this, but this is an other way of looking at it than the License Tracking module. We can even add the scanned ones to the manually entered ones and then list the computers where they were used.

[AnthelioHealth]

Lansweeper wrote:
The license keys that are scanned in the registry are not added in the license tracking module automatically.

Yes, I understand that

Lansweeper wrote:
It is possible to enter the license keys in the License Tracking Module and list the number of computers that are using this license key (if this was scanned in the registry).

How is this done? As a test I've entered 3 different license keys and I still only get one entry with an aggregate total. I expected to see four entries (one for each of the keys I entered (indicating the number of devices where the license key matched) and a fourth with all the other machines with license keys I didn't enter.

Lansweeper wrote:
If you like we can make a custom report for this, but this is an other way of looking at it than the License Tracking module. We can even add the scanned ones to the manually entered ones and then list the computers where they were used.

Please provide the query that can be entered into the Report Builder for this report.

Thanks.