Topic
  • 10 replies
  • Latest Post - ‏2014-07-14T00:25:33Z by Lee Wei
SystemAdmin
SystemAdmin
890 Posts

Pinned topic Help Updating "Fixlet Compliance by Computer Group (v1.5)"

‏2010-07-20T17:43:47Z |
Here is an update to the "Fixlet Compliance by Computer Group (v1.5)" that I find very useful,
this code adds not only "Critical" but "Important" "Moderate" "Low" "None" and "<unspecified>" Fixlets for the Report
http://forum.bigfix.com/viewtopic.php?id=4307

Here it is line 358 under the Baseline DropList (Combobox)

var rel1 = 
'("C||All Microsoft Critical Fixlets||" & it as string) of number of (bes fixlets whose (fixlet flag of it = true and display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "critical" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded")); ("I||All Microsoft Important Fixlets||" & it as string) of number of (bes fixlets whose (fixlet flag of it = true and display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "important" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded")); ("M||All Microsoft Moderate Fixlets||" & it as string) of number of (bes fixlets whose (fixlet flag of it = true and display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "moderate" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded")); ("L||All Microsoft Low Fixlets||" & it as string) of number of (bes fixlets whose (fixlet flag of it = true and display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "low" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded")); ("N||All Microsoft None Fixlets||" & it as string) of number of (bes fixlets whose (fixlet flag of it = true and display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "none" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded")); ("U||All Microsoft Unspecified Fixlets||" & it as string) of number of (bes fixlets whose (fixlet flag of it = true and display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "<unspecified>" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded")); ("A||Microsoft Patches (Current Period - ' + patchTuesdayCurrent + 
')||" & it as string) of number of (bes fixlets whose (fixlet flag of it = true and display name of site of it = "Patches for Windows (English)" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded" and source release date of it >= date "' + patchTuesdayCurrent + 
'" and source release date of it <= date "' + patchTuesdayCurrentEnd + 
'")); ("D||Microsoft Patches (Previous Period - ' + patchTuesdayPrevious + 
')||" & it as string) of number of (bes fixlets whose (fixlet flag of it = true and display name of site of it = "Patches for Windows (English)" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded" and source release date of it >= date "' + patchTuesdayPrevious + 
'" and source release date of it <= date "' + patchTuesdayPreviousEnd + 
'")); ("E||Microsoft Patches (Previous Period - ' + patchTuesdayPrevious2 + 
')||" & it as string) of number of (bes fixlets whose (fixlet flag of it = true and display name of site of it = "Patches for Windows (English)" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded" and source release date of it >= date "' + patchTuesdayPrevious2 + 
'" and source release date of it <= date "' + patchTuesdayPrevious2End + 
'")); "X||-- Baselines --||0"; unique values of ("B||" & name of it & "||" & number of components of component groups of it as string) of bes fixlets whose (baseline flag of it = true);"X||-- Sites --||0"; ("S||" & it & "||" & multiplicity of it as string) of unique values of display names of sites of bes fixlets whose (fixlet flag of it = true);"X||-- Relevance Expression --||0"; "R||Custom Relevance Expression||0" ';

then at 589 replace and add the following

replace   
} 

else 

if (type == 
'C') 
{ fixletFilter = fixletFilter + 
'(sets of bes fixlets whose (display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "critical" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded"))';   With the code below     
} 

else 

if (type == 
'C') 
{ fixletFilter = fixletFilter + 
'(sets of bes fixlets whose (display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "critical" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded"))'; 
} 

else 

if (type == 
'I') 
{ fixletFilter = fixletFilter + 
'(sets of bes fixlets whose (display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "important" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded"))'; 
} 

else 

if (type == 
'M') 
{ fixletFilter = fixletFilter + 
'(sets of bes fixlets whose (display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "moderate" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded"))'; 
} 

else 

if (type == 
'L') 
{ fixletFilter = fixletFilter + 
'(sets of bes fixlets whose (display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "low" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded"))'; 
} 

else 

if (type == 
'N') 
{ fixletFilter = fixletFilter + 
'(sets of bes fixlets whose (display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "none" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded"))'; 
} 

else 

if (type == 
'U') 
{ fixletFilter = fixletFilter + 
'(sets of bes fixlets whose (display name of site of it = "Patches for Windows (English)" and source severity of it as lowercase = "<unspecified>" and name of it as lowercase does not contain "corrupt patch" and name of it as lowercase does not contain "superseded"))';
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2010-07-20T21:00:08Z  
    Very nice Mark, thank you.

    I will make a note to include this into the report if and when I update it the next time around.

    Lee Wei
  • tscott91
    tscott91
    41 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2010-08-04T12:26:10Z  
    Awesome. I would love to add this.. However, when I click on EDIT to add this I only have 49 lines..

    
    <!-- Fixlet Compliance by Computer Group Created by lee_wei@bigfix.com last update: May 10th, 2010 Version 1.5 --> <script type=
    "text/javascript" src=
    "/ext-3.2.0/adapter/ext/ext-base.js"></script> <script type=
    "text/javascript" src=
    "/ext-3.2.0/ext-all.js"></script> <script type=
    "text/javascript" src=
    "/ext-3.2.0/ux/data/PagingStore.js"></script> <script type=
    "text/javascript" src=
    "/ext-3.2.0/ux/window/MessageWindow.js"></script> <script type=
    "text/javascript" src=
    "/ext-3.2.0/print/Printer-all.js"></script> <script type=
    "text/javascript" src=
    "/ext-3.2.0/ux/exporter/Exporter-all.js"></script> <script type=
    "text/javascript" src=
    "/ext-3.2.0/AC_OETags.js"></script> <script type=
    "text/javascript" src=
    "/ext-3.2.0/ux/form/Ext.ux.form.CheckboxCombo.js"></script> <script type=
    "text/javascript" src=
    "/ext-3.2.0/fixlet_compliance.js"></script> <link rel=
    "stylesheet" href=
    "/ext-3.2.0/ux/form/Ext.ux.form.CheckboxCombo.css" /> <link rel=
    "stylesheet" type=
    "text/css" href=
    "/ext-3.2.0/resources/css/ext-all.css"> <body> <div id=
    "help-win" class=
    "x-hidden"> <div class=
    "x-window-header">Important Information</div> <div id=
    "help-tab"> </div> </div> <div id=
    "loading-mask"></div> <div id=
    "loading"> <div class=
    "loading-indicator"> Loading... </div> </div> <div> <div id=
    "filters"> </div> <div style=
    "margin-top:10px; min-width:1000px"> <table width=
    "1000px" border=
    "0"> <tr> <td valign=
    "top"><div id=
    "chart1" style=
    "float:left;"></div></td> <td valign=
    "top"><div id=
    "chart2" style=
    "float:left; margin-left: 8px"></div></td> </tr> </table> </div> <div id=
    "compliance" style=
    "float:left; margin-top:10px;"> </div> <div id=
    "content" style=
    "float:left; margin-top:10px;"> </div> <div id=
    "footer" style=
    "clear:both; margin-bottom:20px;"> <br> </div> </div> </body>
    
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2010-08-04T16:47:20Z  
    Hi Tom,

    The way the report is structured using JavaScript, all the report code is included in the following file:
    /ext-3.2.0/fixlet_compliance.js

    Lee Wei
  • tscott91
    tscott91
    41 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2010-08-04T17:17:15Z  
    Ahh! Got it! Thank Lee and Mark!
  • Lee Wei
    Lee Wei
    599 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2010-08-05T23:09:34Z  
    I have incorporated Mark's modifications into the reports.
    Thanks for sharing Mark.

    Lee Wei
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2011-12-08T18:12:34Z  
    Sorry about that, I didnt get an email on your post ?
    attached is the fixlet_compliance.js I updated

    located here \BESReportsServer\wwwroot\ext-3.2.0\fixlet_compliance.js
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2011-12-08T18:12:34Z  
    Here is the Updated compliance_by_fixlets.js Java script for the "Fixlet Compliance by Content v1.0" Report
    located in the same directory

    and here's the link to the reports,
    http://forum.bigfix.com/viewtopic.php?id=5477

    also I just found "Fixlet Compliance by Content v1.0" today.......
    Awsome reports Lee... but you need to put all of these in a central location
  • SystemAdmin
    SystemAdmin
    890 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2011-12-08T18:12:34Z  
    Here's a screen shot of the new options available with the new .js file for the "Fixlet Compliance by Content (v1.0)" report

    http://forum.bigfix.com/attachment.php?item=310&download=1
  • ptholt79
    ptholt79
    2 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2014-06-04T20:35:17Z  
    Here's a screen shot of the new options available with the new .js file for the "Fixlet Compliance by Content (v1.0)" report

    http://forum.bigfix.com/attachment.php?item=310&download=1

    Hello,

    Is there a way to add a column to the Fixlet Compliance by Computer Group v1.6 report? We have a customer that would like the "user name" column in their compliance report.

    If there isn't a way to add a column to the compliance report, is there a way to make this populate by using a custom relevance expression? I'm unsure of what the syntax would be if this was the case.

    Any assistance in this matter would be appreciated. Thanks!

  • Lee Wei
    Lee Wei
    599 Posts

    Re: Help Updating "Fixlet Compliance by Computer Group (v1.5)"

    ‏2014-07-14T00:25:33Z  
    • ptholt79
    • ‏2014-06-04T20:35:17Z

    Hello,

    Is there a way to add a column to the Fixlet Compliance by Computer Group v1.6 report? We have a customer that would like the "user name" column in their compliance report.

    If there isn't a way to add a column to the compliance report, is there a way to make this populate by using a custom relevance expression? I'm unsure of what the syntax would be if this was the case.

    Any assistance in this matter would be appreciated. Thanks!

    Sorry for the slow response.

    Yes it is possible to add a column, but knowledge of JavaScript will be necessary to edit the source file.

    The source JavaScript file is in this file:

    C:\Program Files (x86)\BigFix Enterprise\BES Server\BESReportsServer\wwwroot\ext-3.2.0\fixlet_compliance.js

    Lee Wei