Computer Product Key Report

[iain707]

Hi,

Please could you assist with a custom report to generate a list of all computers and their product keys. The report needs to contain the following info:

Computer System model:
Manufacturer
Model
Service tag
Chassis

User Info:
User name
Department

Keys:
Product
Product Key

This is a great product! Thanks

[Hemoco]

Microsoft MAK keys simply cannot be recovered. The reason for this is that these keys are not stored on the computer.

[Srikanth08]

hi,

what to do for office 2010 and all..because they are coming as unrecoverable MAK key..

[Hemoco]

try this

Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, Web40OSName.Compimage As icon,
dbo.tblComputers.Domain, dbo.tblComputers.Username,
dbo.tblComputers.Userdomain, tblComputerSystemProduct.Name As Model,
tblComputerSystemProduct.Vendor As Manufacturer,
tblComputerSystemProduct.IdentifyingNumber As Serial,
TsysChassisTypes.ChassisName, tblADusers.Displayname, tblSerialnumber.Product,
tblSerialnumber.ProductID, tblSerialnumber.ProductKey
From dbo.tblComputers Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Inner Join
tblComputerSystemProduct On dbo.tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblSystemEnclosure On dbo.tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Left Join
tblADusers On tblADusers.Username = dbo.tblComputers.Username And
tblADusers.Userdomain = dbo.tblComputers.Userdomain Inner Join
tblSerialnumber On dbo.tblComputers.Computername =
tblSerialnumber.Computername
Order By dbo.tblComputers.ComputerUnique