Step-by-Step tutorial to schedule Active Directory export to Excel

This tutorial explains how to schedule an Active Directory export to excel using LDAP Admin Tool; To export data first connect to the directory server (To create a new connection please see Connecting to Active Directory remotely )

After successful connection, select the entry you want to export and select “Excel Export” from the right click context menu, an export connection dialog opens

Enter all the fields and Click 'Finish' (Click here for Excel Export tutorial)- Now look at the export file and if you are satisfied with the results, select 'Excel Export' again from the right click context menu, same excel export dialog will open. This time select the 'Schedule this Excel Export' Button.

Active Directory export

 

If you are using Simple Authentication, make sure that the save password box is checked and the credentials are admin credentials or credentials with password set to never expire otherwise task will fail when the credentials will expire. Click Next to continue.


Active Directory scheduler

 

If you want scheduler to write to a file, check the 'Write to a file' button and provide the file name and file name prefix date time format. Make sure you check the 'Replace File if exists' if you are using simple date time format like (mmddyy) and plan to run this task more than once a day. Click Next to continue.

 

LDAP Excel Export Page 3

Options

Description

Write To a File

Check the box if you want the scheduler to write the data to a file

Directory

Full path to the directory were scheduler will create the file

FileName

Name of the file to create and write data to

Prefix with DateTime

Check this box if you want the filename to be prefixed with the datetime stamp, select the format from the drop down

Replace File if Exists

Check this box if you want file to be overwritten or else you will get an error if file exists.

 

Check the 'Send Email' box if you want to send email after the scheduled process is over and/ or want to send file as an attachment. Enter the necessary information and Click Next


Scheduler LDAP Export to Excel Step 3

Options

Description

SMTP Host Name

This is the SMTP server to connect to.
If your SMTP server requires username and password to connect - click the options.. and enter the default username and password.

Attach file to email

Check this box, if you want to send the file as an attachment

From

From Email Address

To

Comma separated list of addresses to send the email to

CC

Comma separated list of addresses to cc this email to

Subject

Subject of the email

Append DateTime

Check this box if you want date to be appended to the subject, select the format from the drop down.

Message

Email Message

Append System and Error Messages

Check this box if you want system and error messages to be appended to the email message.

 

Enter a unique name for this task, select the text after header from the text box, open a command/terminal window, paste the text and click enter. Once you are satisfied with the results, create a scheduler task using windows scheduler or Linux cron. Click Finish to save this task.



Scheduler LDAP Export to Excel Step 3

Options

Description

Job Name

Enter a unique name for this task

See Also:

How to schedule task using Windows scheduler