→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
southpaw86
Engaged Sweeper
Select Top 1000000 tblAssets.AssetID,
tblAssets.Username,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypename,
tblProcessor.Name As CPU,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Where tblAssetCustom.Model Like '%OptiPlex 30%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
1 REPLY 1
RCorbeil
Honored Sweeper II
It depends on exactly what you want when you say "OS version". Some possibilities:

tsysOS.OSname
e.g. "Win XP", "Win 7", "Win 10"

tblAssets.SP
Service pack

tblOperatingsystem.Caption
e.g. "Microsoft Windows 10 Pro", "Microsoft Windows 7 Professional", "Microsoft Windows Server 2012 R2 Standard"

Windows 10 ("no more versions!") version info:

tblAssets.Version
tblAssets.BuildNumber