Rob's Blog

Nokia Altiplano – Database Query to list quantity of ONTs provisioned on each PON port

23rd September 2024 No Comments

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

4th September 2024 No Comments

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

4th September 2024 No Comments

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

4th September 2024 No Comments

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

22nd August 2024 No Comments

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

12th August 2024 No Comments

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

9th May 2024 No Comments

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

30th October 2020 1 Comment

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

14th October 2018 No Comments

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…

Alpine IXA-W404R Head Unit Optional Modules / Accessories

28th January 2018 No Comments

I recently picked up one of these head units very cheap from Facebook Marketplace. It appears to be a very modular unit with many accessories available for it. In fact…

Rob's Blog

This is stuff.

Nokia Altiplano – Database Query to list quantity of ONTs provisioned on each PON port

Nokia Altiplano – Database query to output summary count of different ONT models

Nokia Altiplano – Database query to compare ont intents vs l2-user intents

Nokia Altiplano – Database query to retrieve l2-user details from intent

LibreNMS – Database query to export list of outages for past 12 months

Nokia Altiplano – Database query to retrieve ONT details from intent

Fix for Siemens Gigaset phones not ringing with Grandstream HT801/HT802 VoIP ATA

Renaming video files from get_iplayer for easy import into Sonarr

How to reset UniFi controller admin password, without email, including 32bit

Alpine IXA-W404R Head Unit Optional Modules / Accessories

© 2024 Rob's Blog