Micrsoft Office license keys

[Sundata_Helpdes]

Hello Guys

I need to extract Machine name, Microsoft Office and Windows keys from the database. Can somebody help me.

I have latest lansweeper version installed

[Sundata_Helpdes]

Thanks guys, it worked at last. cheers

[Hemoco · Accepted solution]

Sample report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblSerialnumber.Product,
tblSerialnumber.ProductID,
tblSerialnumber.ProductKey,
tsysOS.Image As icon
From tblAssets
Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where (tblSerialnumber.Product Like '%windows%' Or
tblSerialnumber.Product Like '%microsoft%office%') And
tblAssetCustom.State = 1
Order By tblAssets.AssetUnique,
tblSerialnumber.Product

To use the specified report, do the following:
• Browse to the Dashboard\Reports\Report Builder section of the web console.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it.
• The report will now also be listed under Dashboard\Reports\All Reports.