Topic
  • 63 replies
  • Latest Post - ‏2015-03-18T07:21:17Z by shvm
rmnetops91
rmnetops91
17 Posts

Pinned topic Fixlet Remediation History By Computer Name

‏2009-10-02T00:08:57Z |
Anyone know how to create a report that would use a "By Computer Name" filter to show all remediated fixlets along with the dates the fixlets were applied (regardless of the action they were applied by)?

We need to be able to see all fixlets that were applied to a specific machine, and the date they were applied on (for troubleshooting possible patch related issues on any given machine). I tried using the wizard to create a Computer Property report that showed remediated fixlets (and then filter by computer name), but the built-in view doesn't show the date the fixlet was applied. It only lists the fixlets that were applied with the option to click on each one for more details. It would be way more helpful to list the applied fixlets and their apply dates in one table, sorted by apply date.

Edited by Lee Wei (2010-07-29 14:25:00)
I have added this screen shot for convenience, so others can see the structure of the report without having to install it.
Latest report is here:
http://forum.bigfix.com/viewtopic.php?pid=33477#p33477

http://www.leewei.com/bigfix/prod/forum/forum_3948.png
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-02T23:56:51Z  

    rmnetops,

    Maybe you can start with the follow Session Relevance statement and see if the result is what you are looking for:
     

    
    (name of fixlet of it, source severity of fixlet of it, last became nonrelevant of it) of results from (bes fixlets whose (display name of site of it contains 
    "Patches for Windows (English)" and fixlet flag of it = 
    
    true)) whose (exists last became relevant of it and relevant flag of it = 
    
    false) of bes computers whose (name of it = 
    "SomeComputer")
    


    If it looks good, we can wrap some Web Reports presentation around it.


    Lee Wei

  • rmnetops91
    rmnetops91
    17 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-03T00:19:12Z  
    Lee,

    I tested that out in my relevance tester, and that looks perfect.

    Would it be possible to have a drop down menu of computer names similar to the Baseline reports you recently created?
  • rmnetops91
    rmnetops91
    17 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-05T17:13:53Z  
    You rock Lee!

    Works great.

    Thanks
  • kespoor91
    kespoor91
    11 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-19T18:40:53Z  
    Lee-
    I'm SO very glad you created this! I've been looking for this information in this format too!

    I'm wondering if it would be possible add the ability to limit the results to a certain date range? For my needs, being able to select what month to report on would be sufficient, but I'm suspecting others out there might prefer multi-month, weekly, daily or some other combination. I'm not seeing pre-populated filters that would accomplish this.

    rmnetops- thanks for asking for this report!
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-23T04:55:01Z  
    Kespoor,

    I have clobbered together a report with the ability to search a date range.
    I hope you can use it.

    Please see the attachment at this post:
    http://forum.bigfix.com/viewtopic.php?pid=33477#p33477

    Lee Wei
  • kespoor91
    kespoor91
    11 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-23T13:01:31Z  
    Lee-
    That is SO AWESOME! You ROCK!
    Thank you!
  • JasonO91
    JasonO91
    19 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T16:08:20Z  
    Lee Wei,

    No good deed goes unpunished...

    This report is one of my favorite reports, and I've been trying to get the report to work for a computer group. I can't get the report to do what I want. I think it's my lack of javascript that's holding me back.

    Any pointers towards getting this to work with a group would be greatly appreciated.

    Jason
  • arnoldgsteve91
    arnoldgsteve91
    2 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T16:47:46Z  
    JasonO
    Lee Wei,
    No good deed goes unpunished...

    This report is one of my favorite reports, and I've been trying to get the report to work for a computer group. I can't get the report to do what I want. I think it's my lack of javascript that's holding me back.

    Any pointers towards getting this to work with a group would be greatly appreciated.
    Jason
    I am probably looking for almost the same thing. I collect my fixlets into baselines so I can track them through our acceptance testing process. After we get approval from the testers, I put the approved patches into a 'deployment' baseline which I deploy to production as multiple actions (each customized for the targets involved).

    What I need is a report I can export to Excel to answer admin questions like "What fixlets were installed on Server-X and when were they installed?" Ideally, it should look like this:

    For a Chosen Action or Baseline (whichever's easier):
    Loop through each computer targeted by the action/baseline and report:
    Action/Baseline Name
    Computer Name
    Fixlet Name
    Fixlet Source
    Date Applied
    Result (Fixed, Not Relevant, Failed, etc...)

    Anybody know of an existing report which is close to that?
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T17:22:48Z  
    JasonO
    Lee Wei,

    No good deed goes unpunished...

    This report is one of my favorite reports, and I've been trying to get the report to work for a computer group. I can't get the report to do what I want. I think it's my lack of javascript that's holding me back.

    Any pointers towards getting this to work with a group would be greatly appreciated.

    Jason
    Hi Jason,

    Good job for trying to tackle this. I suspect this has less to do with JavaScript, and more on the Session Relevance. I edited the relevance to pull computer names from a computer group.

    Please use the latest report here:
    http://forum.bigfix.com/viewtopic.php?pid=33477#p33477

    Lee Wei
  • kespoor91
    kespoor91
    11 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T17:26:59Z  
    Lee-
    THANK YOU! I didn't even realize I needed this, till you developed it! :)
  • JasonO91
    JasonO91
    19 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T18:12:11Z  
    Lee Wei,

    Good to know that I wasn't just missing the boat on the relevance. I created almost the exact same relevance to get what I wanted. When I run the report, the group has approximately 1340 computers in it, and the report hangs with "Processing"

    I am assuming that it's hanging due to the number of fixlets that it's trying to evaluate.

    Jason
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T18:24:29Z  
    Jason,

    Yes, it is just taking a long time.
    The query has to go through the results of 1340 computers X thousands of Fixlets.
    If we have 1000 Fixlets, that is 1.3 million rows.
    If you select this large result set, the output is probably not very useful.

    In any case, the query will take a while, but it will eventually return.
    Can you also try a smaller computer group to test with?

    Lee Wei
  • arnoldgsteve91
    arnoldgsteve91
    2 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T18:35:13Z  
    Lee-

    Thanks - that's what I wanted!
  • pcaprio91
    pcaprio91
    5 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-12-17T13:45:00Z  
    Lee,

    How can I edit this report to be able to export it to a PDF file, instead of Selecting Printable Version on left for Printing?
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2009-12-17T17:05:17Z  
    pcaprio,

    There is no easy way to add PDF export to the report.
    The easiest would be to Print to a PDF Converter.
    So you are basically printing, but the output is a PDF file.

    Lee Wei
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-22T00:30:07Z  
    Lee Wei
    {quote:title=JasonO}Lee Wei,

    No good deed goes unpunished...

    This report is one of my favorite reports, and I've been trying to get the report to work for a computer group. I can't get the report to do what I want. I think it's my lack of javascript that's holding me back.

    Any pointers towards getting this to work with a group would be greatly appreciated.

    Jason
    Hi Jason,

    Good job for trying to tackle this. I suspect this has less to do with JavaScript, and more on the Session Relevance. I edited the relevance to pull computer names from a computer group.
    Please see the attached Web Reports and see if it is close to what you need.

    Lee Wei{quote}
    Greate Report,

    We ran into an issue where I needed to find out where a certain patch was deployed to,

    How hard would it be to add to the above report another filter field like a certaiin patch by date by group

    so search a patched group for say "MS09-062" only....
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-22T05:55:09Z  
    rmnetops,

    You can try this report.

    color=redNote: There are 3 other variants of this report in this thread. Please scroll down for more info.[/color]

    Latest report is here:
    http://forum.bigfix.com/viewtopic.php?pid=33477#p33477

    Lee Wei
  • rmnetops91
    rmnetops91
    17 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-22T17:04:37Z  
    All of these are great. Thanks!
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-22T18:39:09Z  
    Well, for a Frankenstein report, this report incredible,

    thank you again

    ***** Someone should compile these professional looking reports into a single forum *****
    • so everyone has easy access to this type of resource *****
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-25T13:37:34Z  
    Lee Wei
    Haha,

    This is turning to be a Frankenstein of a report.
    If you guys are game, I am happy to help where I can.

    Here is the modified report, now titled:
    "Fixlet Fix Date by Computer Group with Date and Fixlet Name Search"

    Hope it works for you.

    Lee Wei
    The report only seems to run in the BigFix Session Relevance Tester"

    from the Bes Reports website the output says "Processing..."
    it actually never produces any data

    the error is:
    Error: fixletname is not defined
    Source File: http://bigfixserver:52312/webreports?page=Report&ReportID=165
    Line: 434

    using XP SP2 / Mozilla Firefox 3.5.7
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-28T05:11:27Z  
    Haha,

    This is turning to be a Frankenstein of a report.
    If you guys are game, I am happy to help where I can.

    Here is the modified report, now titled:
    "Fixlet Fix Date by Computer Group with Date and Fixlet Name Search"

    Hope it works for you.

    Lee Wei

    • Removed the attachment from this note and posted a new one below
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-28T05:13:51Z  
    mamacher,

    Thank you for spotting the error, there is a bug in the report.
    I have fixed it.
    Please let me know if it does not run.

    The latest report is here:
    http://forum.bigfix.com/viewtopic.php?pid=33477#p33477

    Lee Wei
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-28T15:35:38Z  
    Works Great......
    Thank You
  • rmnetops91
    rmnetops91
    17 Posts

    Re: Fixlet Remediation History By Computer Name

    ‏2010-02-18T17:57:47Z  
    I found a possible bug in this report. We noticed a patch showed applied on a few particular systems, when it really wasn't. It was in fact a fixlet that was part of a baseline, submitted as an "offer" that was relevant to these particular systems. In other words, the report included it in the results as installed, when really it was only relevant as an offer.

    The fixlet shown as installed in the report was: MS09-055 Cumulative Security Update of ActiveX Kill Bits - Windows Server 2003 SP2 (Superseded)

    Interestingly, that same fixlet in the actual offer action status, doesn't say "(Superseded)" next to it, but it does in the report results.