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

Create a Web Based Report from a Custom SQL Query

I have various SQL queries I have been running against the DB to get custom info. Is it possible to use these as the source for a Web Based report so I can e-mail them to my teams etc.?

Find more posts tagged with

Accepted answers

christopher.t.jones123

when defining the datasource there is an option to define an SWQL/SQL query

Screen Shot 2020-06-17 at 12.35.04 PM.png

All comments

Seashore

Yes, you can have a SQL query as datasource for a report

shocko

Thanks! Could you give me an example of how to set this up?

dunky2k

@shocko

From the Reports Menu select All Reports, then in the top right of the page select 'Manage Reports'

From this page, select the option to create a new report and follow the wizard.

It should be fairly self explanatory when you see it, to get it to email someone or a group of people you will need to setup a schedule with actions, with email being one option.

shocko

OK so I wish to build a custom table so I select the 'Custom Table' resource then 'Add Content' to define my DataSource. SO where do I define the custom SQL query I have built? AM I being dense (very possible! )