[cisco-voip] Excluding Users from Corporate Directory on 6.1

[Pattishall, Jan]

Vicente,

Were you able to do this? Its pretty simple....

Just download the AXL toolkit and put it somewhere local to your machine; and make sure you are running java.

Write an XML file explaining what you want to do; I will put two examples below.

Then from a command prompt; browse to the directory where you saved this stuff and write type in the following using your CCM server, username and PW.

java -cp .\classes;.\lib\saaj-api.jar;.\lib\saaj-impl.jar;.\lib\mail.jar;.\lib\activation.jar;.\lib\jaxm-api.jar;.\lib\jaxm-runtime.jar;.\lib\xercesImpl.jar;.\lib\xml-apis.jar AxlSqlToolkit -username=appadmin -password=****** -host=172.31.2.104 -input=ADchange2.xml

As far as the xml file goes;  we wrote a filter and applying it to Callmanager using the AXL toolkit.

In our edirectory environment, we did this to only sync users who have something in the ipPhone field; and you can do the same for AD. Sample XML files are below. Note that the tkldapserver is 1 if you are doing AD integration and 2 if you are doing LDAP.


For LDAP it looks like this:
<?xml version="1.0" encoding="UTF-8"?>
<!--DTD generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
<!DOCTYPE data [
                <!ELEMENT data (sql+)>
                <!ELEMENT sql EMPTY>
                <!ATTLIST sql
                query CDATA #IMPLIED
                                update CDATA #IMPLIED
>
]>
<data>
                <sql update="update ldapfilter set filter ='(ipPhone=*)' where tkldapserver=2"/>
                <sql query="select * from ldapfilter where tkldapserver=2"/>
</data>

So for AD it should look like this:
<?xml version="1.0" encoding="UTF-8"?>
<!--DTD generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
<!DOCTYPE data [
                <!ELEMENT data (sql+)>
                <!ELEMENT sql EMPTY>
                <!ATTLIST sql
                query CDATA #IMPLIED
                                update CDATA #IMPLIED
>
]>
<data>
                <sql update="update ldapfilter set filter ='(&amp;(objectclass=user)(!(objectclass=Computer))(!(UserAccountControl:1.2.840.113556.1.4.803:=2))(|(ipPhone=*)))' where tkldapserver=1"/>
                <sql query="select * from ldapfilter where tkldapserver=1"/>
</data>

Another user suggested the following XML for AD as well; which will also work:

>
]>
<data>
                <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"/>
                <sql query="select * from ldapfilter where tkldapserver=1"/>
</data>




From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Rodríguez Martínez Vicente
Sent: Thursday, June 12, 2008 6:10 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Excluding Users from Corporate Directory on 6.1

Matthew J. Hughes HI I saw You edited the sql database on CUCM 6.1 I'am trying to do the same just like You, but I have not been able to make it work, is it possible that You tell me step by step how to make it work?  I'll appreciate Your comments thanks in advance...




Vicente Rodriguez Martinez
Consorcio Red Uno S.A. de C.V.
Av Vasconcelos 451 pte
Col Del Valle
Garza Garcia N.L.
Tel.-(81)83990952
Conmutador.-(81)83990900
Cel.-(81)8116368840

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080613/1b280fe3/attachment-0001.html>