LDAP Delta sync

[Navyashree]

Hi All,

 In one of our account, we are using LDAP sync to get Distribution lists data into servicenow custom tables. There are 80K + DL's in AD and around 15-20 DL's has more than 10K member count. The initial sync took almost 3 days to process the entire data. 

 This sync has to be scheduled on daily basis. So, as I part of delta sync I've to load only the records which are modified or created in last one day. Can any one help me with the filter condition for this? or please let me know if there is another way to configure delta sync. 

Note: Since the target tables are custom tables in a scoped application, not able to make use of LDAP listener here.

[J Siva]

Hi @Navyashree 
Check out the comment from the below post. It may help you.

LDAP Search - Ignoring records older than a year

Regards,
Siva

[Ankur Bawiskar]

@Navyashree 

try this in filter to see what changed in last 24 hours

But remember just before your LDAP runs you will have to change the filter in the LDAP filter

(&(objectClass=group)(whenChanged>=20240522000000.0Z))

Use an LDAP filter like (&(objectClass=group)(whenChanged>=YYYYMMDDhhmmss.0Z)), dynamically setting the timestamp for "one day ago" at each sync. This will ensure only newly created or modified DLs are processed daily, drastically improving sync performance

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Navyashree]

Hi Ankur,

 Thanks for your suggestion. Since, we've to schedule the daily sync, the whenchanged date has to be updated dynamically in this filter. Is there a way to do that? For ex: if I want to sync only the DLs modified in last 24 hrs, everyday this filter should be updated with yesterday's datetime stamp.