$fullPathIncFileName = $MyInvocation.MyCommand.Definition
$currentScriptName = $MyInvocation.MyCommand.Name
$currentExecutingPath = $fullPathIncFileName.Replace($currentScriptName, "")
Powershell get execution path of script
Reply
Monthly Archives: February 2013
Powershell custom object in array with hashtable
$resultat = @()
$navn1 = "Henrik"
$alder1 = "34"
$navn2 = "Peter"
$alder2 = "44"
# New object with hash table
$properties = @{'Navn'=$navn1;'Alder'=$alder1}
$object = New-Object –TypeName PSObject –Prop $properties
$resultat += $object
# Short version
$resultat += New-Object –TypeName PSObject –Prop (@{'Navn'=$navn2;'Alder'=$alder2})
$resultat
Powershell custom object in array
$resultat = @()
$navn1 = "Henrik"
$alder1 = "34"
$navn2 = "Peter"
$alder2 = "44"
$object = New-object System.Object
$object | Add-Member -type NoteProperty -name Navn -value $navn1
$object | Add-Member -type NoteProperty -name Alder -value $alder1
$resultat += $object
$object = New-object System.Object
$object | Add-Member -type NoteProperty -name Navn -value $navn2
$object | Add-Member -type NoteProperty -name Alder -value $alder2
$resultat += $object
$resultat
Windows 2008R2 sysprep blue screen: autochk program not found – skipping AUTOCHECK
Boot the VM from the Windows 2008R2 DVD and start command prompt from repair mode.
Run the following commands.
diskpart
list volume
select volume 1
attributes volume
attributes volume clear nodefaultdriveletter
Boot the VM, and SysPrep will continue
SQL: Find duplicate rows
SELECT column,
COUNT(column) AS NumOccurrences
FROM table
GROUP BY column
HAVING ( COUNT(column) > 1 )
Add RowID to SQL table
alter table table_name
add RowID int identity(1,1)