SUGCON Presentation

00_Get-ItemsChangedInLast7Days.ps1

$days = 7;

Get-ChildItem master:\content\home -Recurse | 
    ? { $_."__updated" -gt (Get-Date).AddDays(-$days) } | 
    Format-Table -Property ID, Name, "__updated", "__updated by"

01_Get-ItemsChangedInLastXDays.ps1

$days = 7;
Read-Variable -Parameters @{ Name="days"; Title="Number of days"} -Title "Pointy haired report" | Out-Null

Get-ChildItem master:\content\home -Recurse | 
    ? { $_."__updated" -gt (Get-Date).AddDays(-$days) } | 
    Format-Table -Property ID, Name, "__updated", "__updated by"

02_Show-ListViewOfItemsChangedInLastXDays.ps1

$days = 7;
Read-Variable -Parameters @{ Name="days"; Title="Number of days"} -Title "Pointy haired report" | Out-Null

Get-ChildItem master:\content\home -Recurse | 
    ? { $_."__updated" -gt (Get-Date).AddDays(-$days) } | 
    Show-ListView -Property ID, Name, "__updated", "__updated by"

03_Find-ItemsAndShowReport.ps1

$days = 7;
Read-Variable -Parameters @{ Name="days"; Title="Number of days"} -Title "Pointy haired report" | Out-Null

Find-Item -Criteria @{Filter="DescendantOf"; Value=(Get-Item master:\content\home)} -Index sitecore_master_index |
    ? { $_.Updated -gt (Get-Date).AddDays(-$days) } | Initialize-Item |
    Show-ListView -Property ID, Name, "__updated", "__updated by"

04_Find-ItemsAndSaveReportAsCsv.ps1

# Shows the export functionality with automatic variables
$days = 7;
Read-Variable -Parameters @{ Name="days"; Title="Number of days"} -Title "Pointy haired report" | Out-Null

Find-Item -Criteria @{Filter="DescendantOf"; Value=(Get-Item master:\content\home)} -Index sitecore_master_index |
    ? { $_.Updated -gt (Get-Date).AddDays(-$days) } | Initialize-Item |
    Select-Object -Property ID, Name, "__updated", "__updated by" | 
    Export-Csv -Path "$($SitecoreDataFolder)\PointyHairedReport-$([datetime]::Now.ToString("yyyyMMdd")).csv"

05_Find-ItemsAndShowAsHTMLWebAPI.ps1

  $head = '<style>'+
    'body{font-family:"Lucida Sans Unicode", "Lucida Grande", Sans-Serif; text-align:left;}'+
    'h1 {width:100%;font-family: "Skolar Bold", Palatino, Cambria, "Droid Serif", Georgia, "Times New Roman", Times, serif; font-size: 28px;}'+
    'p {width:100%;font-family: "Proxima Nova Regular", "Helvetica Neue", Calibri, "Droid Sans", Helvetica, Arial, sans-serif; font-size: 18px}'+
    'table {font-size:12px; border-collapse:collapse; border:1px solid #69c; margin:20px;}'+
    'th{font-weight:normal; font-size:14px; color:#039; border-bottom:1px dashed #69c; padding:12px 17px;}'+
    'td{color:#668;padding:7px 17px;border-bottom: 1px dashed #d8e8ff;}'+
    'tbody tr:hover td{color:#339;background:#f0f0ff;}'+
    '</style>'
$body = "<h1>Pointy report $($item)</h1>"

if ($HttpContext -ne $null){
    $HttpContext.Response.ContentType = "text/html";
}

if ($days -eq $null){
    $days = 7;
}

Find-Item -Criteria @{Filter="DescendantOf"; Value=(Get-Item master:\content\home)} -Index sitecore_master_index |
    ? { $_.Updated -gt (Get-Date).AddDays(-$days) } | Initialize-Item |
    Select-Object -Property ID, Name, "__updated", "__updated by" |
    ConvertTo-Html -head $head -body $body |  % { [System.Web.HttpUtility]::HtmlDecode($_) }

06_Get-ItemWithRemoting.ps1

Import-Module -Name SPE

$session = New-ScriptSession -Username admin -Password b -ConnectionUri http://sitecore8
Invoke-RemoteScript -Session $session -ScriptBlock { 
    Get-Item -Path "master:\content\home\"
}

07_SitecoreFunctionMock-Create-Package.ps1

function Install-CustomPackage {
    param(
        [int]$Size = 2
    )
    
    Start-Sleep -Seconds $size
    "Install complete."
}

08_Execute-RemoteFunction.ps1

Import-Module -Name SPE

if(!$session) {
    $session = New-ScriptSession -Username admin -Password b -ConnectionUri http://sitecore8
}

Invoke-RemoteScript -Session $session -ScriptBlock { 

    Import-Function -Name Install-CustomPackage
    Install-CustomPackage -Size 5
}

09_Execute-LongRunningRemoteFunctionWithoutGettingResult.ps1

Import-Module -Name SPE

if(!$session) {
    $session = New-ScriptSession -Username admin -Password b -ConnectionUri http://sitecore8
}


Invoke-RemoteScript -Session $session -ScriptBlock { 
    Start-ScriptSession -Id "SUGCON" -ScriptBlock {
        Import-Function -Name Install-CustomPackage
        Install-CustomPackage 5
    }
}

10_Execute-LongRunningRemoteFunctionAndWaitForResults.ps1

Import-Module -Name SPE

if(!$session) {
    $session = New-ScriptSession -Username admin -Password b -ConnectionUri http://sitecore8
}


Invoke-RemoteScript -Session $session -ScriptBlock { 
    Start-ScriptSession -Id "SUGCON" -ScriptBlock {
        Import-Function -Name Install-CustomPackage
        Install-CustomPackage 5
    }
}

$complete = $false
while(!$complete) {
    $complete = Invoke-RemoteScript -Session $session -ScriptBlock { 
        (Get-ScriptSession -Id "SUGCON").State -ne "Busy"
    }

    Write-Host "." -NoNewline
    Start-Sleep -Milliseconds 500
}


Invoke-RemoteScript -Session $session -ScriptBlock { 
    Receive-ScriptSession -Id "SUGCON"
}

11_Sample-DebugScript.ps1

$colors  = "Cyan", "Gray","Green","Magenta","Red","White","Yellow"
for($i=0; $i -lt 10; $i++){

    if($i -eq 5){
        Set-PSBreakpoint -Script "$PSCommandPath" -Line 15
    }

    $color = "";
    foreach($j in 1..10){
        $color = "$($colors[(Get-Random -Maximum $colors.Length)])";
        Write-Host ("{0:D3} " -f ($i*10+$j)) -ForegroundColor "$color" -no
        Write-Progress -Activity "Line $i, column $j" -PercentComplete (($i*10+$j)/4.2)
        Start-Sleep -Milliseconds 10
    }
    Write-Host " "
    Get-PSBreakpoint | Remove-PSBreakpoint
}