Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Can you display the results of a SQL query in the web console?

Hello,

I am trying to figure out if it's possible to display the results of a SQL query using the "SQL Server User Experience Monitor" component in a SAM template. My query returns two columns with anywhere from 4-5 rows of data; I have edited the query to display the count as the first column for "component statistics" and the type names as the second column. It appears that the component only allows for (or only reports) the first value of the first column as statistics data and the first value of the second column as a "message". Is there a way (custom table, report, etc..) that I can get the full results of the SQL query to display in a dashboard?

Thanks,

Find more posts tagged with

Accepted answers

aLTeReGo

SAM's SQL User Experience Monitor only supports returning a single numeric value, and one optional string value. It cannot at this time be used to return an entire table of information.

All comments

aLTeReGo

SAM's SQL User Experience Monitor only supports returning a single numeric value, and one optional string value. It cannot at this time be used to return an entire table of information.

mcordero

Thanks for the information aLTeReGo, is there an "idea" I can vote on for this? I looked around the forum and saw a few other posts leaning towards this request after I posted my question.

aLTeReGo

I created one at the link below.

mcordero

You got my vote!

Thanks again,