Admin Script: ADDS DsTools to append user attribute value "IPTel/ipPhone"

My friend requested me on script to help mass appending update value to user attribute "IPTel" (ipPhone) as shown on below screenshot.

Well, the solution is to use what is already available. In this script, i am using ADDS DsTools such as dsquery, dsget, and dsmod to update the user attribute value.

Here is the step:
1. Copy the content of below script into a batch file
2. Copy the batch file in Active Directory Server
3. Edit the batch configuration
    a. AD Users Container
    b. IPTel Prefix/Postfix value
4. Run the batch file
5. Once the batch file completed, the log file will be opened automatically.
6. Review the log file of any error as shown below screenshot

Hope this script will help your day....


Admin Scripts

Script #1: ADDS_DsTools_AppendUserAttributeValue_IPTel.cmd

@ECHO OFF SetLocal EnableDelayedExpansion ECHO ============================================================ ECHO YL Library : ActiveDirectory DsTools ECHO to append AD Users attributes (IPTel) ECHO Author : Zhang Yunlong ECHO Blog : ylnotes.blogspot.com ECHO Filename : ADDS_DsTools_AppendUserAttributeValue_IPTel.cmd ECHO ============================================================ ECHO History: ECHO 1.00 Initial Release ECHO ============================================================ ::------------------------------------------------ ::ADDS Container Setup ::------------------------------------------------ ::Set Parameter to OU containing User :: eg. OU=CO_USERS,DC=EXAMPLE,DC=LOCAL ::------------------------------------------------ SET ADDS_USERS_OU= ::------------------------------------------------ ::Set Limit Parameter :: Set to 0 for All Users :: Note: Default value is 100 ::------------------------------------------------ SET ADDS_QUERY_LIMIT=0 ::------------------------------------------------ ::Log File ::------------------------------------------------ SET UPDATE_LOG=ADDS_DsTools_AppendUserAttributeValue_IPTel.txt ::------------------------------------------------ ::Attributes IPTel Append Value ::Note: Set at least PREFIX, POSTFIX, or both and if not in used set to empty ::------------------------------------------------ SET IPTEL_VALUE_PREFIX=2 SET IPTEL_VALUE_POSTFIX= > %UPDATE_LOG% ECHO LOG: ADDS DsTools to Append AD Users Attribute (IPTel) >> %UPDATE_LOG% ECHO. >> %UPDATE_LOG% ECHO. >> %UPDATE_LOG% ECHO ==================================================================================================== >> %UPDATE_LOG% ECHO 1. Before Update >> %UPDATE_LOG% ECHO ==================================================================================================== SET /A iCounter=0 SET sCounter=0 FOR /F "tokens=1 delims=!" %%a IN ('dsquery user "%ADDS_USERS_OU%" -o dn -limit %ADDS_QUERY_LIMIT%^|dsget user -dn -iptel') DO ( IF "%%~a" NEQ "dsget succeeded" ( IF !iCounter! LSS 10000 SET sCounter=!iCounter! IF !iCounter! LSS 1000 SET sCounter=0!iCounter! IF !iCounter! LSS 100 SET sCounter=00!iCounter! IF !iCounter! LSS 10 SET sCounter=000!iCounter! >> %UPDATE_LOG% ECHO [!sCounter!] %%a SET /A iCounter=!iCounter!+1 ) ) :ACTION2 >> %UPDATE_LOG% ECHO. >> %UPDATE_LOG% ECHO ==================================================================================================== >> %UPDATE_LOG% ECHO 2. Updating IPtel >> %UPDATE_LOG% ECHO ==================================================================================================== SET /A iCounter=0 SET sCounter=0 FOR /F "tokens=1 delims=" %%a IN ('dsquery user "%ADDS_USERS_OU%" -limit %ADDS_QUERY_LIMIT% -o dn') DO ( FOR /F "skip=1 tokens=1-2 delims=!" %%b IN ('dsget user "%%~a" -iptel') DO ( IF "%%~b" NEQ "dsget succeeded" ( SET /A iCounter=!iCounter!+1 IF !iCounter! LSS 10000 SET sCounter=!iCounter! IF !iCounter! LSS 1000 SET sCounter=0!iCounter! IF !iCounter! LSS 100 SET sCounter=00!iCounter! IF !iCounter! LSS 10 SET sCounter=000!iCounter! SET sIPTelValue= FOR /F "tokens=1 delims= " %%e IN ("%%~b") DO ( SET sIPTelValue=%%~e ) SET NEW_VALUE=%IPTEL_VALUE_PREFIX%!sIPTelValue!%IPTEL_VALUE_POSTFIX% >> %UPDATE_LOG% ECHO. >> %UPDATE_LOG% ECHO [!sCounter!] DN: %%a >> %UPDATE_LOG% ECHO Update IPTel: ^(!sIPTelValue!^) --^> ^(!NEW_VALUE!^) FOR /F "delims=!" %%f IN ('dsmod user %%a -iptel "!NEW_VALUE!"') DO ( >> %UPDATE_LOG% ECHO %%f ) ) ) ) >> %UPDATE_LOG% ECHO. >> %UPDATE_LOG% ECHO ==================================================================================================== >> %UPDATE_LOG% ECHO 3. After Update >> %UPDATE_LOG% ECHO ==================================================================================================== SET /A iCounter=0 SET sCounter=0 FOR /F "tokens=1 delims=!" %%a IN ('dsquery user "%ADDS_USERS_OU%" -limit %ADDS_QUERY_LIMIT% -o dn^|dsget user -dn -iptel') DO ( IF "%%~a" NEQ "dsget succeeded" ( IF !iCounter! LSS 10000 SET sCounter=!iCounter! IF !iCounter! LSS 1000 SET sCounter=0!iCounter! IF !iCounter! LSS 100 SET sCounter=00!iCounter! IF !iCounter! LSS 10 SET sCounter=000!iCounter! >> %UPDATE_LOG% ECHO [!sCounter!] %%a SET /A iCounter=!iCounter!+1 ) ) START NOTEPAD.exe "%UPDATE_LOG%" EXIT