Microsoft product key Report

[neosys]

As a new lansweeper user I wish to take advantage of the premium version and get my first report out.
I got the 'Apple Inc' sample report from the doc but can't figure out how to run this one...
The goal is to see the product key in use and find duplicate ones.

Any help would be appreciated.

[chubbard]

Is there a way to list these product keys by product?

[Hemoco]

chubbard wrote:
Is there a way to list these product keys by product?

Everything is possible.
If you need a specific report please ask it in the reports section of the forum.

[neosys]

Will you include a documentation on how to use it ?

I would like to see a couple examples of "how to" create and run reports.
Specific to Network and System admin needs.


I tried to add the reg key to - Microsoft Visual Studio 2008 Eng Standard
but can't get the key out. Am I using the right reg key ?


SOFTWARE\Microsoft\VisualStudio\9.0

[neosys]

Thanks I added a few lines to get more informations.

How is it possible to remove query once added ?

[Hemoco]

neosys wrote:
How is it possible to remove query once added ?

Wait for an update of the report builder which will be released next week.

[Hemoco]

This is a count of all license keys and the total found

SELECT     TOP 100 PERCENT ProductKey, COUNT(SerialID) AS Used
FROM         dbo.tblSerialnumber
GROUP BY ProductKey
ORDER BY COUNT(SerialID) DESC