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,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblOperatingsystem.SerialNumber,
tblOperatingsystem.Lastchanged,
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
