LDAP query every 5 to 10 minutes

Alex Macdonel · ‎11-18-2013

Is there a way to configure an LDAP pull that will bring in only new user records for the last few hours or day?

It appears that the Listener process doesn't create new user records but, to create an account, I need to do a full LDAP sync that, if I run every 5 minutes, would swamp my connection.

Is there a way to create an LDAP OU definition with a filter for uSNChanged in the last few hours?

Thanks,

prdelong · ‎11-19-2013

Create a new LDAP OU and Data Source if you haven't already. Make sure the settings are the same as your normal ones, including the target table. This allows you to leverage existing LDAP transform maps.

1) Create new Scheduled Job -- > Automatically run a script of your choosing.
2) Give it a name and set it to run daily at midnight (or whatever time you want).
3) Paste the attached script into the "run this script" field
4) Update the sys_id values in the script for you new LDAP OU and Data source
5) Save record and test

I successfully tested the dynamic filter and OU filter updater in a demo instace. However I was not able to verify the trigger execution as I could not run this against our LDAP server.

View solution in original post

Alex Macdonel · ‎12-19-2013

This looks like what I'm looking for. I haven't had a chance to test it and I won't have for a couple more weeks but I will test it and let you know if it worked for me or not. Thanks!

Aaron40 · ‎12-20-2013

Payton is absolutely right but what kind of feed are you running every few minutes?

Is it a large feed? Is it your user feed?

These types of feeds are typically run at night or during the time there is the least amount of traffic in ServiceNow because you can see performance hits when large feeds run. Just be careful 🙂