Session relevance query for Computer Groups

[vhenry]

Hello,

I’m trying to edit the source of the Schedulable Compliance by Computer report (Reference: Report Available: Schedulable Compliance by Computer or Content). I’d like the report to have the “Computer Groups” column as well.

Can someone please help me with the relevance query?

<?relevance trs of htmls (unique values of (it as string) of (td of (id of computer of it as string & id of fixlet of it as string) & td of (id of computer of it as string) & td of (if exists name of computer of it then name of computer of it else "") & td of (if exists operating system of computer of it then operating system of computer of it else "") & td of (if exists ip addresses of computer of it then concatenations (html "
") of (ip addresses of computer of it as string) else html "") & td of (if exists last report time of computer of it then (((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 computer of it) else ("")) & td of (if (exists first became relevant of it) then ("1") else ("0")) & td of (if (exists Last Became NonRelevant of it and not relevant flag of it) then "1" else "0") & td of (if (exists Last Became Relevant of it and Relevant Flag of it) then "1" else "0")) of results of bes fixlets) ?>

I added the following within the query-

& td of (if exists computer groups of computer of it then computer groups of computer of it else “”)

But it gave the error -
Error in the Session Relevance: The operator “computer groups” is not defined.

[steve]

The property with computer groups is called bes computer groups and there could be multiple, like IP addresses, so you would do something like this:

& td of (if exists bes computer groups of computer of it then concatenations (html "<br>") of (names of bes computer groups of computer of it as string) else html "")

[vhenry]

[vhenry]

Thank you, Steve!

I tried using your query but that just gave a blank error…

[steve]

You probably need to share the entire line of code to check if it was added correctly. You can also test the relevance stmt (the part between <?relevance and ?> on the QNA page in Web Reports: http://wrserver/webreports?page=QNA

[vhenry]

Hi Steve,

Below is the line of code where I inserted the query you provided-

<?relevance trs of htmls (unique values of (it as string) of (td of (id of computer of it as string & id of fixlet of it as string) & td of (id of computer of it as string) & td of (if exists name of computer of it then name of computer of it else "") & td of (if exists bes computer groups of computer of it then concatenations (html "
") of (names of bes computer groups of computer of it as string) else html "") & td of (if exists operating system of computer of it then operating system of computer of it else "") & td of (if exists ip addresses of computer of it then concatenations (html "
") of (ip addresses of computer of it as string) else html "") & td of (if exists last report time of computer of it then (((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 computer of it) else ("")) & td of (if (exists first became relevant of it) then ("1") else ("0")) & td of (if (exists Last Became NonRelevant of it and not relevant flag of it) then "1" else "0") & td of (if (exists Last Became Relevant of it and Relevant Flag of it) then "1" else "0")) of results of bes fixlets) ?>