I have created a SWQL WEB UI for our operations center below is the custom Query that allows them to acknowledge the Alert and add a Note. The last piece I am missing is a column [DOWNSTREAM] that shows the count (#?) of unreachable children for each node and I want to sort by this DOWNSTREAM count. When you click on the count (#?) I want it to show the DOWNSTEAM node names. Is this possible with SWQL or SQL?
