---
title: "How to export data from the database"
canonical: "https://support.appfire.com/space/SUPPORT/153453781/How%20to%20export%20data%20from%20the%20database"
format: markdown
---
The Asset Tracker application data is stored inside the **<JIRA_HOME>/data/attachments/ephorData>** folder. Please note it is an Apache Derby database, so you'll need a DBMS tool to open it. You can retrieve the data depending on your needs. For example, the Title field value is stored inside a table called **FIELDVALUES**. 

However, that table only contains the values of the fields. If you look at that table alone, it won't give you the information you need. The information is stored across other tables. To find the information, you'll need to build a **SELECT** statement to **JOIN** the information across the **FIELDVALUES**, **FIELDS,** and **FIELDDEFINITIONS** tables. 

For example, if you only wanted the **Titles** of the assets, you could use something like this:

```sql
select FV.VALUE
  from FIELDVALUES FV
  join FIELDS F
    on F.ID = FV.FIELD_FK
  join FIELDDEFINITIONS FD
    on FD.ID = F.FIELDDEFINITION_FK
where FD.TITLE = 'Title';
```