Patch Applied History Need Help

(imported topic written by russwm91)

Hello,

I need help figuring this patches applied issue I’m having. I need a report for auditors to view when the last time any Microsoft patch was a applied to a server. We don’t patch on a regular basis and were new to the whole Bigfix patching piece. So I wouldn’t be doing a Data Base query against the Bigfix since patches weren’t being applied to these servers by Bigfix. I came up with this so far on the local server:

Dir /A:H /OD $* > c:\patch.txt

using a Dir command on the server to filter out to $* directories then pipe them to a file this will then tell me when each patch was applied.

Please any help with this or if someone already built a report for this would be helpful.

Thanks,

Russ

(imported comment written by Lee Wei)

Russwm,

Can you please take a look and see if this report will work.

http://forum.bigfix.com/viewtopic.php?pid=15803#p15803

Lee Wei

(imported comment written by russwm91)

Hello Lee,

Thanks for the link yes going forward since we now have BES agents on all devices this is a great report. The only issue is that this will only work on post Bigfix with fixlets and not previous like 5 years ago what was patched. I was able to use another tool to pull this information so we are good for now. I did want to know how can I run the report you created to a signal server. We have ITIL and Change management in place so they audit any changes against a signal server periodically. Other then creating a manual group and adding just one server is there a way to use your report.

Thanks,

Russ Mock

(imported comment written by Lee Wei)

If you don’t have too many computers, the drop list is an OK way to choose a single computer.

You can modify the report to choose by a single computer instead.

I have modified it for you and attached the report here.

Make sure to sign into the forum to see the attachment.

(imported comment written by russwm91)

Hello Lee,

I see the modified report and I can now select a signal device which is great. The issue I’m having now any device I select and run a report against I get no information back just a blank header with not fixlet history. I run the same report using the group knowing the device I’m looking for is in a sample group and it comes back with lots of fixlet history. Please help since this is the report I need for auditing but seems not to work with a signal device now.

Thanks,

Russ

(imported comment written by Lee Wei)

Sorry that I uploaded the wrong file.

Please try this one.

If you don’t specify a Fixlet name, you should get everything fixed.

(imported comment written by russwm91)

Hello Lee,

That works great thanks so much you rock!!!

Russ

(imported comment written by sandesh91)

Hi Lee Wei

It will be great option Thanks a ton.

(imported comment written by YorkLy)

Can anyone tell me why I get this error below from WebReport v8.1.608 when trying to import any FixletFixDatebyComputerGroupWithDateAndFixletNameSearch.besrpt or any .besrpt extension?

Invalid Web Report XML File: Unexpected element: style

But I don’t have issue with any .beswrpt extension.

Suggestions?

Thanks.

York

(imported comment written by Lee Wei)

The .besrpt extension needs to be imported as HTML.

There are minor differences between HTML (.besrpt) and XML (.beswrpt).

The XML format already has the report name embedded, while the other one allows you to choose your own names.

Lee Wei