cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bluskes58
Engaged Sweeper
when I run a report on Microsoft product keys, I notice that many of my machines have the same Product Key and the same Product ID. Why is this?
1 REPLY 1
Hemoco
Lansweeper Alumni
Could you contact us at support@lansweeper.com and provide us with the following:
• Screenshot of your web console landing page. You can access your landing page by clicking on the Lansweeper logo in the top left corner of the web console. Please show us the whole page.
• Output of the report below, preferably in Excel format. Please mark some of the duplicates.

Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Firstseen, tblComputers.Lastseen, tblComputers.Lasttried,
tblComputers.Lasttriggered, tblComputers.LastScheduled,
tblComputers.LastActiveScan, tblComputers.LastLsPush, tblComputers.Scanserver,
Web40OSName.OSname, Web40OSName.SP, Web40OSName.OScode, TsysLastscan.CFGcode,
TsysWaittime.CFGname, TsysLastscan.Lasttime, TsysLastscan.Scantime,
TsysWaittime.Waitdays, tblSerialnumber.Product, tblSerialnumber.ProductID,
tblSerialnumber.ProductKey, tblSerialnumber.Lastchanged
From tblComputers Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
TsysLastscan On tblComputers.Computername = TsysLastscan.Computername
Inner Join
TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode Left Join
tblSerialnumber On tblComputers.Computername = tblSerialnumber.Computername
Where TsysWaittime.CFGname = 'SERIALNUMBER'
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.