michaellwest

$levelFrom = 1
$levelTo = 4
$navigationFilterId = "{D063E9D1-C7B5-4B1E-B31E-69886C9C59F5}" # Main Navigation
#$navigationFilterId = "{6594C7CB-9588-47F6-B1E3-03783C9EAA79}" # Mobile Navigation
$navigationFilterFieldId = "{1FBC6A49-6281-48EE-87E9-A3970B145ADB}"
$navigableTemplateId = "{371D5FBB-5498-4D94-AB2B-E3B70EEBE78C}"
$counter = 0
$startItem = Get-Item -Path "master:" -ID "{961563FC-3445-4558-BF3A-06DF06BA6298}"
function Walk-ItemTree {
    param(

michaellwest

 -- Find field data not associated with an item.
 SELECT Id  FROM SharedFields f
 WHERE NOT EXISTS (SELECT ID FROM Items i WHERE i.ID = f.ItemId) 
 SELECT Id  FROM UnversionedFields f
 WHERE NOT EXISTS (SELECT ID FROM Items i WHERE i.ID = f.ItemId) 
 SELECT Id  FROM VersionedFields f
 WHERE NOT EXISTS (SELECT ID FROM Items i WHERE i.ID = f.ItemId)

michaellwest

#$provider = [Sitecore.DependencyInjection.ServiceLocator]::ServiceProvider.GetService([Sitecore.XA.Foundation.Abstractions.Configuration.IConfiguration[Sitecore.XA.Foundation.Search.SearchConfiguration]]).GetConfiguration().QueryMaxItems

$query = "+template:{51ed5851-1a61-4dae-b803-6c7fae6b43d8};+sxa:SameFirstTagAsCurrentPage|SxaTags;custom:EventStartDate|[NOW TO *];custom:EventEndDate|[NOW TO *];sort:eventstartdate;sort:isfeatured[desc]"
$modelList = [Sitecore.ContentSearch.Utilities.SearchStringModel]::ParseDatasourceString($query)
$contextItem = Get-Item -Path "master:" -ID "{31318AEE-310B-4EE4-84DA-4B84471E0FCA}"
[Sitecore.DependencyInjection.ServiceLocator]::ServiceProvider.GetService([Sitecore.XA.Foundation.Search.Services.ISearchQueryTokenResolver]).Resolve($modelList, $contextItem)

class CustomSearchResultItem : SearchResultItem
{
   [Sitecore.ContentSearch.IndexField("eventstartdate_tdt")]

michaellwest

$sql = @"
SELECT DISTINCT i.* FROM [dbo].[Items] i
INNER JOIN [dbo].[VersionedFields] v
    ON i.ID = v.ItemId
WHERE v.[Language] = ''
--SELECT COUNT(*) AS COUNT FROM [VersionedFields] WHERE [Language] = ''

--DELETE FROM [VersionedFields] WHERE [Language] = ''
"@

michaellwest

# This is a ScopeQuery item found in SXA. You don't have to use this.
$scopeItem = Get-Item -Path "master:" -ID "{648F4C3A-C9EA-4FCF-82A3-39ED2AC90A06}"
# If not using SXA, you can replace this with the string from the QueryBuilder field type.
$scopeQuery = $scopeItem.ScopeQuery
$props = @{
    Index = "sitecore_sxa_master_index"
    ScopeQuery = $scopeQuery
}

$referenceList = Find-Item @props

michaellwest

{{ if i_item.SxaTags != "" }}
<span>
Department: 
</span>
{{ $tags = [] }}
{{ for i_tag in (sc_followmany i_item "SxaTags") }}
{{ $tags[$tags.size] = i_tag | sc_field "Title" }}
{{ end }}
{{ $tags | array.sort | array.join ", " }}
{{ end }}

michaellwest

using System.Collections.Concurrent;
using System.Collections.Generic;
using System.Linq;
using System.Management.Automation;
using System.Threading;
using System.Threading.Tasks;
using Kamsar.WebConsole;
using Rainbow.Model;
using Rainbow.Storage.Sc.Deserialization;
using Sitecore.Data;

michaellwest

$watch = [System.Diagnostics.Stopwatch]::StartNew()
# BLOCK 1: Create and open runspace pool, setup runspaces array with min and max threads
$pool = [RunspaceFactory]::CreateRunspacePool(1, [int]$env:NUMBER_OF_PROCESSORS+1)
$pool.Open()
$runspaces = $results = @()
    
# BLOCK 2: Create reusable scriptblock. This is the workhorse of the runspace. Think of it as a function.
$scriptblock = {
    param (
        [string]$Data

michaellwest

# Use this report to export current access
$users = Get-User -Filter * | Where-Object { $_.Roles.Count -gt 0 }

$records = [System.Collections.ArrayList]@()
foreach($user in $users) {
    $record = [PSCustomObject]@{
        "Username" = $user.Name
        "Roles" = ($user.Roles | Select-Object -ExpandProperty Name) -join ","
    }
    $records.Add($record) > $null

michaellwest

Import-Function -Name Invoke-SqlCommand

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

$query = @"
  DELETE TOP (1000)
  FROM [dbo].[Publishing_JobQueue]
  SELECT COUNT(*) QueueCount
  FROM [dbo].[Publishing_JobQueue]
"@