# Audit Log export displays query result values

**URL:** https://speciforum.org/t/audit-log-export-displays-query-result-values/990
**Category:** New Feature Requests
**Created:** [January 13, 2023, 6:30pm UTC](https://speciforum.org/t/audit-log-export-displays-query-result-values/990 "2023-01-13T18:30:20Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)
#### Post date: [January 13, 2023, 7:43pm UTC](https://speciforum.org/t/audit-log-export-displays-query-result-values/990/3 "2023-01-13T19:43:23Z")

</div>

Hi @Plarson,

I have added a feature request for this on our GitHub issue tracker:

> <https://github.com/specify/specify7/issues/2814>
>
> \<img width="2558" alt="image" src="https://user-images.githubusercontent.com/372…56050/212402312-0dbe64d7-4ddb-40ae-8463-73a5fcd8b010.png"\>
> 
> \<img width="923" alt="image" src="https://user-images.githubusercontent.com/37256050/212404879-c9110792-8104-42ec-bb21-8a0da77a672a.png"\>
> 
> \[query\_results\_2023-01-13T19 25 25.499648.csv\](https://github.com/specify/specify7/files/10414784/query\_results\_2023-01-13T19.25.25.499648.csv)
> 
> \> \*\*\[Plarson:\](https://speciforum.org/t/audit-log-export-displays-query-result-values/990)\*\*
> \>
> \> I use the audit log query to gather data for quarterly reports. The query results display nicely in SP7 but when I export the results, much of it is unreadable and I spend a lot of time doing 40-50 find/replace operations to convert table numbers to the table names so that I can see what’s been done over the last 3 months. It would be more useful to export the table names. Likewise with the actions and field names (user-created caption vs, e.g., “text1”).

If you would like a list of all tables and Table IDs, you can download the database schema for your database as a TSV file.

 ![DB Schema Viewer](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/a/ac6eeb7e2a63ecc3f956b4fa9d0986a38d514eac.png)

This is available in the [User Tools](https://speciforum.org/t/user-tools-menu/536#database-schema-21) menu in your Specify 7 instance.

> **Example:** [https://sp7demofish.specifycloud.org/specify/data-model/](https://sp7demofish.specifycloud.org/specify/data-model/)
> 
> **Username:** `sp7demofish`  
> **Password:** `sp7demofish`

---

_[View the full topic](https://speciforum.org/t/audit-log-export-displays-query-result-values/990)._