Question – Resetting User IDs and Cleaning Up the Database Without Full Reinstall

[Domme0506]

I have imported users multiple times via LDAP in the past, which caused the user IDs to start at around 2000 instead of continuing from the last available lower number.

User ID Reordering
Is it possible to reorder or reassign user IDs so that they are continuous (without large gaps), and move users with very high IDs down to the next available free IDs?
For example, moving a user with ID 2001 to ID 15 if IDs 1–14 are already taken.

Database Cleanup
Is there a way to completely remove all assets — including ones that have been deleted in the UI but still exist in the database — as well as all related history, without creating a brand-new database from scratch?
The goal would be to end up with an “empty” system in terms of assets and history, but still keep:

All users

Categories

Other important configuration settings

Essentially, I want to reset the inventory part of the system while keeping the core setup and user accounts intact.

Version v8.2.2-pre - Build 19319 (develop) / Win Server 2022 / IIS 10 / PHP 8.4.11 / git install

[snipe]

User ID Reordering

Not without breaking everything :( Also User IDs are internally used by Snipe-IT, otherwise not important, so their numbering shouldn't matter.

Is there a way to completely remove all assets — including ones that have been deleted in the UI but still exist in the database — as well as all related history, without creating a brand-new database from scratch?

https://snipe-it.readme.io/docs/purging-soft-deletes#/

To wipe everything, use php artisan db:wipe