→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Malbanese
Engaged Sweeper III
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?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

4 REPLIES 4
Daniel_B
Lansweeper Alumni
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
Engaged Sweeper II
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
Engaged Sweeper III
Thank you - This was exactly what i was looking for.
Hemoco
Lansweeper Alumni
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