This is a PowerShell script (op-prem) I use a lot to inspect SharePoint list columns.
There are also great third party tools such as SPI-Insider and SharePoint Manager to do a deep-inspection of your SharePoint site. But I find that this simple PowerShell is also a great method to quickly inspect a list without starting a desktop application or browser plugin.
1# Copyright (C) www.jurjan.info - All Rights Reserved (MIT License)
2
3param(
4 [Parameter(Mandatory=$True,Position=1)] [string]$url,
5 [Parameter(Mandatory=$True,Position=2)] [string]$listTitle,
6 [Parameter(Mandatory=$False,Position=3)] [string]$listItemID,
7 [Parameter(Mandatory=$False,Position=4)] [string]$filter
8)
9
10Write-Host "usage: ListItems.ps1 [url] [listTitle] [listItemID] [filter] (listItemID and filter is optional)" -ForegroundColor Yellow -BackgroundColor Green
11if ($null -eq (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue))
12{
13 Add-PSSnapin Microsoft.SharePoint.PowerShell
14}
15
16try {
17 $web = Get-SPWeb $url -ErrorAction SilentlyContinue
18 $list = $web.Lists[$listTitle]
19} catch {
20 Write-Host "$url does not exist" -ForegroundColor Red
21 break
22}
23
24if(-not $listItemID)
25{
26 Write-Host "ListItemID was not supplied, listing all listitems" -BackgroundColor DarkGreen -ForegroundColor Black
27 if($null -eq $list)
28 {
29 Write-Host "No list found, showing all available lists" -ForegroundColor Red
30 $web.Lists | ForEach-Object {
31 Write-Host $_.Title
32 }
33 }
34 $list.Items | Format-Table
35}
36else
37{
38 Write-Host "Showing specific ListItem: " -BackgroundColor DarkGreen -ForegroundColor Black
39 try {
40 $listItem = $list.GetItemByID($listItemID)
41 } catch {
42 Write-Host "Listitem $listItemID does not exists" -ForegroundColor Red
43 break
44 }
45
46 if(-not $filter)
47 {
48 $listItem.Fields | ForEach-Object {
49 Write-Host $_.Title "[" $_.InternalName "]`t`t" -NoNewline -ForegroundColor Yellow -BackgroundColor DarkRed
50 Write-Host $listItem[$_.InternalName] -ForegroundColor Yellow -BackgroundColor Red
51 }
52 }
53 else
54 {
55 $listItem.Fields | Where-Object {$_.InternalName -match $filter} | ForEach-Object {
56 Write-Host $_.Title "[" $_.InternalName "]`t`t" -NoNewline -ForegroundColor Yellow -BackgroundColor DarkRed
57 Write-Host $listItem[$_.InternalName] -ForegroundColor Yellow -BackgroundColor Red
58 }
59 }
60}