I am currently overseeing a large multi-cluster deployment with literally hundreds of SIP trunks spanning almost 10 leaf clusters, plus SME. Maintaining configuration standardization on deployment with… Read more “Extracting CUCM SIP Trunk Information using SQL”
Tag: sql
Analyzing UC Application Informix SQL Tables, Columns and Data Types
Overview It is often necessary or useful to analyze a specific table’s columns and their associated data types when constructing queries for CUCM, CUCxN, UCCX etc. However,… Read more “Analyzing UC Application Informix SQL Tables, Columns and Data Types”
Finding Jabber devices with Custom Configuration Files
Finding custom Jabber configuration files can be a pain. These are set via a “Remote Support Field”, which internally to CUCM is stored inside a vendorConfig when… Read more “Finding Jabber devices with Custom Configuration Files”
Finding Incorrectly Provisioned Extensions on CUCM with SQL
A customer had a multi-site deployment, with 30,000+ extensions, but is facing problems with dialing from missed calls directory not working for random users, generating on-going tickets… Read more “Finding Incorrectly Provisioned Extensions on CUCM with SQL”
CUCM SQL – Reporting on User/Phone Data
Overview A friend at work needed a simple report detailed basic phone data and associated user information. This is a common requirement for many CUCM admins,… Read more “CUCM SQL – Reporting on User/Phone Data”
Serializing Thin AXL SQL Query Responses with python-zeep
I have a buddy who asked for some help in constructing an SQL query to get all phones from CUCM that used a VPN Profile, which were… Read more “Serializing Thin AXL SQL Query Responses with python-zeep”
Active Unassigned DN’s – Updating with SQL
Update to a previous post… Disclaimer : Provided as is – you break your box all on your own buddy! Lab this first. The offending DNs can be… Read more “Active Unassigned DN’s – Updating with SQL”
