<span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; "><p class="MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 11pt; color: rgb(31, 73, 125); ">"The appliance Callmanager is nice from a maintenance perspective, but not having native SQL access is frustrating."</span></p>
<p class="MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font class="Apple-style-span" color="#1F497D" size="4"><span class="Apple-style-span" style="font-size: 15px;"><br></span></font></p>
<p class="MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font class="Apple-style-span" color="#1F497D" size="4"><span class="Apple-style-span" style="font-size: 15px;">That's <i>exactly</i> why it is so nice from a maintenance perspective :)</span></font></p>
</span><br><div class="gmail_quote">On Fri, Jan 15, 2010 at 10:29 AM, Eric Pedersen <span dir="ltr"><<a href="mailto:eric.pedersen@sait.ca">eric.pedersen@sait.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">We have an old version of HEAT but the customer DB is not well
maintained. Until it is upgraded and improved, it would be better to
query the data in Callmanager or active directory. I did some AXL
programming with .NET but it has been a long time since I wrote any Java
code. Maybe when I have some time I will look at writing some code to do
an LDAP query of AD since that is probably easier than AXL.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">The appliance Callmanager is nice from a maintenance
perspective, but not having native SQL access is frustrating.</span></p>
<p class="MsoNormal"><a name="1263363186adb902__MailEndCompose"><span style="font-size:11.0pt;color:#1F497D"> </span></a></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt"> Scott Voll
[mailto:<a href="mailto:svoll.voip@gmail.com" target="_blank">svoll.voip@gmail.com</a>] <br>
<b>Sent:</b> January 15, 2010 08:46<br>
<b>To:</b> Eric Pedersen<br>
<b>Cc:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Re: [cisco-voip] querying AD or CM user information in CCX</span></p>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal">Eric--</p>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">What are you going to do with it once you have it? are
you putting it into a ticket system?</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">if so, you could grab the ANI and have it open a ticket and
put the ANI in, and then your ticket system could do the matching???</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">It's something I'm planning on doing here........ Just
haven't had time yet.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Scott</p>
<div>
<p class="MsoNormal">On Thu, Jan 14, 2010 at 4:43 PM, Eric Pedersen <<a href="mailto:eric.pedersen@sait.ca" target="_blank">eric.pedersen@sait.ca</a>> wrote:</p>
<div>
<div>
<p class="MsoNormal"><span lang="EN-CA">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?</span></p>
<p class="MsoNormal"><span lang="EN-CA"> </span></p>
<p class="MsoNormal"><span lang="EN-CA"> We are AD integrated so I could do an LDAP query but it looks
like I would need some custom Java code for that.</span></p>
<p class="MsoNormal"><span lang="EN-CA"> </span></p>
<p class="MsoNormal"><span lang="EN-CA">It’s CCX 7.0 and CM 7.1.</span></p>
<p class="MsoNormal"><span lang="EN-CA"> </span></p>
<p class="MsoNormal"><span lang="EN-CA"> </span></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></p>
</div>
<p class="MsoNormal"> </p>
</div>
</div></div></div>
</div>
<br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Tanner Ezell<br>