List all computers except VMmachines?

[Ryoen_Deprouw]

Hello,

I got a simple question. I want to list all computers except VMWare machines.
Now I got by AssetTypename = 'windows'. That gives all the computers

Now I want to have also integrate a filter on Model, that should be: does not contain VMware or is not equal to VMware Virtual Platform.

How do I create that criteria on my report builder?

Regards

[RCorbeil · Accepted solution]

Technet T-SQL reference (comparison operators)

W3Schools SQL tutorial (operators in the WHERE clause)

W3Resource SQL Tutorial (comparison operators)

Google

[Ryoen_Deprouw]

Allright got it, not equal expression is: <>

Is there any place where I can find all the expressions?