Web Reports QNA with custom property

Reporting
1

(names of it, ids of it, last report time of it, operating systems of it) of bes computers returns x computers

The same query with an additional custom property returns much lesser, like x/10.

(names of it, ids of it, last report time of it, operating systems of it, values of results from (BES Property “System lifecycle”) of it) of bes computers

On the Webreports->Computers, adding the custom property returns all the computers (x)

So, what am I missing in QNA, any ideas? Is there a way to see the query executed by the Webreports->Computers after adding the property to it?

2

The short answer is that when you pluralize items in a tuple like this, the results will be limited to those objects that contain results for each of the items. Try something like the following:

(names of it, ids of it, last report time of it, operating systems of it, value of result from (BES Property "System lifecycle") of it | "n/a") of bes computers

3 Likes
3

Worked perfectly. Thanks Aram

1 Like