PowerShell › Brandon's IT Blog

Removing locally installed printers and replacing with print server

Brandon / PowerShell, Print Server / Leave a Comment

Recently ran into an environment where there was a print server installed and managing all 200 printers however some users (380 computers) still had printers installed locally and were printing directly to the printer through the IP address or host name. This can cause issues with permissions, driver updates, or logging.

Instead of manually touching each computer I created a PowerShell script to verify it was a network printer installed locally and if it existed on the print server to install it for the user, reducing phone calls to the help desk. The script also confirms they are on the corporate network to continue and run and also verifies the printer is online so that it doesn’t remove personal printers that may have been installed for home use.

#Only run if on the corporate network to prevent removing personal printers
$Continue = $false
  
$DNSAddresses = Get-DNSClientServerAddress | Select-Object -ExpandProperty ServerAddresses
  
foreach ($DNSAddresses in $DNSAddresses)
{
    #Check DNS server IP to ensure on corporate network
    if($DNSAddresses -eq "192.168.x.x")
    {
        $Continue = $true
        Write-Host "We are on corporate network, continuing.."
        break
    }
}
  
if($Continue -eq $true)
{
    $LocalPrinters = Get-Printer
  
    foreach ($printer in $LocalPrinters)
    {
        if($printer.Type -eq 'Local')
        {
  
            $Port = $printer.PortName.Split("_")
       
            #Checking if a live printer on corporate network
            $ConnectionResults = Test-Connection $Port[0] -Count 1 -Quiet
  
            #Checking if printer is a network printer
            if($ConnectionResults -eq $true)
            {
                Write-Host "Deleting printer: " $printer.Name
                Remove-Printer -Name $printer.Name
  
                #Checking if printer is on print server so we can re-add it
                 $PrintServerPrinterPortName = Get-Printer -ComputerName "printserver.domain.org" -Name $Port[0]
  
                Write-Host "Printers found on print server with same port name: "$PrintServerPrinterPortName.Count
  
                if($PrintServerPrinterPortName.Count -gt 0)
                {
                    $AddPrinter = "\\printserver.domain.org\" + $Port[0]
                   Write-Host "Adding printer from print server: " + $AddPrinter
                  
                   Add-Printer -ConnectionName $AddPrinter
                }
                else
                {
                    Write-Host "Did not find printer on print server with same port name. Checking printer name."
                    $PrintServerPrinterName = Get-Printer -ComputerName "printserver.domain.org" -Name $printer.Name
  
                    Write-Host Write-Host "Printers found on print server with same printer name: "$PrintServerPrinterName.Count
  
                    if($PrintServerPrinterName.Count -gt 0)
                    {
                        $AddPrinter = "\\printserver.domain.org\" +$printer.Name
                        Write-Host "Adding printer from print server: " + $AddPrinter
                        
                        Add-Printer -ConnectionName $AddPrinter
                    }
                    else
                    {
                        Write-Host "Exhausted all options and no printers found."
                    }                
                }
            }        
        }
    }
}
  

Removing locally installed printers and replacing with print server Read More »

Remove DNS NS Records after demoting domain controller with PowerShell

Brandon / Active Directory, DNS, PowerShell / Leave a Comment

Get-DnsServerZone | ForEach-Object { Get-DnsServerResourceRecord -ZoneName $_.ZoneName -RRType Ns | Where-Object {$_.RecordData.NameServer -like ‘DCName.fqdn.com.‘} | Remove-DnsServerResourceRecord -ZoneName $_.ZoneName -Confirm:$false }

Replace the bold test with the fully qualified domain name of the name server. Don’t forget to keep the period at the end of it as well.

Remove DNS NS Records after demoting domain controller with PowerShell Read More »

SharePoint – Export All Documents on Site and Sub-Sites

Brandon / PowerShell, SharePoint / Leave a Comment

I was eliminating a site on SharePoint that had over 50 sub-sites. I wanted an easy way to get all the documents in each site without having to manually visit each one. Here is an easy PowerShell script I came up with.

#Created by Brandon Claps
#9/25/14
#Exports all documents under a specific site and sub-sites to a local directory
  
#Address of your SharePoint root site
$MainSiteAddress = "https://sharepointsite.contoso.com"
  
#URL of what you you would like to gather. Type a single asterisk if you want everything
$MatchURL = "*URLAddress*"
  
#Destination where you want to download the documents to
$destination = "D:\Exported Documents"
  
  
$Site = Get-SPSite $MainSiteAddress
$WebCollection = $Site.AllWebs
  
foreach($Web in $WebCollection)
{
    foreach($List in $Web.Lists)
    {
        if($List.ParentWebUrl -like $MatchURL)
        {
            if($List.BaseTemplate -eq "DocumentLibrary")
            {                                
                $webUrl = $MainSiteAddress + $List.ParentWebUrl
                $listUrl = $webUrl + "/" + $List.RootFolder.Url
                
                $web2 = Get-SPWeb -Identity $webUrl
                $list2 = $web2.GetList($listUrl)
                
                function ProcessFolder 
                {
                    param($folderUrl)
                    $folder = $web2.GetFolder($folderUrl)
                    
                    foreach ($file in $folder.Files) 
                    {
                        $destinationfolder = $destination + "/" + $List.ParentWebUrl.TrimStart("/").Replace("/","-") + "---" + $folder.Url 
                        if (!(Test-Path -path $destinationfolder))
                        {
                            $dest = New-Item $destinationfolder -type directory 
                        }
                        
                        $binary = $file.OpenBinary()
                        $stream = New-Object System.IO.FileStream($destinationfolder + "/" + $file.Name), Create
                        $writer = New-Object System.IO.BinaryWriter($stream)
                        $writer.write($binary)
                        $writer.Close()
                    }
                }
                Write-Host "Downloading: " $listUrl 
                ProcessFolder($list2.RootFolder.Url)
            
                foreach ($folder in $list2.Folders) {
                    ProcessFolder($folder.Url)
                }                                
            }        
        }        
    }
 }

SharePoint – Export All Documents on Site and Sub-Sites Read More »

Configuring alarms on all VMware alarm definitions automatically using PowerShell

Brandon / PowerShell, VMware / Leave a Comment

My example contains alarm actions to send an email, but you can configure this for SNMP or any other actions. You can copy and paste this into a “.ps1” file to create a PowerShell scripts.

# This command will remove any alarms actions that are configured currently.
Get-AlarmDefinition | Get-AlarmAction | Remove-AlarmAction -confirm:$false
 
#This command will add an alarm action to send an email. It automatically adds the trigger for status "Yellow" to "Red".
Get-AlarmDefinition | New-AlarmAction -Email -To '[email protected]'
 
#This command adds and additional trigger to send an email when the the status changes from "Yellow" to "Green"
Get-AlarmDefinition | Get-AlarmAction -ActionType "SendEmail" | New-AlarmActionTrigger -StartStatus "Yellow" -EndStatus "Green"

Configuring alarms on all VMware alarm definitions automatically using PowerShell Read More »

SharePoint 2010 Alerts – Daylight Savings Time (DST)

Brandon / PowerShell, SharePoint 2010 / 9 Comments

Are your alerts behind or ahead by an hour? Microsoft has created a PowerShell script to automatically update your alerts for daylight savings time.

http://technet.microsoft.com/en-us/library/cc508847.aspx

You’ll want to make sure you’re running the script as a SharePoint administration from within the SharePoint Management Shell.

Add the PowerShell script to the scope

. ./Invoke-AlertFixup.ps1 (make sure there is a period, space, period)

Type Invoke-AlertFixup –site <URL> –oldurl <URL> (if using this script for DST, make sure the site URL and oldurl are the same.

SharePoint 2010 Alerts – Daylight Savings Time (DST) Read More »

SharePoint 2010: Unable to Display This Web Part. Error while executing web part: System.StackOverflowException: Operation caused a stack overflow.

Brandon / PowerShell, SharePoint 2010 / 1 Comment

This was caused by the XsltTransformTimeout when using an Xslt list view. This is corrected by installing the February 2012 Cumulative Update and by making the following change via PowerShell.

Check Current Setting

$farm = Get-SPFarm
$farm.XsltTransformTimeOut

The default setting is 1 second. The PowerShell code below changes it to 5 seconds which should be sufficient.

Change Setting to 5 Seconds

$farm = Get-SPFarm
$farm.XsltTransformTimeOut = 5
$farm.Update()

SharePoint 2010: Unable to Display This Web Part. Error while executing web part: System.StackOverflowException: Operation caused a stack overflow. Read More »

Schedule Update-SPProfilePhotoStore

Brandon / PowerShell, SharePoint 2010 / Leave a Comment

Create a PowerShell script with the following. Make sure your MySite host location is correct.

Add-PSSnapin Microsoft.SharePoint.PowerShell Update-SPProfilePhotoStore -CreateThumbnailsForImportedPhotos 1 -MySiteHostLocation http://mysitehostlocation/MySite/

Save the file as a .ps1 file on your SharePoint 2010 server – C:\Scripts\UpdateSPPhotos.ps1
Create a daily scheduled task on the SharePoint 2010 server that runs at the SharePoint Farm Administrator account.
Configure the action as follows

Program/script: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
Arguments: -NonInteractive -NoProfile -File “C:\Scripts\UpdateSPPhotos.ps1”

Schedule Update-SPProfilePhotoStore Read More »

Check Windows Service Status with PowerShell

Brandon / PowerShell / Leave a Comment

I needed a way to watch a service and if it was stopped to start it. I created this PowerShell script to check it, start it and create a log, using it in a scheduled task.

Make sure the service name is the name of the actual service and not the display name for the service.

$logFile = "C:\test.csv"
$serviceName = "ServiceName";
$serviceStatus = (get-service "$serviceName").Status;
$date = Get-Date
$dateShort = $date.ToShortDateString()
$timeShort = $date.ToShortTimeString()
$i = 1
 
if ($serviceStatus -eq "Running") 
    {
        Add-Content $logFile "$dateShort, $timeShort, $serviceName is $serviceStatus"
    }
elseif ($serviceStatus -eq "Stopped") 
    {
 
            Add-Content $logFile "$dateShort, $timeShort, $serviceName is $serviceStatus, Starting"
            Start-Service $serviceName
        $serviceStatus = (get-service "$serviceName").Status;
        Add-Content $logFile "$dateShort, $timeShort, $serviceName is $serviceStatus"
            
    }
else 
    {
            Add-Content $logFile "$dateShort, $timeShort, $serviceName is $serviceStatus, Unable to Start"
    }

Check Windows Service Status with PowerShell Read More »