Bes Computers of Bes Sites

(imported topic written by netmeister91)

Trying to get some aggregate numbers for different platforms in the enterprise. Using the code below and it’s sloooow…

number of (names of bes computers whose (subscribed (all bes sites whose (name of it=“Retail Production”)) of it AND device type of it as string =“Desktop”))

This returns a value of a little over 28000… and it takes about 35 seconds. Have not got this in to a web page yet…,using the presentation debugger…Is there a better way ?

(imported comment written by liuhoting)

Why not try something like this? I think you go through bes computers twice with names of bes computers then number of it. Also with this I think the filtering gets done first.

number of subscribed computers whose (device type of it as string = “Desktop”) of bes sites whose (name of it contains “Retail Production”)