Give this a try... going back to The Authority at Efficient Session Relevance Query for Computer Properties and adapting it for Fixlet Results, I think this should be considerably more efficient.
It first builds a set of Fixlets and a set of Computers, so we can pre-filter to only the Fixlets and Computers that we care about. Then it iterates through both sets and retrieves a 'bes fixlet result' for each computer/fixlet and filters to only the results that are 'relevant'.
(
/* retrieve properties of interest */
name of item 1 of it | "Name Not Reported"
, name of item 0 of it | "Name Not Reported"
, name of site of item 0 of it
, unique value of mime field "x-fixlet-cve" of item 0 of it | "N/A"
, unique value of mime field "x-fixlet-superseded" of item 0 of it | "N/A"
)
of (
item 0 of it /* bes fixlet */
, item 1 of it /* bes computer */
, results (item 0 of it, item 1 of it) whose (relevant flag of it) /* bes fixlet result */
)
of (
elements of item 0 of it /* unwind fixlet set */
, elements of item 1 of it /* unwind computer set */
)
of (
set of fixlets whose (fixlet flag of it and exists applicable computers of it)
of bes sites whose (display name of it contains "Patches for " OR display name of it contains "Enterprise " OR display name of it contains "updates ") /* set of fixlets of interest */
, union of subscribed computer sets
of bes sites whose (display name of it contains "Patches for " OR display name of it contains "Enterprise " OR display name of it contains "updates ") /* set of computers of interest */
)