We require a custom BigFix patch report with the following options in a printable format, including a compliance chart:
- Computer Name
- OS
- Last Report Time
- Severity
- Source
- Fixlet Name
- Site
- Patch Installed Date
You can use this template
<?relevance
table "border=1" of (
(tr of (td of "Computer Name" & td of "IP Address" & td of "OS" & td of "Source ID" & td of "CVE ID" & td of "Fixlet Flag" & td of "Fixlet Name" & td of "Release Date" & td of "Severity" & td of "First Became Relevant" & td of "Last Became Relevant"))
& concatenation of trs of
(
( td of (item 0 of it as string)
& td of (item 1 of it as string)
& td of (item 2 of it as string)
& td of (item 3 of it as string)
& td of (item 4 of it as string)
& td of (item 5 of it as string)
& td of (item 6 of it as string)
& td of (item 7 of it as string)
& td of (item 8 of it as string)
& td of (item 9 of it as string)
& td of (item 10 of it as string))of ( (if (exists Name of Computer of it | false) then Name of Computer of it as string else "<none>"), (if (exists IP Addresses of Computer of it | false) then concatenations ", " of (IP Addresses of Computer of it as string) else "<none>"), (if (exists Operating System of Computer of it as string | false) then Operating System of Computer of it else "<none>"), (if (exists Source ID of Fixlet of it as string | false) then Source ID of Fixlet of it else "<none>"), (if (exists CVE ID List of Fixlet of it | false) then CVE ID List of Fixlet of it as string else "<none>"), (if (exists Fixlet Flag of Fixlet of it | false) then Fixlet Flag of Fixlet of it as string else "<none>"), (if (exists Name of Fixlet of it | false) then Name of Fixlet of it as string else "<none>"), (if (exists Source Release Date of Fixlet of it) then Source Release Date of Fixlet of it as string else "Fri, 15 Feb 1980"), (if (exists Source Severity of Fixlet of it | false) then Source Severity of Fixlet of it as string else "<none>"), (if (exists First Became Relevant of it) then First Became Relevant of it as string else "Fri, 15 Feb 1980 00:00:00 -0000"), (if (exists Last Became Relevant of it) then Last Became Relevant of it as string else "Fri, 15 Feb 1980 00:00:00 -0000")) of results of bes fixlets whose (name of site of it = "Enterprise Security")
)
)
?>
2 Likes
Thanks for this template, but do you have another template for the same query
Where should I input this template?
Please refer to the KB article below for guidance on creating a custom report. While creating the report, make sure to copy the provided template as instructed.