‎12-06-2019 03:02 PM
‎12-06-2019 06:09 PM
Where
( tblAssets.AssetID Not In (Select Top 1000000
tblSoftware.AssetID
From
tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where
tblSoftwareUni.softwareName Like '%Netskope%')
And tsysOS.OSname = 'win 10'
)
Or (tsysOS.OSname = 'win 7')
Where
tblAssets.AssetID Not In (Select Top 1000000
tblSoftware.AssetID
From
tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where
tblSoftwareUni.softwareName Like '%Netskope%')
And (tsysOS.OSname = 'win 10' Or tsysOS.OSname = 'win 7')
And tsysOS.OSname IN ('win 10', 'win 7')
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now