Category Archives: Scripts

Update AD users from CSV

Create a CSV file with relevant data i.e. sAMAccountName,postalCode,givenName,sn user.name,444444,user,name Then import and run piping results to a csv.  Adapt the CSV and Set-AdUser sections to do what job you need. $data = Import-CSV -Path .\data.csv $data | ForEach-Object { $user = Get-ADUser -Filter “sAMAccountName -like ‘*$($_.sAMAccountName)*’” -Properties st,postalCode Set-ADUser -identity $user.sAMAccountName -PostalCode $_.postalCode }… Read More »

A simple VBS script to change IE Proxy Settings

I give this script to remote users so they can remove the Proxy settings when off site. set WshShell = CreateObject(“WScript.Shell”) Const HKEY_CURRENT_USER = &H80000001 strComputer = “.” Set objRegistry = GetObject(“winmgmts:\” & strComputer & “rootdefault:StdRegProv”) strKeyPath = “SOFTWAREMicrosoftWindowsCurrentVersionInternet Settings” wshshell.run “tskill iexplore /a” strValueName = “ProxyEnable” dwValue = 0 objRegistry.SetDWORDValue HKEY_CURRENT_USER, strKeyPath, strValueName, dwValue… Read More »

Mapping Printers via OU or Computer Name

A simple script that will map printers for users based on either the computer name or OU the computer is in, very handy if users roam between computers. Create the following script, save it in an accessible share such as netlogon and set it to run as a user startup script via GPO. ‘================================================== ‘PrinterMapping.vbs… Read More »

Force Windows to shutdown at a specific time free

Forcing shutdown can be done easily by creating a scheduled task on clients issuing the shutdown command. I create these tasks with a simple computer startup script run via a GPO. BasicScheduleTaskCreator.bat REM Delete existing tasks schtasks.exe /delete /TN Shutdown /f schtasks.exe /delete /TN Log_Off /f REM Create new tasks schtasks.exe /create /SC WEEKLY /D MON,TUE,WED,THU,FRI,SAT /ST 21:00:00 /TN… Read More »

Personalize Users Microsoft office

Having problems when users try to open a office document that is already open by another user but it doesn’t show the username.  The problem usually resides around a missing registry key at HKCUSoftwareMicrosoftOfficeCommonUserInfo run the following VBS script as a logon script to set the registry key correctly. on error Resume Next const HKEY_CURRENT_USER… Read More »