Den Delimarsky

I am an engineer working on API documentation, security and machine learning.

github twitter linkedin email rss
Pulling Ubnt Stats Locally
Dec 28, 2017
2 minutes read

Ubnt Stats

I love looking at my Ubnt graphs - how much traffic goes where, to what clients, and many other interesting indicators. But I am also the kind of person that loves having raw access to the data, so I started digging - how can I pull those statistics locally?

The setup I run is described here - I have a cloud key that manages the network, composed of a router acting as a switch, access point and the security gateway. So, when I am thinking about the data aggregated, I think of the cloud key, that stores it. Some more digging points that the data is likely managed by a MongoDB instance - that should be easy.

To see what I can dig up, I SSH into the cloud key:

ssh ubnt@192.168.1.9

Going through /usr/bin reveals what we would expect:

SSH into the Ubnt cloud key

This means that we can also easily dump data out. The MongoDB instance is running on port 27117 and the database we are looking for is called ace_stat:

/usr/bin/mongodump -d ace_stat -o /home/datadump -port 27117

Dump data

If all goes well, now you should have the data dump ready on the key. You now can export it to the local machine (the one you SSH-d out of):

scp -r ubnt@192.168.1.9:/home/datadump /Users/targaryen/Downloads/ubnt-data

You should now have the complete data dump locally:

Content of the data dump

Time to view the data locally! For that, make sure that you install MongoDB first on your local computer. Instructions may vary depending on the platform, so I will leave it up to you to follow the right set of steps from official documentation.

I like to have a GUI for my data, so given that I am working on a Mac, I downloaded and installed Robo3T.

To import the data, make sure that the MongoDB server is running (typically can be done by running mongod --dbath {PATH_TO_SOME_DATA_DIRECTORY}). Once it’s up, just run the import command:

mongorestore -d ace_stat ubnt-data/ace_stat

You are specifying the new database, and the source of the backup. Now, when you go to a tool, like Robo3T, you can see all the stat data, in the ace_stat database:

Screenshot of data

Now you are in posession of the data snapshot! Next on my TODO list is to create a scheduled job that will pull the data, re-format it in a more consumable format (e.g. CSV) and plug it into an analytics platform.

Cheers!


Back to posts