Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
finding OU and deleting from domain Batch Script list COMPUTER and Another script move/delete them
Hello fellas,
Is there any way, anybody can help me to create these three scripts below, I would appreciate a brilliant mind/s:
1) put in a computerlist.txt and will output.csv the computer name(column A) and current OU(column B) e.g.:
PC NAME OU
workstation1 ACME
2)put in a computerlist.txt and it moves them to an specific OU
3)put in a computerlist.txt and deletes them from the domain
any thoughts?
Is there any way, anybody can help me to create these three scripts below, I would appreciate a brilliant mind/s:
1) put in a computerlist.txt and will output.csv the computer name(column A) and current OU(column B) e.g.:
PC NAME OU
workstation1 ACME
2)put in a computerlist.txt and it moves them to an specific OU
3)put in a computerlist.txt and deletes them from the domain
any thoughts?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Finding the OU could be done with DSQuery:
Is this what you are looking for?
setlocal EnableDelayedExpansion
rem Header
echo PCNAME,OU > output.csv
for /F %%A in (computerlist.txt) do call :findou %%A
exit /b
:findou
set OU=
for /F "tokens=2 delims=," %%F in ('dsquery computer -name %1') do set OU=%%F
echo %1,%OU% >> output.csv
exit /b
Is this what you are looking for?
Moving a computer is quite similar, after finding the OU of the computer, use dsmove to move it to another OU:
Deleting is done with dsrm:
As always, first test !
setlocal EnableDelayedExpansion
for /F %%A in (computerlist.txt) do call :movecomputer %%A
exit /b
:movecomputer
set OU=
for /F %%F in ('dsquery computer -name %1') do dsmove %%F -newparent ou=Marketing,dc=microsoft,dc=com
exit /b
Deleting is done with dsrm:
setlocal EnableDelayedExpansion
for /F %%A in (computerlist.txt) do call :removecomputer %%A
exit /b
:removecomputer
set OU=
for /F %%F in ('dsquery computer -name %1') do dsrm %%F -noprompt
exit /b
As always, first test !
Deroode,
pretty close..., for your first, I created this one line script, which pretty much does what I need but I don't know how to split the result into the two columns
for /f "tokens=1" %a in (computerlist.txt) DO dsquery computer -name %a>>output.csv
so this is what CSV would look like e.g.
CN=WORKSTATION1,OU=Compute
do you know how to split the result csv like so?
Column A Column B
cn=workstation1 OU=Computers,OU=Marketing,
pretty close..., for your first, I created this one line script, which pretty much does what I need but I don't know how to split the result into the two columns
for /f "tokens=1" %a in (computerlist.txt) DO dsquery computer -name %a>>output.csv
so this is what CSV would look like e.g.
CN=WORKSTATION1,OU=Compute
do you know how to split the result csv like so?
Column A Column B
cn=workstation1 OU=Computers,OU=Marketing,
I wouldn't know how to do that; mainly because the output of de dsquery command is in fact a comma separated list, and for the csv file you actually want the first name, a comma, and then the rest of the line in quotes so the result is:
"cn=workstation1","OU=Comp
Maybe with some tricks you could do that in one line, but i guess that would become quite unreadable. My script does the job and is pretty straightforward....
"cn=workstation1","OU=Comp
Maybe with some tricks you could do that in one line, but i guess that would become quite unreadable. My script does the job and is pretty straightforward....
Premium Content
You need an Expert Office subscription to comment.Start Free Trial