Filter on more than one property

Question

Hi Guys

I am a total noob when it comes to SQL,

I want to filter Top XX volumes by fixed disk and by server.

The following filter works VolumeType = 'Fixed Disk' but I want to insure we only see servers I've added MachineType but haven't had any joy.

I get the following error "Custom SQL filter is incorrectly formatted" searching on the site indicates I might have to clear cache and rebuild website.

Before I go down that road does anyone have a working query I can throw in and confirm if its me or the system - any help is much appreciated!

stanners · Answer

Hi Jorich

Thank you very much, confirmed its my poor SQL skills not a website issue really appreciate your reply and it totally sorts my problem!.

Your awesome!!!

jorich · Answer

stanners​ - examples of queries that all work properly for me.  (With potentially different results depending on the nodes you are monitoring and level of SAM you are using)

volumetype = 'fixed disk' and (machinetype like '%linux%' or machinetype like  '%windows%')

volumetype = 'fixed disk' and machinetype like '%windows%'

volumetype = 'fixed disk' and isserver = 1