How to Flush Old Users & Statistics

Issue:

We have our UniFi Controller that has a large number of old client devices still showing under Clients menu and I want to flush these out of the system as they are no longer required.

The Statistics menu has a "Clear All Statistics" button but this only flushes the current usage statistics.

How do I remove all the old details as well?

Solution:

The following link allows you to prune all the statistics and old users 

https://help.ubnt.com/hc/en-us/articles/204911424-UniFi-How-to-remove-prune-older-data-and-adjust-mongo-database-size

but if you are having issues we have simplified the issue for you.

Attached is a zip file that should be extracted to "c:\prune" directory.

Once extracted:

* Edit the "mongo_prune_js.js" file with any text editor and change the "var days=x" value to the number of previous days to prune.

* Run the "delete_stats.bat" file.

This will remove all old statistics & users and clean up the database.

Once it has finished stop and restart the UniFi Controller.

You should now see all the old statistics have been removed.

Note:

You must have the Controller running when running the batch file.

You should make a backup of your UniFi Controller before running this script.

This is based on the 64bit version of MongoDB msi