Here’s some sample session relevance that returns the desired properties, and computer group information, in a more efficient single query, for devices that have reported in within the last 24 hours (again, this is based on the methods described in Efficient Session Relevance Query for Computer Properties):
(
(concatenation “;” of values of results (item 0 of it, elements of item 1 of it))
, name of item 0 of it | “missing name”
, (concatenation “;” of values of results (item 0 of it, elements of item 2 of it))
, (concatenation “;” of names of bes computer groups of item 0 of it)
, (concatenation “;” of values of results (item 0 of it, elements of item 3 of it))
, (concatenation “;” of values of results (item 0 of it, elements of item 4 of it))
, (concatenation “;” of values of results (item 0 of it, elements of item 5 of it))
, (concatenation “;” of values of results (item 0 of it, elements of item 6 of it))
, (concatenation “;” of values of results (item 0 of it, elements of item 7 of it))
) of (
elements of item 0 of it
,item 1 of it
,item 2 of it
,item 3 of it
,item 4 of it
,item 5 of it
,item 6 of it
,item 7 of it
) of (
set of BES computers whose (last report time of it > (now - 24 * hour))
, set of bes properties whose (name of it as lowercase = (“ID”) as lowercase AND reserved flag of it)
, set of bes properties whose (name of it as lowercase = (“OS”) as lowercase AND reserved flag of it)
, set of bes properties whose (name of it as lowercase = (“_PG_pcserialnumber”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“_PG_Manufacturer”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“_PG_pcmodel”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“_PG_LastUser”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“_PG_ImageType”) as lowercase)
)
And the same query collapsed:
((concatenation ";" of values of results (item 0 of it, elements of item 1 of it)), name of item 0 of it | "missing name", (concatenation ";" of values of results (item 0 of it, elements of item 2 of it)), (concatenation ";" of names of bes computer groups of item 0 of it), (concatenation ";" of values of results (item 0 of it, elements of item 3 of it)), (concatenation ";" of values of results (item 0 of it, elements of item 4 of it)), (concatenation ";" of values of results (item 0 of it, elements of item 5 of it)), (concatenation ";" of values of results (item 0 of it, elements of item 6 of it)), (concatenation ";" of values of results (item 0 of it, elements of item 7 of it))) of (elements of item 0 of it,item 1 of it,item 2 of it,item 3 of it,item 4 of it,item 5 of it,item 6 of it,item 7 of it) of (set of BES computers whose (last report time of it > (now - 24 * hour)), set of bes properties whose (name of it as lowercase = ("ID") as lowercase AND reserved flag of it), set of bes properties whose (name of it as lowercase = ("OS") as lowercase AND reserved flag of it), set of bes properties whose (name of it as lowercase = ("_PG_pcserialnumber") as lowercase), set of bes properties whose (name of it as lowercase = ("_PG_Manufacturer") as lowercase), set of bes properties whose (name of it as lowercase = ("_PG_pcmodel") as lowercase), set of bes properties whose (name of it as lowercase = ("_PG_LastUser") as lowercase), set of bes properties whose (name of it as lowercase = ("_PG_ImageType") as lowercase))