UniFi Mongo Queries - sprocktech/ubi-tools GitHub Wiki

Querying the UniFi Mongo DB

By default, the Mongo DB for UniFi Network runs on localhost, port 27117.

Note: The --quiet switch is optional, but useful when piping to jq for instance

mongo --quiet localhost:27117/ace --eval 'db.site.findOne({name:"abcdefgh"})'

Useful Queries

Find site by name used in URL

db.site.findOne({name:"abcdefgh"})

Find site by description set in configuration

Note: This is what is set as 'Site Name' in the configuration

db.site.findOne({desc:"Site"})

Reset admin password

Note: This sets the admin account with the name 'admin' to use 'password' for the password

db.admin.update({name:"admin"},{$set:{x_shadow:"$6$9Ter1EZ9$lSt6/tkoPguHqsDK0mXmUsZ1WE2qCM4m9AQ.x9/eVNJxws.hAxt2Pe8oA9TFB7LPBgzaHBcAfKFoLpRQlpBiX1"}})

Delete invalid connectivity settings

db.setting.deleteMany({key:"connectivity",site_id:{$exists:false}})