02-18-2020 04:48 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblOperatingsystem.Caption As FullOSname,
tblAssets.Version As [Windows Version]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where (tblAssets.AssetName Like 'LT-FR' And tsysOS.OSname = 'win 10' And
tblAssetCustom.State = 1) Or
(tblAssets.AssetName Like 'PC-FR')
Solved! Go to Solution.
02-19-2020 02:42 PM
Erik.T wrote:
Hi roro,
I moved your post to the report questions as you will be more likely to get an answer there.
02-19-2020 05:02 PM
Where
( tblAssets.AssetName Like '%LT-FR%'
And tsysOS.OSname = 'win 10'
And tblAssetCustom.State = 1)
Or
(tblAssets.AssetName Like '%PC-FR%')
(asset name contains "LT-FR"
AND OS is Win10
AND asset state is active
)
OR
(asset name contains "PC-FR"
AND don't care what OS
AND any state (active, non-active, sold, broken, etc.)
)
Where
tblAssetCustom.State = 1
And tsysOS.OSname = 'win 10'
And ( tblAssets.AssetName Like '%LT-FR%'
Or tblAssets.AssetName Like '%PC-FR%')
02-19-2020 11:41 AM
02-19-2020 02:42 PM
Erik.T wrote:
Hi roro,
I moved your post to the report questions as you will be more likely to get an answer there.