Aggregating Running Applications information for servers

Reporting
1

(imported topic written by sminisini91)

Hi,

i’m trying to get a list of unique values of running applications and a list of all the servers where this application is running and the publisher of the application something like:

BESClient.exe; host1, host2, host3; BigFix Inc

firefox.exe; host2; Mozilla Corporation

iexplore.exe; host2, host3, Microsoft Corporation

.

.

.

.

The computer property report does something very similar but i need to export the data programatically so was thinking of using SOAP and to have one line per running applications, aggregating the servers on the same line.

I haven’t gone anywhere with this, I don’t even know how i can just extract the name of the application. I tried this:

((unique values of results(it, bes property “Running Applications”) as string), names of it) of bes computers whose (name of it as lowercase starts with “cp”)

but i get: Error: The operator “unique values” is not defined.

Any help ould be appreciated.

2

(imported comment written by SystemAdmin)

Hey sminisini,

Your session relevance is very close, the “unique values” inspector operates on a list of strings, but “results” returns a list of bes property results. To get the string values of the property results, you need the "value of " inspector. You expression will look like this:

((unique values of values of results(it, bes property “Running Applications”) as string), names of it) of bes computers whose (name of it as lowercase starts with “cp”)

Hope that helps.

-Zak

3

(imported comment written by sminisini91)

Hey Zak,

Thanks for that, however i realized this is not exactly what i wanted to do. I wanted something like:

(computer1, computer2, computer3), (“BESClient.exe”, “BigFix Inc”)

(computer4, computer5), (“Firefox.exe”, “Mozilla Corporation”)

so i tried that:

(names of item 1 of it, unique values of values of item 0 of it) of (results of bes properties whose (name of it as lowercase = “running applications”), bes computers whose (name of it as lowercase starts with “cp”))

and it came back with :

Error: The expression could not be evaluated for an unknown reason.

I know you can get the value count but i need the actual host names… is it possible with some session relevance?