Amend a report to include another field

Reporting
1

(imported topic written by gcibirch91)

Hi

I need to amend a report by adding another field to it but not sure how to do it. we want to add the field for Location/OU so that we can then export to Excel and sort the report.

How do I do this?

2

(imported comment written by Lee Wei)

What version of BigFix/TEM and which report are you using?

There are some reports where we can add columns, but not others.

Lee Wei

3

(imported comment written by gcibirch91)

Version 7.2

I was looking at the baseline by Computer Group report you guys created.

4

(imported comment written by Lee Wei)

Can you please post a link to the report? Thanks.

5

(imported comment written by gcibirch91)

This is the report:

http://forum.bigfix.com/viewtopic.php?id=3643

thanks

6

(imported comment written by Lee Wei)

Thanks for the link.

You can modify the session relevance statement in the report to this:

var relevance = '(html "

color=red

[/color]" & it & html "
Computer Operating

System

 IP Address Last Report Time Compliance (%25) Applicable Components Installed and Patched Still Relevant Location
") of concatenations of trs of(td of item 0 of it & td of item 1 of it & td of item 2 of it & td of(item 3 of it as string) & td "align=right" of (if (item 4 of it = 0) then ("100") else (if ((((item 5 of it as floating point / item 4 of it as floating point) * 100) as string) starts with "NaN") then("0") else (((item 5 of it as floating point / item 4 of it as floating point) * 100) as string)) ) & td "align=right" of(item 4 of it as string) & td "align=right" of (item 5 of it as string) & td "align=right" of(item 6 of it as string)

color=red

& td of item 7 of it[/color]) of ((if(exists link of it) then(link of it) else (html “”)), (if (exists operating system of it) then (operating system of it) else ("")), (if (exists ip addresses of it) then (concatenation (html "

") of (ip addresses of it as string)) else (html " ")), ((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, number of results from (source fixlets of components of component groups of bes fixlets whose (baseline flag of it = true and id of it = ’ + baselineName.value + ')) whose (exists last became relevant of it) of it, number of results from (source fixlets of components of component groups of bes fixlets whose (baseline flag of it = true and id of it = ’ + baselineName.value + ')) whose (exists last became nonrelevant of it and relevant flag of it = false) of it, number of results from (source fixlets of components of component groups of bes fixlets whose (baseline flag of it = true and id of it = ’ + baselineName.value + ')) whose (relevant flag of it = true) of it

color=red

, (if (exists results from (bes property whose (name of it = “Location”) ) of (it)) then (concatenation "; " of values of results from (bes property whose (name of it = “Location”) ) of (it)) else (“None”))[/color] ) of ’ + computerFilter;

Note to replace the 3 “Location” with the exact name of the property you want to extract.

Lee Wei

7

(imported comment written by gcibirch91)

Thanks Lee

I will give it a try