Device Export Shows Duplicate Entries and Incorrect Total Count: Sort by Device Name to Avoid Batch-Order Race Condition

Android

Title: Device export contains duplicates or wrong count — sort by Device Name to fix

When exporting your device list from the Esper Console, the resulting file may contain duplicate device entries, missing devices, or a total row count that does not match what the Console displays.

Why this happens

The export is generated in batches, not as a single snapshot. When the list is sorted by Last Updated (the default), online devices continuously shift position in the sort order as they send heartbeats to Esper. As each new batch is fetched, devices that moved between batches are either counted twice or skipped entirely. The number of duplicate entries and missing entries will always be equal. Your actual device records are unaffected — this is an export artifact only.

Steps to resolve

1. In the Esper Console, navigate to Devices & Groups.
2. Locate the column header row and click Device Name to sort by that column. Device Name is static and does not change while the export runs, which eliminates the batch-order shift that causes duplicates.
3. Confirm the sort indicator shows Device Name is the active sort column before proceeding.
4. Select Export and choose your preferred format (CSV or Excel).
5. Open the downloaded file and check the total row count, excluding the header row.

Verify: The row count in the exported file should match the total device count shown in the Devices & Groups header in the Esper Console. To confirm no duplicates remain, select the Device ID column in Excel and run Data → Remove Duplicates — the result should report zero duplicates removed.

If this doesn't resolve it

If duplicates persist after sorting by Device Name, or if the total count displayed in the Esper Console itself appears incorrect, contact Esper Support and include the following:

• The exported file
• The sort column and sort direction used at the time of export
• The timestamp of the export
• The Device Name and Device ID for any confirmed duplicate entries

Still need help?

If you continue to experience duplicate entries or incorrect counts in device exports, please submit a support ticket and include your export filters, the number of devices in your fleet, and whether you've already applied the device name sort workaround.