Fixed Telecommunications Network Company: Maintenance: Special Scripts & Data from Database

Home » Maintenance » Special Scripts & Data from Database

Access: AMS access scripts.
Telegram: Script for Telegram BotFather to build department and section specific channels and groups

Specially formated scripts ready for upload and execution on different network elements.

AMS Scripts

SQL Scripts

Insert missing access entries by using statistical address estimation generated from service request order addresses and current ONT and NDD position

Special Purpose Data from SQL Queries

ONTs with no subscriber DNs assigned: (ip, ont_id)
Connections with no IP assigned (IP = 0 or IP = null): (ont_id,ont_serial)
Numbers that have *disappeared* from Service Request but still have a trace in Service Request Service records: (dn)
SIP IP range according to OLT as outlined in NDD (Network Design Document): (olt,external network_number,gateway)
Different ONTs (according to service requests) connected to same IP: (ont_id,dn,ip)

Statistics:

Number, connection, & address information for all numbers in ONTs
Non SFU ONTs on the network
Duplicate addresses within field table
Numbers not is the list of officially allowed Dns to be registered
PBX key numbers from Service Request Service
Number of Dn records in System, Service, Service_Active, and Service_Request_Service tables
Dn-Mobile number association from Report records
Routing parameters extracted from log file 'sendToS12.history.COMT1'
Number count of ONTs with non-trivial ont_serial numbers (neither 'ALCL00000000' nor NULL) in every PON
IPs of ONT Id positions that do not have corresponding field in supplier file
Export Important Data to Text

Integrity (ideally every query below should give no results):

ONTs in ont_positions that do not conform to the standard for their ONT ID (meaningless, obsolete)
ONTs with IPs that do not conform to the standard for their ONT ID
Numbers with integrity issues
IPs within protocol that belong to the second half of the GPON internal network numbering definition in NDD (Network Design Document)
IPs within MGC protcol output log file 'SCRT_10.255.250.15_20090101a.log' that belong to the second half of the GPON internal network numbering definition in NDD (Network Design Document)
IPs within MGC protcol output log file 'SCRT_10.255.250.15_20090101a.log' that DO NOT belong to neither the list of standard ont-ips that have their ont positions defined in field data with at least an address, nor in ia_ont_voip and have defined ONTs connected to them
ONTs that have not applicable values in database (ont serial, state, or voip state is NULL)
Numbers within System but not in Service Request Service
Differences between Supplier ONT ID address data and actual customer givin address for provisioned services
ONT positions with same IP within AMS
ONT records: in Standard but not in Ont
ONT records: in Ont but not in Standard
Numbers within System, Service, or Service_Active but not in Service Request Service
ONT serials within Supplier data that are different from the ONT serials retrieved from AMS for the same ONT positions (excluding 'ALCL00000000' serials)
ONT records in Ont_Voip but not in Ont
Duplicate ONT serials within Supplier data and the current corresponding AMS ONT serials
Duplicate ONT serials within AMS

Script:

Repetitions: