How to GetSPN output to .csv

Question

I have the below script, but having issues outputting to csv. Tried changing to write-output as well.

---# Source / credit:
---# https://social.technet.microsoft.com/wiki/contents/articles/18996.active-directory-powershell-script-to-list-all-spns-used.aspx

cls
$search = New-Object DirectoryServices.DirectorySearcher([ADSI]"")
$search.filter = "(servicePrincipalName=*)"

---## You can use this to filter for OU's:
---## $results = $search.Findall() | ?{ $_.path -like 'OU=whatever,DC=whatever,DC=whatever' }
$results = $search.Findall()

foreach( $result in $results ) {
$userEntry = $result.GetDirectoryEntry()
Write-host "Object Name = " $userEntry.name -backgroundcolor "yellow" -foregroundcolor "black"
Write-host "DN = " $userEntry.distinguishedName
Write-host "Object Cat. = " $userEntry.objectCategory
Write-host "servicePrincipalNames"

$i=1
foreach( $SPN in $userEntry.servicePrincipalName ) {
Write-host "SPN(" $i ") = " $SPN
$i+=1
}
Write-host ""
}

Answer 1

Try this (without using the old ADSI clutter):

Get-ADObject -Filter 'servicePrincipalName -like "*"' -properties *|
    ForEach-Object{
        Write-Host "Object Name = " $_.name -backgroundcolor "yellow" -foregroundcolor "black"
        Write-Host "DN = "          $_.distinguishedName
        Write-Host "Object Cat. = " $_.objectCategory
        Write-Host "servicePrincipalNames"
        $i = 0
        ForEach ( $SPN in $_.servicePrincipalName ) {
            Write-Host "SPN(" (++$i) ") = " $SPN
        }
        Write-Host ""
    }

To get all that into a CSV:

Get-ADObject -Filter 'servicePrincipalName -like "*"' -properties *|
    ForEach-Object{
        $_ | Select-Object      @{n='Object Name';e={$_.name}}, 
                                @{n="DN";e={$_.distinguishedName}},
                                objectCategory,
                                @{n="servicePrincipalNames";e={$_.servicePrincipalName -join ";"}}
    } | Export-Csv c:\junk\SPNs.csv -NoTypeInformation

Note that because the number of SPNs may be different for each object it wouldn't do to place each SPN in a separate column. In this example I've placed them all into one column and separated each with a semi-colon.