Messages posted by: support

Try the following statement where cn is the name of the group.

Select member from RootDSE where objectclass='group' and cn='Presidents'

That is very easy with AD Admin & Reporting tool, Open a sql window from top tool bar sql button , modify the following sql change the group names (memberof) and after select list all the attributes you want to export or view then copy and paste and click run or export.

The following statement will list sn and cn attribute of all users which are either member of 'testusergroup or 'testusergroup2'.

Select sn,cn from RootDSE where memberof='CN=testusersgroup,DC=LDAPSoft,DC=COM' or memberof='CN=testusersgroup2,DC=LDAPSoft,DC=COM' and objectclass='user'

Try Null in small letters - null - also no space after =

SET telephoneNumber=null

Try one of the following:

Increase MaxPageSize (http://support.microsoft.com/kb/315071) and
disable Enable Ldap Paged Result control from Preference|General (Last
check box)

or

Constraint update to less than 1000 using some attribute for e.g (and sn
like 'a%' or 'b%') and run update sql a few times.

UPDATE OU=Users,DC=example,DC=com SET telephoneNumber=NULL WHERE telephoneNumber='519-111-2222' and sn like 'a%' or 'b%' subtreescope;

Unfortunately not. You can't create users automatically but you can manually.

Please find the attribute containing this value, right click on the attribute and select 'Edit value with..", select 'text editor'
Now try exporting again. If problem persists let us know.

Seems like bat scripts execution is disabled on the machine you are trying to install the software.

Please manually execute the batch file "unpackall.bat" under the installation directory

Open a command prompt and cd to the script directory
> cd C:\Program Files\LDAPSoft\AD Admin And Reporting Tool\rt\bin
and then run the file
>unpackall.bat

Please download and try http://www.ldapsoft.com/ldapplusad.html.
This tool will give you all the information you mentioned. Also with this tool you can reset password and modify all the Active Directory attributes.

Byte,

Above query should give you all the users which are member of group CN=Internet-Standard,OU=Sicherheitsgruppen,DC=whatever,DC=de

Try the following query without objectClass=user:

SELECT * FROM OU=EDP,OU=Bremen,DC=whatever,DC=de where memberOf=CN=Internet-Standard,OU=Sicherheitsgruppen,DC=whatever,DC=de

and also search for mail = Joseph.schmidt@whatever.com (Top Search) and look for memberof attribute and make sure that this user is a member of CN=Internet-Standard,OU=Sicherheitsgruppen,DC=whatever,DC=de

It is very easy to search for user who are memberof a group just need the correct syntax.

Thanks

If I understand it correctly you are looking for all users in OU=EDP,OU=Bremen,DC=whatever,DC=de
which are member of CN=Internet-Standard,OU=Sicherheitsgruppen,DC=whatever,DC=de

If it the case try the following sql statement (Click on the sql button at the tool bar, copy and paste and click run).

SELECT * FROM OU=EDP,OU=Bremen,DC=whatever,DC=de where memberOf=CN=Internet-Standard,OU=Sicherheitsgruppen,DC=whatever,DC=de and objectClass=user

If above works, replace the * with attribute for e.g cn, sn and click run or export.

SELECT cn,sn FROM OU=EDP,OU=Bremen,DC=whatever,DC=de where memberOf=CN=Internet-Standard,OU=Sicherheitsgruppen,DC=whatever,DC=de and objectClass=user

Byte,

You can't use wildcard characters with memberof as it contains the DN values (DN is path and wildcard characters don't work with it).
Please modify the query to something like the following:

(memberOf=CN=Internet-test,OU=Acus,OU=mycity,DC=mydomains,DC=de)

If you don't know the complete DN, use the tool bar search -> select cn and enter internet* -> Click Find button.
Select the entry and from right click context menu select 'copy DN'.

Thanks

Try escaping % with \

You can't have any wild character (%) in DN.

Unfortunately you can't do that

The way I will handle this:

1. Export all the values of pager using a statement like this
Select pager from OU=xxx,DC=xx,DC=com
2. Export the result in csv format
3. Modify the file and generate update statements (Update CN=xxxxxx\, xx,OU=xxxxx,DC=xxx,DC=com Set extensionAttribute2= value)
4. Run those statements one by one.

Yes, you can mass delete attribute with LDAP ADmin Tool.

To delete an attribute you set them to null using sql statement.

e.g.
update ou=MemberGroupB,o=stooges set carLicense=null

The above statement will find all the entries under the ou=MemberGroupB,o=stooges and will update their carlicense value to null or in other word it will delete the attribute.