cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

Create a Web Based Report from a Custom SQL Query

Jump to solution

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.?

Labels (2)
0 Kudos
1 Solution

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

View solution in original post

6 Replies
Level 12

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

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

0 Kudos

@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.

 

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! 😁)

0 Kudos

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

View solution in original post

I think I need a holiday as I am going blind! Sorry for wasting your time guys but much appreciated! 🙄

0 Kudos