Nokia Altiplano – database query to list SFP type installed in ports with no ONTs
This query is useful to easily know what SFPs are installed in the field in all those empty ports! You will need to adjust the SFP model numbers to suit…
Nokia Altiplano – Database query to count OLT SFP types
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
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. It takes into account the…
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…