Web Reports - Group fixlets by 'computer group' using excel connector

Reporting
1

Hi,
I am pretty new to BigFix and I am trying to get some reports out of it. Please forgive me if this was already answered, I searched but couldn’t find anything.
I am trying to set-up report that will provide me with available fixlets (patches) older than 30-days. My goal would be to have report with graphs automated and sent every week, however excel connector would be a good solution as well. When running reports in Web Reports under Explore Data > Content, I encounter few problems.

  1. It’s important to be able to distinguish servers vs. computers (endpoints). Although I can filter out for computer group, I cannot add computer group column to my report. Is there any way that I can add computer group column in my results? Currently, I run two reports one for servers one for endpoints and It would be great if there is a way to run only one.
  2. I would like to target patches older than 30-days based on when patch first became relevant instead of source release data. But I don’t know how to do this in Web Reports and is it even possible. I cannot find a field that would filter out for when patch first became relevant. Note: There is ‘First Became Relevant’ field in excel connector when you run “Results of BES fixlets”
  3. Using Excel connector (version 3.3.3) would sort of provide automation that I need but I run into similar problems. In Excel connector when I run “BES Fixlets” I can’t even filter for computer group (servers vs computers) and I still don’t see an option for Relevant field.
    Please let me know if you have any ideas or suggestions. Your help is much appreciated.
    Web Reports Version 9.2.5.130
1 Like
2

One issue is that a single endpoint can belong to many computer groups, so how would it know which group to show?

Other than that, most of these things could be done with a custom report, but I’m not sure if it can be done with a normal report.

3

Thanks for your reply, I’ll check it out.