Creating Excel apps for Cisco collaboration.
This SQL query searches for translation patterns with a description that includes “Main Line” returning both the translated and original pattern and the description, sorting by the translation pattern. This SQL query searches for route patterns that include ‘associated device’ that contain ‘fax’. Returning the route pattern and the description.
I’ve been working with the Cisco Call Manager for over 15 years. In 2022 I took a Cisco digital course on Implementing Automation for Cisco Collaboration Solutions. This opened up a whole new concept to me, I had no idea what could be accomplished with the Cisco API interface. Next I needed to find a … Continue reading Cisco CandE Introduction
This getPhone API call gets a phone by the MAC address and returns everything that’s returnable for the phone. This updateUser API call updates the user, by adding an associated device and adding the IPCC number. Keep in mind that adding a new device clears out the current list of devices. To keep the current … Continue reading Postman API calls
In the last post I demonstrated the phone copy application and how it works. In this post I’ll detail the step by step process on how I developed the initial description and device pool searches for the application section shown in the image below. Starting with using the Cisco Schema reference, then testing with the … Continue reading Cisco CUCM listphone API Call, in detail
Now that we’ve used the listphone API call to find a phone to copy, we’ll use the getphone API call to pull phone details that will be copied to the new phone. The image below shows the blanks this section will be filling in. The getphone API call is made using the devicename of the … Continue reading Cisco CUCM getphone API Call
Quick overview of the phonecopy application: This is what the app looks like, missing lines 2 thru 5 which extend down below line 1. The Excel application has four main areas: The search area: Columns A thru D Finds and list phones by searching for the description or by the device pool of the phones. … Continue reading Cisco Phone Copy App Summary
Cisco Collaboration and Excel 