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
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.
Please log in or register to submit a comment.