Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bmbarnett
Engaged Sweeper III
When I exclude one the code is
Where tsysAssetTypes.AssetTypename != 'Monitor' And tblState.Statename =
'Active'
Order By AssetType,
tblAssets.AssetName

And it excludes Monitor

But when I add another one more to the Or.. it looks like

Where (tsysAssetTypes.AssetTypename != 'Monitor' And tblState.Statename =
'Active') Or
(tsysAssetTypes.AssetTypename != 'IOS')

It doesn't exclude anything with the code above.
1 ACCEPTED SOLUTION
AZHockeyNut
Champion Sweeper III
off the top of my head try Not in '......'

Where tsysAssetTypes.AssetTypename not in ('Monitor','IOS') and tblState.Statename =
'Active'

something like that?

View solution in original post

2 REPLIES 2
bmbarnett
Engaged Sweeper III
Thank you for your help.
AZHockeyNut
Champion Sweeper III
off the top of my head try Not in '......'

Where tsysAssetTypes.AssetTypename not in ('Monitor','IOS') and tblState.Statename =
'Active'

something like that?

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now