Directory Wizards Inc.

Solutions For Your Directory Needs

RSS feed
Add to Google


 

Categories

Knowledgebase

Changing Join indexes

Category:Active Directory

Last Updated:2011-08-02

 

Download PDF version

 

Many Create/Join connections use source/dest indexes of mail/mail.  Sometimes this causes duplicate entries when the source email address is changed. This is because as the source index, changing the source primary email address makes the object look like a new object to the sync.  So a new object is created. To avoid this, you must use indexes other than mail/mail.

 

In order to modify the connection to use different index attributes, you must identify appropriate source/dest attributes. These attributes must be populated and contain unique values, allowing the Join to work as designed, matching source objects to the destination.  If you have indexes that contain the required Join values, change the source/dest indexes appropriately. On the General tab, disable Sync and enable Simulation.  Run the simulation to review results before running a Sync. (See Important Notes below.)

 

If you can not identify appropriate source/dest attributes to use in place of mail/mail, it will be necessary to manufacture them (so to speak). In this case, you'd pick a source attribute SourceAttribX (that contains a guaranteed unique value in each source object) and set up your existing connection to sync that value to all destination objects using a custom mapping i.e DestAttribY=SourceAttribX. The first time you run with this mapping, you leave your mail/mail indexes in place. Once the above mapping has been applied on the initial sync run, you now have these alternate attributes set up and ready for use of source/dest indexes (SourceAttribX / DestAttribY). And new Adds will populate the DestAttribY as required.  

 

Once you have done the above, you can change your source/dest index from mail/mail to SourceAttribX/DestAttribY. Subsequent syncs will use this alternate index attribute set. And the custom mapping will remain so any new object added will have DestAttribY set as required for future Joins.  (See Important Notes below.)

 

Important Notes:

 

a) The first time you run after changing you indexes, it is highly recommended you disable Sync and enable Sim (General tab) in order to verify the Sim shows all Mods and no unexpected Adds. In the event of configuration mistakes, Simulation may show mass deletes or mass adds or other unexpected results. If you don't like the looks of your Sim results, do not run a real Sync until Support has reviewed your Sim log files.

 

b) You want make the above changes before any more source email addresses are changed... as the mail/mail indexes will continue to result in duplicates when any source email address is changed. Once you've changed your index set, the modification of the source email address will no longer result in duplicates.

 

c) The attribute DestAttribY must be indexed and visible in the Global Catalog.