Display custom SQL report on the Orion web as a Resource view

This article describes how to display results from a custom SQL query in a widget within a view in the Orion Web Console.

1. Open the Orion Report Writer.
2. Click New.
3. Click Advanced SQL.
4. Execute your custom query.

   See the Report Lab in THWACK for tips.

5. Save the generated report.
6. In the Orion Web Console, navigate to the view where you want to add a widget for the report.

   To learn more about adding widgets, see the Orion Platform Administrator Guide.

7. Click Customize page > Add Widgets > Reports.
8. Click Custom List of Reports to add that widget.
9. Return to the view to which you are adding the widget and click Edit.
10. Edit the Title and Subtitle for the widget, as necessary, and then select the report that you want to display in the widget.
11. Click Submit to save changes to the widget.