<div>You said you were running CUCM6 and Edirectory?</div>
<div>Did you encounter anything specific when you have the integration done?</div>
<div>do you use ldap authentication as well?</div>
<div>maybe some other integrated apps like unity connection or ipcc express, that are used.</div>
<div>I would like to know, as i am doing a test integration for a customer of mine, even though the edir is officially not supported by cisco.</div>
<div> </div>
<div>thanks,</div>
<div> </div>
<div>erik<br><br></div>
<div class="gmail_quote">On Wed, Jun 4, 2008 at 5:22 PM, Ryan West <<a href="mailto:rwest@zyedge.com">rwest@zyedge.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p><span style="COLOR: #1f497d">Jan,</span></p>
<p><span style="COLOR: #1f497d"> </span></p>
<p><span style="COLOR: #1f497d">Just to summarize some of the steps that I went through before:</span></p>
<p><span style="COLOR: #1f497d"> </span></p>
<p style="TEXT-INDENT: -0.25in"><span style="COLOR: #1f497d"><span>1)<span> </span></span></span><span style="COLOR: #1f497d">I wanted to provide a full 10 digit number for windows mobile devices that are using a corporate directory or other services needing the full 10 digit</span></p>
<p style="TEXT-INDENT: -0.25in"><span style="COLOR: #1f497d"><span>2)<span> </span></span></span><span style="COLOR: #1f497d">I wanted to sync based on the presence of the IP Phone field and I wanted that to used for the primary extension and corporate directory on the phones</span></p>
<p><span style="COLOR: #1f497d">To accomplish this was a two-fold project. I needed to write a vb script to pull the last digits from each existing phone number in AD, you can always manually move the phone numbers as well. I then needed to use the axltoolkit to update from the original LDAP matching structure to a new match that looks for active users with the presence of the IP phone field.</span></p>
<p><span style="COLOR: #1f497d"> </span></p>
<p><span style="COLOR: #1f497d">Here is the AXL SQL update that I am using currently, it was tested within the week.</span></p>
<p><span style="COLOR: #1f497d"> </span></p>
<p><span style="COLOR: #1f497d"><?xml version="1.0" encoding="UTF-8"?></span></p>
<p><span style="COLOR: #1f497d"><!--DTD generated by XMLSPY v5 rel. 4 U (<a href="http://www.xmlspy.com/" target="_blank">http://www.xmlspy.com</a>)--></span></p>
<p><span style="COLOR: #1f497d"><!DOCTYPE data [</span></p>
<p><span style="COLOR: #1f497d"> <!ELEMENT data (sql+)></span></p>
<p><span style="COLOR: #1f497d"> <!ELEMENT sql EMPTY></span></p>
<p><span style="COLOR: #1f497d"> <!ATTLIST sql</span></p>
<p><span style="COLOR: #1f497d"> query CDATA #IMPLIED</span></p>
<p><span style="COLOR: #1f497d"> update CDATA #IMPLIED</span></p>
<p><span style="COLOR: #1f497d">> </span></p>
<p><span style="COLOR: #1f497d">]></span></p>
<p><span style="COLOR: #1f497d"><data></span></p>
<p><span style="COLOR: #1f497d"> <sql update="update ldapfilter set filter ='(&amp;(objectclass=user)(!(objectclass=Computer))(!(UserAccountControl:1.2.840.113556.1.4.803:=2))(|(ipPhone=1*)(ipPhone=2*)(ipPhone=3*)(ipPhone=4*)(ipPhone=5*)(ipPhone=6*)(ipPhone=7*)(ipPhone=8*)(ipPhone=9*)(ipPhone=0*)))' where tkldapserver=1"/></span></p>
<p><span style="COLOR: #1f497d"> <sql query="select * from ldapfilter where tkldapserver=1"/></span></p>
<p><span style="COLOR: #1f497d"></data></span></p>
<p><span style="COLOR: #1f497d"> </span></p>
<p><span style="COLOR: #1f497d">I recommend running the sql query first so you can see what the default CM install comes with and have something to backup to in case of any issues. Remember that you'll need to start and stop dirsvcs for the cache to update. (Thanks to Andrew Short for that tip and the IpPhone OR statement above).</span></p>
<p><span style="COLOR: #1f497d"> </span></p>
<p><span style="COLOR: #1f497d">If you're still hitting the wall on the vb script, let me know and I can repost that as well.</span></p>
<p><span style="COLOR: #1f497d"> </span></p>
<p><span style="COLOR: #1f497d">-ryan</span></p>
<p><span style="COLOR: #1f497d"> </span></p>
<div>
<div style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<p><b><span style="FONT-SIZE: 10pt">From:</span></b><span style="FONT-SIZE: 10pt"> <a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a> [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>] <b>On Behalf Of </b>Pattishall, Jan<br>
<b>Sent:</b> Wednesday, June 04, 2008 11:10 AM<br><b>To:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br><b>Subject:</b> [cisco-voip] LDAP filter for CUCM 6</span></p></div>
</div>
<div>
<div></div>
<div class="Wj3C7c">
<p> </p>
<p>Hello </p>
<p> </p>
<p>I am running into an issue discussed prior in which someone was attempting to filter out certain users from the directory by referencing the presence or absence of a certain field. (like CiscoPrivateUser used to do). </p>
<p> </p>
<p>I am running into the same issue with CUCM6 and Edirectory 8 and was hoping for some assistance in implementing the LDAP filter. </p>
<p> </p>
<p>Any help would be greatly appreciated. </p>
<p> </p>
<p> </p>
<p>Cordially,</p>
<p><span style="FONT-SIZE: 10.5pt">Jan Pattishall</span></p>
<p><span style="FONT-SIZE: 10.5pt">Senior Voice and Infrastructure Engineer </span></p></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>