Multiple property query

Reporting
1

I’m trying to write the most efficient way to pull back multiple bes properties of a computer (across 10s of thousands of clients), but only some computers, but i’m having issues with combining 2 property filters at the end (

    (name of computer of it,
values of results from (bes properties whose (name of it = "DNS Name")) of computer of it,
values of results from (bes properties whose (name of it = "RAM")) of computer of it,
values of results from (bes properties whose (name of it = "Location By IP Range")) of computer of it,
values of results from (bes properties whose (name of it = "Locked")) of computer of it) of results whose (value of it contains "Yes") of bes properties whose (name of it = "Locked") of results whose (value of it as contains "1024") of bes properties whose (name of it = "RAM")

Any suggestions? I found reporting on the …of bes properties… seems to be faster than …of bes computers…
thanks

2

Our environment doesn’t have the Location by IP Range properties but I tested against:

(name of it, value of results from (bes property "DNS Name") of it, values of results from (bes property "RAM") of it) of bes computers whose ((value of result from (bes property "RAM") of it contains "1024") )

and this returned a nice list of Computer Name, DNS Name, and RAM properties from computers who have 1024 RAM.

So you probably want something along these lines:

(name of it, value of results from (bes property "DNS Name") of it, values of results from (bes property "RAM") of it, values of results from (bes property "Locked") of it, value of results from (bes property "Location By IP Range") of it) of bes computers whose ((value of result from (bes property "RAM") of it contains "1024") AND (value of result from (bes property "Locked") of it contains "Yes"))

Note that this may still throw an error if a computer does not have a result to return so you may have to add some error checking to see if a value does exist and if it doesn’t, then have it return something. Example Session Relevance Help

2 Likes
3

this works, but is only returning results from out of the 4 datasources in our WebReports. I’ve updated it to be (bes properties) but still only outputs computers from 1 source.