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
Explore the full platform, free for 14 days.
No credit card required.