Get-CmSiteCode

Get-CmSiteCode.PS1

$result = @()
$time = 1
$searchbase = 'OU=WORKSTATIONS,DC=COMPANY,DC=com'
$list = (Get-ADComputer -SearchBase $searchbase -Filter 'Enabled -eq $true').name

function Get-ComputerSite($i)
{
   $site = nltest /server:$i /dsgetsite 2>$null
   if($LASTEXITCODE -eq 0){ $site[0] }
}

Foreach ($i in $list)
{

$resData = New-Object System.Object
$resData | Add-Member -type NoteProperty -name ComputerName -value $i

if (Test-Connection -ComputerName $i -Quiet -Count 1) 
    {
    try {
    $resData | Add-Member -type NoteProperty -name SiteCode -value ((Invoke-WMIMethod -ComputerName $i –Namespace root\ccm –Class SMS_Client –Name GetAssignedSite -ErrorAction Stop).sSiteCode)
    $resData | Add-Member -type NoteProperty -name ADSite -value (Get-ComputerSite $i) }
    catch {$resData | Add-Member -type NoteProperty -name SiteCode -value ("Connection Failed : $($error[0].Exception.Message)") -Force}
    }

   

else {$resData | Add-Member -type NoteProperty -name SiteCode -value ('Connection Failed : Ping Failed')} 

$result += $resData
Write-Progress -activity "Checking Site Codes for $($list.length) clients" -status "Percent checked: " -PercentComplete (($time / $list.length)  * 100)
$time++

}

$result | sort SiteCode