#Requires -Version 5.1
<#
    JbTecWiz Support Centre -- read-only diagnostic

    Fault : "File is locked for editing by another user" -- including when that user is you
    Source: https://jbtecwiz.com/support/win-office-file-locked

    This script CHANGES NOTHING. It runs only the inspection commands
    from the write-up -- the Get-, Test- and Resolve- calls that
    establish which cause is in play -- and prints what each returned.
    Anything that writes, deletes, starts or stops is excluded by
    construction, not by judgement.

    Read the output alongside the write-up, then pick the fix that
    matches. Each fix has its own script on the same page.
#>

[CmdletBinding()] param([switch]$Transcript)
$ErrorActionPreference = 'Continue'

if ($Transcript) {
    $log = Join-Path $env:USERPROFILE ("jbtecwiz-win-office-file-locked-" + (Get-Date -Format yyyyMMdd-HHmmss) + ".txt")
    Start-Transcript -Path $log | Out-Null
    Write-Host ('  Saving a transcript to ' + $log)
}

function Write-Rule { param([string]$Text)
    Write-Host ''
    Write-Host ('-' * 70) -ForegroundColor DarkGray
    if ($Text) { Write-Host $Text -ForegroundColor Cyan }
}

function Probe { param([string]$Label, [string]$Fix, [scriptblock]$Command)
    Write-Rule ("  " + $Label)
    Write-Host ("  from: " + $Fix) -ForegroundColor DarkGray
    Write-Host ''
    foreach ($l in ($Command.ToString().Trim() -split "`n")) {
        Write-Host ("    " + $l.Trim()) -ForegroundColor DarkGreen
    }
    Write-Host ''
    try {
        $out = & $Command 2>&1 | Out-String
        if ([string]::IsNullOrWhiteSpace($out)) {
            Write-Host '    (returned nothing)' -ForegroundColor DarkGray
        } else {
            foreach ($l in ($out.TrimEnd() -split "`n")) { Write-Host ("    " + $l.TrimEnd()) }
        }
    } catch {
        Write-Host ("    could not run: " + $_.Exception.Message) -ForegroundColor Yellow
    }
}

Write-Rule
Write-Host '  "File is locked for editing by another user" -- including when that user is you' -ForegroundColor White
Write-Host '  Read-only diagnostic -- nothing is changed.' -ForegroundColor Green
Write-Rule

Probe -Label 'Find the open handle by file name.' -Fix 'Close the stale handle on the file server' -Command {
    Get-SmbOpenFile | Where-Object Path -like '*Budget.xlsx*' | Select-Object FileId, SessionId, ClientUserName, ClientComputerName, Path
}

Probe -Label 'Verify: The handle no longer appears and the document opens for editing.' -Fix 'Close the stale handle on the file server' -Command {
    Get-SmbOpenFile | Where-Object Path -like '*Budget.xlsx*'
}

Write-Rule
Write-Host '  Diagnostic finished. Nothing was changed.' -ForegroundColor Green
Write-Host ''
Write-Host '  Compare the output above with the write-up, then run the'
Write-Host '  script for the fix that matches:'
Write-Host '    https://jbtecwiz.com/support/win-office-file-locked'
Write-Rule
if ($Transcript) { Stop-Transcript | Out-Null }