username + assetname WHERE assatname == keyword1 OR keyword2

[pedaleo]

I'm new!

I have a custom report (Username)&his(Computer) :

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Username
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblComputersystem.PartOfDomain = 1

But also I want to filter asset names starting by NB*** and PC***. I don't need the other named assets.

Is this possible?

many thanks

[RCorbeil · Accepted solution]

Technically, it would be

Where (tblAssets.AssetName Like 'PC%') Or
(tblAssets.AssetName Like 'NB%')

As you wrote it, the two conditions are Assetname contains 'PC' OR Assetname contains 'NB'. Given that, you would get a match for Assetname = 'wibblePCwobble' where, according to your initial question, you only want it to match things like 'PCwibble' and 'NBwobble'.

[pedaleo]

the answer is:

Where (tblAssets.AssetName Like '%PC%') Or
(tblAssets.AssetName Like '%NB%')