Finding "never relevant" fixlets

Reporting
1

(imported topic written by Bill.Ehardt)

Easy question… how do I find out of a particular fixlet was never relevant? For example, its a patch for Excel, but excel isn’t installed.

I’d like to be able to do something like (not in relevance, just plain speak)

If relevant then 
"Relevant" 

else 

if fixed then 
"Fixed" 

else 
"Never Needed"

I’ve been messing with “Relevant flag if it” and “last became nonrelevant of it” with session relevance, but I can’t seem to get the “never needed” portion.

Any ideas?

2

(imported comment written by Lee Wei)

Here is something that you might be able to use:

names of bes fixlets whose ( name of it as lowercase contains 
"excel" and fixlet flag of it = 

true and not exists results of it)
3

(imported comment written by Bill.Ehardt)

That seems to be a start, but that will only show me fixlets with zero relevant systems. I’m looking at something like MS10-080. I see out of our systems in our 134 systems in our test environment, we have 13 that show relevant for one of these fixlets.

How do I get a report showing…

  1. The 13 systems that are relevant (have this)

  2. The systems that were fixed (have this)

  3. The systems that don’t fall into either of the first two categories, in other words, not needed (need this)

I’m not looking for something just for this bulletin (like searching if excel doesn’t exist as regapp), but just a general method to accomplish something like this regardless of the fixlet.

Am I making sense?

4

(imported comment written by Lee Wei)

“not exists results of” the Fixlets will pull the Fixlets where no computers have reported at all.

Technically, this could be because none are relevant, but it is possible that some are relevant but never get a chance to report.

If you want to know the computers not falling into the 2 categories of relevant and fix, one way is to use the set operator.

(all computers - computers that have reported some status).

Note that “computers that have reported some status” will include both the ones still relevant, and the ones already fixed.