UpdateAdd Statement (Version 3.2 onwards)

 

The UPDATEADD statement adds values to the exiting attributes, creating the attribute if it does not already exists. The basic UpdateAdd statement has 4 clauses:

 

The UPDATEADD clause specifies the entry(ies) to update. The SET clause specifies the attributes to update. The WHERE clause specifies the condition. The WHERE clause is optional; if missing, all the entries within the container will be updated depending upon the query scope. The QUERY SCOPE is new for ldap query, if missing the default is subtree scope and will return all the subentries (you can change the default from the radio buttons at the bottom of sql editor). UpdateAdd statement has the following general format

 

UPDATEADD Entry SET set-list [WHERE predicate] [QuerryScope]

 

To add a new value to an existing attribute for e.g mail you write a statement as:

UPDATEADD ou=testusers,o=stooges SET mail='newaddress@ldapsoft.com'

This sql will update all the entries in the cn=testuser,DC=LDAPSOFT,DC=COMcontainer as the default scope is subtree scope,  the above update statement is same as :

UPDATEADD ou=testusers,o=stooges SET mail='newaddress@ldapsoft.com' subtreescope

 

To update only the immediate children you type sql statement as:

UPDATEADD ou=testusers,o=stooges SET mail='newaddress@ldapsoft.com' onelevelscope

 

To update the entry only you type sql statement as:

UPDATEADD ou=testusers,o=stooges SET mail='newaddress@ldapsoft.com' basescope

 

Before and after snapshot after running the following UPDATEADD statement:

UPDATEADD cn=testuser1,ou=testusers,o=stooges SET description ='description2'

 

Update Replace Ldap Attribute            Update Add ldap attribute

 

Related Links:

Difference b/w Update, UpdateAll and UpdateReplace

UpdateReplace statement

Update Statement

Update statement examples

 


Ldapsoft Home page AD Admin Tool Home Page