LDAPSoft LDAP And Active Directory Tools Community Forums LDAPSoft Home
  [Search] Search   [Register] Register /  [Login] Login 
Messages posted by: support
Forum Index » Profile for support » Messages posted by support
Author Message
Thank you for reporting this issue to us.

Can u please check the attribute, is it a binary attribute or a text attribute?
If it is binary then the values are base64 encoded UTF8 and will preserve the characters during import.
If you are trying to connect to ADAM using SSL not SASL and using the internal Microsoft CA certificate, please read the following on how to fix this issue:

http://www.ldapsoft.com/activedirectorysslissue.html
Please read the following on how to fix this problem:

http://www.ldapsoft.com/activedirectorysslissue.html
Try setting the max Results to 0 and try.

Admin Tool behaves same unless it is Active Directory.

If still you are unable to get more than 10,000 it might be the security on you side.
As the error says there is some data which the export process unable to convert to excel format.
Try exporting in the csv format or limit the number of attributes to export.

To limit the number of attributes
1. Select the browse button on the right hand side of 'Returning Attributes' text box
2. Select a few attributes like distinguishedName,cn,description,mail,creationTime,co,company,department,displayName,homeDirectory,homeDrive

Click Finish.
Make sure that you don't have any spaces after the last )
To export all Active Directory disabled user

Select a top level container (not RootDSE) from the left hand explorer window and select export->Excel Export from the right hand context menu and follow the following steps:

1. Enter the name of the Excel file
2. In the filter text box remove (objectclass=*) and paste the following:
(&(objectCategory=Person)(objectClass=User)(userAccountControl:1.2.840.113556.1.4.803:=2))
3. Select the attributes to return or leave it to default.


Click Finish.

-------------------------

To Search for all disabled user

Right Click RootDSE (Top left in the explorer window) and Select Search. In the dialog click the Text Filter tab and paste the following

(&(objectCategory=Person)(objectClass=User)(userAccountControl:1.2.840.113556.1.4.803:=2))

Click Search.

To search specific container select a container to search and select search from the right hand context menu.
Make sure that you have the permission to access the monitor and also monitor is enabled

Please read the following on how to enable the openldap monitor
http://www.openldap.org/doc/admin24/monitoringslapd.html
Replace o=stooges with something like OU=US,DC=LDAPSOFT,DC=COM or DC=LDAPSOFT,DC=COM
this is the search base - It is the container containing the computer

Replace cn='test331copy of Curley Howard1'
with cn=computername or distinguishedName='Full Computer DN'
Unfortunately not, may be in future we will try to provide this functionality.
Sorry it can't. You cannot schedule ldap exports with LDAP Admin Tool.
You can't import the list, what you can do is get the cn or dn from the list and construct a statement like this

1) Select FROM o=stooges where cn='test331copy of Curley Howard1' subtreescope

2) Now Click on the SQL button on the top

3) Run the statment, if you get the results change the statement to
DELETE FROM o=stooges where cn='test331copy of Curley Howard1' subtreescope


4) Run the delete statement, confirm the records and click 'Yes'

You will have to do it for all the records in the list

Make sure that you run the statements in the dev environment before running them against production.
This issue has been fixed in 2.6 version, please download the latest from the download page.
If the attributes values are empty or null they are not exported and displayed in the export file.
Only attributes with values are displayed.

If any one record has all the attributes populated, it will display all the attributes in the export file.



Thank you for reporting this issue to us.

This issue has been fixed.

 
Forum Index » Profile for support » Messages posted by support
Go to:   
[Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
Powered by JForum 2.1.8 © JForum Team