Content Authoring-Web Reports

I am trying to create a custom report that does the following:

  1. Checks the computers OS
  2. Checks the device type
  3. Checks a certain property (Concept) and groups according to this.

So part 1 and 2 I have managed to do ok.
part 3, I am stuck at refining the Relevance
I have this:

                    ***<?Relevance number of (bes computers) whose (exist bes properties whose (name of it =  "Concept"))  ?>***

This returns all the computers.
I want to limit the results to computers which have Concept = Babyshop.

How can I do this?
I have tried using the ‘value’ but its not working.

Thanks

Here’s an example that counts the number of computers with a particular version of the BES Client.

number of values whose (it = "9.2.6.94") of results(bes computers, bes property "BES Client Version")

Yours could be something like

number of values whose (it = "Babyshop") of results(bes computers, bes property "Concept")

I’m using the <bes property result> inspector

Thanks a lot for this Taylor. :smile:

Now if I want to count computers that match 2 properties, how can I edit this?
When I use this:

number of (values whose (it = "9.2.5.130") of results(bes computers, bes property "BES Client Version"), values whose (it = "Server") of results(bes computers, bes property "Device Type"))

Its giving me the wrong count (3*3) instead of 3

Thanks.

number of bes computers whose (value of result(it, bes property("BES Client Version")) = "9.2.6.94" AND value of result (it, bes property("Device Type")) = "Server")

Hi Taylor,

This worked like a baby :smile:

Much appreciated and Thanks a lot.