michaellwest

<#
  .SYNPOSIS
    Convert a PrivateKey from the certificate store into a PKCS8 formatted file.
    
  .LINK
    Found C# version here https://gist.github.com/chenrui1988/6b104a010172786dbcbc0aafc466d291/
    
  .NOTES
    Michael West
#> 

michaellwest

<#
    .SYNOPSIS
        Lists all the items locked by the specified user.
        
    .NOTES
        Adam Najmanowicz, Michael West
#>

Import-Function -Name Invoke-SqlCommand

michaellwest

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.1/jquery.js" integrity="sha256-WpOohJOqMqqyKL9FccASB9O0KwACQJpFTUBLTYOVvVU=" crossorigin="anonymous"></script>
<script type="text/javascript">
$(function() {
  var statesTable = $('table[id^="State"');
  var selectAll = $('<a href="#" id="select-all-states">Select All</a>').insertBefore(statesTable);
  selectAll.on('click', function(e) {
    e.preventDefault();
    statesTable.find('.ms-RadioText :checkbox').prop('checked', true);
  });
  $('<span>&nbsp;</span>').insertBefore(statesTable);

michaellwest

DECLARE @BlobID uniqueidentifier;
SELECT @BlobID = '{FF8A2D01-8A77-4F1B-A966-65806993CD31}';

WITH [BlobFields] ([fieldid])
     AS (SELECT [sharedfields].[itemid]
         FROM   [sharedfields]
         WHERE  [sharedfields].[fieldid] = @BlobID
                AND [sharedfields].[value] = 1
         UNION
         SELECT [versionedfields].[itemid]

michaellwest

$items = [Sitecore.Diagnostics.Statistics]::RenderingStatistics
$props = @{
    Property = @(
        @{Label="Rendering"; Expression={$_.TraceName} },
        @{Label="Site"; Expression={$_.SiteName} },
        @{Label="Count"; Expression={$_.RenderCount} },
        @{Label="From cache"; Expression={$_.UsedCache} },
        @{Label="Avg. time (ms)"; Expression={$_.AverageTime.TotalMilliseconds} },
        @{Label="Avg. items"; Expression={$_.AverageItemsAccessed} },
        @{Label="Max. time"; Expression={$_.MaxTime.TotalMilliseconds} },

michaellwest

# Solution for https://github.com/SitecoreSupport/Sitecore.Support.94909
# Cannot login in Sitecore CMS due to multiple same users already logged in
# Saved to /sitecore/system/Modules/PowerShell/Script Library/[CUSTOM_MODULE_NAME]/Pipelines/LoggedIn/Remove Multiple Sessions
$pipelineArgs = Get-Variable -Name pipelineArgs -ValueOnly
$username = $pipelineArgs.UserName

if(!$username) { return }

$sessionId = [System.Web.HttpContext]::Current.Session.SessionID
Write-Log "The current session Id is $($sessionId) for user $($username)"

michaellwest

$watch = [System.Diagnostics.Stopwatch]::StartNew()

$path = "/sitecore/templates/Project"
$templateId = "{AB86861A-6030-46C5-B394-E8F99E8B87DB}"
$templateFieldId = "{455A3E98-A627-4B40-8035-E683A0331AC7}"

$db = Get-Database -Name "master"
$rootItem = $db.GetItem($path)
$templates = $rootItem.Axes.GetDescendants() |
    Where-Object { $_.TemplateId -eq $templateId } | Initialize-Item

michaellwest

$rootPath = "/content/Company/DotCom/usa/home"
$file = "$($SitecoreDataFolder)\temp\alt-tags.csv"
$records = Import-Csv -Path $file
$totalCount = $records.Count
$currentCount = 0
$activity = "Updating alt tags"
foreach($record in $records) {
    $currentCount += 1
    $percentComplete = $currentCount / $totalCount * 100
    $itemPath = $rootPath + ($record.Url -replace "www.Company.com","")

michaellwest

class DesktopLink {
    [string]$DatabaseName
    [string]$Path
    [string]$Icon
    [string]$Header
    [string]$Language
    
    [string]ToString(){
        $fields = @()
        $fields += [System.Web.HttpUtility]::UrlEncode($this.DatabaseName)

michaellwest

function Get-ItemUrl {
    param(
        [item]$Item,
        [Sitecore.Sites.SiteContext]$SiteContext
    )
    
    $result = New-UsingBlock(New-Object Sitecore.Sites.SiteContextSwitcher $siteContext) {
        New-UsingBlock(New-Object Sitecore.Data.DatabaseSwitcher $item.Database) {
            [Sitecore.Links.LinkManager]::GetItemUrl($item)
        }