Get All Instances of a SharePoint Field in a Site Collection

Paste the below text into PowerShell or PowerShell ISE

You could even add the ability to output the array to CSV if you like.





#region INFO

########################
####   INFORMATION   ###
########################

<#
.DESCRIPTION
    This script will use an input parameter for a SharePoint field,
    using the internal field name, and display all the locations where it is instanced.
    It will even give you the URL to the property
.NOTES
    Author    : Eric Jochens
    Tags      : SharePoint
#>

#endregion INFO


#region PARAMETERS
[CmdletBinding()]
Param
(
    [Parameter(Mandatory=$true,HelpMessage="Enter the SharePoint Field Internal Name")][String]$FieldInternalName,
    [Parameter(Mandatory=$true,HelpMessage="Enter the SharePoint Field Display Name")][String]$FieldDisplayName,
    [Parameter(Mandatory=$true,HelpMessage="Enter the URL for the site collection we will search for fields")][String]$SiteCollectionUrl
)
#endregion PARAMETERS


#region SNAPINS

    Add-PSSnapin "Microsoft.SharePoint.PowerShell" -EA 0

#endregion SNAPINS


#region SCRIPT

####################
#####  Script  #####
####################

#System Variables
$StartTime = Get-Date
Write-Host ("Start Time:     " + $StartTime)
$DateStr = $StartTime.ToString("yyyy-MM-dd_HHmm")
Try
{
    $site = Get-SPSite -Identity $SiteCollectionUrl
    If($site){
        $arrayFields = @()
        Write-Host "Found site collection: " $site.Url -ForegroundColor Cyan
        $webs = $site.AllWebs
        ForEach($web in $webs){
            $webTitle = $web.Title
            $lists = $web.Lists
            ForEach($list in $lists){
                $listTitle = $list.Title
                ForEach ($field in ($list.Fields | Where-Object{$_.internalName -eq $FieldInternalName -or $_.Title -eq $FieldDisplayName} ))
                {
                    $listGUID = [uri]::EscapeDataString("{" + $list.ID.Guid + "}")
                    [String]$fieldUrl = $web.Url + "/_layouts/15/FldEdit.aspx?List=" + $listGUID + "&Field=" + $field.internalName
                    $objField = New-Object System.Object
                    $objField | Add-Member -MemberType NoteProperty -Name "SiteURL" -Value $site.Url
                    $objField | Add-Member -MemberType NoteProperty -Name "WebTitle" -Value $webTitle
                    $objField | Add-Member -MemberType NoteProperty -Name "ListTitle" -Value $listTitle
                    $objField | Add-Member -MemberType NoteProperty -Name "FieldDisplayName" -Value $field.Title
                    $objField | Add-Member -MemberType NoteProperty -Name "FieldInternalName" -Value $field.internalName
                    $objField | Add-Member -MemberType NoteProperty -Name "FieldType" -Value $field.Type
                    $objField | Add-Member -MemberType NoteProperty -Name "FieldURL" -Value $fieldUrl
                    $arrayFields += $objField
                }#fields
            }#lists
            $web.Dispose()
        }#webs
    }#site
    $arrayFields | Format-Table -Property WebTitle,ListTitle,FieldDisplayName,FieldInternalName,FieldType,FieldURL -AutoSize
}# try
Catch [system.exception]
{
    While($_.Exception.Message){Write-Error $_.Exception.Message}
    While($_.Exception.InnerException){Write-Error $_.Exception.InnerException}
    Break
}
Finally
{
$site.Dispose()
    $EndTime = Get-Date
$TimeToComplete = $EndTime - $StartTime
Write-Host ("Script Complete.")
Write-Host ("End Time       : " + $EndTime)
Write-Host ("Total Elapsed  : " + $TimeToComplete.Minutes + " min " + $TimeToComplete.Seconds + " sec")
    [System.GC]::Collect()
}

#endregion SCRIPT

Comments

Post a Comment

Popular posts from this blog

SharePoint Designer 2013 Approval Workflow with Comments

Image
Adding Comments to a SharePoint 2013 Approval Workflow I needed the ability to capture comments from Approval Tasks in a workflow.  This has changed greatly in 2013 workflows.  Everything is more modular and as such must be built somewhat from scratch. SharePoint 2013 workflows can become corrupt .  This may have been fixed by a patch, but please refer to a previous post before creating any 2013 workflows in Designer:  http://www.ericjochens.com/2014/12/sharepoint-2013-workflow-observations.html SharePoint 2013 does not have a built-in approval workflow, nor does a built-in task item include comments.  I solved this by building my own approval workflow, and using a custom content type to include a comments field. A SharePoint 2013 Workflow will not store the Task ID when a task is created, so you cannot do a lookup into that task list to grab comments or any other field.  I solved this by creating a separate workflow in the task list to read the Related Items column, and update t
Read more

SharePoint Search - Content Processing Pipeline Failed to Process the Item

Image
SharePoint 2013 Search Crawls Stop Crawling All Content Recently the search system stopped successfully crawling content.  ASPX pages were crawled, but no content was being indexed. Opening up the crawl log showed thousands of errors with this message: The content processing pipeline failed to process the item.  (Index was out of range.  Must be non-negative and less than the size of the collection.  Parameter name: index; SearchID = [GUID]) Note: the resolution is in the resolution section for those who cannot or refuse to read. What does this mean?  Honestly initially it made no sense.  So I learned a valuable lesson: I misguidedly spent the next 2 days trying the usual fixes like resetting the index, rebuilding the 2013 search components, and lastly what EVERYONE does: they fix it with a sledgehammer (in this case rebuilding the search service application). But what if rebuilding the search service application is a horrible pain?  We have thousands of query rules, 30 result
Read more

Change SharePoint server hostname and Web Application Names

Note: I realize that many admins are reluctant to delete web applications.  I personally know why I ma doing it and how to achieve this easily.  You should always retain any customization you have added to the site, like web.config mods, etc.  The Alternate Access Mappings are always available, but they leave open holes that I do not wish to keep active.  I like a clean setup. Why? Perhaps you need to clone a development, test, or some SharePoint server and you need to change the hostname so that it can exist on the same domain without a SID conflict.  Or you just have a use-case for wanting to rename the hostname of a SharePoint server.  It can be done, just make sure you go through all of the steps. The Rename-SPServer PowerShell command can also be used to change the SQL Server name, for the case where you might move the databases to a new SQL server or instance and you need to point all of the farm servers to this new hostname\instance. Changing the hostname isn't that
Read more