Topic
  • 5 replies
  • Latest Post - ‏2009-04-28T18:41:27Z by jb11191
james_fryman91
james_fryman91
3 Posts

Pinned topic Retreive Missing Patches by Computername

‏2008-03-11T22:32:36Z |
Hello!

I am trying to find out a way to display a web report that flips the way reporting occurs. I've been asked to provide a report that shows each computer in BigFix and displays a computer and the total number of missing enterprise patches (microsoft) that remain outstanding.

The report needs to be exportable to CSV for manipulation. What would be the best way to go about discovering this data? I'd appreciate any help offered.

Thanks.

-James
  • BenKus
    BenKus
    597 Posts

    Re: Retreive Missing Patches by Computername

    ‏2008-03-12T03:21:39Z  
    What about this?
    http://forum.bigfix.com/viewtopic.php?id=898

    You should be able to copy/past to excel I think...

    Ben
  • james_fryman91
    james_fryman91
    3 Posts

    Re: Retreive Missing Patches by Computername

    ‏2008-03-12T13:46:17Z  
    So I was looking at that report, and it seemed to be very helpful... but the data I'm being asked for is more comprehensive than a number. It has to include the total number of missing patches/service packs per machine, either in a consecutive column view or a single text field with lots of data
  • james_fryman91
    james_fryman91
    3 Posts

    Re: Retreive Missing Patches by Computername

    ‏2008-03-12T18:54:48Z  
    I guess I'm looking for something along the lines of a relevance line that would return....

    list of relevant fixlets of site whose (name of it = "Enterprise Security")

    This is undefined, since there is no 'list' or 'names' clause... what would be the better way to do this?
  • BenKus
    BenKus
    597 Posts

    Re: Retreive Missing Patches by Computername

    ‏2008-03-13T07:07:12Z  
    Try this:
    In webreports, go to "Create Report" > "Computer Properties" > Click the box "Include Relevant Fixlets".

    Does this meet your needs? You can use the Filters to filter out computers/Fixlets.

    Ben
  • jb11191
    jb11191
    1 Post

    Re: Retreive Missing Patches by Computername

    ‏2009-04-28T18:41:27Z  
    I'm not sure anyone is monitoring this subject but I'll post anyway. Like James, I would like a missing Microsoft patches report on a single server. I used Ben's suggestion ("Create Report" > "Computer Properties" > Click the box "Include Relevant Fixlets"). It came back with several properties and pages 1-265 (2 servers per page). Is there a way to filter beyond this? Here are the options I see under create filter:
    +Saved Filter
    +Database
    +Site
    +Computer
    +Fixlet / Task / Baseline / Analysis