However, the initial consideration would be how is the incoming caller ID associated to the user, precisely, and in which system (CUCM/AD) is that relationship stored? For example, it could simply be an E164 string in AD, it could be a CUCM DN associated to a phone device associated to a user, it could be a DN associated directly to a user via 'primary line' in CUCM, etc.
If the 'source of truth' is AD, I would suggest using AD APIs to query/retrieve the data. If it's in CUCM via some line/user/field then we can further help recommend the AXL query to use...
The source of truth is AD which populates the telephone Number field in CUCM via the ipPhone field in AD. I want to cross reference the telephone number and retrieve the associated userid (SAMAccountName), Firstname, Lastname and MailID.
So do you think that querying AD would be the best option via a UCCX Script?
I found some info on running an SQL Query via AXL on CUCM which might work.
Good info, though keep in mind that this query likely involves a full, unindexed table scan of the user table in the CUCM DB, and may have a bigger performance impact than you might expect - would be worth some testing.
This is the sign you have been waiting for. It's the year YOU apply to become a Cisco Champion. As a Cisco Champion, you’ll:
Get early insights into new Cisco products and solutions
Receive access to Cisco’s engineering rock stars
12.6 ES03 release which has important updates for the VPN-Less feature has been released. The changes and configuration details can be found on the TechNote page for the release.
VPN-Less Finesse provides...
The 2021 IT Blog Awards, hosted by Cisco, is now open for submissions. Submit your blog, vlog or podcast today. For more information, including category details, the process, past winners and FAQs, check out: https://www.cisco.com/c/en/us/t...
Parsec's MARS CRM Connector application works as a bridge between CRM & Cisco UCCE / PCCEThe CRM user will have the capability to handle both incoming & outgoing callsInbound Call indication/Popup on CRM screen with customer/caller number and name...
Audio and Video Endpoints Knowledge Base
For one-on-one help with these products, you can open a ticket at https://developer.cisco.com/site/support/. For other products, please contact Cisco TAC at https://www.cisco.com/c/en/us/support/index.ht...