# Having an Issue exporting users WITH last login field **URL:** \ **Category:** Get Help\ **Tags:** user-profile, user-management\ **Created:** [November 27, 2025, 3:38am UTC](https://community.auth0.com/t/having-an-issue-exporting-users-with-last-login-field/194970 "2025-11-27T03:38:56Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![alex56](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/alex56/32/71515_2.png) [@alex56](https://community.auth0.com/u/alex56)\ **Post date:** [November 27, 2025, 3:38am UTC](https://community.auth0.com/t/having-an-issue-exporting-users-with-last-login-field/194970/1 "2025-11-27T03:38:56Z")
I have tried the import / export tool but it returns nothing for last\_login Only the user id field is returned. I have also tried the bulk export functionality from the app adding last\_login, no luck. When I export as a CSV without specifying any fields, I get the column for last\_login, and 1800 empty rows. But adding the last\_login then gives me an empty column. Tried using the management API, but it limits me to 1000 paged records so this is no use either. ---
**Author:** ![vlad.murarasu](https://sea1.discourse-cdn.com/auth0/user_avatar/community.auth0.com/vlad.murarasu/32/72793_2.png) [@vlad.murarasu](https://community.auth0.com/u/vlad.murarasu)\ **Post date:** [November 27, 2025, 2:04pm UTC](https://community.auth0.com/t/having-an-issue-exporting-users-with-last-login-field/194970/3 "2025-11-27T14:04:01Z")
Hi @alex56, Welcome to the Auth0 Community! The root cause of your issue is that the last login information is stored in the user metadata and not in the root user object that the bulk export tool directly queries. The bulk export requires you to explicitly select fields from the root user profile, which is why simply adding `last_login` doesn’t work. For the Management API, the 1000-record limit per page is a default, but it can be overcome by using pagination. We have two robust solutions for you, depending on whether you prefer a fully-automated API approach or a manual dashboard one. ### 1. **Recommended: Use the Management API with Pagination** This is the most direct and reliable way to get all your users and their full profiles. You must use the `page` and `per_page` parameters in your requests to iterate over your user base. - **Endpoint:** `GET /api/v2/users` > **[Auth0 Management API v2](https://auth0.com/docs/api/management/v2/users/get-users)** - **Steps:** 1. Start with `page=0` and set `per_page` to a maximum value of `100` (or `50` for better stability). 2. Include the `include_totals=true` parameter in your first request to find out the total number of users. 3. In your request, specify the fields you need, including `last_login`. You may need to use `fields=user_id,last_login,name` (or whatever fields you need) and `include_fields=true`. 4. Make a subsequent request, incrementing the `page` number by 1, until you have retrieved all users. **Example Request Flow (Conceptual):** 1. Request 1: `GET /api/v2/users?page=0&per_page=100&include_totals=true` 2. Request 2: `GET /api/v2/users?page=1&per_page=100` 3. … and so on. ### 2. **Manual Solution: User Export Tool (Alternative Field Selection)** If you still prefer the dashboard tool for a quick, one-off export, try these steps: 1. Go to **Dashboard \> Users & Roles \> User Export**. 2. Select **CSV** as the format. 3. In the “Fields to Include” box, try specifying the exact path to the `last_login` field if it’s nested. If the bulk export is **not** picking up the root `last_login` field, your only reliable option is the Management API (Solution 1), as the dashboard export tool has known limitations with non-root profile fields. **The API is the source of truth.** If you have any further questions, please don’t hesitate to reach out. Have a good one, Vlad ---
**Author:** ![system](https://global.discourse-cdn.com/auth0/original/3X/b/5/b560f266932fcce5d57f09a6595bd50518cae3f3.jpeg) [@system](https://community.auth0.com/u/system)\ **Post date:** [December 11, 2025, 2:04pm UTC](https://community.auth0.com/t/having-an-issue-exporting-users-with-last-login-field/194970/4 "2025-12-11T14:04:58Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.