petart - I use two methods for querying SQL into SAM.
Aside from viewing the results in the monitor's Application page, either of these methods lets you display the results in a Custom Object Resource element (again, not intuitive to learn, but doable and and excellent tool in your belt) or alternately a Custom SWQL element (ditto!)
Love to hear how others are handling this.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.