# Get a list of users per day

**URL:** <https://community.auth0.com/t/get-a-list-of-users-per-day/61839>\
**Category:** Get Help\
**Created:** [April 27, 2021, 1:18pm UTC](https://community.auth0.com/t/get-a-list-of-users-per-day/61839 "2021-04-27T13:18:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![vincentbell](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/vincentbell/32/29073_2.png) [@vincentbell](https://community.auth0.com/u/vincentbell)\
**Post date:** [April 27, 2021, 1:18pm UTC](https://community.auth0.com/t/get-a-list-of-users-per-day/61839/1 "2021-04-27T13:18:41Z")

</div>

First of all, not a developer so I’m very new to the lingo. I have basic knowledge.

We currently use the free plan for a simple service that requires a passwordless login process.  
Our users type in their email and gets a code to their email that they use to get access to our service/website.

I’d like an easy way to export or list the email addresses that successfully got a code and managed to log in on a given day or a period of days. I’ve looked in the log files but I can’t figure out how to export the data. When I filter it doesn’t work.

I’d be very grateful for any suggestions.  
Thank you!

---

<div class="post-metadata">

**Author:** ![stephanie.chamblee](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/stephanie.chamblee/32/26087_2.png) [@stephanie.chamblee](https://community.auth0.com/u/stephanie.chamblee)\
**Post date:** [April 27, 2021, 2:25pm UTC](https://community.auth0.com/t/get-a-list-of-users-per-day/61839/3 "2021-04-27T14:25:34Z")

</div>

Hi @vincentbell,

Welcome to the Community!

You can filter results by event type using the [event code](https://auth0.com/docs/logs/log-event-type-codes). For example, querying for a successful login would be `type:s`.

You can use this query in the dashboard UI or use the Management API’s [GET](https://auth0.com/docs/api/management/v2?_ga=2.246162692.1847387816.1618225160-1595415333.1607347674#!/Logs/get_logs)[/api/v2/logs](https://auth0.com/docs/api/management/v2?_ga=2.246162692.1847387816.1618225160-1595415333.1607347674#!/Logs/get_logs) endpoint:

```auto
https://YOUR_DOMAIN/api/v2/logs?include_totals=true&take=100&q=type%3As

```

However, there are a couple limitations:

- You must paginate results for a max of 100 logs per request
- You can only paginate for up to 1,000 log entries per search criteria

If you require more data then these limitations allow, you can either:

- Use the [retrieve logs by checkpoint method](https://auth0.com/docs/logs/retrieve-log-events-using-mgmt-api#retrieve-logs-by-checkpoint)
- Use Auth0’s Log Stream service to export logs to a URL or another service: [Log Streams](https://auth0.com/docs/logs/streams)

---

<div class="post-metadata">

**Author:** ![vincentbell](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/vincentbell/32/29073_2.png) [@vincentbell](https://community.auth0.com/u/vincentbell)\
**Post date:** [April 29, 2021, 1:00pm UTC](https://community.auth0.com/t/get-a-list-of-users-per-day/61839/4 "2021-04-29T13:00:27Z")

</div>

Thank you very much @stephanie.chamblee . I appreciate your swift reply.

So I managed to use “type:s” and only got successful logins, but is there a way to export to an excel or csv?

---

<div class="post-metadata">

**Author:** ![stephanie.chamblee](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/stephanie.chamblee/32/26087_2.png) [@stephanie.chamblee](https://community.auth0.com/u/stephanie.chamblee)\
**Post date:** [April 29, 2021, 1:04pm UTC](https://community.auth0.com/t/get-a-list-of-users-per-day/61839/5 "2021-04-29T13:04:15Z")

</div>

Hi @vincentbell,

Unfortunately, there isn’t a way to export logs from the dashboard. It would be great to hear about your use case in a feature request in our feedback category:

> **[Feedback](https://community.auth0.com/c/feedback/95)**
>
> Submit and vote on product feedback and feature requests.

The current options would be to either [set up a 3rd-party logging service integration](https://auth0.com/docs/logs/streams?_ga=2.209413009.2045786806.1619351559-1595415333.1607347674) or write a script that uses the [Management API logs endpoint](https://auth0.com/docs/logs/retrieve-log-events-using-mgmt-api?_ga=2.209413009.2045786806.1619351559-1595415333.1607347674#retrieve-logs-by-checkpoint) to generate a CSV.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/auth0/original/3X/b/5/b560f266932fcce5d57f09a6595bd50518cae3f3.jpeg) [@system](https://community.auth0.com/u/system)\
**Post date:** [May 14, 2021, 1:04pm UTC](https://community.auth0.com/t/get-a-list-of-users-per-day/61839/6 "2021-05-14T13:04:24Z")

</div>

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.
