Currently Relevant Fixlets and Tasks in a Baseline or Not?

(imported topic written by jhickman91)

Is there a way to create a Web Report using the filters to report which currently relevant fixlets and tasks belong to existing baselines OR which currently relevant fixlets and tasks do not belong to any baselines?

I suppose the opposite report would also be helpful. In other words which currenlty non-relevant fixlets and tasks belong to existing baselines OR which currently relevant fixlets and tasks do not belong to any baselines?

If not already possible it would be very helpful to someday be able to create these types of reports.

(imported comment written by jhickman91)

I am clearly beginning to see the benefit of posting questions to the BigFix Forum. It wasn’t my intention to stupify the “experts”.

(imported comment written by Lee Wei)

Here are some ideas that you might be able to use to create what you need.

The following is an example Session Relevance for “relevant Fixlets and tasks belonging to an existing baseline”.

“applicable computer count > 0” is the one that gives us relevant Fixlets.

To get non-relevant Fixlets, change to “= 0”.

Note that in the example, we are filtering base on the site “Patches for Windows (English)”.

You can change, add, or remove the AND clause.

( names of source fixlets whose ( applicable computer count of it > 0 and display name of site of it = 
"Patches for Windows (English)") of components of component groups of it, name of it ) of bes fixlets whose (baseline flag of it)

A simple but complete code for a custom report for Web Reports is as follows.

(html 
"<table border=1 style=%22border-collapse: collapse; border: medium none;%22>" & html (it) & html 
"</table>") of concatenation of ( (unique values of (it as string)) of trs of (td of item 0 of it & td of item 1 of it) of ( names of source fixlets whose ( applicable computer count of it = 0 and display name of site of it = 
"Patches for Windows (English)") of components of component groups of it, name of it ) of bes fixlets whose (baseline flag of it) )

Lee Wei