SQL Filter Query

[penfold]

I'm trying to generate a report to identify systems which may be vulnerable because they do not have specific updates installed. I can do this for a single update using the filter for KB but if I try and do it with multiple KB then I do not get any results.

 

The filter structure I am using is this

Update contains KBnumber

Status <> Installed

 

This works for each KB, but if I try the following filter

Update contains KBnumber1

Status <> Installed

AND

Update contains KBnumber2

Status <> Installed

 

the report generates nothing

 

If I change the And condition to OR I can see the results show some systems with both KBs and they are not installed. However as I need to exclude those systems where any KB has been installed I need to filter systems which have a status of NOTinstalled for ALL KBs. Can anyone correct my logic and point me in the right direction please?

[Bedders]

Could you not use something like (assuming MSSQL):

 

WHERE Update IN (KBnumber1, KBnumber2)