I need to generate a report based off of ''Results of BES Fixlets" with the following attributes.
Name of Fixlet | Name of Computer | Source Release Date of Fixlet | Last Became Nonrelevant
I can pull this report fine however I need to substitute “Name of Computer” with global property “DNS Name”.
Is it possible to bring the “DNS Name” global property into the report?
It’s not exactly what you are looking for, but here’s a start …
(name of computer of it, value of it)
of property results whose (name of property of it = "DNS Name")
of bes computers
@EMPOWER, unfortunately, we cannot replace the columns available in the Excel Connector easily.
As @TimRice had indicated, we will have to write the report separately.
The Excel Connector has a feature to “Show Relevance Code”, so you can start there to see what it has already generated so far and add the DNS Name.
This is not easy if you have not written Relevance before, so please let us know when you need help.
Thanks guys… I wanted to check with the experts before I went down the path of writing the custom relevance for the report. I’ll let you know if I need some assistance and what I come up with for a solution in case someone else has a similar requirement.
@leewei, I was able to locate the relevance in the excel connector for the report I’m running. I’m trying to figure out how to create a custom report based off the following relevance with replacing the “Name of Computer” value with global property value of “DNS Name” which @TimRice provided above.
( item 0 of it as string & “$x$” &
item 1 of it as string & “$x$” &
(if (year of it as integer = 1980)
then ("")
else
(year of it as string & “/” &
(month of it as two digits) as string & “/” &
(day_of_month of it as two digits) as string) )
of (item 2 of it as date) & “$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 3 of it as time))
of (
(if (exists Name of Computer of it)
then (concatenations “%0A” of (Name of Computer of it as string))
else ("")),
(if (exists Name of Fixlet of it)
then (concatenations “%0A” of (Name of Fixlet of it as string))
else ("")),
(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 Last Became Nonrelevant of it)
then (Last Became Nonrelevant of it as string)
else (“Fri, 15 Feb 1980 00:00:00 -0000”)))
of
results
whose (((Fixlet Flag of Fixlet of it = True) AND
(Source Release Date of Fixlet of it >= “Thu, 01 Jan 2015” as date) AND
(Name of Fixlet of it as lowercase starts with “rhsa”)))
of bes fixlets
whose (
(name of site of it = “Patches for RHEL5 Native Tools” OR
name of site of it = “Patches for RHEL6 Native Tools”))
I’m not really sure the best way to approach this and any guidance you can provide would be much appreciated!