Get-sqmSpnReport
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.