so, SQL Agent jobs and windows tasks are able to query the environment and come back with the number of "objects" to monitor.
Right now, SW component checks are limited to 10 sets of result pairs. The SQL User Experience monitor - Query only allows 1 result pair.
What we need is the ability to dynamically generate a grid like SQL agent jobs or Task scheduler.
I understand that there would need to be a uniqueID for each row to ensure data integrity; this would be accomplished in the setup of the grid perhaps
Maybe this could behave somewhat like the "list resources on a node" where it allows you to check off the rows that are returned...