Useful commands for Sys Admins

• Given an IP and mask, return the subet the IP belongs to

for /f "tokens=1-8 delims=.- " %i in ('echo 192.168.5.200 255.255.255.0') do set /a Octet1="%i & %m" >nul & set /a Octet2="%j & %n" >nul & set /a Octet3="%k & %o" >nul & set /a Octet4="%l & %p" >nul & Echo %i.%j.%k.%l,!Octet1!.!Octet2!.!Octet3!.!Octet4!,%m.%n.%o.%p

• Disable the internal speaker beep

sc config beep start= demand & net stop beep

• List the Volume Shadow Copy Sets

vssadmin list shadows

• List the volume Shadow Copy storage associations and sizes

vssadmin list shadowstorage

• Find the domain controller GUID of the specified DC

dsquery * "CN=dcname,OU=Domain Controllers,DC=domainRoot" -scope base -attr objectguid

• Find DFS roots from Active Directory

dsquery * "CN=Dfs-Configuration,CN=System,domainRoot" -filter "(objectClass=fTDfs)"

• Find the SQL Server version

sqlcmd -S %server% -d master -W -s "," -Q "SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')"

• From a list of computers, run a command if the machine responds to a ping

for /f %i in (computers.txt) do @ping -n 1 %i >nul & if errorlevel 0 if not errorlevel 1 echo %i

• Make a bootable CD using the specified boot sector file and source files

oscdimg /m /n /h -bc:\temp\bootsector.bin "c:\temp\source" install.iso

• Find memory information from a list of machines

for /f %i in (computers.txt) do for /f "tokens=1-5" %m in ('"wmic /node:%i path Win32_PerfFormattedData_PerfOS_Memory get PoolNonpagedBytes,PoolPagedBytes,PoolPagedResidentBytes,FreeSystemPageTableEntries,AvailableMBytes | find /i /v "bytes""') do echo %i,%m,%n,%o,%p,%q

• Allow remote desktop connections on a the Server (requires reboot)

reg add "HKLM\SYSTEM\CurrentControlSet\Control\Terminal Server" /v fDenyTSConnections /t reg_dword /d 0x0

• Disable hibernation on the Server

powercfg -hibernate off

• Enable boot logging on the Server

bcdedit /set {default} bootlog yes

• Adjust Windows Server event log sizes to 128MB

wevtutil sl Security /ms:135266304

• Find the physical disk sector size

wmic path win32_diskdrive get BytesPerSector

• Find the current amount of memory used by the file system virtual cache

wmic path Win32_PerfFormattedData_PerfOS_Memory get SystemCacheResidentBytes

• Use robocopy in backup mode to take a copy of folder-level permissions

Robocopy \\server\source c:\temp\copy zxcvsadfqwer /E /B /COPYALL /R:1 /W:1