Help trying to add remediated date column to web report

Reporting
1

(imported topic written by Kenz91)

Here’s what I’m trying to do. I need a report that has MS patch fixlets listed with affected workstations listed below. Then each workstation has a column showing if it’s been remediated and if so the date and time it was remediated. I would need this in a single report even when selecting multiple MS patch fixlets. The only way I’ve been able to get close is to do an Issue Assessment report, select all the MS patch fixlets on the next screen and select DNS Name as my Primary sorting group. This gives me everything I want except the remediation time. There doesn’t appear to be a property that I can sort by for the remediation time. The only way I can get the info is to bring up that report then click on each individual fixlet hyperlink. Unfortunately this would lead to exporting numerous reports instead of one.

I hope my explination isn’t to confusing. Any ideas how I can get the output that I need? Thanks.

2

(imported comment written by BenKus)

You might try playing with the Excel Connector to try to get this info:

http://support.bigfix.com/labs/excelconnect.html

Ben

3

(imported comment written by Kenz91)

Ok I downloaded the connector and found that I can pull the information using the Results of BES Fixlets then selecting Computer name and Last Became Relevant and Fixlet name. I can then filter by fixlet name contains MS10-30 or what ever I need. The problem is it’s pulling the data for every machine. There doesn’t seem any way to filter by computer group so that I can seperate out the servers from the workstations. I could get around it if I could create both AND and OR filters but it appears I can only have one or the other. Any ideas?