<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#404040;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Jorge:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">From what I understand and have read, the telephoneNumber=* should automatically filter NULL fields.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I cannot get your filter to work properly in my lab:<o:p></o:p></p>
<p class="MsoNormal">(&(objectclass=user)(!(objectclass=Computer))(objectclass=contact)(telephoneNumber=*))<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Looking at the syntax of this filter, it seems we’re looking for objects that are both user and contact instead of users OR contacts. I’ve edited the filter to the following:<o:p></o:p></p>
<p class="MsoNormal"><span style="color:#404040"><o:p> </o:p></span></p>
<p class="MsoNormal"><b>(&<span style="color:#C00000">(|(objectclass=user)(objectclass=contact))</span>(!(objectclass=Computer))(telephoneNumber=*))<span style="color:#404040"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:#404040"><o:p> </o:p></span></p>
<p class="MsoNormal">I added this to my lab and it worked without issues – it’s basically allowing only user objects OR contacts where the telephone number field is populated. Both end users and contacts are imported with no problem using this in the lab. Removing
the configured number in the telephone number field on the user object in AD results in an inactive user in CUCM after forcing another directory sync.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>NOTE</b>: Contact objects in Active Directory don’t have a sAMAccountName attribute, which is the default LDAP attribute used for end user User ID in CUCM. To pull in contacts, you’ll need this changed to something other than sAMAccountName,
but changing this would also require that all LDAP directory synchronizations to be removed completely.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hope this helps.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Daniel<o:p></o:p></p>
<div>
<p class="MsoNormal"><u><span style="color:#595959"><o:p><span style="text-decoration:none"> </span></o:p></span></u></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> cisco-voip [mailto:cisco-voip-bounces@puck.nether.net]
<b>On Behalf Of </b>Jorge L. Rodriguez Aguila<br>
<b>Sent:</b> Wednesday, March 12, 2014 10:19 AM<br>
<b>To:</b> Cisco-Voip (cisco-voip@puck.nether.net)<br>
<b>Subject:</b> [cisco-voip] Correct Filter Syntax Question<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am trying to build a filter so that users from AD who do not have a number on the telephoneNumber field of AD do not get pulled into AD.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I created this one but is not working, can someone tell me where I might be doing something wrong with the Filter<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">(&(objectclass=user)(!(objectclass=Computer))(objectclass=contact)(telephoneNumber=*))<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks in advance<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Jorge Rodriguez - CCNP, CCNP-Voice<o:p></o:p></p>
<p class="MsoNormal">Senior Voice/Data Consultant<o:p></o:p></p>
<p class="MsoNormal">Netxar Technologies<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:Jorge.rodriguez@netxar.com">Jorge.rodriguez@netxar.com</a><o:p></o:p></p>
<p class="MsoNormal">787-765-0058 X2044<o:p></o:p></p>
<p class="MsoNormal">787-688-8530<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>