Skip to main content
WARNING You're browsing the documentation for an old version of Deskpro. Consider updating to Deskpro Horizon.

How to: Export User Data

in Managing and Deleting Personal Data
Authors list
Published: May 15, 2018|Last updated: Jan 31, 2019

To export user data, go to Reports in the agent interface.

Open the Stat Builder, and click on the + ADD button.

You will see a New Stat pane open.

Give the stat a new title, and input the following:


SELECT

people_emails.person.id, people_emails.date_created, people_emails.person, people_emails.email, people_emails.person.organization.name

FROM

people_emails

ORDER BY

people_emails.person.id


Export-User-Data-1.png

Note: Running this query will give you the user name, id, email address and organization. If you need more or different fields to be captured in the export, adjust the SELECT clause accordingly. See our full DPQL Query Guide for more information.

Now click the Save button.

HelpfulUnhelpful
next pageHow to: Delete Guide Topics
previous pageHow to: Delete Agents

Please log in or register to submit a comment.