0 Replies Latest reply on Jul 19, 2017 2:48 PM by johanbr

    Dashboard for Group Node Summary Status


      I am busy with a new implementation for a large retail organisation that have multiple store chains.

      The client wants a dashboard that display a summary of his nodes by Store chain.


      I have grouped the servers and routers on the various Store Chains so I need something that look similar like this:


      Store Chain                 Routers               Up              Down

      Store x                           100                    90                  10

      Store y                             60                    55                   5

      Store w                             80                    70                   10


      I am battling to build this with a dynamic query and was wondering if I can't do it with a SQL query


      Please advise


      Many Thanks