# Getting a report identifier from the data mart

Available in...

* Big Data Platform
* Cloud API Services Platform
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Management Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* MDM Platform
* Qlik Cloud Enterprise Edition
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

## Procedure

1. Open the Data Explorer perspective in Talend Studio.
2. In the Connections view, right-click a database connection and select New SQL Editor.
3. 
   * If you want the identifier of one report, enter the following SQL query in the editor:

     ```
     use <datamart database name>;
     /* get report UUID */ 
     select  REP_UUID, REP_LABEL  from tdq_analysis where REP_LABEL = '<report name>';
     ```

     Information noteImportant: Use the exact data mart and report names in the query.

   * If you want the identifier of several reports, enter the following SQL query in the editor:

     ```
     use talend_dq61;
     /* get report UUID */ 
     select  REP_UUID, REP_LABEL  from tdq_analysis where REP_LABEL like 'c%' 
     ```

     In this example, you want to access the talend\_dq61 data mart and get the identifiers of all the reports which start with the letter *c* .
4. Execute the SQL query.

## Results

The data explorer outputs the report names and their identifiers, three in this example. ![Report names and identifiers in the Data Explorer.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/SQLQuery_reports.png)

## What to do next

Use the identifiers in another SQL query to delete the reports.