CodeKeep PowerShell Feed

Killing a Hanging Service

Wed, 13 Jun 2012 14:37:16 GMT

Description: Commands to kill a Hung / Hanging windows Service

Link: http://www.codekeep.net/snippets/a317fda1-0b93-47d4-bdbf-e1e8661294d9.aspx

C:\Documents and Settings\Administrator>sc queryex ServiceName

SERVICE_NAME: ServiceName
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 2  START_PENDING
                                (STOPPABLE,NOT_PAUSABLE,ACCEPTS_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0
        PID                : 2364
        FLAGS              :

C:\Documents and Settings\Administrator>taskkill /F  /PID 2364
SUCCESS: The process with PID 2364 has been terminated.

GetInstalledPrograms

Fri, 27 Jan 2012 14:29:32 GMT

Description: get a list of all installed programs

Link: http://www.codekeep.net/snippets/dd48dff8-b1da-4120-919a-9b17bde06075.aspx

    function Get-InstalledPrograms($computer = '.') { $programs_installed = @{}; $win32_product = @(get-wmiobject -class 'Win32_Product' -computer $computer); foreach ($product in $win32_product) { $name = $product.Name; $version = $product.Version; if ($name -ne $null) { $programs_installed.$name = $version; } } return $programs_installed; }

Create Event Source

Mon, 16 Jan 2012 00:48:01 GMT

Description: Create Event Source

Link: http://www.codekeep.net/snippets/bb33c747-36d9-42ed-aff5-8cafd4d1bc34.aspx

new-eventlog -source ScheduledTasks -logname Application
write-eventlog -logname Application -source ScheduledTasks -eventID 1000 -entrytype Information -message "Test"

Reset FireFox Profile

Sat, 19 Nov 2011 13:11:30 GMT

Description: Helps if FireBug wacks out...

Link: http://www.codekeep.net/snippets/ff85a954-c540-4062-9f4d-7f715397a58a.aspx

Installing in a clean profile

To test for bugs regarding interactions with other extensions or corrupted profiles, you should do the following.

Firefox and Firebug re-install rarely fixes problems because the configuration files are not altered on reinstall. So to clear out the configuration files you need to create a new Firefox profile:
[edit] Linux Way

    Exit Firefox
    Get to a command line
    Run Firefox with -ProfileManager 

 $ firefox -ProfileManager

    Create New Profile
    Start Firefox with your new profile
    Load Firebug into this clean profile. 

[edit] Windows Way

    Exit Firefox
    Get to a command line
        Windows: Start->Run->"cmd" enter 
    Run Firefox with -ProfileManager (use quotes around the file name because of the spaces) 

 "C:\Program Files\Mozilla Firefox\firefox.exe" -ProfileManager

    Create New Profile
    Start Firefox with your new profile
    Load Firebug into this clean profile.

Scheduling a Powershell Script

Wed, 02 Nov 2011 14:32:57 GMT

Description: Setting the "Action" for Scheduling a Powershell Script with arguments

Link: http://www.codekeep.net/snippets/cf09585a-bf13-429d-a481-8b36b5f14144.aspx

#Assumptions
#-Arg1 is a file path

#Program  : 
Powershell.exe
#Arguments: 
-nolog -command "&{.\myPSScript.ps1 -Arg1 ".\myfilepath"}"

Load vs2010 environment variables

Tue, 04 Oct 2011 15:30:06 GMT

Description: run the vs2010 command prompt batch file to add those values to the local ps environment

Link: http://www.codekeep.net/snippets/9ee3f3a2-2d7c-4b69-a711-516ff2531ce6.aspx

#remove-item alias:\devenv -force
$private:defaultvs2010path="D:\Program Files (x86)\Microsoft Visual Studio 10.0"
if(test-path $defaultvs2010path){
    $vs2010path=$defaultvs2010path 
    if(join-path $vs2010path "vc\vcvarsall.bat" | test-path)
    {
        function VS-CmdPrompt()
        {
            #%comspec% /k ""D:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\vcvarsall.bat""
            $private:vsvarsallbatPath=join-path $vs2010path "\VC\vcvarsall.bat"
            if(!(test-path $vsvarsallbatPath)){
                $(throw "Vsvarsall.bat not found at :"+$vsvarsallbatPath)
            } else {
                & ($vsvarsallbatPath)
            }
    }
    }    
}

Launch VS2010

Tue, 04 Oct 2011 14:55:45 GMT

Description: different options for opening VS2010 with flags

Link: http://www.codekeep.net/snippets/ac3da136-e1b9-4784-baeb-3cb0f19a73a4.aspx

$private:defaultvs2010path="C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE"

#remove-item alias:\devenv -force

if(test-path $defaultvs2010path){
    $vs2010=$defaultvs2010path
}

if(!(get-alias | where-object {$_.Name -match "devenv"}) -and (Join-Path $vs2010 "devenv.exe" | test-path))
{
    set-alias devenv (Join-Path $vs2010 "devenv.exe") -option readonly
}
if(!(get-alias devenv))
{
    set-alias devenv = $(throw "devenv.exe was not found")
}

function VS-DevEnv([Parameter(Position=0)][string] $fileToOpen=((gci alias:\devenv).definition),[switch]$safemode,[switch]$frameworkDebug,[switch] $WhatIf,
[Parameter(Position=1,ParameterSetName="log")]$log=$false) 
{
    [string[]]$private:args2 = @()
    if($frameworkDebug -and $env.COMPLUS_ZapDisable -and ($env.COMPLUS_ZapDisable -ne 1))
    {
    write-host "setting frameworkdebug"
        #http://blogs.msdn.com/b/kirillosenkov/archive/2009/01/27/how-to-disable-optimizations-during-debugging.aspx
        #http://www.cplotts.com/2009/01/07/disabling-optimizations-when-debugging-net-framework-source-code/
        if($WhatIf -eq $false)
        {
           $env.COMPLUS_ZapDisable=1
           write-host "You must disable the Visual Studio Hosting process in the project"
        } else {
             write-host '$env.COMPLUS_ZapDisable=1'
        }
        
    }
    if($safemode)
    {
        $args2+="/safemode"
        write-host "set safemode"
    }
    
    #$logCmd=""
    if($PSCmdlet.ParameterSetName -eq "log" -and $log -ne $false)
    {
        write-host "set logging"
        #$args2 +=@("/log", """C:\temp\vs2010log.xml""")
    
    
        $private:stamp=get-date -f "yyyyMMdd.hhmmss" 
        $logPath="C:\temp\devenv"+$stamp+".xml"
        $args2 +=@("/log", """$logPath""")
    #    $logCmd="/log "+$logPath
        write-host "Writing to $logPath"
    }
    
   
    if($WhatIf)
    {
     echo $filetoOpen @args2
    #    write-host "$filetoopen" @args
    } else {
     & $filetoopen @args2  
    }
    
    
}

CreateZipFile

Thu, 22 Sep 2011 23:01:38 GMT

Description: Creates a zip file, that is ready for files to be copied into

Link: http://www.codekeep.net/snippets/3eab9dec-378b-4d60-9c84-153a4c298e98.aspx

function CreateNewZip{
#http://blogs.msdn.com/b/stuartleeks/archive/2009/08/13/powershell-script-to-clean-and-zip-a-directory.aspx
param (
     [Parameter(Mandatory=$true)]
     [string] $zipPath
    )
    if(test-path $zipPath) {$(throw "Zip file already exists at "+$zipPath); return}
    set-content $zipPath ("PK" + [char]5 + [char]6 + ("$([char]0)" * 18))
    (dir $Zippath).IsReadOnly= $false
    #if((dir $zipfi
    return (new-object -com shell.application).NameSpace($zipPath)
    }

Get-NewestDirectory

Thu, 22 Sep 2011 23:00:54 GMT

Description: get the directory with the newest modified date

Link: http://www.codekeep.net/snippets/42095253-6882-43ee-a0d6-5848a55a2423.aspx

function Get-NewestDirectory{
param (
    [string] $path = $(throw "Path is required")
)
    gci $path `
    | ? {$_.PSIsContainer} `
    | select Name,LastWriteTime `
    | sort-object lastwriteTime -descending `
    | select-object -first 1
}

PSUsing

Thu, 22 Sep 2011 15:35:27 GMT

Description: a .net style using clause

Link: http://www.codekeep.net/snippets/b287e788-3a2e-4105-9131-1c33f2e282db.aspx

function PSUsing {
    param (
        [System.IDisposable] $inputObject = $(throw "The parameter -inputObject is required."),
        [ScriptBlock] $scriptBlock = $(throw "The parameter -scriptBlock is required.")
    )
    
    Try {
        &$scriptBlock
    } Finally {
        if ($inputObject -ne $null) {
            if ($inputObject.psbase -eq $null) {
                $inputObject.Dispose()
            } else {
                $inputObject.psbase.Dispose()
            }
        }
    }
}

DataRowToCompareableObject

Thu, 22 Sep 2011 15:34:55 GMT

Description: http://podcast.acoupleofadmins.com/media/Scripts/Compare-QueryResults.ps1 This function breaks each data row up into an object for each field in the row. the name property is the column name and the value property is the field value

Link: http://www.codekeep.net/snippets/262baf7a-1d22-48ee-bf69-9a642b57d12a.aspx

function DataRowToCompareableObject()
{
	Process
	{
		$_.psobject.properties | select name, value  
	}
}

SaveDatasetToTempFile

Thu, 22 Sep 2011 15:33:26 GMT

Description: Save a dataset off to a temp file, for WinMerge to come and compare it with something else

Link: http://www.codekeep.net/snippets/2f31f9ac-f600-4707-a795-f9a69e927c06.aspx

function SaveAsTempFile([System.Data.DataSet] $item) {
    $tmp1=[System.IO.Path]::GetTempFileName()
    Write-progress -activity "SaveAsTempFile" -status "GotTempFileName"
     $item.WriteXML($tmp1)
    Write-progress -activity "SaveAsTempFile" -status "WroteContent"
    return $tmp1
}

LoadAssemblyWithNoLocking

Thu, 22 Sep 2011 15:32:28 GMT

Description: load an assembly into memory without locking the file

Link: http://www.codekeep.net/snippets/49df20da-7fe6-49e4-960d-4c9f9ae7342b.aspx

function LoadAssemblyWithNoLock{
    param(
        [string] $path= $(throw "The parameter -path is required.")
        )

    $Private:fileStream=([System.IO.FileInfo] (Get-Item $path)).OpenRead()
    $Private:assemblyBytes=new-object byte[] $fileStream.Length
    $fileStream.Read($assemblyBytes, 0, $fileStream.Length)
    $fileStream.Close()
    [System.Reflection.Assembly]::Load($assemblyBytes);
}

Serialize to JSon

Thu, 22 Sep 2011 15:31:42 GMT

Description: failed on datatable/dataset recursive reference, but works for other types

Link: http://www.codekeep.net/snippets/fbb42125-555c-4eb9-ba0c-8b5a3a06acde.aspx

function ConvertTo-Json([object] $item)
{
    
    Process
    {
        add-type -assembly system.web.extensions
        $js=new-object system.web.script.serialization.javascriptSerializer
        $js.Serialize($item)
    }
}

script WinMerge

Thu, 22 Sep 2011 15:30:49 GMT

Description: call winmerge

Link: http://www.codekeep.net/snippets/46a62aaf-bce3-4c84-9eec-dbeef4d5ebae.aspx

$winMerge="C:\Program Files (x86)\WinMerge\WinMergeU.exe"
function WinMergeCompareFiles ( [string] $path1, [string] $path2)
{
    & $winMerge /u /wl /wr  $path1 $path2
}

run Sql Query

Thu, 22 Sep 2011 15:27:30 GMT

Description: Run a sql query and return a dataset

Link: http://www.codekeep.net/snippets/213bd54e-8fb1-4e77-b8c2-afd06de80dec.aspx

function Run-Query()
{
	param (
	$SqlQuery,
	$SqlServer,
	$SqlCatalog
	)
	
	$SqlConnString = "Server = $SqlServer; Database = $SqlCatalog; Integrated Security =SSPI;"
	$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
	$SqlConnection.ConnectionString = $SqlConnString
	
	$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
	$SqlCmd.CommandText = $SqlQuery
	$SqlCmd.Connection = $SqlConnection
	
	$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
	$SqlAdapter.SelectCommand = $SqlCmd
	
	$DataSet = New-Object System.Data.DataSet
	$Private:a = $SqlAdapter.Fill($DataSet)
	
	$SqlConnection.Close()
	
	return $DataSet
}

Delete all event log entries

Thu, 28 Jul 2011 07:41:23 GMT

Description: Batch file and Powershell Script to delete the event long entries

Link: http://www.codekeep.net/snippets/beb5e606-0e63-4815-9c06-c16216993882.aspx

REM Batch File to delete all event long entries
powershell Set-ExecutionPolicy unrestricted
powershell -file "C:\DevTools\PowerShell Scripts\clearEventLog.ps1"
@pause Press [Enter] to continue

----------------------------------------------------------------------------------

Write-Host "Clearing Application, System, Powershell, Security, and Tumbleweed event logs"
$log=get-eventlog -list|?{$_.log -eq "Application"}
$log.clear()
Write-Host "     Application Log Cleared"
$log=get-eventlog -list|?{$_.log -eq "System"}
$log.clear()
Write-Host "     System Log Cleared"
$log=get-eventlog -list|?{$_.log -eq "Tumbleweed"}
$log.clear()
Write-Host "     Tumbleweed Log Cleared"
$log=get-eventlog -list|?{$_.log -eq "Security"}
$log.clear()
Write-Host "     Security Log Cleared"

$log=get-eventlog -list|?{$_.log -eq "Windows PowerShell"}
$log.clear()
Write-Host "     Powershell Log Cleared"
Write-Host | Get-EventLog -List

Delete All Temp Files

Thu, 28 Jul 2011 07:37:58 GMT

Description: Batch File and Powershell script to delete all temp files

Link: http://www.codekeep.net/snippets/69dc3aa6-6ce4-4fb2-8baa-916b31fe3580.aspx

REM Batch File to Start Powershell Script
@echo off
@Echo Deleting Temp Files
powershell Set-ExecutionPolicy unrestricted
powershell -file "C:\DevTools\PowerShell Scripts\DeleteAllTempFiles.ps1"
@pause Press any key to continue..

----------------------------------------------------------------------------------
#==================================================================================
# Delete_Temp_Files_W7.ps1
#
# Author: Bill Clark (http://bitsoftech.net/)
#
# This script deletes all files in all users' Temp and Temporary Internet Files
# folders on a Windows Vista or Windows 7 machine.
#
#==================================================================================
 
<#
 
.SYNOPSIS
 
Deletes all files and subdirectories in %UserProfile%\AppData\Local\Temp and
%UserProfile%\AppData\Local\Microsoft\Windows\Temporary Internet Files for all user
profiles on the machine.
 
.PARAMETER
 
No parameters are accepted by this script.
 
.EXAMPLE
 
Delete_Temp_Files_W7.ps1
 
.NOTES
 
The script will not remove any files that are in use by other processes, and will
throw an error upon encountering any in use files.
 
#>
 
# Create array containing all user profile folders
$colProfiles = Get-ChildItem "C:\Users\" -Name
# Remove the All Users profile from the array
$colProfiles = $colProfiles -ne "Public"
 
# Removes temporary files from each user profile folder
ForEach ( $objProfile in $colProfiles ) {
    # Remove all files and folders in user's Temp folder
    Get-ChildItem "C:\Users\$objProfile\AppData\Local\Temp\*" -recurse | remove-item -force -recurse
    # Remove all files and folders in user's Temporary Internet Files. The -force switch on Get-ChildItem gets hidden directories as well.
    Get-ChildItem "C:\Users\$objProfile\AppData\Local\Microsoft\Windows\Temporary Internet Files\*" -recurse -force | remove-item -force -recurse
}

Wait-UntilQueueEmpty

Wed, 03 Nov 2010 11:27:07 GMT

Description: Monitors a queue on a box until it becomes empty, or an allotted time elapses.

Link: http://www.codekeep.net/snippets/3e84e722-bc7a-465c-a2d5-306e622c57d6.aspx

function Wait-UntilQueueEmpty([string]$ServerName, [string]$QueueName, [int]$waitTimeInSeconds)
{
	$queuePollingIntervalInSeconds = 5
	$waitTimeLimit = [DateTime]::Now.AddSeconds($waitTimeInSeconds)
	while ($true)
	{
		$queueReference = gwmi -class Win32_PerfRawData_MSMQ_MSMQQueue -computerName $ServerName | where-object {$_.Name -like "*\$QueueName"}
		if ($queueReference) 
		{
			$count = $queueReference.MessagesInQueue
			if ($count -eq 0)
			{
				Write-Verbose "The $QueueName queue on $ServerName is empty."
				break
			}
			else {
				Write-Verbose "The $QueueName queue on $ServerName has $count messages remaining, sleeping $queuePollingIntervalInSeconds seconds ...."
				Start-Sleep -Seconds $queuePollingIntervalInSeconds
			}
			if ([DateTime]::Now -gt $waitTimeLimit){
				Write-Error "The $QueueName queue on $ServerName did not completely empty in the wait time allocated ($waitTimeInSeconds seconds)."
				break;
			}
		}else {
			# If we can't get the queue reference it means the queue isn't active or isn't on that box.
			Write-Warning "The $QueueName was not found on the server $ServerName"
			break
		}
	}
}

List MSMQ queues and message count

Wed, 03 Nov 2010 09:52:30 GMT

Description: Get's the MSMQ queues and messages counts for a machine.

Link: http://www.codekeep.net/snippets/7c504c35-e5a9-4380-b0cb-81caa1dcb45f.aspx

gwmi -class Win32_PerfRawData_MSMQ_MSMQQueue -computerName $computerName | ft -prop Name, MessagesInQueue

Send All Process To OneNote

Mon, 14 Dec 2009 14:20:14 GMT

Description: Send all processes to OneNote or other installed printer

Link: http://www.codekeep.net/snippets/aaaf544c-1e96-4114-bb31-ab510cc42d81.aspx

PS C:\Windows\system32> Get-Process | Out-Printer -Name "Send To OneNote 2007"
PS C:\Windows\system32> Get-Process | Out-Printer -Name "FreePdf"
PS C:\Windows\system32> Get-Process | Out-Printer -Name "PdfCreator"
PS C:\Windows\system32> Get-Process | Out-Printer -Name "Canon PIXMA iP3000"

Recursively Copy Folder (with excludes) in PowerShell

Tue, 01 Dec 2009 12:25:40 GMT

Description: This function recursively copies a folder and all subfolders while allowing you to properly exclude certain items.

Link: http://www.codekeep.net/snippets/4e793354-dedb-4f03-9f89-fbd86b580856.aspx

function CopyFolder($source, $destination, $excludes)
{
    $items = get-childitem $source -recurse -exclude $excludes
    foreach ($item in $items)
    {
        $target = join-path $destination $item.FullName.Substring($source.Length)
        if (-not($item.PSIsContainer -and (test-path($target))))
        {
            copy-item -path $item.FullName -destination $target
        }
    }
}

Recursively Delete Item in PowerShell

Tue, 01 Dec 2009 08:47:36 GMT

Description: This function recursively deletes an item from the current location. The item can be a file or folder, and can be specified with or without wildcards.

Link: http://www.codekeep.net/snippets/6fc67263-d4fc-4d9c-9946-4a6015d2a7ee.aspx

function CleanupItem([string]$item)
{
    if (($item.StartsWith("*") -eq $true) -or ($item.EndsWith("*") -eq $true))
    {
        get-childitem -recurse -force | where {$_.name -like $item} | foreach ($_) {remove-item $_.fullname -recurse -force}
    }
    else
    {
        get-childitem -recurse -force | where {$_.name -eq $item} | foreach ($_) {remove-item $_.fullname -recurse -force}
    }
}

Create Folder in PowerShell

Tue, 01 Dec 2009 08:34:02 GMT

Description: Creates a folder in the current location. If the folder already exists, it will be deleted and then re-created.

Link: http://www.codekeep.net/snippets/a423f583-0a72-4cac-b7fb-64eff3bff70e.aspx

function CreateFolder([string]$name)
{
    if ((test-path $name) -eq $true)
    {
        remove-item $name -recurse -force
    }
    
    new-item -name $name -itemType "Directory"
}

DOS .bat file to synch backup copy with SVN repository

Wed, 21 Oct 2009 14:39:07 GMT

Description: DOS .bat file used to synch backup copy on same server with with SVN repository

Link: http://www.codekeep.net/snippets/8839235d-2ff6-40f0-945e-c037ebb95006.aspx

SET SVN=C:\Progra~1\Subversion\bin\svn.exe
SET WORKING_COPY= [location ex: D:\EventsRegistration]
SET ASPNET_USERNAME= [uname]
SET ASPNET_PASSWORD= [pass]
SET CONFIG_DIR=D:\SVNRepo\CteSVN\conf

%SVN% update %WORKING_COPY% --non-interactive --config-dir %CONFIG_DIR% --username %ASPNET_USERNAME% --password %ASPNET_PASSWORD% 

::In case there are conflicts, revert all changes
%SVN% revert --recursive %WORKING_COPY%