How to generate Bigfix Report with "AND"/"OR"-mixed filters?

Reporting
1

(imported topic written by alvinyun91)

I can generate report#1(Solais systems missing “Security” category fixlets) with Active Filter like:

Include Fixlet categories: Security

Include Computer Group: ComputerGroup_Solaris

I can generate report#2(Linux systems missing “Critical” severities fixlets) with Active Filter like:

Include Fixlet source severities: Critical

Include Computer Group: ComputerGroup_Linux

Now, how can I generate a single report to merge report#1 and report#2 ?

That is, I need a filter working like

( “Computer Group = ComputerGroup_Solaris” AND “categories = Security” ) OR ( “Computer Group = ComputerGroup_Linux” AND “severities = Critical” )

Please note that Solaris uses “categories” while Linux uses “severities” for searching the relevant fixlets.

Now I scheduled the reports to be sent out to multiple system administrators weekly. For each SA, I have to send out 8 reports in 8 separate emails, if I can merge 8 reports to one, then schedule to send out the report within one email, that will be great.

Please advise how I can flexibly use Bigfix report filters to come up one single report.

Thank you!

Alvin

2

(imported comment written by BenKus)

Unfortunately, I don’t think the filters will incorporate the arbitrary AND/OR logic combinations (it must be all ANDS or all ORs)… We struggled with this problem in all filter dialogs for a while and I think we are planning an update to this in our next version… I will ask our developers about what they intend to do here…

Ben

3

(imported comment written by alvinyun91)

Thanks for the quick response.

Do you know any workaround for this problem? Or any suggestions?

Is it possible to write report script to achieve that?

Thanks!

Alvin

4

(imported comment written by BenKus)

Hey Alvin,

I think you would need to write a custom report for this…

Ben

5

(imported comment written by alvinyun91)

Hi Ben,

How can I write “custom report”?

Could you give me some tips or point me to the docs?

Do you have a sample/template custom report for similar requirement report?

Thanks!

Alvin

Ben Kus

Hey Alvin,

I think you would need to write a custom report for this…

Ben

6

(imported comment written by BenKus)

Here are a bunch of custom reports that Zak made:

http://forum.bigfix.com/viewtopic.php?id=1879

You can also look around this forum for more info about custom reports.

The basic idea is that you use “Session Relevance” to pull data from the Web Reports and then you format it using HTML or Javascript into your report.

Here is a recent example from a couple days ago:

http://forum.bigfix.com/viewtopic.php?id=3457

Ben

Ben