Trying to get a swiss query to run and its failing. What am I doing wrong?

I think it uses the words LIKE and NOT LIKE instead of = or <> but here are the docs.

Use SolarWinds Query Language (SWQL - SWIS) - SolarWinds Worldwide, LLC. Help and Support

I have looked at that document and it says WHERE is supported...  But I will try that also.

LIKE and LIKE NOT did not work either...

getting this error now in the SWQL Studio

mismatched input ',' expecting 'EOF'

This runs but provides no results..

SELECT HostName, ExpirationDate, Manufacturer, Model, OSArchitecture,  SerialNumber, WarrantyStatus

FROM Orion.AssetInventory.NodeWarrantyAlert

WHERE Manufacturer = 'VMware,Inc'

We have a couple of hundred VMware clients

Eureka!

This is what worked.

SELECT HostName, ExpirationDate, Manufacturer, Model, OSArchitecture,  SerialNumber, WarrantyStatus

FROM Orion.AssetInventory.NodeWarrantyAlert

WHERE NOT Manufacturer = 'VMWare, Inc.';