Nokia Altiplano – Database query to list all fiber intents with no onts provisioned
Useful for checking the utilisation of your OLTs, this query will list all of the PONs which do not have any ONTs provisioned on them.
Nokia Altiplano – Database Query to list quantity of ONTs provisioned on each PON port
This query will count the number of ONTs provisioned per port. Useful for reporting and capacity planning to ensure split ratios are followed correctly. This query normalises the output of…
Nokia Altiplano – Database query to output summary count of different ONT models
This script exports a summary count showing the quantities of each model of ONT provisioned on Altiplano. This is useful when aligning support contract details and planning for upgrades.
Nokia Altiplano – Database query to compare ont intents vs l2-user intents
Used for cleaning up data, shows ONT records that don’t have corresponding l2-user entries. Be warned that the query may take considerable time to complete depending on the number of…
Nokia Altiplano – Database query to retrieve l2-user details from intent
This snippet exports a list of all l2-user details including intent name, network state, active state, UNI interface, VLAN and service profile. This is useful for backup purposes or in…
LibreNMS – Database query to export list of outages for past 12 months
This snippet of code extracts a list of device outages from a LibreNMS database that are longer than 20 minutes, over the previous 12 month period. The results display the…
Nokia Altiplano – Database query to retrieve ONT details from intent
This snippet exports a list of all ONT intents, including the intent name, fiber name, ONT model, serial number and active status. This is helpful for backup purposes or to…
Fix for Siemens Gigaset phones not ringing with Grandstream HT801/HT802 VoIP ATA
This seemed to not be documented anywhere that I was able to find, so I am posting here to hopefully help someone else in the same situation. When using any…
Renaming video files from get_iplayer for easy import into Sonarr
There may become a time where someone wants to obtain some media from the popular get_iplayer application to add to their Sonarr library. Sonarr doesn’t like importing such files by…
How to reset UniFi controller admin password, without email, including 32bit
I was recently in a situation where I needed to reset a forgotten Ubiquiti UniFi controller password. There is some forum posts on the Ubiquiti forums, but the procedure is…