Find content types for given column

Question

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfield.listsfieldusedin.aspx

$web = Get-SPWeb http://”sitecollectionurl”
$column = $web.Fields[“Column Display Name”]
$column.ListsFieldUsedIn()
$allCT = $web.ContentTypes
foreach (SPContentType $ct in $allct)
{
  # Need help here so I can find the field in question
}

returns nada. do i need to add

I am trying to delete a field and it said it's in used by some content type.

Answer 1

I found a powershell script from: http://netsourcecode.blogspot.com/2011/12/listing-all-content-types-and-fields.html and modified it.

Try this:

$columnname = "StartDate"

write-host ("Looking for: " + $columnname)      
$url=  "http://localhost/"  
$site = get-spsite $url         
$web = $site.OpenWeb()      
foreach ($contenttype in $web.ContentTypes) {   
    foreach ($field in $contenttype.Fields) {
        if ($field.get_InternalName() -eq $columnname) {
            write-host("Content Type Name: " + $contenttype.Name + " has field: " + $field.get_InternalName())  
        }   
    }   
}

Answer 2

Instead of ListsFieldUsedIn, try to use $column.UsedInWebContentTypes()