Filter and sort FXCop warning from build output - Powershell

FxCopFilter.ps1

$buildfile = "build.log"
$outputfile = "FxCopList.csv"

$hash = @{} # used to filter duplicates

$fxcopFilter = "[CodeAnalysis]"
gc $buildfile |
	%{if($_.contains($fxcopFilter) -and $_.contains(" CA")) {$_}} |
	%{
		$startindex = $_.IndexOf($fxcopFilter) + $fxcopFilter.Length;
		$line = $_.SubString($startindex).TrimStart();
		$line;
	} | 
	%{
		if($hash.$_ -eq $null){$_};
		$currrentLine = $_;
		$myobj = "" | Select codeAnalysisCategory,codeAnalysisId,description,file,fullDetails
		$myobj.fullDetails = $_;
		if($currrentLine.Indexof("CA") -ne 0)
		{
			if($currrentLine.Indexof(": CA") -gt 0)
			{
				$endindex = $currrentLine.IndexOf(": CA");
				$myobj.file = $currrentLine.SubString(0,$endindex).TrimStart();
				$currrentLine = $currrentLine.replace($myobj.file +":", "").Trim();					
			}				
		}			
		if($currrentLine.Indexof("CA") -ne 0)
		{
			Write-Error "error" -ForegroundColor Red
			Write-Error $currrentLine -ForegroundColor Red
			throw "I messed up. CA should be the start of this line"
		}
		$endindex = $currrentLine.IndexOf(" : ");
		if($endindex -lt 0){ throw "codeAnalysisId could not be found for $_"}
		$myobj.codeAnalysisId = $currrentLine.SubString(0,$endindex).Trim();
		$currrentLine = $currrentLine.Replace($myobj.codeAnalysisId + " : ", "").Trim();
		
		$endindex = $currrentLine.IndexOf(" : ");
		if($endindex -lt 0){ 
			Write-Warning "codeAnalysisCategory could not be found for $_";
			$myobj.codeAnalysisCategory = "";
			$myobj.description = $currrentLine;
		}
		else
		{
			$myobj.codeAnalysisCategory = $currrentLine.SubString(0,$endindex).Trim();
			$myobj.description = $currrentLine.replace($myobj.codeAnalysisCategory + " : ", "").Trim();
		}			
		$hash.$_ = 1
		$myobj;
	} | 
	Sort-Object codeAnalysisCategory, codeAnalysisId | 
	Export-Csv $outputfile

Build files from MSBuild/TeamCity are big, they have lots of stuff in them. I just want to extract distinct FXcop violation from them so I can montior the Code Quailty with out opening the solution... visual studio, i never though id miss you.
Basically this allows me to see where oour major issues are and assign specific tasks as a backlog item, eg Fix Capitialisation issues (of which there is 42 warnings)