Michael michaellwest

## FindLockedItemsInTheDatabase.ps1
Import-Function -Name Invoke-SqlCommand

$owner = "sitecore\admin"

$connection = [Sitecore.Configuration.Settings]::GetConnectionString("master")

$fieldId = [Sitecore.FieldIDs]::Lock

$query = @"
SELECT [ItemId], [Value], [Language], [Version]

## SharePoint-AddSelectAll
<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);

## CleanupBlobData.sql
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]

## SitecoreRenderingStats.ps1
$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} },

## Remove-Multiple-Sessions.ps1
# 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)"

## Report-Template-Sources-Faster.ps1
$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

## Update-AltTags.ps1
$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","")

## New-DesktopShortcut.ps1
class DesktopLink {
    [string]$DatabaseName
    [string]$Path
    [string]$Icon
    [string]$Header
    [string]$Language

    [string]ToString(){
        $fields = @()
        $fields += [System.Web.HttpUtility]::UrlEncode($this.DatabaseName)

## Get-ItemUrl.ps1
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)
        }

## FindFieldsWithChangeFromStandardValues.ps1
# Find all fields where there is a standard value defined and is not the same as the current value
$item = Get-Item -Path "master:" -ID "{DFDDF372-3AB7-45B1-9E7C-0D0B27350439}"
# Since $item.Fields.ReadAll() is not called, you never get back fields using the StandardValue
$results = [System.Collections.ArrayList]@()
foreach($field in $item.Fields) {
    $standardValue = $field.GetStandardValue()
    if([string]::IsNullOrEmpty($standardValue)) { continue }
    $value = $field.Value
    if($standardValue -eq $value) { continue }
    $result = [PSCustomObject]@{