Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
I'm hoping to get some help with generating a report whereby I can pull all of my Microsoft licenses and the product's they belong to. Can someone assist me with this?

many thanks!

Engaged Sweeper

Worked like a charm!
Thank you for the expert and timely response!!

Lansweeper Alumni
Could you try the report below, which may be incomplete. There is no separate "vendor" field for product key scanning, so we are relying on the product names for this report.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblSerialnumber.Product, tblSerialnumber.ProductID,
tblSerialnumber.ProductKey, tblSerialnumber.Lastchanged
From tblComputers Inner Join
tblSerialnumber On tblComputers.Computername = tblSerialnumber.Computername
Where (tblSerialnumber.Product Like '%microsoft%') Or
(tblSerialnumber.Product Like '%windows%') Or
(tblSerialnumber.Product Like '%internet explorer%') Or
(tblSerialnumber.Product Like '%sql server%')
Order By tblComputers.ComputerUnique, tblSerialnumber.Product

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.