Aghy's SharePoint Journey

Recently, I was working with FAST Search Server 2010 for SharePoint (FS4SP) and had to provide a list of all crawled properties in the category “MyCategory”. Here is my pretty simple script that provides the list in a .CSV file:

$outputfile = "CrawledProperties.csv"

if (Test-Path $outputfile) { clear-content $outputfile }

foreach ($crawledproperty in (Get-FASTSearchMetadataCrawledProperty))
{
    $category = $crawledproperty.categoryName
    if ($category = "MyCategory")
    {

        # Get the name and type of the crawled property
        $name = $crawledproperty.name
        $type = $crawledproperty.VariantType

        switch ($type) {
            20 {$typestr = "Integer"}
            31 {$typestr = "Text"}
            11 {$typestr = "Boolean"}
            64 {$typestr = "DateTime"}
            default {$typestr = “other”}

        }
        # Build the output: $name and $typestr separated by “ “ 
        $msg = $name + " " + $typestr

        Write-output $msg | out-file $outputfile -append
    }
}

$msg = "Crawled properties have been exported to the file " + $outputfile
write-output ""
write-output $msg
write-output ""
write-output ""