Click here Batch Script ABCs (Basics)

Batch Script Basics
1) http://www.computerhope.com/batch.htm#01
2) http://www.csie.ntu.edu.tw/~r92092/ref/win32/win32scripting.html

Read More

Converting DOS Batch Files to Shell Scripts

Click the above link for Converting DOS Batch Files to Shell Scripts
http://tldp.org/LDP/abs/html/dosbatch.html

Read More

SQLCMD Syntax

sqlcmd
  [-U login id] [-P password] [-S server] [-H hostname] 
  [-E trusted connection] [-d use database name] [-l login timeout]
  [-N encrypt connection] [-C trust the server certificate]
  [-t query timeout] [-h headers] [-s colseparator] [-w screen width]
  [-a packetsize] [-e echo input] [-I Enable Quoted Identifiers]
  [-c cmdend] [-L[c] list servers[clean output]] [-q "cmdline query"]
  [-Q "cmdline query" and exit] [-m errorlevel] [-V severitylevel]
  [-W remove trailing spaces] [-u unicode output]
  [-r[0|1] msgs to stderr] [-i inputfile] [-o outputfile]
  [-f  | i:[,o:]]
  [-k[1|2] remove[replace] control characters]
  [-y variable length type display width]
  [-Y fixed length type display width]
  [-p[1] print statistics[colon format]]
  [-R use client regional setting] [-b On error batch abort]
  [-v var = "value"...]
  [-X[1] disable commands[and exit with warning]]
  [-? show syntax summary]

Click here for SQLCMD Utility 

Read More

Click here for DOS commands with XP

Click above link for DOS commands with XP

Read More

Create a Folder Using Batch Script

ECHO Starts Creating Folder
Set FDate=%Date:~-10,10%
Set Fdate=%FDate:/=-%
MD C:\test\%FDate%
Move C:\test\DATA\*.* C:\test\%FDate%

Copy above code in Notepad and save as ".BAT" Extension.

Read More

How to Import and Export bulk users/objects from Active Directory using CSVDE

Export users from a specified OU (organizational Unit)

Go to command prompt type the below command to export members from specified OU..

c:\csvde -f c:\ramadminss.csv -d ou="ouname",dc=dcname,dc=com -r (objectclass=user) -l "objectclass,sAMAccountName,sn,givenname,displayname,description,userprincipalname"

Bulk Export : c:\csvde -f report.csv

Bulk Import : c:\csvde -i -f report.csv

Follow this link for more information:
http://option9.blogspot.com/2009/05/importing-users-into-active-directory.html
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Bulk.htm

Read More

Export Distribution List Members (from Active Directory to Text)

Here is the Script to Export the members from DL

On Error Resume Next

WScript.Echo Now()
Set objGroup = GetObject _
("ldap://CN=testgroup,OU=groupname,DC=domain,dc=com")
objGroup.GetInfo
arrMemberOf = objGroup.GetEx("member")
WScript.Echo "Members:"
For Each strMember in arrMemberOf
WScript.echo strMember
Next

Copy the above code and save it in Notepad. Save this file as "DLmembers.vbs"

Execute from Command mode

c:\>cscript dlmembers.vbs >c:\output.txt

Read More

Batch File to Map network drive.

First, open up Notepad or your favorite text editor.


Next, copy the commands as shown below and paste them into the file. Don't forget to modify the net use command with the drive letter you want to use, the name of the Computer and share you want to map a drive to, and password and account name.

ECHO Starts Mapping Drive
net use W: file://computer1/Test
net use X: file://computer2/NewFolder
exit

Then save the file with any name and a .bat extension
When you need to map the drive(s), just double click on it.

Read More