Get-PowerShell Andy Schneider's Blog about Windows PowerShell

   1: function new-array {$args}                                                                                        

   2: $CharacterArray = new-array A B C D E F G H I J K L M N O P Q R S T U V X Y Z;                                    

   3: $CharacterHashTable = new-object System.Collections.Hashtable                                                                                                                                                                     

   4: for ($i=0; $i -ilt $CharacterArray.Count; $i++) {$CharacterHashTable.Add($i, $CharacterArray[$i])}                

   5: $randomNumber = new-object System.Random                                                                          

   6: $randomCharacter = $CharacterHashTable[$randomNumber.next(0,25)]                         

   1: PS >  [char]65

   2: A

   1: $randomObject = New-Object System.Random

   2: $randomChar = [char]$randomObject.next(65,90)

   1: 268 >  $hash = New-Object System.Collections.Hashtable

   2: 269 >  $hash.Add("one",1)

   3: 270 >  $hash

   4:  

   5: Name                           Value

   6: ----                           -----

   7: one                            1

   8:  

   9:  

  10: 271 >  $hash.one

  11: 1

  12: 272 >

   1: #Code to update a connection string on a web.config file –yes this can be used to change a lot more stuff too J

   2:  

   3: #Set the Connection String and the path to web.config (or any config file for that matter)

   4: $connectionString = "Data Source=old-db;Initial Catalog=mydb;Integrated Security=True;User Instance=True"

   5: $webConfigPath = "C:\Inetpub\wwwroot\myapp\web.config"

   6: $currentDate = (get-date).tostring("mm_dd_yyyy-hh_mm_s") # month_day_year - hours_mins_seconds

   7: $backup = $webConfigPath + "_$currentDate"

   8:  

   9: # Get the content of the config file and cast it to XML and save a backup copy labeled .bak followed by the date

  10: $xml = [xml](get-content $webConfigPath)

  11:  

  12: #save a backup copy

  13: $xml.Save($backup)

  14:  

  15: #this was the trick I had been looking for

  16: $root = $xml.get_DocumentElement();

  17:  

  18: #Change the Connection String. Add really means "replace"

  19: $root.connectionStrings.add.connectionString = $connectionString

  20:  

  21: # Save it

  22: $xml.Save($webConfigPath)

   1: 119 >  $c = Get-Credential

   2:  

   3: cmdlet Get-Credential at command pipeline position 1

   4: Supply values for the following parameters:

   5: Credential

   6: PromptForCredential_UserAndy

   7: PromptForCredential_Password********

   8:  

   9: 120 >

   1: function Get-Cred {

   2:     Write-Host "";

   3:     $username = Read-Host "Enter username to access some resource (no domain required)"

   4:     if ($username -notlike "MYDOMAIN\*"){$username = "MYDOMAIN\$username"}

   5:         

   6:     Write-Host ""

   7:     $password = Read-Host  -AsSecureString "Password to access some resource"

   8:     

   9:     $credential = New-Object System.Management.Automation.PSCredential($username,$password)

  10:     return $credential

  11: }

   1: 130 >  $cred = Get-Cred

   2:  

   3: Enter username to access some resource (no domain required): andy

   4:  

   5: Password to access some resource: **************

   6: 131 >

   7: 131 >  $cred.GetNetworkCredential() | fl *

   8:  

   9:  

  10: UserName : andy

  11: Password : secretpassword

  12: Domain   : MYDOMAIN

   1: param (

   2:     [string]$tfsServer = "TFSServerName",

   3:     [string]$tfsLocation = "$/TFS/Project",

   4:     [string]$localFolder ="c:\scripts",

   5:     [string]$file,

   6:     [string]$checkInComments = "Checked in from PowerShell"

   7: )

   8: $clientDll = "C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\Microsoft.TeamFoundation.Client.dll"

   9: $versionControlClientDll = "C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\Microsoft.TeamFoundation.VersionControl.Client.dll"

  10: $versionControlCommonDll = "C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\Microsoft.TeamFoundation.VersionControl.Common.dll"

  11:  

  12: #Load the Assemblies

  13: [Reflection.Assembly]::LoadFrom($clientDll)

  14: [Reflection.Assembly]::LoadFrom($versionControlClientDll)

  15: [Reflection.Assembly]::LoadFrom($versionControlCommonDll)

  16:  

  17: #Set up connection to TFS Server and get version control

  18: $tfs = [Microsoft.TeamFoundation.Client.TeamFoundationServerFactory]::GetServer($tfsServer)

  19: $versionControlType = [Microsoft.TeamFoundation.VersionControl.Client.VersionControlServer]

  20: $versionControlServer = $tfs.GetService($versionControlType)

  21:  

  22: #Create a "workspace" and map a local folder to a TFS location

  23: $workspace = $versionControlServer.CreateWorkspace("PowerShell Workspace",$versionControlServer.AuthenticatedUser)

  24: $workingfolder = New-Object Microsoft.TeamFoundation.VersionControl.Client.WorkingFolder($tfsLocation,$localFolder)

  25: $workspace.CreateMapping($workingFolder)

  26: $filePath = $localFolder + "\" + $file

  27:  

  28: #Submit file as a Pending Change and submit the change

  29: $workspace.PendAdd($filePath)

  30: $pendingChanges = $workspace.GetPendingChanges()

  31: $workspace.CheckIn($pendingChanges,$checkInComments)

  32:  

  33: #Delete the temp workspace

  34: $workspace.Delete()