gistfile1.txt

$searches = Get-ComplianceSearch | select name, @{n = "SharePoint"; e = {(Get-ComplianceSearch $_.identity).SharePointLocation}} 
foreach ($row in $searches) {
    $searchHash = @{}
    if ($($row.SharePoint)) {
        foreach ($site in $row.SharePoint) {
            $searchHash['name'] = $row.name
            $searchHash['SharePoint'] = $site
            $resultArray += [psCustomObject]$searchHash
        }    
    }
    else {
        $searchHash['name'] = $row.name
        $searchHash['SharePoint'] = "none"
        $resultArray += [psCustomObject]$searchHash
    }
}