This tutorial explains how to schedule the count of all users created yesterday(For more information on how to query LDAP to find the count of records in a container, please click here).

To schedule the count of all users created yesterday first connect to the directory server (To create a new connection please see Connecting to a LDAP Server using LDAP Admin Tool)

After successful connection, select the SQL button from the top menu, this will open the sql tab where you can enter the sql statements.

To find the count of all users created yesterday in the container o=stooges enter the following sql statement in the SQL Pane:

SELECT Count (*) FROM o=stooges where (objectClass='person' or objectClass='organizationalPerson' or objectClass='inetOrgPerson' ) and createTimestamp <= CurrentEndofDay -1 days and createTimestamp >=CurrentStartofDay -1 days
subtreescope

also increase the maximum count if you expect more than 1000 records

Now Click the Run button from the top menu or from right click context menu. After successful run a dialog will open showing a total number of records in the container o=stooges.

 

To schedule this count of records, Click the Export Button and select 'Schedule this export' link (For count (*) query you can select any type of export, the results will only be written to the log file and emailed to you if you select the email option)

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.

 

For count (*) you can skip the write to a file page as the count will only be written to logs and will be send in email, so uncheck the write to a file check box or just leave it to default.

 

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. Fill in the necessary information and click Next.

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.

Options Description Job Name Enter a unique name for this task

 

See Also:

How to schedule task using Windows scheduler
How to schedule task using Linux cron
Query LDAP Using Select Statements