cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2506
Views
5
Helpful
3
Replies

User/Device data options thru CUCM API

scottg0076
Level 1
Level 1

Hello,

We need to create a report listing device details (Device Type, MAC, Description, Device Pool, etc...), along with the details for the associated end user of each device (User ID, Name, Display name, Department, etc...). Is there any way to extract this information through a single query thru the CUCM API? Trying to find a way to avoid manually having to merge all of this data together.

Thanks.

3 Replies 3

Alex Stevenson
Cisco Employee
Cisco Employee

 

Have you tried looking at the Cisco Administrative XML Web Service (AXL)?

https://developer.cisco.com/docs/axl/

 

Learn about the DevNet Sandboxes you can use to experiment/practice/learn at: 

https://developer.cisco.com/docs/axl/#!the-sandboxes

 

How to Access Cisco CallManager (CUCM) with AXL API Postman Tool Check out this discussion:

https://community.cisco.com/t5/collaboration-voice-and-video/how-to-access-cisco-callmanager-cucm-with-axl-api-postman-tool/ba-p/4027261

 

I'm not sure this is the answer you're looking for but maybe it's worth a look...

AXL would be the correct API.  The easiest technique would get to use a <getPhone> request to get all the device details, including the user id, then perform a subsequent <getUser> requests to get the specific user details.

It would probably be possible to use AXL <executeSqlQuery> with a hand-crafted SQL statement designed to join the device and user tables (and any others that contain data you need), to do things in 'one shot', however that will likely take a fairly expert level of SQL knowledge along with some detailed knowledge about the UCM database schema (there is some schema documentation here that can help: https://developer.cisco.com/docs/axl/#!12-5-cucm-data-dictionary)

Thank you both for your assistance, I was able to run getPhone and getUser API queries through Postman and I think this will get us the info that we need.  I appreciate the quick response!

 

Scott

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: