====== Active Directory Users and Computers custom LDAP query ====== - Right click on 'Saved Queries' - New -> Query - Enter name - Click 'Define Query' - Select 'Custom Search' - Click 'Advanced' tab - Enter query and confirm * **(&(samAccountName=*)(objectCategory=user))** All users * **(&(samAccountName=*)(objectCategory=user)(memberOf=cn=Domain Admins,CN=Users,DC=example,DC=com))** All users in group 'Domain Admins' * **(&(objectCategory=person)(userAccountControl:1.2.840.113556.1.4.803:=65536))** Users with valid password expiry * **(objectCategory=person)(objectClass=user)(pwdLastSet=0)(!useraccountcontrol:1.2.840.113556.1.4.803:=2)** Users with expiring password * **(objectCategory=person)(objectClass=user)(useraccountcontrol:1.2.840.113556.1.4.803:=2)** All disabled users * **(objectCategory=person)(objectClass=user)(!useraccountcontrol:1.2.840.113556.1.4.803:=2)** All enabled users * **(objectcategory=person)(!mail=*)** Users with no email address * **(&(&(objectCategory=person)(objectClass=user))(|(lastLogon=0)(!(lastLogon=*))))** Users who never loged in * **(&(objectCategory=computer)(servicePrincipalName=MSSQLSvc*)(operatingSystem=Windows Server*))** All servers with SQL * **(&(objectCategory=computer)(servicePrincipalName=MSSQLSvc*)(operatingSystem=Windows Server 2003))** All Windows 2003 servers with SQL * **(&(samAccountName=*)(objectCategory=computer))** All computers * **(&(objectCategory=computer)(operatingSystem=Windows 2000*))** All Windows 2000 computers * **(&(objectCategory=computer)(operatingSystem=Windows XP*))** All Windows XP computers * **(&(objectCategory=computer)(operatingSystem=Windows XP*)(!operatingSystemServicePack=*))** All Windows XP computers with no service pack * **(&(objectCategory=computer)(operatingSystem=Windows XP*)(operatingSystemServicePack=Service Pack 1))** All Windows XP computers with SP1 * **(&(objectCategory=computer)(operatingSystem=Windows XP*)(operatingSystemServicePack=Service Pack 2))** All Windows XP computers with SP2 * **(&(objectCategory=computer)(operatingSystem=Windows XP*)(operatingSystemServicePack=Service Pack 3))** All Windows XP computers with SP3 * **(&(objectCategory=computer)(operatingSystem=Windows Server 2003))** All Windows 2003 computers * **(&(objectCategory=computer)(operatingSystem=Windows Server 2003)(!operatingSystemServicePack=*))** All Windows 2003 computers with no service pack * **(&(objectCategory=computer)(operatingSystem=Windows Server 2003)(operatingSystemServicePack=Service Pack 1))** All Windows 2003 computers with SP1 * **(&(objectCategory=computer)(operatingSystem=Windows Server 2003)(operatingSystemServicePack=Service Pack 1))** All Windows 2003 computers with SP2 * **(&(objectCategory=computer)(operatingSystem=Windows Vista*))** All Windows Vista computers * **(&(objectCategory=computer)(operatingSystem=Windows Vista*)(!operatingSystemServicePack=*))** All Windows Vista computers with no service pack * **(&(objectCategory=computer)(operatingSystem=Windows Vista*)(operatingSystemServicePack=Service Pack 1))** All Windows Vista computers with SP1 * **(&(objectCategory=computer)(operatingSystem=Windows Vista*)(operatingSystemServicePack=*))** All Windows Vista computers with SP2 * **(&(objectCategory=computer)(operatingSystem=Windows Server 2008*))** All Windows 2008 computers (including R2) * **(&(objectCategory=computer)(operatingSystem=Windows Server 2008*)(!operatingSystemServicePack=*))** All Windows 2008 computers with no service pack * **(&(objectCategory=computer)(operatingSystem=Windows Server 2008*)(operatingSystemServicePack=Service Pack 1))** All Windows 2008 computers with SP1 * **(&(objectCategory=computer)(operatingSystem=Windows Server 2008*)(operatingSystemServicePack=Service Pack 2))** All Windows 2008 computers with SP2 * **(&(objectCategory=computer)(operatingSystem=Windows 7*))** All Windows 7 computers * **(&(objectCategory=computer)(operatingSystem=Windows 7*)(!operatingSystemServicePack=*))** All Windows 7 computers with no service pack * **(&(objectCategory=computer)(operatingSystem=Windows 7*)(operatingSystemServicePack=Service Pack 1))** All Windows 7 computers with SP1 * **(&(objectCategory=computer)(operatingSystem=Windows 8*)(!operatingSystem=Windows 8.1*))** All Windows 8 computers * **(&(objectCategory=computer)(operatingSystem=Windows 8.1*))** All Windows 8.1 computers * **(&(objectCategory=computer)(operatingSystem=Windows 10*))** All Windows 10 computers * **(&(&(&(objectCategory=Person)(objectClass=User)(lockoutTime>=1))))** All locked users