Friday, 25 July 2014

Powershell script to add printers from CSV and adjust driver

If you find yourself needing to do a printer migration but cant/don't want to re-install the old drivers (e.g. a cross architecture migration), you can import your printers from a .csv and change the driver as needed:
CSV Format:

XXX,HP Test,IP_x.x.x.x,x.x.x.x,printername,location test,comment test,printername


function CreatePrinter {

$server = $args[0]

$print = ([WMICLASS]"\\$server\ROOT\cimv2:Win32_Printer").createInstance()

$print.drivername = $args[1]

$print.PortName = $args[2]

$print.Shared = $true

$print.Sharename = $args[3]

$print.Location = $args[4]

$print.Comment = $args[5]

$print.DeviceID = $args[6]



function CreatePrinterPort {

$server = $args[0]

$port = ([WMICLASS]"\\$server\ROOT\cimv2:Win32_TCPIPPrinterPort").createInstance()

$port.Name= $args[1]



$port.HostAddress= $args[2]





$printers = Import-Csv c:\printers.csv

foreach ($printer in $printers) {

CreatePrinterPort $printer.Printserver $printer.Portname $printer.IPAddress

CreatePrinter $printer.Printserver $printer.drivername $printer.Portname $printer.Sharename $printer.Location $printer.Comment $printer.Printername


Wednesday, 23 July 2014

VBScript to automatically map PST files into Outlook

Edit Set objFolder = objFSO.GetFolder("H:\PST")to suit your requirements:


Set objFSO = CreateObject("Scripting.FileSystemObject")

Set objnet = CreateObject("")

Set olkApp = CreateObject("Outlook.Application")

Set objFolder = objFSO.GetFolder("H:\PST")

For Each objFile In objFolder.Files

   If LCase(objFSO.GetExtensionName(objFile.Name)) = "pst" Then

     olkApp.Session.AddStore objFile.Path

   End If


Sunday, 13 July 2014

Extract data from Offline Files Client Side Cache (CSC) using CSCCMD

On a XP or 2003 machine:

Download CSCCMD 1.1 

Run the following:

csccmd /isenabled

csccmd /disable

Use the following reg key to set an alternate location for the database to be restored:


String = c:\CSCFiles

Disable NIC 

csccmd /enable

csccmd /enum

csccmd /extract /target:PathWhereToPutExtractedFiles /recurse

Wednesday, 30 April 2014

Simple powershell robocopy log analyser

Select-String -path "\\server\share\logfile.log" -pattern "Access Is Denied" -allm

atches -simplematch -context 1 | out-file '\\server\share\errors.log'

Wednesday, 23 April 2014

Robocopy monitor copying old files

If robocopy /MON or /MOT appears to be re-copying older files still - try these switches:

/XO - Exclude old files
/FFT - Assume FAT file times - allows slightly less sensitivity (2 seconds) when comparing file times.

robocopy SRC DST /copyall /MIR /MON:1 /XO /Z /W:5 /R:5 /fft

Tuesday, 15 April 2014

Aruba IAP's - Cisco Switches - Inconsistent peer vlan - Spanning Tree Blocking

If you receive the errors below on a Cisco switch when using Aruba IAP's:

%SPANTREE-2-BLOCK_PVID_PEER: Blocking FastEthernet0/XX on VLAN000X. Inconsistent peer vlan

and show spanning-tree shows the port as being blocked

Setup this configuration on the individual port:

spanning-tree bpdufilter enable