SharePoint Server¶

# Check SharePoint installation details
$spPath = "HKLM:\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\16.0\WSS\Setup"
Get-ItemProperty $spPath -ErrorAction SilentlyContinue |
    Select-Object Location, Version

# Read the farm configuration database connection
$configDbPath = "HKLM:\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\16.0\Secure\ConfigDB"
$configDb = Get-ItemProperty $configDbPath -ErrorAction SilentlyContinue
Write-Output "Config DB DSN: $($configDb.dsn)"
Write-Output "Farm ID: $($configDb.id)"

# Get detailed SharePoint build number and patch level
$spPath = "HKLM:\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\16.0\WSS"
Get-ItemProperty "$spPath\InstalledProducts" -ErrorAction SilentlyContinue

# Also check via SharePoint cmdlet
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
(Get-SPFarm).BuildVersion

# Check all SharePoint-related services
$spServices = @("SPTimerV4", "SPSearchHostController", "SPWriterV4",
    "AppFabricCachingService", "SPAdminV4", "W3SVC")

foreach ($svc in $spServices) {
    $service = Get-Service $svc -ErrorAction SilentlyContinue
    if ($service) {
        Write-Output "$($service.DisplayName) : $($service.Status) ($($service.StartType))"
    }
}

# Check Search Service Application status
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
Get-SPEnterpriseSearchServiceApplication |
    Select-Object Name, Status, SearchAdminDatabase, CloudIndex

# Check current index location
Get-SPEnterpriseSearchServiceInstance -Local |
    ForEach-Object {
        $_.Components | Where-Object { $_.GetType().Name -eq "IndexComponent" } |
            Select-Object ServerName, IndexPartitionOrdinal, RootDirectory
    }

# Move search index to a dedicated SSD volume
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$ssa = Get-SPEnterpriseSearchServiceApplication
$active = Get-SPEnterpriseSearchTopology -SearchApplication $ssa -Active
$clone = New-SPEnterpriseSearchTopology -SearchApplication $ssa -Clone -SearchTopology $active

# Get the current index component
$indexComponent = Get-SPEnterpriseSearchComponent -SearchTopology $clone |
    Where-Object { $_.GetType().Name -eq "IndexComponent" }

# Remove old index component
Remove-SPEnterpriseSearchComponent -SearchTopology $clone -Identity $indexComponent -Confirm:$false

# Add new index component on dedicated SSD
$searchInstance = Get-SPEnterpriseSearchServiceInstance -Local
New-SPEnterpriseSearchIndexComponent -SearchTopology $clone `
    -SearchServiceInstance $searchInstance `
    -RootDirectory "D:\SharePointIndex" `
    -IndexPartition 0

# Activate the new topology
Set-SPEnterpriseSearchTopology -Identity $clone

# Check and configure crawl settings
$ssa = Get-SPEnterpriseSearchServiceApplication

# Get content sources
Get-SPEnterpriseSearchCrawlContentSource -SearchApplication $ssa |
    Select-Object Name, Type, CrawlState, CrawlStarted, StartAddresses

# Check crawl log for errors
Get-SPEnterpriseSearchCrawlLog -SearchApplication $ssa |
    Where-Object { $_.LogLevel -eq "Error" } |
    Select-Object -First 10 Url, ErrorMessage

# Check Search Host Controller service
Get-ItemProperty "HKLM:\SYSTEM\CurrentControlSet\Services\SPSearchHostController" |
    Select-Object DisplayName, Start, ObjectName

# Find web.config files for SharePoint web applications
$iisPath = "HKLM:\SOFTWARE\Microsoft\InetStp"
$iisVersion = (Get-ItemProperty $iisPath).MajorVersion
Write-Output "IIS Version: $iisVersion"

# List SharePoint web application directories
Get-WebSite | Where-Object { $_.Name -like "*SharePoint*" -or $_.PhysicalPath -like "*inetpub*" } |
    Select-Object Name, PhysicalPath, State

# Enable Blob Cache for a SharePoint web application
$webAppUrl = "https://intranet.corp.local"
$webApp = Get-SPWebApplication $webAppUrl

# Get the IIS site path
$iisSettings = $webApp.IisSettings[[Microsoft.SharePoint.Administration.SPUrlZone]::Default]
$webConfigPath = Join-Path $iisSettings.Path.FullName "web.config"

# Read the web.config
$webConfig = [xml](Get-Content $webConfigPath)

# Find the BlobCache node
$blobCache = $webConfig.configuration.'SharePoint'.'BlobCache'

# Display current settings
Write-Output "Blob Cache Enabled: $($blobCache.enabled)"
Write-Output "Location: $($blobCache.location)"
Write-Output "Max Size: $($blobCache.maxSize)"

# Enable and configure Blob Cache
$blobCache.SetAttribute("enabled", "true")
$blobCache.SetAttribute("location", "D:\BlobCache")
$blobCache.SetAttribute("maxSize", "50")

# Add common file types to cache
$blobCache.SetAttribute("path", "\.(gif|jpg|jpeg|jpe|jfif|bmp|dib|tif|tiff|themedbmp|themedcss|themedgif|themedjpg|themedpng|ico|png|wdp|hdp|css|js|asf|avi|flv|m4v|mov|mp3|mp4|mpeg|mpg|rm|rmvb|wma|wmv|ogg|ogv|oga|webm|xap)$")

# Save the web.config
$webConfig.Save($webConfigPath)
Write-Output "Blob Cache enabled with 50 GB max on D:\BlobCache"

# Flush the Blob Cache (required after enabling or changing file types)
$webApp = Get-SPWebApplication "https://intranet.corp.local"

[Microsoft.SharePoint.Publishing.PublishingCache]::FlushBlobCache($webApp)
Write-Output "Blob Cache flushed successfully"

# Check Distributed Cache service
Get-ItemProperty "HKLM:\SYSTEM\CurrentControlSet\Services\AppFabricCachingService" |
    Select-Object DisplayName, Start, ObjectName

# Check current Distributed Cache allocation
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
$dcInstance = Get-SPDistributedCacheClientSetting -ContainerType DistributedLogonTokenCache

# Get cache host info
Get-SPServiceInstance | Where-Object {
    $_.TypeName -eq "Distributed Cache"
} | Select-Object Server, Status

# Check cache cluster health
Use-CacheCluster
Get-CacheHost | Select-Object HostName, PortNo, Status, CacheSize

# Increase Distributed Cache memory allocation
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

# Stop Distributed Cache gracefully
$instanceId = (Get-SPServiceInstance | Where-Object {
    $_.TypeName -eq "Distributed Cache" -and $_.Server.Name -eq $env:COMPUTERNAME
}).Id
Stop-SPDistributedCacheServiceInstance -Graceful

# Update cache size (MB)
Update-SPDistributedCacheSize -CacheSizeInMB 8192

# Restart Distributed Cache
$farm = Get-SPFarm
$cacheService = $farm.Services | Where-Object { $_.Name -eq "AppFabricCachingService" }
$cacheService.ProcessIdentity.CurrentIdentityType = "SpecificUser"
$cacheService.ProcessIdentity.Update()

Start-SPDistributedCacheServiceInstance
Write-Output "Distributed Cache updated to 8192 MB"

# Check Timer Service configuration
Get-ItemProperty "HKLM:\SYSTEM\CurrentControlSet\Services\SPTimerV4" |
    Select-Object DisplayName, Start, ObjectName, DependOnService

# List Timer Jobs and their schedules
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
Get-SPTimerJob | Where-Object { $_.IsDisabled -eq $false } |
    Select-Object Name, Schedule, LastRunTime, Status |
    Sort-Object LastRunTime -Descending |
    Select-Object -First 15 |
    Format-Table -AutoSize

# Find failed Timer Jobs in the last 24 hours
$startTime = (Get-Date).AddDays(-1)
Get-SPTimerJob |
    ForEach-Object {
        $history = $_.HistoryEntries | Where-Object {
            $_.StartTime -gt $startTime -and $_.Status -ne "Succeeded"
        }
        if ($history) {
            [PSCustomObject]@{
                JobName = $_.Name
                Status  = ($history | Select-Object -First 1).Status
                Error   = ($history | Select-Object -First 1).ErrorMessage
                Time    = ($history | Select-Object -First 1).StartTime
            }
        }
    } | Format-Table -AutoSize

# Check Workflow Manager installation
$wfPath = "HKLM:\SOFTWARE\Microsoft\Workflow Manager\1.0"
if (Test-Path $wfPath) {
    Get-ItemProperty $wfPath | Select-Object InstallPath, Version
} else {
    Write-Output "Workflow Manager is not installed on this server"
}

# Check SharePoint-Workflow Manager registration
Get-SPWorkflowConfig -WebApplication "https://intranet.corp.local" |
    Select-Object DeclarativeWorkflowsEnabled, WorkflowTimerServiceEnabled

# List all IIS sites with their bindings
Import-Module WebAdministration
Get-WebSite | ForEach-Object {
    $bindings = $_.Bindings.Collection | ForEach-Object {
        "$($_.protocol)://$($_.bindingInformation)"
    }
    [PSCustomObject]@{
        Name     = $_.Name
        ID       = $_.Id
        State    = $_.State
        AppPool  = $_.ApplicationPool
        Bindings = ($bindings -join "; ")
    }
} | Format-Table -AutoSize

# Check SharePoint application pool configuration
Get-WebAppPool | Where-Object { $_.Name -like "*SharePoint*" } |
    Select-Object Name, State, ManagedRuntimeVersion, ProcessModel |
    ForEach-Object {
        [PSCustomObject]@{
            Name        = $_.Name
            State       = $_.State
            CLR         = $_.ManagedRuntimeVersion
            Identity    = $_.ProcessModel.IdentityType
            UserName    = $_.ProcessModel.UserName
        }
    } | Format-Table -AutoSize

# Check SSL bindings for SharePoint sites
netsh http show sslcert | Select-String -Pattern "IP:port|Certificate Hash|Application ID" |
    ForEach-Object { $_.Line.Trim() }

# Add HTTPS binding to a SharePoint web application
$webAppUrl = "https://intranet.corp.local"
$webApp = Get-SPWebApplication $webAppUrl

# Add an alternate access mapping for the new URL
New-SPAlternateURL -WebApplication $webApp `
    -Url "https://portal.corp.com" -Zone "Internet"

# Add IIS binding
New-WebBinding -Name "SharePoint - Intranet" `
    -Protocol "https" -Port 443 -HostHeader "portal.corp.com" -SslFlags 1

# Bind the certificate
$cert = Get-ChildItem Cert:\LocalMachine\My |
    Where-Object { $_.Subject -match "portal.corp.com" }
$binding = Get-WebBinding -Name "SharePoint - Intranet" -Protocol "https" -HostHeader "portal.corp.com"
$binding.AddSslCertificate($cert.Thumbprint, "My")

Write-Output "HTTPS binding added for portal.corp.com"

# Check SharePoint page load performance with Developer Dashboard
# Enable Developer Dashboard to measure page load times
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$farm = Get-SPFarm
$devDashboard = $farm.GetChild("SPDeveloperDashboardSettings")
Write-Output "Developer Dashboard Mode: $($devDashboard.DisplayLevel)"

# Check database latency
$contentDb = Get-SPContentDatabase -WebApplication "https://intranet.corp.local"
foreach ($db in $contentDb) {
    Write-Output "$($db.Name) : Size=$([math]::Round($db.DiskSizeRequired / 1GB, 2)) GB, Sites=$($db.CurrentSiteCount)"
}

# Enable Blob Cache on the web application
$webApp = Get-SPWebApplication "https://intranet.corp.local"
$iisSettings = $webApp.IisSettings[[Microsoft.SharePoint.Administration.SPUrlZone]::Default]
$webConfigPath = Join-Path $iisSettings.Path.FullName "web.config"

# Create the Blob Cache directory on SSD
New-Item -Path "D:\BlobCache" -ItemType Directory -Force | Out-Null

# Modify web.config
$webConfig = [xml](Get-Content $webConfigPath)
$blobCache = $webConfig.configuration.'SharePoint'.'BlobCache'

# Enable and configure Blob Cache
$blobCache.SetAttribute("enabled", "true")
$blobCache.SetAttribute("location", "D:\BlobCache")
$blobCache.SetAttribute("maxSize", "50")
$blobCache.SetAttribute("max-age", "86400")

$webConfig.Save($webConfigPath)
Write-Output "Blob Cache enabled: D:\BlobCache, 50 GB max, 24h max-age"

# Move search index to dedicated SSD
$ssa = Get-SPEnterpriseSearchServiceApplication
$active = Get-SPEnterpriseSearchTopology -SearchApplication $ssa -Active
$clone = New-SPEnterpriseSearchTopology -SearchApplication $ssa -Clone -SearchTopology $active

# Get current index component
$oldIndex = Get-SPEnterpriseSearchComponent -SearchTopology $clone |
    Where-Object { $_.GetType().Name -eq "IndexComponent" }

# Remove old component
Remove-SPEnterpriseSearchComponent -SearchTopology $clone -Identity $oldIndex -Confirm:$false

# Create index directory on SSD
New-Item -Path "D:\SearchIndex" -ItemType Directory -Force | Out-Null

# Add new index component
$searchInst = Get-SPEnterpriseSearchServiceInstance -Local
New-SPEnterpriseSearchIndexComponent -SearchTopology $clone `
    -SearchServiceInstance $searchInst `
    -RootDirectory "D:\SearchIndex" `
    -IndexPartition 0

# Activate
Set-SPEnterpriseSearchTopology -Identity $clone
Write-Output "Search index moved to D:\SearchIndex"

# Check Distributed Cache utilization
Use-CacheCluster
Get-CacheStatistics | Select-Object ItemCount, Size, RegionCount, MissCount, RequestCount

# Increase Distributed Cache size
Stop-SPDistributedCacheServiceInstance -Graceful
Update-SPDistributedCacheSize -CacheSizeInMB 8192
Start-SPDistributedCacheServiceInstance
Write-Output "Distributed Cache increased to 8192 MB"

# Enable IIS compression for SharePoint
Import-Module WebAdministration

# Enable static and dynamic compression
Set-WebConfigurationProperty -Filter "system.webServer/urlCompression" `
    -PSPath "IIS:\Sites\SharePoint - Intranet" `
    -Name "doStaticCompression" -Value $true
Set-WebConfigurationProperty -Filter "system.webServer/urlCompression" `
    -PSPath "IIS:\Sites\SharePoint - Intranet" `
    -Name "doDynamicCompression" -Value $true

Write-Output "IIS compression enabled for SharePoint"

# Measure page load time after optimizations
$url = "https://intranet.corp.local/SitePages/Home.aspx"
$measurements = @()

for ($i = 1; $i -le 5; $i++) {
    $sw = [System.Diagnostics.Stopwatch]::StartNew()
    Invoke-WebRequest -Uri $url -UseDefaultCredentials -UseBasicParsing | Out-Null
    $sw.Stop()
    $measurements += $sw.ElapsedMilliseconds
    Write-Output "Test $i : $($sw.ElapsedMilliseconds) ms"
}

$avg = ($measurements | Measure-Object -Average).Average
Write-Output "Average load time: $([math]::Round($avg, 0)) ms"