Executing SQL Queries against CUCM through Cisco AXL (part 3 of 3)

Posted by Carl Karawani on Mar 24, 2016 7:30:00 AM

Once you have completed part 1 (Integrate any 3rd party provisioning application with your CUCM using Cisco AXL) and part 2 (Sending AXL Requests to Cisco CUCM with Postman), part 3 takes it one step further with direct access to the CUCM database with Cisco AXL.

Executing SQL queries against CUCM with Cisco AXL is the third and final part of our 3-part series on taking you through the steps to get the most from your CUCM using the Cisco AXL API.  Once you have completed part 1 and part 2, part 3 takes it one step further with direct access to the CUCM database with Cisco AXL. Perhaps two of the most powerful things about the Cisco AXL API are the executeSQLQueryReq and the executeSQLUpdateReq functions. These features allow you to create, update and delete directly in the CUCM database.

For a complete view of the database schema, please consult the CUCM Database Dictionary

To demonstrate this, we will show you the steps to query CUCM to find all the Directory Numbers that are inactive. 

Read More

Topics: Weekly UC Tips, How to(s), Cisco AXL

Sending AXL Requests to Cisco CUCM with Postman (part 2 of 3)

Posted by Carl Karawani on Mar 17, 2016 8:00:00 AM

Sending AXL requests to Cisco CUCM with Postman is part 2 of 3 in our series taking you through the steps to get the most from your Cisco CUCM using the AXL API.  This article assumes your CUCM has the AXL Service Enabled and that you have credentials for an Application User account with Standard AXL Access. Please read our part 1 post on integrating any 3rd party provisioning applications with your CUCM using Cisco AXL, if you require instructions on how to set that up before proceeding with part 2.  

The Administrative XML Web Service (AXL) is an XML/SOAP based API that enables remote provisioning of Cisco Unified Communications Manager (CUCM) using any modern (and even not so modern!) programming language. We will be looking at how to quickly test your AXL API calls using Postman. This Google Chrome App is a great tool for developers or anyone who wants an easy way for testing any web APIs (including Cisco's AXL API). Now let's review the steps required to set up and install Postman then to send an AXL request to Cisco CUCM with Postman.

Read More

Topics: Cisco AXL, CUCM

Integrate any 3rd party provisioning application with your CUCM using Cisco AXL (part 1 of 3)

Posted by Carl Karawani on Mar 10, 2016 8:00:00 AM

 

Cisco Unified Communication Manager gives you a set of essential tools that allow you to do most of the things you need to do with your system. However, there are times where these tools may not be the most effective or efficient to provision your CUCM. The following post is the first of a 3 part series that will take you through the steps to get the most from your CUCM using the Cisco AXL API.

This first one is on how to enable Cisco AXL service on your Cisco Unified Communications Manager (CUCM) System allowing you to integrate any 3rd party provisioning application such as SMACS.

The second article takes it a step further and shows you how to send your own AXL request to CUCM with the help of postman.

And the third of this series, for those who want to push even further and shows you how to execute SQL queries against CUCM through AXL. 

Read More

Topics: Cisco Unified Communications Insights, Weekly UC Tips, How to(s), Cisco AXL

Don’t miss out. Expert advice straight to your inbox!

Insightful tips, troubleshooting and solutions for your everyday Unified Communications challenges from our team of experts. You can look forward to:

  • Weekly UC tips;
  • Cisco Unified Communications insights;
  • UCCX - Contact Center insights;
  • Network and Security insights;
  • Cisco Release notes and Product reviews.
Join us for free live demo