Select Top (1000000) tblAssets.AssetID,
tblAssets.AssetName, tblAssets.Domain,
tsysOS.OSname As [OS Version],
tblAssets.IPAddress,
tblSqlServers.displayVersion As [MS-SQL Version],
tblSqlServers.skuName As [MS-SQL Edition],
tblSqlServers.spLevel As SP,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.Image As icon
From tblAssets
Inner Join tblSqlServers On tblSqlServers.AssetID = tblAssets.AssetID
Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSqlServers.skuName Not Like 'Express%' And
tblSqlServers.skuName Not Like '%Internal%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblAssets.Domain
