I have appinsight for sql on our databases but i'm wanting to pull a report with all of the "Clustered With" information for the instance name. I've been looking through building a report for this but unable to figure out how.
Create a report with SQL, information is found in the APM_SqlBbClusterNode table. Just group them by instance (a.name) in case you don't have multiple with the same name, or group them by ApplicationID. You'll have to work on it a little depending how you wish to see the info and what is relevant to you.
select acn.nodename, acn."current", a.name, acn.ApplicationID
from APM_SqlBbClusterNode acn
left join APM_Application a on a.ID=acn.applicationid
This is exactly what i was wanting. Thank you for the info.
