Share this page

# Run SQL queries from Web UI

You can run database queries directly against the OpenText PPM database schema from Web UI.

In this topic:

## Prerequisites

To run SQL queries from Web UI, you must have all of the following:

- The Configuration license

- The Sys Admin: Server Tools: Execute Admin Tools access grant

- The Sys Admin: Server Tools: Execute SQL Runner access grant

## Run SQL statements from Web UI

When running SQL statements from the standard interface, you can run a statement that ends with a semicolon (;).

To run a SQL statement (select statement only) from the standard interface:

1. From the masthead, click the Administration button .

2. From the Administration menu, click Support Task > SQL Runner.

3. In the SQL Statement box, type the select statement to run against the OpenText PPM database.

   To resize the edit window, drag the border of the SQL statement box. To enter the full screen edit mode, press F11.

4. Click Run SQL to run the SQL statement.

   You can also press CTRL+ENTER to run the statement, or press CTRL+DOWN or CTRL+UP to cycle through previously run SQL statements. Click below the SQL statement box to learn about the details.

   The results grid lists the query results in numbered rows.

5. You can create a dashboard data source and list portlet from the SQL statement. For details, see Create dashboard data sources and list portlets from SQL Runner page.

## Export SQL run results

You can export the SQL run results to a .csv file, a text file, or an Excel file. If you export the results, any sorting and grouping you perform in the Administration Console is discarded. Only the raw results are exported.

To export the results:

1. Right-click on the results grid.
2. Click Export from the dropdown menu, and select the file format to which you want to export the data.

## SQL statement execution details

To view the performance details, click to display the Execution Details section.

The Execution Details section provides the following information:

Value | Description
--- | ---
Database Roundtrip | The time spent (in milliseconds) between the PPM Server and the OpenText PPM database. Note: In the PPM Workbench, the Server Roundtrip value represents the time spent between the PPM Workbench client and the PPM Server). In either context, the measure is a good indication of measure network latency.
ResultSet Extraction | The amount of time (in milliseconds) required to extract results from the results set.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: