Trying to report on relevant security patches within certain dates

Reporting
1

(imported topic written by JS6591)

Hi,

I’ve been trying to create a web report that would show the number of relevant security patches within certain time frames (1 day old, 3 day old, 5 days old, 15 days old, and 30 days old +) for all BES computers, but I havent’ been able to figure how.

Would anyone have code to do this or at least help point me in a direction?

2

(imported comment written by BenKus)

Hi JS,

How do you define the “days old”? Days since the patch first became relevant on the system? Or days since the patch was released?

Ben

3

(imported comment written by JS6591)

I would like to define days old from when the patch first became an active action or released in to our environment.

4

(imported comment written by BenKus)

Are any of these similar to what you want?

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

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

Ben

5

(imported comment written by JS6591)

Ben,

Thanks, it was a great start and I was able to modify it for my needs.

6

(imported comment written by JS6591)

Ben,

I was able to modify the code you showed me and it works great, but I have one additional question.

Is there a way to modify the code so I can export the returned results to CSV?

I copied the original code I used as an example.

<?relevance (trs of ( td of name of computer of it & td of (name of fixlet of it as string) & td of (if (exists source of fixlet of it) then source of fixlet of it else "n/a") & td of (if (exists category of fixlet of it) then category of fixlet of it else "n/a" ) & td of (if (exists source release date of fixlet of it) then source release date of fixlet of it as string else "n/a") & td of (id of fixlet of it as string) & td of (relevant flag of it as string ) & td of (if (exists first became relevant of it) then first became relevant of it as string else "n/a") & td of (if (exists last became nonrelevant of it) then last became nonrelevant of it as string else "n/a") ) ) of results of bes fixlets whose (exists source of it AND source of it as lowercase = "microsoft" AND exists source release date of it AND source release date of it > (current date - 6 * 30 * day)) ?>
Computer Name Fixlet Name Source Category Source Release Date Fixlet ID Relevant? First became relevant Fixed time
7

(imported comment written by BenKus)

There isn’t an easy way to do this in a custom report with HTML tables… but you should be to copy the table to an excel file easily.

Ben

8

(imported comment written by JS6591)

I understand, but I was hoping for a more automated way. Going through the message board I see that this request comes up some what often. Do you know if BigFix is working on an enchancement like this in web reports in perhaps a later release?