Patch report in bigfix

how to fetch below columns for patch report , is it via relevance or SQL query? I want to fetch these columns for windows patch report.

download and import “Fixlet Compliance by Computer Group (v1.7)” to bigfix reports, this gives very good report of compliance.

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Endpoint%20Manager/page/Interactive%20Fixlet%20Compliance%20by%20Computer%20Group%20Report

1 Like

@mail2vij, Vijay,

We have 2 reports that perform compliance info, one is “by Computer Group”, and the other “by Content”.

By Content uses one Session Relevance to extract the data.

Since you asked, I will give you the details. All the reports below run against “All Critical Microsoft Patches” and “All Computers”.

unique values of (("<A name=%22" & name of it & "%22 href=%22" & link href of it & "%22 target=%22_blank%22>" & name of it & "</A>") & "||" & id of it as string & "||" & (if (exists category of it) then (if (category of it as lowercase contains "<unspecified>") then (category of it as string) else ("Unspecified") ) else ("Unknown")) & "||" & (if (exists source severity of it) then  (if (source severity of it as lowercase contains "<unspecified>" or source severity of it as lowercase contains "<n/a>") then ("Unspecified") else (source severity of it) ) else ("Unspecified")) & "||" & (if (exists source release date of it) then ((year of it as string & "/" & month of it as two digits & "/" & day_of_month of it as two digits & " (" & day_of_week of it as three letters & ")") of source release date of it) else ("--")) & "||" & number of results whose (exists last became relevant of it AND exists last became nonrelevant of it and last became relevant of it < last became nonrelevant of it) of it as string & "||" & number of results whose (relevant flag of it) of it as string & "||0||0||" & name of site of it) of elements of unions of ((sets of bes fixlets whose (display name of site of it starts with "Patches for Windows" 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")))

However, By Computer Group is more complicated in that it does processing in JavaScript to summarize the results from 2 different Session Relevance.
This is why you don’t see reports from the perspective of Computers easily in Web Reports.

This Session Relevance retrieves all the computers selected:

unique values of (id of it as string & "||" & ("<A name=%22" & name of it & "%22 href=%22" & link href of it & "%22 target=%22_blank%22>" & name of it & "</A>") & "||" & (if (exists operating system of it) then (operating system of it) else ("Unknown")) & "||" & (if (exists ip addresses of it) then (concatenation ("<br />") of (ip addresses of it as string)) else (" ")) & "||" & ((year of it as string & "/" & month of it as two digits & "/" & day_of_month of it as two digits) of date (local time zone) of it & " " & (two digit hour of it as string & ":" & two digit minute of it as string & ":" & two digit second of it as string) of time (local time zone) of it) of last report time of it & "||" & (if (exists bes computer group of it) then (concatenation ("<br />") of (unique values of names of bes computer groups of it as string)) else (" "))) of elements of unions of ((sets of bes computers whose (exists name of it)))

This Session Relevance retrieves all the Fixlets information:

unique values of (id of item 0 of it as string & "||" & name of item 0 of it & "||" & item 1 of it & "||" & item 2 of it & "||" & item 3 of it & "||" & item 4 of it & "||" & item 5 of it & "||" & item 6 of it & "||" & item 7 of it) of (applicable computers whose (exists name of it) of it, ("<A name=%22" & name of it & "%22 href=%22" & link href of it & "%22 target=%22_blank%22>" & name of it & "</A>"), (if (exists source severity of it) then ( if (source severity of it as lowercase contains "unspecified" or source severity of it as lowercase contains "<n/a>") then ("Unspecified") else (source severity of it) ) else ("Unspecified")), (if (exists source release date of it ) then ((year of it as string & "-" & month of it as two digits as string & "-" & day_of_month of it as two digits as string) of source release date of it as string) else "1000-01-01"), (if (exists category of it) then (if (category of it as lowercase contains "unspecified") then ("Unspecified") else (category of it as string) ) else ("Unknown")), (if (exists download size of it) then ((download size of it) as string) else ("0")),display name of site of it, applicable computer count of it as string) of elements of unions of ((sets of bes fixlets whose (display name of site of it = "Patches for Windows" 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")))

So long answer to your question there is no easy Session Relevance to perform compliance summary.
We do have access of the source code of the processing in the JavaScript files.
(e.g. C:\Program Files (x86)\BigFix Enterprise\BES Server\wwwrootbes\ext-3.2.0\fixlet_compliance_1_8.js)

It is not easy to get the columns you need, which is why I have done the processing. I am providing the Session Relevance to give you a feel since you asked as not to make this opaque.

4 Likes

Thanks for your help Lee. I will take a look and let you know

Thanks