About custom SQL query in OpsCenter Analytics
In OpsCenter, you can create reports by directly running SQL queries. Using this report creation option, you do not need to go through multiple parameter selections.
OpsCenter provides detailed information about the OpsCenter database schema that you may want to know before running any SQL query to generate reports. On the Report Wizard > SQL Query page, click the OpsCenter Schema Document link to open the PDF that contains all relevant information.
Note:
You can create only tabular reports by running SQL queries. You can also run stored procedures using this feature.
See About supporting OpsCenter custom reports and custom SQL queries.