Topic
54 replies Latest Post - ‏2014-04-22T13:04:31Z by Jay.Fox
rmnetops91
rmnetops91
17 Posts
ACCEPTED ANSWER

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
Updated on 2012-05-18T16:29:12Z at 2012-05-18T16:29:12Z by Lee Wei
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-02T23:56:51Z  in response to rmnetops91

    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

    Updated on 2013-05-07T15:18:11Z at 2013-05-07T15:18:11Z by Lee Wei
    • ageorgiev
      ageorgiev
      5 Posts
      ACCEPTED ANSWER

      Re: Fixlet Remediation History By Computer Name

      ‏2014-01-17T14:09:01Z  in response to Lee Wei

      Lee,

      Would it be possible based on this code to extract the "last remediation date" of the entire set of fixlets (latest of all "fixed" dates) and if so how would you do it code-wise? Thank you.

      • Lee Wei
        Lee Wei
        573 Posts
        ACCEPTED ANSWER

        Re: Fixlet Remediation History By Computer Name

        ‏2014-01-17T15:49:43Z  in response to ageorgiev

        Latest of all fixed dates can be Maximum of the all the dates, so something like the following.

        It is modified from the statement posted above.

        maximum of (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")

        Lee Wei

        • ageorgiev
          ageorgiev
          5 Posts
          ACCEPTED ANSWER

          Re: Fixlet Remediation History By Computer Name

          ‏2014-01-17T16:13:08Z  in response to Lee Wei

          I was doing something similar with the idea that I just need the "last remediation date" of each machine against a set of fixlets:

          (name of it, maximum of (last became nonrelevant of it) of results from (source fixlets of components of component groups of bes fixlets whose (baseline flag of it = true and (name of it starts with "Baseline"))) whose (exist last became nonrelevant of it) of it) of bes computers
          

          but I get error and not exactly sure why/where it is coming from:

          computer1, ( Sun, 20 Jan 2013 03:11:50 -0500 )Singular expression refers to nonexistent object.
          

          I ran the report w/o the "maximum of" and this is the data I do see the full data (some machines have 1-2-3 remediated fixlets as you can see)

          computer1, ( Sat, 25 Aug 2012 23:48:33 -0500 )
          computer1, ( Sun, 20 Jan 2013 03:11:50 -0500 )
          computer2, ( Tue, 05 Mar 2013 20:26:42 -0500 )
          computer2, ( Tue, 05 Mar 2013 20:26:42 -0500 )
          computer3, ( Sun, 05 Aug 2012 12:31:39 -0500 )
          computer3, ( Sun, 03 Mar 2013 12:49:55 -0500 )
          computer4, ( Sat, 12 Jan 2013 02:00:47 -0500 )
          computer4, ( Sat, 12 Jan 2013 02:00:47 -0500 )
          computer5, ( Sat, 16 Feb 2013 12:28:15 -0500 )
          computer6, ( Sat, 02 Mar 2013 21:48:08 -0500 )
          computer6, ( Sat, 02 Mar 2013 21:48:08 -0500 )
          

          Any idea what I am missing? Why the error and how to fix the code?

          • Lee Wei 2
            Lee Wei 2
            10 Posts
            ACCEPTED ANSWER

            Re: Fixlet Remediation History By Computer Name

            ‏2014-01-18T03:23:55Z  in response to ageorgiev

            You can give this a try.

            (    name of it,
                maximum of last became nonrelevants of results from (source fixlets of components of component groups of bes fixlets whose (baseline flag of it = true and (name of it starts with "Baseline"))) of it
            ) of bes computers
                whose (exists last became nonrelevant of results from (source fixlets of components of component groups of bes fixlets whose (baseline flag of it = true and (name of it starts with "Baseline"))) of it)
             

            Lee Wei

            • ageorgiev
              ageorgiev
              5 Posts
              ACCEPTED ANSWER

              Re: Fixlet Remediation History By Computer Name

              ‏2014-01-20T12:16:30Z  in response to Lee Wei 2

              Thanks Lee, that did the trick.

  • rmnetops91
    rmnetops91
    17 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-03T00:19:12Z  in response to rmnetops91
    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?
    Updated on 2009-10-03T00:19:12Z at 2009-10-03T00:19:12Z by rmnetops91
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-22T05:55:09Z  in response to rmnetops91
    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
    Updated on 2010-01-22T05:55:09Z at 2010-01-22T05:55:09Z by Lee Wei
  • rmnetops91
    rmnetops91
    17 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-05T17:13:53Z  in response to rmnetops91
    You rock Lee!

    Works great.

    Thanks
  • kespoor91
    kespoor91
    11 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-19T18:40:53Z  in response to rmnetops91
    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
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-23T04:55:01Z  in response to rmnetops91
    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
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

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

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T16:08:20Z  in response to rmnetops91
    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
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T16:47:46Z  in response to rmnetops91
    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
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T17:22:48Z  in response to rmnetops91
    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
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

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

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T18:12:11Z  in response to rmnetops91
    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
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T18:24:29Z  in response to rmnetops91
    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
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-10-26T18:35:13Z  in response to rmnetops91
    Lee-

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

    Re: Fixlet Remediation History By Computer Name

    ‏2009-12-17T13:45:00Z  in response to rmnetops91
    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
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2009-12-17T17:05:17Z  in response to rmnetops91
    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
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-22T00:30:07Z  in response to rmnetops91
    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....
    Updated on 2010-01-22T00:30:07Z at 2010-01-22T00:30:07Z by SystemAdmin
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-28T05:11:27Z  in response to rmnetops91
    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
    Updated on 2010-01-28T05:11:27Z at 2010-01-28T05:11:27Z by Lee Wei
  • rmnetops91
    rmnetops91
    17 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-22T17:04:37Z  in response to rmnetops91
    All of these are great. Thanks!
  • SystemAdmin
    SystemAdmin
    890 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-22T18:39:09Z  in response to rmnetops91
    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 *****
    Updated on 2010-01-22T18:39:09Z at 2010-01-22T18:39:09Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    890 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-25T13:37:34Z  in response to rmnetops91
    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
    Updated on 2010-01-25T13:37:34Z at 2010-01-25T13:37:34Z by SystemAdmin
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-28T05:13:51Z  in response to rmnetops91
    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
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-01-28T15:35:38Z  in response to rmnetops91
    Works Great......
    Thank You
  • rmnetops91
    rmnetops91
    17 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-02-18T17:57:47Z  in response to rmnetops91
    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.
    Updated on 2010-02-18T17:57:47Z at 2010-02-18T17:57:47Z by rmnetops91
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-02-18T21:45:13Z  in response to rmnetops91
    A fix or an applied patch is defined as:
    1. The Relevant Flag of the Fixlet evaluation is False.
    2. The Last Become Nonrelevant field has a time stamp. This is the date/time when the client reported the fix.

    So you can test the Fixlet and Computer combination in question by running the following relevance:

    (name of computer of it,
    relevant flag of it,
    (if (exists last became nonrelevant of it) then (last became nonrelevant of it as string) else ("Not applied")),
    name of fixlet of it)
    of results from (bes fixlets whose (name of it = "fixlet_name"))
    of bes computers whose (name of it = "computer_name")

    The report will have a filter where "Relevant Flag = False" and "Exists Last Became NonRelevant".

    Lee Wei
  • rmnetops91
    rmnetops91
    17 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-02-19T03:09:04Z  in response to rmnetops91
    I "think" I understand what your saying. Can you think of any scenarios where a fixlet might be "Relevant Flag = False" and "Exists Last Became NonRelevant", but didn't actually get "installed".
    Updated on 2010-02-19T03:09:04Z at 2010-02-19T03:09:04Z by rmnetops91
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-02-20T00:44:20Z  in response to rmnetops91
    Not really, the scenario you described should not have happened.
    What constitutes "Installed"?

    It should be shown in the Fixlet relevance, with all the different statements.
    • If the relevance is TRUE, the patch is missing. Relevance Flag = true, and not installed
    • If the relevance is FALSE, the patch is not required, or already installed

    So we should be able to reconcile that way.
  • Kenz91
    Kenz91
    16 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-06-16T15:50:21Z  in response to rmnetops91
    Why aren't reports like these exportable?
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-06-24T19:36:51Z  in response to rmnetops91
    Kenz,

    You have correctly noted that the "Export to CSV" link in Web Reports is for the built-in reports.
    Custom reports will have to provide their own export functionality.

    For the moment, I suggest:

    • Click on the "Printable Version" link to run the report with minimal frills.
    • Do a Control-A to select the entire report.
    • Paste-Special with Text only into Excel.

    Lee Wei
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-08-02T16:40:53Z  in response to rmnetops91
    There is a related report that filters by a single Computer, rather than a Computer Group:
    http://forum.bigfix.com/viewtopic.php?id=5445

    Lee Wei
  • SystemAdmin
    SystemAdmin
    890 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-11-16T17:07:01Z  in response to rmnetops91
    Hey,

    Does this report also pull non-windows results?

    if not, is there a report similar that could pull both windows and non-windows fixlet history.

    thanks,
    Baraq
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-11-16T17:14:39Z  in response to rmnetops91
    Baraq,

    If you look at the report, there is a clause that limits the content to "Patches for Windows (English)".

    
    display name of site of it contains 
    "Patches for Windows (English)"
    

    You can change that to include other sites of interest.
    For example, replace that with

    
    name of site of it as lowercase contains 
    "patches"
    

    This will pull all Fixlets in any sites with the word Patches.

    Lee Wei
  • SystemAdmin
    SystemAdmin
    890 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2010-11-16T17:19:54Z  in response to rmnetops91
    ahh, ok.

    Thanks Lee!
  • ttefera91
    ttefera91
    1 Post
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2011-03-15T20:00:17Z  in response to rmnetops91
    Lee Wei
    Not really, the scenario you described should not have happened.
    What constitutes "Installed"?

    It should be shown in the Fixlet relevance, with all the different statements.
    • If the relevance is TRUE, the patch is missing. Relevance Flag = true, and not installed
    • If the relevance is FALSE, the patch is not required, or already installed

    So we should be able to reconcile that way.
    Hi Lee,

    I have found recently that the "Last Reported Non-Relevant" field is no longer reflecting accurate information. For example, using the bigfix Excel connector, i have created a Result of BES Fixlets" report with the following attributes checked:
    • Computer Name
    • Fixlet Name
    • Last Became Nonrelevant
    • Relevant Flag

    What I have found are fixlets that have a Relevancy Flag of TRUE (meaning the computer is missing the patch) but "Last Became Nonrelevant" is dated 2010/04/08 08:00PM. How can that be the case?

    I have been running similar reports and have not seen this scenario before.
    Can you give me some ideas?

    Thank you.

    ttefera
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2011-03-15T23:41:46Z  in response to rmnetops91
    ttefera,

    Yes it is possible to have a result where color=blueRelevant Flag[/color] = TRUE and some value is the color=blueLast Became Nonrelevant[/color] field.
    This means that the Fixlet was fixed at some point, but it has become relevant (again).
    You would then expect to see a value in the color=blueLast Became Relevant[/color] field to be a later time.

    I just took a quick look at the last report in this thread, and there is a filter condition for the Fixlet Results to be color=blue(exists last became relevant of it and relevant flag of it = false)[/color]. So that looks correct to me.

    Lee Wei
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2011-03-15T23:44:37Z  in response to rmnetops91
    These topics can get a little confusing, but quite important to understand so you know how to interpret the results, and to stand up against audits and inquiries.
    Feel free to send me a private message and I am happy to walk anyone through the issues.
    Sometimes easier to have a dialogue.

    Lee Wei
  • SystemAdmin
    SystemAdmin
    890 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2011-08-19T17:10:06Z  in response to rmnetops91
    We have been using several variations of these reports for a while. Recently they have stopped functioning. I am not sure if it was our upgrade to version 8, of if it is related to IE 7&8. I think there are a couple of different issues.
    First the calendaring function no longer works. I think this is an IE related issue with how IE 7 & 8 handle the focus() to an IFRAME. When selecting the textfield for the date, the calendar pops open, but you have no functionality, and you can not get the calendar to go away. (We have tested this in FF, Safari, and Chrome as well. The issue is in FF and IE, but not Safari, and Chrome )
    Second, if you go into the javascript and hard code in start and end dates and hit the generate report button, the browser basically locks up, and will never return. It has to be killed via the task manager.

    Any help would be appreciated.
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2011-12-08T18:12:25Z  in response to rmnetops91
    worleysj,

    I have removed the calendar picker function.
    So you can just type in the date choices.

    Lee Wei

    (Sign-in to see the attachment)
    Updated on 2011-12-08T18:12:25Z at 2011-12-08T18:12:25Z by Lee Wei
    • tscott91
      tscott91
      41 Posts
      ACCEPTED ANSWER

      Re: Fixlet Remediation History By Computer Name

      ‏2012-02-02T13:19:40Z  in response to Lee Wei
      Lee, first off I want to say thanks again for all these reports. They add great value and functionality (should be included!)..

      When I run the Fixlet Compliance by Computer Group (v1.6) and choose a group that has 160 nodes with a fix data of only 1 month it sits at processing for at least 5 minutes and the CPU on the BigFix server shoots to 100%..

      Is this normal?

      Thanks again!
      • Lee Wei
        Lee Wei
        573 Posts
        ACCEPTED ANSWER

        Re: Fixlet Remediation History By Computer Name

        ‏2012-02-02T18:48:54Z  in response to tscott91
        Tom,

        If you are running 8.2 of Web Reports, there is a newly introduced bug that causes the report to run slowly.
        This will be fixed hopefully in the next patch release.
        The report referenced is in this thread:
        http://www.ibm.com/developerworks/forums/message.jspa?messageID=14771889#14771889

        Lee Wei
        • tscott91
          tscott91
          41 Posts
          ACCEPTED ANSWER

          Re: Fixlet Remediation History By Computer Name

          ‏2012-02-06T20:46:21Z  in response to Lee Wei
          I'm actually still on 8.1.617.0
          • Lee Wei
            Lee Wei
            573 Posts
            ACCEPTED ANSWER

            Re: Fixlet Remediation History By Computer Name

            ‏2012-02-06T20:59:31Z  in response to tscott91
            That does not ring a bell for me.
            On the Server side, the process doing work in Web Reports, so you can check on its CPU usage.
            Most of the work should be client side JavaScript on the browser.
            In any case, this behavior does not reconcile for me.
    • TallTomD
      TallTomD
      1 Post
      ACCEPTED ANSWER

      Re: Fixlet Remediation History By Computer Name

      ‏2014-02-12T22:10:22Z  in response to Lee Wei

      Lee,

       

        Thanks for the report.  It is very close to what I need.  However, when I run the report it only provides results for 2 computers in the group I've selected.  How can I get results for all the computers in the group?

       

        I'm also looking for another report that is giving me troubles.  If you could help it would be great.  For that report I'm trying to gather Computer Name, a retrieved Property, and the Subscribed Sites.  I'd like to filter Subscribed Sites results to only show certain information.  Can you help?

       

      Please advise,

      Tom

  • SystemAdmin
    SystemAdmin
    890 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2011-08-25T13:56:56Z  in response to rmnetops91
    Lee - Thanks for the update. the code shows an "error on page" message when the date is entered. I assume that is because the javascript now calls a non-existent function...

    onfocus="showCalendarControl(this);

    Do you see any issue removing this call? I have tested out onfocus="" and everything seems to be fine.

    One other question - when running this report, the browser is completely locked up and unusable until the report finishes (30+ minutes for a 1 day date range), is that expected?
  • Lee Wei
    Lee Wei
    573 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2011-08-25T15:24:18Z  in response to rmnetops91
    You have fixed the error correctly.
    Better still you can remove the entire onfocus statement.

    The speed of the report depends on how much data is being returned.
    If it takes yours 30 minutes, you must have a big deployment.
    Obviously it would be better to filter down base on the computer group and small set of Fixlets.

    Lee Wei
  • routergirl91
    routergirl91
    1 Post
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2012-05-17T19:48:02Z  in response to rmnetops91
    I've gone through this thread several times - is there an attached report anywhere for the "Fixlet Remediation History by Computer Name"? I keep seeing links back to the old forum, which does not have an attachment that I can find, and the only one here is the one for the Computer Group. Sorry if I missed it - it's been a long day. :)

    I actually have that report in our Web Reports already - I really just need to remove the Calendar popup - I have been going through the report for the Computer Group (where the date picker was removed, and you can now type it in in clear text) to see if I can find the relevant lines and remove it by hand because it pops up and just sits there. But my eyes are starting to glaze over at this point. If anyone can help with that, I'd be so grateful!
  • liuhoting
    liuhoting
    19 Posts
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2014-01-23T22:01:13Z  in response to rmnetops91

    Would this be a good thing to eventually have as a dashboard on bigfix labs so we can see this on the thick console instead of just web reports?

  • Jay.Fox
    Jay.Fox
    1 Post
    ACCEPTED ANSWER

    Re: Fixlet Remediation History By Computer Name

    ‏2014-04-22T13:04:31Z  in response to rmnetops91

    I am brand new to IEM, Big Fix. 

    I am looking for a report very similar to this one.  My final outcome would be to create a graph to show the number of patches installed per day, for a 90 day period (as part of my quarterly ops. review).  Does such a thing exist?