VERY new to Big Fix Reporting

(imported topic written by michelec91)

Hello,

I am taking over Big Fix in the coming months and the first thing my director wants is a report that can single out and separate servers and workstations for MS Patch compliance evaluation. Unfortunatly he wants it by Monday. :frowning:

I saw someone mention the Issue Assessment report, but I can’t find it.

Also, can we create our own detailed custom reports or do they have to be created by Big Fix? If we can, what’s needed to do so?

Thanks for the help!

~MicheleC

(imported comment written by MattBoyd)

michelec

I am taking over Big Fix in the coming months and the first thing my director wants is a report that can single out and separate servers and workstations for MS Patch compliance evaluation. Unfortunatly he wants it by Monday. :frowning:

Take a look at Lee Wei’s excellent Fixlet Compliance Report: http://forum.bigfix.com/viewtopic.php?id=4307 . This should help do what you’re looking for. You can just make separate computer groups in BigFix for servers and workstations.

michelec

Also, can we create our own detailed custom reports or do they have to be created by Big Fix? If we can, what’s needed to do so?

You can certainly create your own reports. At the top of Web Reports is a “create” button where you can use the built-in templates to create your own custom reports. That’s the easy way. To design your own custom reports, you need to write your own HTML and BigFix Session relevance. If you want to make something like Lee’s report above where there are user inputs, you need javascript as well. Here’s a thread with some more information: http://forum.bigfix.com/viewtopic.php?pid=9942#p9942. If you’re really serious about writing custom reports, take a look at the source code of the reports that some of the BigFix engineers have written to get an idea of how they did it. Also, look at using javascript frameworks, such as jQuery, for helping you do things like display and sort a table of results. It will save you a lot of time.

(imported comment written by michelec91)

Thank you Boyd, that was helpful. :slight_smile:

(imported comment written by michelec91)

Hello,

the report Lee did looks like what I need, however, I cannot download the report; it’s no longer in the directory specified. anyone know where i can get this report?

TIA

(imported comment written by MattBoyd)

I think it’s still there. Try right click -> save as on the link: http://www.leewei.com/bigfix/prod/customreports/FixletComplianceByComputerGroup.besrpt

(imported comment written by michelec91)

Hi Boyd,

i did try that; it saves it as an HTM file. :frowning: i found the one before it: http://forum.bigfix.com/viewtopic.php?pid=14439#p14439 and was able to download and import that one. howerver like Lee said, the one you recomended has everything i want… like drill down capablilities for the patch info. oh well.

hey, 'nother question - the excel connector and session relevance editor - do they get installed on the BigFix server, or can they be intalled on a loal machine? i don’t see any info on installation…

thanks again! :slight_smile:

(imported comment written by MattBoyd)

Hey michelec,

The source code of Lee’s report is all HTML, just save it with the .besrpt extension. It’s a very simple report file, because most of logic is in the zip archive that you’re supposed to download and extract onto the BES server. If you’re still having problems, I would definitely send Lee an e-mail.

Regarding the Excel Connector and Session Relevance Editor… both can be installed on your local machine. They connect to the Web Reports server from your workstation. Check out these links if you haven’t seen them already:

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

Session Relevance Editor: http://support.bigfix.com/labs/relevanceeditor.html