Hi @leewei
I’ve rearranged your query with our needs and came to the following result:
((name of it, ((number of results whose (exists first became relevant of it) of it as floating point - number of results whose (relevant flag of it) of it) * 100 / number of results whose (exists first became relevant of it) of it) ) of bes fixlets whose (exist results of it and (not (name of it contains "Superseded" or name of it contains "corrupt")) and month_and_year of source release date of it = (month_and_year of current date - 1*month) and display name of site of it contains "Patches for Windows" and source severity of it contains "Critical"))
This will give me the percentage of compliance of the critical patches from the last month (without the superseded and the corrupt ones). Now my question:
How can I add relevance for specific computer groups? I’ve tried adding of members of bes computer groups whose (name of it contains "xxx") at the end, but no luck. My session relevance tester goes into time out…
Any idea?
Thanks!