‎06-19-2017 06:04 PM
Select tblSoftwareUni.softwareName,
tblAssets.AssetName
From tblSoftwareUni
Inner Join tblSoftware On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Where tblSoftwareUni.softwareName Not Like '%SOFTWARE TITLE 1%' And
tblSoftwareUni.softwareName Not Like '%SOFTWARE TITLE 2%' And
tblSoftwareUni.softwareName Not Like '%SOFTWARE TITLE 3%' And
tblSoftwareUni.softwareName Not Like '%SOFTWARE TITLE 4%' And
AND (tblSoftwareUni.SoftwareName NOT LIKE '%SOFTWARE TITLE 5%' AND tblAssets.AssetName NOT LIKE 'pc-%')
‎07-07-2017 04:06 PM
(tblAssets.AssetName Like 'team1-%' Or tblAssets.AssetName Like 'team2-%' Or tblAssets.AssetName Like team3-%')
AND tblAssets.AssetName Not Like 'team%-a%'
‎07-07-2017 11:39 AM
‎06-20-2017 01:56 PM
Like 'team1-%' Or Like 'team2-%' Or Like 'team3-%'
AND (tblAssets.AssetName Like 'team1-%' Or tblAssets.AssetName Like 'team2-%' Or
tblAssets.AssetName Like 'team3-%')
Like 'team1-%' Or Like 'team2-%' Or Like 'team3-%' And Not Like 'team%-a%'
AND (tblAssets.AssetName Like 'team1-%' Or tblAssets.AssetName Like 'team2-%' Or
(tblAssets.AssetName Like 'team3-%' AND tblAssets.AssetName Not Like 'team%-a%'))
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now