About muti values in a column

(imported topic written by bearandy)

I want to make a custom report(like attachment).

But I can’t Just show the computer name once. It shows like this:

D40, Adobe Shockwave Player 11.5

D40, Adobe Reader X (10.1.0) - Chinese Traditional

D40, Adobe Flash Player 10 ActiveX

D40, Adobe AIR

D40, ActivClient x86

D38, Yahoo! Toolbar

D38, WordPerfect Office 12

D38, WinZip

D38, Windows XP Service Pack 3

How to show a column with a computer name once and next column with muti values?

session relevance:

(name of computer of it ,unique values of values of it) of results from (bes computers) of (bes property “Installed application”)

Thanks for help.

(imported comment written by Lee Wei)

Here is an example statement for you.

(html 
"<table border=>" & it & html 
"</table>") of concatenations of trs of ( td 
"valign=%22top%22" of name of computer of it & td of concatenation (html 
"<br>") of unique values of values of it) of results from (bes computers) of (bes property whose (name of it = 
"Installed Applications - Windows" and name of source analysis of it = 
"Application Information (Windows)"))

Lee Wei

(imported comment written by bearandy)

It’s helpful!

Thanks a lot.

(imported comment written by bearandy)

I made a session relevance to compare with two properties like this :

the function is to list applications not in wl.txt’s list.

unique values of (item 1 of it as string) of it whose ((item 1 of it as string) does not start with (item 0 of it as string)) of (unique values of values of results from (bes computer whose (name of it = “CARESYS-THINK”)) of (bes property whose (name of it = “list wl”)),unique values of values of results from (bes computer whose (name of it = “CARESYS-THINK”)) of (bes property whose (name of it = “Installed Application”)))

And I don’t know how to put it to the relevance you provided and to all the computer.

P.S. The property “list wl” relevance is “lines of file “wl.txt” of parent folder of (regapp “besclient.exe”)”

Thanks for help.

(imported comment written by Lee Wei)

This would be a good use of the Set operators.

Here are some examples.

If I have 2 sets of strings, I can use add, minus, etc to compare the sets.

q: (
"A"; 
"B"; 
"C"; 
"M"; 
"N") A: A A: B A: C A: M A: N   q:(
"M"; 
"N"; 
"X"; 
"Y"; 
"Z") A: M A: N A: X A: Y A: Z   q: elements of (set of (
"A"; 
"B"; 
"C"; 
"M"; 
"N") - set of (
"M"; 
"N"; 
"X"; 
"Y"; 
"Z")) A: A A: B A: C

Lee Wei

(imported comment written by bearandy)

Thanks for answer!

I try a example :

elements of (set of (unique values of values of results from (bes computer whose (name of it = “XXX”)) of (bes property whose (name of it = “Installappkeyword”))) - set of (unique values of values of results from (bes computer whose (name of it = “XXX”)) of (bes property whose (name of it = “list wl”))))

But it’s just for a computer.

I still don’t know how to modify it to the relevance your provided to each computer:

<?relevance concatenations of trs of ( td "valign=%22top%22" of name of computer of it & td of concatenation (html "
") of unique values of values of it) of results from (bes computers) of (bes property whose (name of it = "Installed application" and name of source analysis of it = "Installed application"))?>

Thanks for any suggestion

(imported comment written by bearandy)

I tried this to directly insert the computer name.

<?relevance concatenations of trs of ( td "valign=%22top%22" of name of bes computer whose (name of it = "XXX") & td of concatenation (html "
") of elements of (set of (unique values of values of results from (bes computer whose (name of it = "XXX")) of (bes property whose (name of it = "Installed application"))) - set of (unique values of values of results from (bes computer whose (name of it = "XXX")) of (bes property whose (name of it = "list wl"))))) ?>

I can’t figure out how to show each computer.

Any suggestion, Thanks.

(imported comment written by Lee Wei)

This is the general construct that you can try.

  • I don’t have your custom properties, so the statements are not properly tested.

  • I am cautious about fact that you are moving the white list file to the endpoints, then back to the server. Especially if they are big files.

  • These processing should be done on the endpoints, but I know that you have run into a bug.

    ( name of it, elements of ( set of (values of results from (bes property whose (name of it =
    “Installed application”)) of it) - set of (values of results from (bes property whose (name of it =
    “list wl” )) of it) ) ) of bes computers

This one has the formatting for better output and suitable for Web Reports

<?relevance concatenations of trs of (      td of name of it & td 
"valign=%22top%22" of concatenation (html 
"<br>") of unique values of elements of ( set of (values of results from (bes property whose (name of it = 
"Installed application")) of it) - set of (values of results from (bes property whose (name of it = 
"list wl"              )) of it) ) ) of bes computers ?>

Lee Wei

(imported comment written by bearandy)

I’ll try this.

Thanks so much for help, Lee Wei.

(imported comment written by bearandy)

I tried to add filter bar to filter by group.

But why some group can show the list , some group can’t.(see attachment)

Is it javascript problem?

Thanks for help.

(imported comment written by Lee Wei)

What is the relevance statement that you are using to extract the data?

You can test the results using the QNA interface in Web Reports.

http://

webreports_server:port

/webreports?page=EvaluateRelevance

Can you start a different thread as this one is getting farther away from the original question.

(imported comment written by bearandy)

I directly type the group in code is OK.

But I change to select group bar some group just show “searching”.

refer attachment

(imported comment written by Lee Wei)

What is the error that you are getting from the report?

Since you are working in JavaScript, you can see the error this way:

  • If IE9, then Menu–>Tools–>F12 developer tools–> then file the Console
  • If FireFox 10, then Menu–>Tools–>Web Developer–>Error Console

Depending on what browser and version you are using, the error location might be different

Would you mind starting a new thread for this new issue?

(imported comment written by bearandy)

It seems didn’t show any error.