Get-sqmSpnReport
Diagnostics sqmSQLTool v1.8.2+
Checks the registered SPNs for SQL Server instances (default and named instances).

Examples

Get-sqmSpnReport
Get-sqmSpnReport

    Checks all SQL Server instances on the local computer.
Get-sqmSpnReport -ComputerName 'SQL01' -InstanceFilter 'MSSQLSERVER'
Get-sqmSpnReport -ComputerName 'SQL01' -InstanceFilter 'MSSQLSERVER'

    Checks only the default instance on SQL01.
'SQL01','SQL02' | Get-sqmSpnReport -ContinueOnError
'SQL01','SQL02' | Get-sqmSpnReport -ContinueOnError

    Checks all instances on two servers; errors are skipped.
$result = Get-sqmSpnReport -ComputerName 'SQL01'
$result = Get-sqmSpnReport -ComputerName 'SQL01'
    $result.DetailRows | Where-Object Status -eq 'Missing' | Select-Object Spn, SetSpnCommand

    Returns only missing SPNs with the ready-to-use setspn command.