Lowell (1/29/2015)
i have a dashboard, that pulls multiple sub reports from a couple of central tables;those tracking tables get populated by queries/sql jobs that grab statistics and insert them into the table.
so they don't query other reports, but a central repository of various stats that get assembled.
is that what you are after?
or you really want to check other dashboards?
Thanks for the reply, Lowell. As in my other reply, this is likely the solution (to load in the data and report back out on it), but I was trying to get DMV queries to execute in real-time against a dynamic list of instances and report back on health, and roll that status up on-the-fly.
Show just a list of applications and their statuses.
App 1 - Red
App 2 - Green
App 3 - Green
Click on App 1 and see the following:
App 1 (Red)
--Instance 1: Green
--Instance 2: Red
--Instance 3: Green
Click on App 2 and see the following:
App 2 (Green)
--Instance 1: Green
--Instance 2: Green
--Instance 3: Green
Click on App 3 and see the following:
App 3 (Green)
--Instance 1: Green
--Instance 2: Green
--Instance 3: Green