Is not and Does not contain in Session Relevance

Hello team,

I am trying to create the session relevance version of this report from BigFix WebReports:

These filters returns 64 Servers in WebReports

This is the session relevance I have right now but it only returns 4 Servers:

(name of it, last report time of it, value of results from (bes property “UpTime”) of it, value of results from (bes property “Patch Window”) of it) of bes computers whose (operating system of it starts with “Win2” AND last report time of it > (now - 30 * day) AND ((value of result from (bes property “Patch Window”) of it contains “1”) OR (value of result from (bes property “Patch Window”) of it contains “2”) OR (value of result from (bes property “Patch Window”) of it contains “3”) OR (value of result from (bes property “Patch Window”) of it contains “4”)) AND (value of result from (bes property “Patch Method”) of it does not contain “MANUAL”) AND (value of result from (bes property “Patch Method”) of it does not contain “OFFER”) AND (value of result from (bes property “Pending Restart - Windows Updates - Windows”) of it is not “”) AND (value of result from (bes property “Pending Restart - Windows Updates - Windows”) of it does not contain “none”))

I am using the Patch Method and Patch Window property conditions in my other session relevance and they seem to work fine so I am thinking that it could be the condition for the Pending Restart - Windows Updates - Windows property value.

The report is to get list of servers that are still in Pending restart.

Any feedback or alternatives are very much appreciated.

Thank you.

You need to break down your session relevance query step by step and test each condition individually to identify which specific condition is preventing the expected results from appearing.