(imported comment written by liuhoting)
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?
(imported comment written by Jay.Fox)
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?
Is there a report similar to Fixlet Remediation History by Computer Name Report where I DONT need to select a computer group (because we don’t use computer groups) ?
Hello,
This report appears to be exactly what I am looking for at the moment, however, the link does not appear to be working. Where can I get this report? Thanks in advance.
-Phil
That brings me directly to the report in my browser. Is there a link to download the .besrpt file?
You can right click on the “Download the report here” link and Save As.
Or if it is already in the browser, you can also Save Page.
Obviously depending on the browser used.
Let me know if there are problems and I will help where I can.
Lee Wei
Thank you. By right clicking that gave me the option to look at all files and give it the proper file extension. I imported it and it is working very nicely. Thanks again.
HI Leewei,
Thanks a lot for your report , is it possible to add the release date of the fixlet to this report. if yes , please share the details.
thanks a lot in advance.
Naresh
@nareshjon, here you go, I have added the Source Release Date Fixlet attribute in the attached.
1 Like
I recieve a parsing error when trying to import this file into bigfix.
The content in “FixletFixDatebyComputerGroupWithDateSearch.bes” could not be imported.
XLM parsing error: no declaration found for element ‘style’ line 6, Character 24
Can you tell me how to fix this.
@roberteastman, looks like 2 issues here:
-
You should cut-and-paste the report into Web Reports.
Web Reports menu --> Explore Data --> Custom -
Secondly, the report is referring to the old name for the Windows patch site.
Please change “Patches for Windows (English)” to “Patches for Windows”
Lee Wei
Hello Lee Wei,
We haven’t taken all data for 2016 patches using Fixlet Remediation History By Computer Name report?
Have you ever encountered this problem ?
Thanks.
@candan, sorry for the late reply.
The report refers to the old name for the Windows patch site.
So we need to search and replace “Patches for Windows (English)” with “Patches for Windows”.
I suspect that is our problem here.
@leewei, Thanks for your reply.
Actually our problem is only about MS2016 patches.
I have replaced “Patches for Windows (English)” with “Patches for Windows” before running Report and I can get all year patches like 2015 2014 2013 except 2016.It is so strange.
Select Printable Version on left for printing
| Select Computer Group: | --Select Computer Group-- <?relevance (html "" & it & html "") of names of bes computer groups ?> | ||
| Fixlet Name: |
| Fixlet | Source Severity | Fix Date |
|---|
// var relevance = ‘(html “
| Computer | Fixlet | Source Severity | Fix Date |
|---|
var relevance = ‘(html “
| Computer | Fixlet | Source Severity | Fix Date |
|---|
// var relevance = ‘(html “
| Computer | Fixlet | Source Severity | Fix Date |
|---|
strResponse = EvaluateRelevance(relevance);
divRes.innerHTML = strResponse;
sortables_init();
stripe('resultsTable', '#fff', '#E6E3E8');
}
function init_load()
{
// stripe('resultsTable', '#fff', '#E6E3E8');
// sortables_init();
var currentTime = new Date()
var year = currentTime.getFullYear();
var month = currentTime.getMonth() + 1;
var day = currentTime.getDate();
if (month < 10){
month = "0" + month
}
if (day < 10){
day = "0" + day
}
document.getElementById('end_date').value = month + '-' + day + '-' + year;
document.getElementById('start_date').value = '01-01-2016';
}
var SORT_COLUMN_INDEX;
function sortables_init(){
// Find all tables with class sortable and make them sortable
if (!document.getElementsByTagName)
return;
tbls = document.getElementsByTagName("table");
for (ti = 0; ti < tbls.length; ti++) {
thisTbl = tbls[ti];
if (((' ' + thisTbl.className + ' ').indexOf("sortable") != -1) && (thisTbl.id)) {
//initTable(thisTbl.id);
ts_makeSortable(thisTbl);
}
}
}
function ts_makeSortable(table){
if (table.rows && table.rows.length > 0) {
var firstRow = table.rows[0];
}
if (!firstRow)
return;
// We have a first row: assume it's the header, and make its contents clickable links
for (var i = 0; i < firstRow.cells.length; i++) {
var cell = firstRow.cells[i];
var txt = ts_getInnerText(cell);
cell.innerHTML = '<a href="#" class="sortheader" ' +
'onclick="ts_resortTable(this, ' +
i +
');return false;">' +
txt +
'<span class="sortarrow"> </span></a>';
}
}
function ts_getInnerText(el){
if (typeof el == "string")
return el;
if (typeof el == "undefined") {
return el
};
if (el.innerText)
return el.innerText; //Not needed but it is faster
var str = "";
var cs = el.childNodes;
var l = cs.length;
for (var i = 0; i < l; i++) {
switch (cs[i].nodeType) {
case 1: //ELEMENT_NODE
str += ts_getInnerText(cs[i]);
break;
case 3: //TEXT_NODE
str += cs[i].nodeValue;
break;
}
}
return str;
}
function ts_resortTable(lnk, clid){
// get the span
var span;
for (var ci = 0; ci < lnk.childNodes.length; ci++) {
if (lnk.childNodes[ci].tagName && lnk.childNodes[ci].tagName.toLowerCase() == 'span')
span = lnk.childNodes[ci];
}
var spantext = ts_getInnerText(span);
var td = lnk.parentNode;
var column = clid || td.cellIndex;
var table = getParent(td, 'TABLE');
// Work out a type for the column
if (table.rows.length <= 1)
return;
var itm = ts_getInnerText(table.rows[1].cells[column]);
sortfn = ts_sort_caseinsensitive;
if (itm.match(/^\d\d[\/-]\d\d[\/-]\d\d\d\d$/))
sortfn = ts_sort_date;
if (itm.match(/^\d\d[\/-]\d\d[\/-]\d\d$/))
sortfn = ts_sort_date;
if (itm.match(/^[ $]/))
sortfn = ts_sort_currency;
if (itm.match(/^[\d\.]+$/))
sortfn = ts_sort_numeric;
SORT_COLUMN_INDEX = column;
var firstRow = new Array();
var newRows = new Array();
for (i = 0; i < table.rows[0].length; i++) {
firstRow[i] = table.rows[0][i];
}
for (j = 1; j < table.rows.length; j++) {
newRows[j - 1] = table.rows[j];
}
newRows.sort(sortfn);
if (span.getAttribute("sortdir") == 'down') {
ARROW = ' <img src="/images/besreports/ENU/maximizebutton1.gif" border="0" height="12" width="15" alt="">';
newRows.reverse();
span.setAttribute('sortdir', 'up');
}
else {
ARROW = ' <img src="/images/besreports/ENU/minimizebutton1.gif" border="0" height="12" width="15" alt="">';
span.setAttribute('sortdir', 'down');
}
// We appendChild rows that already exist to the tbody, so it moves them rather than creating new ones
// don't do sortbottom rows
for (i = 0; i < newRows.length; i++) {
if (!newRows[i].className || (newRows[i].className && (newRows[i].className.indexOf('sortbottom') == -1))) {
table.tBodies[0].appendChild(newRows[i]);
if (i % 2 > 0)
newRows[i].className = 'wr_oddRow';
else
newRows[i].className = 'wr_evenRow';
}
}
// do sortbottom rows only
for (i = 0; i < newRows.length; i++) {
if (newRows[i].className && (newRows[i].className.indexOf('sortbottom') != -1))
table.tBodies[0].appendChild(newRows[i]);
}
// Delete any other arrows there may be showing
var allspans = document.getElementsByTagName("span");
for (var ci = 0; ci < allspans.length; ci++) {
if (allspans[ci].className == 'sortarrow') {
if (getParent(allspans[ci], "table") == getParent(lnk, "table")) { // in the same table as us?
allspans[ci].innerHTML = ' ';
}
}
}
// adds up/down arrow to the column header
span.innerHTML = ARROW;
// Make zebra stripes in table
stripe(‘resultsTable’, ‘#fff’, ‘#E6E3E8’);
}
function getParent(el, pTagName){
if (el == null)
return null;
else
if (el.nodeType == 1 && el.tagName.toLowerCase() == pTagName.toLowerCase()) // Gecko bug, supposed to be uppercase
return el;
else
return getParent(el.parentNode, pTagName);
}
function ts_sort_date(a, b){
// y2k notes: two digit years less than 50 are treated as 20XX, greater than 50 are treated as 19XX
aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);
bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]);
if (aa.length == 10) {
dt1 = aa.substr(6, 4) + aa.substr(3, 2) + aa.substr(0, 2);
}
else {
yr = aa.substr(6, 2);
if (parseInt(yr) < 50) {
yr = '20' + yr;
}
else {
yr = '19' + yr;
}
dt1 = yr + aa.substr(3, 2) + aa.substr(0, 2);
}
if (bb.length == 10) {
dt2 = bb.substr(6, 4) + bb.substr(3, 2) + bb.substr(0, 2);
}
else {
yr = bb.substr(6, 2);
if (parseInt(yr) < 50) {
yr = '20' + yr;
}
else {
yr = '19' + yr;
}
dt2 = yr + bb.substr(3, 2) + bb.substr(0, 2);
}
if (dt1 == dt2)
return 0;
if (dt1 < dt2)
return -1;
return 1;
}
function ts_sort_currency(a, b){
aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).replace(/[^0-9.]/g, '');
bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]).replace(/[^0-9.]/g, '');
return parseFloat(aa) - parseFloat(bb);
}
function ts_sort_numeric(a, b){
aa = parseFloat(ts_getInnerText(a.cells[SORT_COLUMN_INDEX]));
if (isNaN(aa))
aa = 0;
bb = parseFloat(ts_getInnerText(b.cells[SORT_COLUMN_INDEX]));
if (isNaN(bb))
bb = 0;
return aa - bb;
}
function ts_sort_caseinsensitive(a, b){
aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).toLowerCase();
bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]).toLowerCase();
if (aa == bb)
return 0;
if (aa < bb)
return -1;
return 1;
}
function ts_sort_default(a, b){
aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]);
bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]);
if (aa == bb)
return 0;
if (aa < bb)
return -1;
return 1;
}
function addEvent(elm, evType, fn, useCapture)// addEvent and removeEvent
// cross-browser event handling for IE5+, NS6 and Mozilla
// By Scott Andrew
{
if (elm.addEventListener) {
elm.addEventListener(evType, fn, useCapture);
return true;
}
else
if (elm.attachEvent) {
var r = elm.attachEvent("on" + evType, fn);
return r;
}
else {
alert("Handler could not be removed");
}
}
// this function is needed to work around
// a bug in IE related to element attributes
function hasClass(obj) {
var result = false;
if (obj.getAttributeNode(“class”) != null) {
result = obj.getAttributeNode(“class”).value;
}
return result;
}
function stripe(id) {
// the flag we’ll use to keep track of
// whether the current row is odd or even
var even = false;
// if arguments are provided to specify the colours
// of the even & odd rows, then use the them;
// otherwise use the following defaults:
var evenColor = arguments[1] ? arguments[1] : “#fff”;
var oddColor = arguments[2] ? arguments[2] : “#eee”;
// obtain a reference to the desired table
// if no such table exists, abort
var table = document.getElementById(id);
if (! table) { return; }
// by definition, tables can have more than one tbody
// element, so we’ll have to get the list of child
//
var tbodies = table.getElementsByTagName(“tbody”);
// and iterate through them…
for (var h = 0; h < tbodies.length; h++) {
// find all the
var trs = tbodies[h].getElementsByTagName(“tr”);
// … and iterate through them
for (var i = 0; i < trs.length; i++) {
// get all the cells in this row…
var tds = trs[i].getElementsByTagName(“td”);
// and iterate through them...
for (var j = 0; j < tds.length; j++) {
var mytd = tds[j];
mytd.style.backgroundColor =
even ? evenColor : oddColor;
}
// flip from odd to even, or vice-versa
even = ! even;
}
}
}
I do see MS16 patches in my report, so nothing immediately obvious.
Hi Lee @leewei ,
I have been using this report on and off for a couple years. I have modified it a bit for my own requirements, but the one thing that I would really like to see if it could be updated is the calendar control.
Couple issues that I have:
- The control does not work well on IE or FireFox and works ok on Chrome (but not great)
- The control pops up over the fields, so if I want to manually enter the date, I cannot fully see the field.
Not huge issues, but my JS ability is not the best, but I am trying to work on it 
Thanks
Martin
Haha, this report could use an update eh!
Looks like when I was just trying to learn JavaScript.
Thanks for the feedback!
Lee,
I need this report so can you please guide me how can i extract the report.
@Prakasho, you import the report by downloading the report from here:
http://leewei.com/bigfix/prod/forum/FixletFixDatebyComputerGroupWithDateA.besrpt
- Save as text file
- In Web Reports --> Report List --> Import report --> Use HTML format