This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Struggling!! I need a basic report showing the output of a SQL query.

I'm struggling here...

All I need is a report showing the output of a SQL query. The output will have 3 columns and can have anywhere from 0 rows to 100+ rows. Report will run once a day. I cannot figure out for the life of me how to create a report with this. Please someone help!!

Top Replies

Parents

0 shuth over 1 year ago
If you're talking about the SAM SQL User Experience Monitor, then it only supports 2 values and won't do what you're asking:

Statistic - the first cell (first row/column of data) returned by the query - this must be a number

Message - the cell in the second column / first row returned by the query - optional, can be text

If you're talking about a SQL query pulling data from the SolarWinds database, then you'll need to provide more information.
Cancel
Vote Up +3 Vote Down

Cancel

Reply

0 shuth over 1 year ago
If you're talking about the SAM SQL User Experience Monitor, then it only supports 2 values and won't do what you're asking:

Statistic - the first cell (first row/column of data) returned by the query - this must be a number

Message - the cell in the second column / first row returned by the query - optional, can be text

If you're talking about a SQL query pulling data from the SolarWinds database, then you'll need to provide more information.
Cancel
Vote Up +3 Vote Down

Cancel

Children

No Data