Topic
  • 2 replies
  • Latest Post - ‏2014-04-26T14:25:38Z by jgstew
Calilaugh
Calilaugh
1 Post

Pinned topic BES Relays with High Connections WebReport

‏2014-03-04T01:59:48Z |

Hi All,

I'm trying to produce a report for Relay servers with a high number of connections.  Currently I use QNA in webreports and use " (it, multiplicity of it) of an unique values of relay servers of bes computers".  How do I create a webrerpot that will send me this information automatically and produce the output in descending order. I'm still new to TEM.  Thank You!

 

  • TJessee
    TJessee
    12 Posts

    Re: BES Relays with High Connections WebReport

    ‏2014-04-25T16:46:07Z  

    In your reports, create a custom report with this

    <?relevance
    (
     html "<table border=1 style=%22border-collapse; collapse; border: medium none; %22>" &
     html ("<th>Relay</th><th>Clients</th>") & it &
     html "</table>"
    )
    of concatenations of trs of
    (
     td of it &
     td "align=left" of (multiplicity of it as string)
    )
    of unique values of relay servers of bes computers
    ?>

  • jgstew
    jgstew
    33 Posts

    Re: BES Relays with High Connections WebReport

    ‏2014-04-26T14:25:38Z  

     

    you can filter the report to only contain relays with connections over a certain threshold:

     

    (it, multiplicity of it) of an unique values whose(multiplicty of it > 1000) of relay servers of bes computers