<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest topics for the forum "General Discussion"]]></title>
		<link>http://www.ldapsoft.com/forum/forums/show/4.page</link>
		<description><![CDATA[The newest discussed topics in the forum "General Discussion"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>List all the users in an AD group and export that to an Excel worksheet SQL syntax</title>
				<description><![CDATA[ I would like to list all the users in an AD group and export that to an Excel worksheet.  What is the SQL syntax to query and report that information<br /> <br /> For example, I have group Presidents and I want to list all the presidents in that AD group.]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/74/244.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/74/244.page</link>
				<pubDate><![CDATA[Tue, 27 Jul 2010 14:36:40]]> GMT</pubDate>
				<author><![CDATA[ chrisT]]></author>
			</item>
			<item>
				<title>Export certain user attributes for user that belong to specific user groups in AD</title>
				<description><![CDATA[ I downloaded an evaluation copy of AD Admin & Rpt Tool,  We need to be able to export certain user attributes for user that belong to specific user groups in AD.  Is there a way to accomplish this with your tool without having to do a lot of work on the result set?<br /> Thanks]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/73/243.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/73/243.page</link>
				<pubDate><![CDATA[Tue, 27 Jul 2010 14:35:24]]> GMT</pubDate>
				<author><![CDATA[ chrisT]]></author>
			</item>
			<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>What tool can I use?</title>
				<description><![CDATA[ I have an IIS based CMS application which uses SQL server to store reg info.   I want to be able to automatically create a user in Active Directory whenever a person registers through the app.<br /> <br /> I can execute custom SQL statements during the registration process.   Do you have a tool that will be able to work in this scenario?<br /> <br /> Thanks]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/71/236.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/71/236.page</link>
				<pubDate><![CDATA[Sun, 4 Jul 2010 04:01:42]]> GMT</pubDate>
				<author><![CDATA[ Thinktank]]></author>
			</item>
			<item>
				<title>Bug in csv of excel export?</title>
				<description><![CDATA[ excel or cvs export in ldap admin tool causes a java exception:<br /> java.lang.NumberFormatException: For input string: "0000111afd21"<br /> <br /> Thanks]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/70/234.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/70/234.page</link>
				<pubDate><![CDATA[Thu, 17 Jun 2010 20:50:23]]> GMT</pubDate>
				<author><![CDATA[ cjonath]]></author>
			</item>
			<item>
				<title>AD Admin &amp; Reporting Tool Installation error</title>
				<description><![CDATA[ Upon installation of Ad Admin & Reporting Tool, a notepad window pops up titled “unpackall – Notepad” with the following displayed in the text/body area:<br /> <br /> const WindowStyleStealth  = &H20000000<br /> <br /> set WSO = createobject("WScript.Shell")<br /> <br /> WSO.run "%comspec% /c unpackall.bat", WindowStyleStealth, true<br /> <br /> The installation hangs there until I close the notepad file.  Once closed, the installation “completes” and I launch the tool.  I then get an error message of “Invalid Component: No CPB” from ADAdminReportingTool.exe.<br /> <br /> Please help.]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/69/231.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/69/231.page</link>
				<pubDate><![CDATA[Tue, 15 Jun 2010 16:35:30]]> GMT</pubDate>
				<author><![CDATA[ don12]]></author>
			</item>
			<item>
				<title>Active Directory tool with logon information</title>
				<description><![CDATA[ I am looking for a tool that will show me:<br /> Account lockout date/time-<br /> last successfull login<br /> last failed login<br /> password age<br /> last time password was changed<br /> i worked for a company who had a tool that created an additional "view" in Active Directory that displayed that "Additional Information" related to Account Lockout... <br /> <br /> Which tool should I download?]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/67/228.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/67/228.page</link>
				<pubDate><![CDATA[Wed, 9 Jun 2010 14:24:52]]> GMT</pubDate>
				<author><![CDATA[ linda]]></author>
			</item>
			<item>
				<title>how to export to excel - AD ADmin &amp; Reporting Tool</title>
				<description><![CDATA[ Hello all,<br /> <br /> today i downloaded the AD Admin & Reporting Tool.<br /> <br /> i tryed the export to excel the following "issue":<br /> i need to list all members which matches the following criterias:<br /> <br /> - Must be member of the OU"whatever"<br /> AND<br /> must be member of the SecurityGroup "Test1"<br /> <br /> the second thing i tryed with 0 returns was:<br /> Must be member of the OU "whatever"<br /> AND<br /> extensionattribute1 IS "SAP"<br /> <br /> i tryed several things in the export assistent with no luck, always returned 0 rows.<br /> <br /> what i set:<br /> Excel filename: C:\Users\user1\Desktop\test1.xls<br /> Search Base: DC=mydomain,DC=de<br /> Filter: (&(memberOf=Internet-*)(distinguishedName=OU=Acus,OU=mycity,DC=mydomains,DC=de))<br /> Returning Attributes:cn,distinguishedName,sAMAccountName<br /> <br /> but, i never recieve a entry in my list. <br /> <br /> could someone attach the correct searchstring for that (to simple import it)<br /> <br /> would be fine.<br /> i would like to buy this software but our head wants to see if we are able to get the results from it.<br /> <br /> regards<br /> byte]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/66/222.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/66/222.page</link>
				<pubDate><![CDATA[Tue, 23 Feb 2010 14:19:01]]> GMT</pubDate>
				<author><![CDATA[ bytesleuth]]></author>
			</item>
			<item>
				<title>Searching users with memberof</title>
				<description><![CDATA[ Sorry I am not good at this SQL query stuff but in my AD I am looking for membership in a particular group using memberOf but I am not getting the correct results. <br /> <br /> Here is the sql statement I am running:<br /> <br /> SELECT displayName FROM OU=Users,OU=TEST,DC=electric,DC=net WHERE   memberOf NOT 'CN=zz%All TEST,OU=Groups,OU=TEST,DC=electric,DC=net'<br /> <br /> Thanks]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/65/216.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/65/216.page</link>
				<pubDate><![CDATA[Mon, 8 Feb 2010 20:06:15]]> GMT</pubDate>
				<author><![CDATA[ jjohn]]></author>
			</item>
			<item>
				<title>Updating a user attribute to the same value as a different attribute</title>
				<description><![CDATA[ I'm trying to write a SQL query that will update a user attribute to be the same value as a different attribute, but so far all I can get it to do is make it the name of the other attribue, rather than the value.<br /> <br /> Update CN=xxxxxx\, xx,OU=xxxxx,DC=xxx,DC=com Set extensionAttribute2 = pager<br /> <br /> That's the query that I'm working with.  Right now, it makes the value of extensionAttribute2 literally "pager."  I want it to be the vlaue of the pager attribute.]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/64/214.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/64/214.page</link>
				<pubDate><![CDATA[Mon, 8 Feb 2010 19:54:11]]> GMT</pubDate>
				<author><![CDATA[ ssa1]]></author>
			</item>
			<item>
				<title>Deleting Attributes</title>
				<description><![CDATA[ I have a client who has a Novell eDirectory where about 7000 groupwise accounts have become corrupted. Using the normal management (ConsoleOne) it will not let him delete and re-create the groupwise accounts. They have determined that there are 7 attributes of each account that are still populated with groupwise information even though their groupwise account is corrupted. They need to be able to mass delete those 7 attributes while leaving the rest of the properties and the eDirectory account intact. Can your LDAP admin tool standard edition do that for them.]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/63/212.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/63/212.page</link>
				<pubDate><![CDATA[Mon, 8 Feb 2010 19:11:52]]> GMT</pubDate>
				<author><![CDATA[ jjohn]]></author>
			</item>
			<item>
				<title>Cannt see objectSID</title>
				<description><![CDATA[ Since yesterday we got your AD Admin and Reporting Tool 4.2 running in our production environment.<br /> Why can't we see the ObjectSid from a user.]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/62/209.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/62/209.page</link>
				<pubDate><![CDATA[Mon, 30 Nov 2009 15:44:20]]> GMT</pubDate>
				<author><![CDATA[ melissa]]></author>
			</item>
			<item>
				<title>Loading Certificate in OpenLDAP</title>
				<description><![CDATA[ I am trying to load certificate in userCertificate attribute but getting an error "Undefined Attribute Type". <br /> The certificate is correct and I can view it with the table certificate editor. Everything seems correct, it just don't save it into directory.<br /> <br /> I am using version 4.4 LDAP Admin Tool Prof.<br /> <br /> Thank you for your help in advance.]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/61/208.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/61/208.page</link>
				<pubDate><![CDATA[Mon, 30 Nov 2009 15:38:54]]> GMT</pubDate>
				<author><![CDATA[ ssa1]]></author>
			</item>
			<item>
				<title>Querying more than 1000 records from Active Directory</title>
				<description><![CDATA[ I need to export more than 1000 records at a time. How can I do this with the AD Admin and Reporting tool? I have a SQL query that returns what I want but I cannot get all of the records I need.]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/60/205.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/60/205.page</link>
				<pubDate><![CDATA[Tue, 10 Nov 2009 22:18:52]]> GMT</pubDate>
				<author><![CDATA[ melissa]]></author>
			</item>
			<item>
				<title>How to export all hex attributes from AD</title>
				<description><![CDATA[ How can I export attribute's binary/hex values]]></description>
				<guid isPermaLink="true">http://www.ldapsoft.com/forum/posts/preList/59/204.page</guid>
				<link>http://www.ldapsoft.com/forum/posts/preList/59/204.page</link>
				<pubDate><![CDATA[Tue, 10 Nov 2009 22:16:48]]> GMT</pubDate>
				<author><![CDATA[ Joe67]]></author>
			</item>
	</channel>
</rss>