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