Skip to content

afterthenumber

Thoughts and experiences of a Cisco Collaboration engineer after clearing the CCIE lab…

  • Freelance Services
  • UC Applications
    • CUCM
    • sdl
    • sql
    • CUC
    • UCCX
    • IM and Presence
    • Cisco Jabber
    • Prime Collaboration
    • TelePresence
    • ExpressWay
    • WebEx
  • Development
    • AXL
    • SIP Normalization Scripting
    • sql
    • Software Engineering
  • Linux
    • ubuntu
  • IOS Devices
    • CUBE
    • IOS Media Resources
    • SRST
    • CME
    • Voice Gateways
    • ISDN
  • SIP
    • SIP Trunking
  • About Me
  • More

    Tag: sql

    Extracting Unsupported and Deprecated Phones Models for UCM 12.5 Migrations

    One of my customers who is targeting a migration to 12.5 is running a number of legacy phone and VC models that will fall in the unsupported… Read more “Extracting Unsupported and Deprecated Phones Models for UCM 12.5 Migrations”

    February 24, 2020February 25, 2020 by jonathan

    Extracting CUCM SIP Trunk Information using SQL

    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”

    December 2, 2019December 2, 2019 by jonathan

    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”

    December 21, 2018December 23, 2018 by jonathan

    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”

    December 21, 2018December 21, 2018 by jonathan

    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”

    December 21, 2018 by jonathan

    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”

    September 3, 2018September 3, 2018 by jonathan

    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”

    April 27, 2018December 10, 2019 by jonathan

    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”

    April 5, 2016December 10, 2019 by jonathan
    Website Powered by WordPress.com.
    Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
    To find out more, including how to control cookies, see here: Cookie Policy
    • Follow Following
      • afterthenumber
      • Join 53 other followers
      • Already have a WordPress.com account? Log in now.
      • afterthenumber
      • Customize
      • Follow Following
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar