Rob's Blog

Nokia Altiplano – Database query to count OLT SFP types

27th March 2025 No Comments

This query counts the quantity of the different SFP types provisioned on the network. It takes into account the models used for Multipon and GPON on the Lightspan platform, as…

Nokia Altiplano – Database query to list all fiber intents with no onts provisioned

12th November 2024 No Comments

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

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…

Rob's Blog

This is stuff.

Nokia Altiplano – Database query to count OLT SFP types

Nokia Altiplano – Database query to list all fiber intents with no onts provisioned

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

© 2025 Rob's Blog