Detailed Licensing Report

[derek_rose]

All of the machines I need information from seem to be in Lansweeper. I need to look at these machines, get the OS Type (i.e. Windows Server 2003 Enterprise x64), and/or the version of SQL Server (i.e. SQL Server 2000 or 2005), and the correct product key to go with it.

As you can see here - I get the listing of OS broken down :



However, on a machine-by-machine basis, I only get the bland Microsoft Windows 2000 in the section I get the product key. As you can imagine, when doing my reports, this won't be accurate enough.




Lastly - I was wondering if you had confirmation on key location for SQL 2005 (9.0)

I think it is HKLM\SOFTWARE\MICROSOFT\MICROSOFT SQL SERVER\90\PRODUCTID

It doesn't appear to be picking it up yet, although maybe I need to wait longer.

[derek_rose]

I did that as well - it's OK for now as I had to use a few other methods to get around it. I'm using Product Key Explorer in conjuction with Lansweeper to build my initial report.

I may want to re-visit this in a few weeks, as I need to maintain it going forward and being able to do it with Lansweeper would be nice.

For instance, my master report at the end should show ALL MS Products that require a license that are in our environment, or maybe all MS to be easy, then I can filter. Also would show All Adobe software, and then be able to add it in the end.

I assume this is reliant on me having the correct registry entries to look for with regards to their keys. The keys I tried for SQL server still aren't working either.

[Hemoco]

Could you try to leave out : "OR (dbo.tblSerialnumber.Product IS NULL)"

[derek_rose]

I tried your report - it ran but it displayed no data.

[derek_rose]

On the 32 bit instance of SQL the key is DigitalProductID77654 and the 64 bit seems to be 77671 - this threw me off a little though because in most cases, like for SQL Server 8.0, you only have to go to the Registration key and it reads within.

I just put a bunch of these new test values in, will see what happens with that.

With regards to the OS licensing - I want to be able to run reports and get keys for all instances of Windows 2003 Server Enterprise x64, x86, and the same for all flavors of Server and Windows. I have to test this out a little more, but at quick glance it appears that it only shows Microsoft Windows Server 2003 instead of the full name with the correct key.

[Hemoco]

derek.rose wrote:

With regards to the OS licensing - I want to be able to run reports and get keys for all instances of Windows 2003 Server Enterprise x64, x86, and the same for all flavors of Server and Windows. I have to test this out a little more, but at quick glance it appears that it only shows Microsoft Windows Server 2003 instead of the full name with the correct key.

You need a custom report for this.

this is an example report

SELECT TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblSerialnumber.Product, dbo.tblSerialnumber.ProductID,
dbo.tblSerialnumber.ProductKey
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblSerialnumber ON dbo.tblComputers.Computername = dbo.tblSerialnumber.Computername
WHERE (dbo.tblSerialnumber.Product LIKE 'Microsoft Windows%') OR
(dbo.tblSerialnumber.Product IS NULL)
ORDER BY dbo.tblComputers.Computername, dbo.tblComputers.Domain

[Hemoco]

Could you please explain the first question some more.

For the key location I noticed on a test PC that the registry value was named "DigitalProductID77558"
Instead of "DigitalProductID"
Could you confirm this?