Find inactive LDAP accounts by using the userAccountControl field

task brazil Updated Sep 10, 2026 1 min read t_FindInactLDAPAcctsWUsrAcctCtrlFld.md
Raw file servicenow.com

Identify when an Active Directory (AD) user is deleted (or made inactive).

Before you begin

Role required: admin

About this task

One method is to track the active status of AD users and create a business rule to update corresponding accounts when an AD account is inactive.

Procedure

  1. Create a new string field on the User [sys_user] table to track the value of the AD userAccountControl field.

    For example: u_ad_user_account.

  2. Create an LDAP transform script to set the field value.

    Text
    target.u_ad_user_account = source.userAccountControl
  3. Update the LDAP filter to show disabled AD accounts.

    Here is an example of a filter.

    Text
    (&(objectClass=person)(sn=*)(!(objectClass=computer))(!(userAccountControl:1.2.840.113556.1.4.803:=2)))

    Here is an example of a replacement filter you can use.

    Text
    (&(objectClass=person)(sn=*)(!(objectClass=computer)))
  4. Create an onChange business rule to set the active field to false whenever the u_ad_user_account field has the value 514.

    '514' indicates an inactive account.

Search documentation
Search document titles and file paths on the brazil branch