Thanks a lot for the help
Query is the following and it works:
(
(concatenation %22%3B%22 of values of results (item 0 of it, elements of item 1 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 2 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 3 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 4 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 5 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 6 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 7 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 8 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 9 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 10 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 11 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 12 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 13 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 14 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 15 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 16 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 17 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 18 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 19 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 20 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 21 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 22 of it))
, (concatenation %22%3B%22 of values of results (item 0 of it, elements of item 23 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
,item 8 of it
,item 9 of it
,item 10 of it
,item 11 of it
,item 12 of it
,item 13 of it
,item 14 of it
,item 15 of it
,item 16 of it
,item 17 of it
,item 18 of it
,item 19 of it
,item 20 of it
,item 21 of it
,item 22 of it
,item 23 of it
) of (
set of bes computers
, set of bes properties whose (name of it as lowercase = (“ID”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Computer Name”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“OS”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Last Report Time”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Agent Type”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“agent version”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“CPU”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Device Type”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“License Type”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“locked”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Relay”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“BES Relay Selection Method”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“BES Root Server”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“IP Address”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Subnet Address”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“RAM”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“User Name”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Free Space on System Drive”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Total Size of System Drive”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Environment”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Relay Server 1”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Relay Server 2”) as lowercase)
, set of bes properties whose (name of it as lowercase = (“Relay Name of Client”) as lowercase)
)