SharePoint get field by GUID with PowerShell

Once I was looking for a problem in SharePoint, I've spent some time digging the ULS Logs. There was an error with the message "Failed caching field with id '{GUID}'".

The first problem I had was the question: which field?

So I decided to build a script that returns the name of the field.
After I knew the name, I wanted to know where the field is used, so I extended the script. Now it returns the Lists and Content Types where the field is in use.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
$web = Get-SPWeb http://YourWebURL/
$fieldId = "Your-Field-GUID"

#Get the field in the web
$fieldInWeb = $web.Fields | Where {$_.Id.ToString().StartsWith($fieldId) }
if($fieldInWeb) {
 Write-Output "'$($fieldInWeb.Title)' in Web: '$($web.Title)'"
}

#Get all ContentTypes in the web containing the field
foreach($ct in $web.ContentTypes) {
 $fieldInCt = $ct.Fields | Where {$_.Id.ToString().StartsWith($fieldId) }
 if($fieldInCt) {
  Write-Output "'$($fieldInCt.Title)' in CT: '$($ct.Name)'"
 }
}

#Get all lists in the web containing the field
foreach($list in $web.Lists) {
 $fieldInList = $list.Fields | Where {$_.Id.ToString().StartsWith($fieldId) }
 if($fieldInList) {
  Write-Output "'$($fieldInList.Title)' in List: '$($list.Title)'"
 }          
}
 
$web.Dispose()

Comments

Post a Comment

Popular posts from this blog

Refresh the User Information List in SharePoint

If you are going into the User Information List, you will sometimes see it is not up to date. There are two jobs (User Profile to SharePoint Quick Sync and User Profile to SharePoint Full Sync). The quick sync will only add new member into your list and somehow it does not work sometimes. So you need to trigger the full sync. The question is how.. there is no point in the UI to do so and not even PowerShell is able to start it. The good old stsadm will rescue us. There are two commands you need to execute in your SharePoint Managing Shell (as administrator).
More »

Get the mail address from a FieldUserValue Client Side vs Server Side

In SharePoint are two ways to code by using an object model. The one way is the Client-Side Object Modell (CSOM) and the other side is the Server-Side Object Model (SSOM). At the first look they both look the same the only difference is how the objects are looking for example the is the 'Site'-object (client side) is called 'SPSite' on server side. A good way to demonstrate the difference is to get the mailaddress of a userfield. That sounds easy, but needs more lines that I thought at first. So let's say you got a SharePoint 2013 and want to read the mailaddress on client side. That would look like this: 1 2 3 4 5 6 7 8 9 // get the userfield of the item e.q. Author FieldUserValue Author = (FieldUserValue)currentItem[ "Author" ]; // ask the web to find a user with the id in the field (only works if the user visited the site) var user = web.SiteUsers.GetById(Author.LookupId); // load the data with the context context.Load(user); context.ExecuteQue...
More »