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”
Tag: sql
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”