Microsoft Audit

[Malbanese]

My organization is being audited my Microsoft for license compliance. I know what I have in terms of my Volume Licenses but i need to compare it to what had been deployed, so i am looking to create a report that will show me the Windows Key as well as the Office Key.

Is this possible or should i leave the country?

[Daniel_B]

Certainly, the username is stored in tblAssets.Username. Please find the modified query below.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Username,
  tblAssets.Userdomain,
  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 '%office%') And tblAssetCustom.State = 1
Order By tblAssets.AssetUnique,
  tblSerialnumber.Product

BTW: If you would like to add certain details to a report, have a look at the database dictionary which is accessible at the top of the report editor. It lists all tables and columns with explanation of every detail.

[max204]

Thank you!

Is it also possible to retrieve the last user on the computers and get this into the report?
This would be of great use if you assign a license to a specific user.

[Malbanese]

Thank you - This was exactly what i was looking for.

[Hemoco · Accepted solution]

The report below lists the Windows and Office keys found in your network, but keep in mind that these keys are not necessarily in use. From a Lansweeper point of view, there is no link between software installations and software keys:
- Software isntallation scanning recreates Add/Remove Programs.
- Software key/serial scanning searches the client machine's registry for software keys. Keys are often left behind in the registry when the corresponding software package is uninstalled.

To use the report below, do the following:
•Open the report builder under Reports/Create New Report.
•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. Export options are listed on the left.

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 '%office%') And tblAssetCustom.State = 1
Order By tblAssets.AssetUnique,
tblSerialnumber.Product