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

    Dashboard for Group Node Summary Status

    johanbr

      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