<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Mass Update Active Directory"]]></title>
		<link>http://www.ldapsoft.com/forum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Mass Update Active Directory"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Mass Update Active Directory</title>
				<description><![CDATA[ I'm trying to update about 8500 records in active directory and I'm getting the following error when I run my SQL query:<br /> <br /> LDAPException: Sizelimit Exceeded (4) Sizelimit ExceededLDAPException: Matched DN: -- null<br /> Here is my SQL query (with modified values):<br /> <br /> UPDATE OU=Users,DC=example,DC=com SET telephoneNumber=NULL WHERE telephoneNumber='519-111-2222' subtreescope<br /> <br /> I also changes the Max. Results value to 10000.<br /> <br /> If I do a search for all users with that phone number I get 8344 entries returned, so I don't think there is anything wrong with the domain controllers settings.  I even set MaxPageSize to 10000 and MaxResultSetSize to 1Mb on the domain controller and I still get the same error.<br /> <br /> Any help would be greatly appreciated.]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/72/238.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/72/238.page</link>
				<pubDate><![CDATA[Wed, 7 Jul 2010 19:26:59]]> GMT</pubDate>
				<author><![CDATA[ don12]]></author>
			</item>
			<item>
				<title>Re:Mass Update Active Directory</title>
				<description><![CDATA[ Try one of the following:<br /> <br /> Increase MaxPageSize (<a class="snap_shots" href="http://support.microsoft.com/kb/315071" target="_blank" rel="nofollow">http://support.microsoft.com/kb/315071</a>) and <br /> disable Enable Ldap Paged Result control from Preference|General (Last <br /> check box)<br /> <br />  or<br /> <br /> Constraint update to less than 1000 using some attribute for e.g (and sn <br /> like 'a%' or 'b%') and run update sql a few times.<br /> <br /> UPDATE OU=Users,DC=example,DC=com SET telephoneNumber=NULL WHERE telephoneNumber='519-111-2222' and sn like 'a%' or 'b%' subtreescope;]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/72/239.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/72/239.page</link>
				<pubDate><![CDATA[Wed, 7 Jul 2010 21:33:36]]> GMT</pubDate>
				<author><![CDATA[ support]]></author>
			</item>
			<item>
				<title>Re:Mass Update Active Directory</title>
				<description><![CDATA[ Thanks, I will do it in increments.<br /> <br /> How do I set the value of the attribute so that there is no value that appears in AD?  If I do SET telephoneNumber = NULL, NULL appears as the phone number, if I do SET telephoneNumber = '', '' appears as the phone number.<br /> ]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/72/240.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/72/240.page</link>
				<pubDate><![CDATA[Wed, 7 Jul 2010 21:39:05]]> GMT</pubDate>
				<author><![CDATA[ don12]]></author>
			</item>
			<item>
				<title>Re:Mass Update Active Directory</title>
				<description><![CDATA[ Try Null in small letters - null - also no space after =<br /> <br /> SET telephoneNumber=null<br /> ]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/72/241.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/72/241.page</link>
				<pubDate><![CDATA[Wed, 7 Jul 2010 21:43:50]]> GMT</pubDate>
				<author><![CDATA[ support]]></author>
			</item>
			<item>
				<title>Re:Mass Update Active Directory</title>
				<description><![CDATA[ Thanks alot, it worked perfectly!]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/72/242.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/72/242.page</link>
				<pubDate><![CDATA[Thu, 8 Jul 2010 13:46:48]]> GMT</pubDate>
				<author><![CDATA[ don12]]></author>
			</item>
	</channel>
</rss>
