As the Web Report can’t show up the patch installation date directly, but there is the embedded function which in the fixlet view calls “Time Remediated” for all OS(Windows/Linux/AIX/UNIX).
I’d appreciate any help that add this “Time Remediated” to web report 1st page directly, we need this analysis function for our monthly patching report. Thanks
Any advise for this analysis function? Thanks
Was this query ever solved. I have the exact same requirement and looking for solution.
Take a look at the below session relevance. It shows the Fixlet, the computer name, the last time it be came non relevant and the relevant flag.
Does this get you what you need? It can be dropped into a web report if needed.
( item 0 of it as string & "$x$" &
item 1 of it as string & "$x$" &
(if ((year of date (local time zone) of it) as integer = 1980)
then ("<none>")
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) of time (local time zone) of it))
of (item 2 of it as time) & "$x$" &
item 3 of it as string )
of (
(if (exists Name of Fixlet of it | false)
then (concatenations "%0A" of (Name of Fixlet of it as string))
else ("<none>")),
(if (exists Name of Computer of it | false)
then (concatenations "%0A" of (Name of Computer of it as string))
else ("<none>")),
(if (exists Last Became Nonrelevant of it)
then (Last Became Nonrelevant of it as string)
else ("Fri, 15 Feb 1980 00:00:00 -0000")),
(if (exists Relevant Flag of it | false)
then (concatenations "%0A" of (Relevant Flag of it as string))
else ("<none>")))
of
results
of bes fixlets
whose (
(name of site of it = "Enterprise Security"))Hi All,
Can we get Time Remediated column after Relationship in the report ?
Thank you.
What do you mean by after relationship? Ultimately Last Became Nonrelevant is going to show when it was remediated.
This hasn’t really changed since the earlier recommendation in this thread. There is no way to add the Time Remediated to this view.
The solution is to build a fully-customized report, where you provide both the HTML content and the Session Relevance to generate it. The Session Relevance from earlier in the thread provides the content.
Hi ,
I have activated analysys using the above mentioned relevance ,but results are not getting.
Can you please help me ,how to provide the html content and the session relevance?
Thanks,
I’m afraid there’s a pretty significant learning curve of this is your first custom web report. The documentation is at https://developer.bigfix.com/other/web-reports-api/ (be sure to read through each of the sub-links).
It may also be useful to see a custom report to start with. I’d recommend one of JGStew’s, like
I believe there are several others there as examples
Hi,
I have copied the above relevance in custom report here but couldn’t get the data.I copied some other relevance from bigfix-content/webreports at main · jgstew/bigfix-content · GitHub and tried I was able to get the data.Could you please help me how to get Time remediated column in patch report.
I’m not sure what you are trying to show. There does not appear to be any relevance pasted into that screen shot.
Hi ,
I have copied the above relevance.
( item 0 of it as string & “$x$” &
item 1 of it as string & “$x$” &
(if ((year of date (local time zone) of it) as integer = 1980)
then (“”)
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) of time (local time zone) of it))
of (item 2 of it as time) & “$x$” &
item 3 of it as string )
of (
(if (exists Name of Fixlet of it | false)
then (concatenations “%0A” of (Name of Fixlet of it as string))
else (“”)),
(if (exists Name of Computer of it | false)
then (concatenations “%0A” of (Name of Computer of it as string))
else (“”)),
(if (exists Last Became Nonrelevant of it)
then (Last Became Nonrelevant of it as string)
else (“Fri, 15 Feb 1980 00:00:00 -0000”)),
(if (exists Relevant Flag of it | false)
then (concatenations “%0A” of (Relevant Flag of it as string))
else (“”)))
of
results
of bes fixlets
whose (
(name of site of it = "Enterprise Security"))
Ah, you need to put the whole query inside a Relevance tag…
<?relevance
Put your query here
?>
https://developer.bigfix.com/other/web-reports-api/wr_content.html
It’s likely some of the doublequote characters were replaced by the UNICODE “Smart Quotes”. Delete and re-type them
The relevance worked ,but Time remediated data is not coming .
How can we get that data ?
The “Last became no relevant” column is the time it was Remediated.
None of those “Microsoft Unsupported” were ever Remediated, so they show “None”.
Now that you’re actually getting results you could add HTML formatting to the query. Are you still using that first Session Relevance listed above, or have you rearranged anything?
