URGENT : Inactivate in ServiceNow disabled LDAP users

[Nisha30]

Hello Experts,

Need help with a LDAPs filter query  where it should query only users who have been updated/refreshed in last 24 hours.

Connection is successfully to this OU (and this OU is only for INACTIVE users so we know all users present here are inactive) but we don't want whole bunch of such users who have been disabled a year ago or a month ago only the recent ones.

Purpose: Only user data who have been inactivated in last 24 hours comes in Import Staging table and ServiceNow can set such sys_user record to Active=FALSE

Any suggestion will be really helpful.

Thanks

[Mark Manders]

What is the urgency? You can ensure that nothing happens with users coming in as inactive, that are already inactive in ServiceNow. It will just end up in the import table and those are cleaned up.

[Nisha30]

Hi Mark,

Its urgent as we are approaching go live date .

Need is to inactivate users in ServiceNow As soon as it is in LDAP. So we have frequently scheduled but looking for some logic from community if can help so that we dont bring in all inactive users in ldap_import which are inactive for few years and months just need which have been updated in last 24 hours.

Thanks

[Mark Manders]

Check what attributes you have available in LDAP and find anything you can filter on: https://ldap.com/ldap-filters/

If you can't limit the input from there, you will need to apply the logic in your transform map (you will get all users then, but only transform the ones that are changed.

[Nisha30 · Accepted solution]

Just to let what we did is logic to change the filter dynamically and now it brings the filtered data .

I got an idea from the below post and it helped

Update LDAP Filter Query