Non OEM Windows License

List Non OEM Windows Licenses

Receive an overview of all Windows operating systems installations which are not using an OEM license. When scanning Windows systems, Lansweeper automatically scans the serial number which is used to determine whether the machine is using an OEM license key or not. This way you can find out which devices utilize manufacturer support and also which license key can potentially be re-used on other machines.

Non OEM Windows License Query

Select Top 1000000 tblAssets.AssetID,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblOperatingsystem On
    tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblOperatingsystem.SerialNumber Not Like '%-OEM-%' And
  tblOperatingsystem.SerialNumber Not Like '%OEM' And tblAssetCustom.State = 1
Order By tblAssets.AssetName

Run This Report in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting