Other articles

  1. Querying Service Desk Call Metrics with Python

    Extracting Metrics from Cisco Unified Call Manager (CUCM)

    Background

    About a year and a half ago, I was asked to find a way to extract metrics from Cisco Unified Call Manager (CUCM) to support our Service Desk team. They needed basic insights: - How many calls were made to the service desk - Who answered the calls - How many calls went to voicemail

    Over time, additional requests came in, such as tracking evening-hour calls to determine if extra support was needed.

    Initial Challenges

    After some research, I found that CUCM didn’t provide an easy way to access this information through its …

    Read more...

  2. A Practical Approach to Finding 100GB QSFPs

    Automating 100GB QSFP Transceiver Inventory with PowerShell

    Understanding the quantity and distribution of 100GB QSFP transceivers in your data center can be essential for optimizing network performance. But how can you efficiently gather this information across multiple devices? Let me share with you a straightforward method I’ve developed using PowerShell, which you can adapt to suit your environment.

    Firstly, I typically start by SSH’ing into my devices to manually gather information. This initial exploration helps me identify patterns that can be automated later. One command I’ve found to be particularly useful is show interface transceiver, which lists …

    Read more...

  3. Querying CUCM Database using SQL

    Exploring Cisco Unity Call Manager (CUCM) Database Access via Postman and SOAP/AXL API

    Delving into the intricacies of Cisco Unity Call Manager (CUCM) database access via Postman and SOAP/AXL API opens up a realm of possibilities. While this won’t serve as a step-by-step guide, consider it a tour through a few essential examples, primarily focusing on leveraging custom SQL queries within Postman requests.

    If SQL isn’t in your skill set, this isn’t the tutorial where you’ll find comprehensive lessons. I’m no SQL guru myself, having only dabbled in it sparingly. Below, I’ll …

    Read more...