Guid hunter

[void]([System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo"))

## GUID HUNTER >_< ##

$hostname = "SERVER"
$database = "CATALOG"
$guid = "GUID"

$SQLServer =  new-object Microsoft.SqlServer.Management.Smo.Server $hostname
$SQLDatabase = $SQLServer.Databases[$database]

$SQLDatabase.Tables | ?{$_.rowcount -gt 0 } | %{
    $guidColumns = @($_.Columns | ?{$_.Datatype.Name -eq "varchar" -and $_.Datatype.MaximumLength -eq 32} | %{$_.Name})

    if($guidColumns.Count -gt 1) {
        $SQLQuery = "SELECT TOP 1 * FROM [" + $_.Name + "] WHERE ["
        for($i=0;$i-lt$guidColumns.Count-1;$i++) { $SQLQuery += $guidColumns[$i] + "] = '"+$guid+"' OR [" }
        $SQLQuery += $guidColumns[$guidColumns.Count-1] + "] = '"+$guid+"'"

        $Results = $SQLDatabase.ExecuteWithResults($SQLQuery)
        if($Results.Tables[0].Rows.Count -gt 0) {
            Write-Host "Found in table" $_.Name
        }
    }
}