cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MarkJonN
Engaged Sweeper II
Hello, May i know how to remove the Microsoft Windows 10 and leave only the Professional, Enterprise and Pro in tblOperatingsystem.Caption OS Version. I Tried this report below but Microsoft Windows 10 still showing in my query report.Brick wall

Select Top 1000000 tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysOS.OSname As [OS Name],
tblOperatingsystem.Caption As [OS Version],
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblSystemEnclosure On
tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Inner Join tblPortableBattery On
tblAssets.AssetID = tblPortableBattery.AssetID
Inner Join lansweeperdb.dbo.tblOperatingsystem On tblAssets.AssetID =
tblOperatingsystem.AssetID
Where tblAssets.Lastseen <> '' And tblAssetCustom.State = 1 And
tblAssets.Assettype = -1
Order By tblAssets.AssetName


See the 2nd picture i attached, i want my report same like that.

Any help will do, Thank you!!! Team LS! Dancing
1 REPLY 1
RCorbeil
Honored Sweeper II
Duplicate. See here.