[cisco-voip] querying AD or CM user information in CCX

[Tim Reimers]

I really don't know what TAC would think of this, but using the AXL SQL
toolkit that comes with UCM 7.X this works:
 
<sql query="select description, alertingname, alertingnameascii,
dnorpattern from numplan where dnorpattern like '%5512%' "/>
 
That gets me back my name and extension.
 
I don't know enough about programming to do more than slightly modify
the example XML and batch file to get what I want.
A real programmer should be able to do what Cisco is intending with that
AXL SQL toolkit 
and actually embed the SQL into an application of some sort.
 
I'd guess the usual caveats apply about too many SQL queries causing
performance issues, etc, with UCM.
 
Tim Reimers
Systems Analyst II
Information Technology Services
City of Asheville
70 Court Plaza
Asheville, NC 28801
phone - 828-259-5512
treimers at ashevillenc.gov <mailto:timreimers at ashevillenc.gov> 
 

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Eric Pedersen
Sent: Thursday, January 14, 2010 7:44 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] querying AD or CM user information in CCX



We are using CCX for our internal helpdesk and most of the people that
call have user accounts in CM.  Is there a way in CCX to fetch user
information based on the ANI?  It's CM 7.1 so I can't do a SQL query.
Am I missing something obvious?

 

 We are AD integrated so I could do an LDAP query but it looks like I
would need some custom Java code for that.

 

It's CCX 7.0 and CM 7.1.

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100115/e7220d5d/attachment.html>