Create Column to Show How Many Clients Per Relay

(imported topic written by thesurg3on91)

When drilling down to All Computers >> By Group >> All BES Relays, I need a way to show me how many clients each BES relay is managing. Are you aware of any relevance that can be used in the Managed Properties?

Unfortunately when Using ALL Computers >> By Retrieved Properties >> By Relay, only shows you Relays that actually have hosts that they are managing. Therefore it is difficult to find relays that do not have clients pointing at them, such as DMZ computers that we cannot confirm are getting BES updates.

Any suggestions?

(imported comment written by BenKus)

Try this:

  1. Get the Excel Connector at http://support.bigfix.com/labs/excelconnect.html

  2. Open the “Session Relevance Editor” and paste in:

(it, multiplicity of it - 1) of unique values of (it as lowercase) of (if (it contains “:”) then preceding text of first “:” of it else it) of (relay hostnames of bes computers whose (relay server flag of it OR root server flag of it); relay servers of bes computers)

I think that will work…

Ben