# Hoe kan ik de administratieve gegevens extraheren voor een EU AVG-verzoek?

**URL:** <https://meta.discourse.org/t/how-can-i-extract-the-adminstrative-records-for-a-eu-gdpr-request/176348>\
**Category:** Product Support\
**Created:** [17 januari 2021 om 11:24 UTC](https://meta.discourse.org/t/how-can-i-extract-the-adminstrative-records-for-a-eu-gdpr-request/176348 "2021-01-17T11:24:11Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![GuidoD](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/guidod/32/292621_2.png) [@GuidoD](https://meta.discourse.org/u/GuidoD)\
**Post date:** [17 januari 2021 om 11:24 UTC](https://meta.discourse.org/t/how-can-i-extract-the-adminstrative-records-for-a-eu-gdpr-request/176348/1 "2021-01-17T11:24:11Z")

</div>

Dear Discourse devs, admins and users.

is someone of you great folks able to help me to solve a EU GDPR request where I do have to provide the data next Tuesday?

> [@Legal Tools Plugin](https://meta.discourse.org/t/legal-tools-plugin/87966/25):
>
> it is not a problem of this great plugin but does someone know how can get this data. I do have the [data explorer](https://meta.discourse.org/t/32566?silent=true) but I do not know the structure of all database tables and in which tables I would have to look for the data and which ones I would have to join in order to get this data.

With the great tool from @angus I was already able to extract as the admin quite a lot of information for the user who requested his data. @angus had fixed the bug that I first had encountered.  
But in order to be prepared that also the 'administrative’ records with the user’s `user_id` such as flags, complaints and staff whispers might also have to be provided, what would be the best SQL statements to get the data from the database with the [data explorer](https://meta.discourse.org/t/32566?silent=true)?  
I am not so familiar with the different tables and their structure and I want to avoid that I might extract incorrect information due to my missing knowledge of the different tables and their usage.

The German authorities are quite restrict with violations against the german data protection law (based on the EU GDPR regulations) and the user requests based on this law. I want to avoid to get a penalty for my organization by the authorities.

Any help will be appreciated  
best regards  
Guido

---

_[View the full topic](https://meta.discourse.org/t/how-can-i-extract-the-adminstrative-records-for-a-eu-gdpr-request/176348)._
