Produced by Araxis Merge on 11/9/2018 12:16:34 PM Eastern Standard Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | RAMS-2.3.0.zip\RAMS-2.3.0\ps\misc | getListColumns.ps1 | Wed Aug 22 15:43:34 2018 UTC |
2 | RAMS-2.3.0.zip\RAMS-2.3.0\ps\misc | getListColumns.ps1 | Thu Nov 8 21:18:20 2018 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 6 | 164 |
Changed | 5 | 10 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | <# | |
2 | .SYNOPSIS | |
3 | Utilit y and Test ing script to retrie ve List in formation | |
4 | ||
5 | .DESCRIPTI ON | |
6 | Retrie ves and re ports on a specified list, pro vides the InternalNa me, Static Name, Titl e, Require d, Default Value, | |
7 | Type, LookupList , LookupFi eld, Hidde n, CanBeDe leted. Hav ing a wide screen to view the informatio n is helpf ul. This | |
8 | is a g ood way to determine the inter nalNames a nd StaticN ames for a give list and siteC olumn. | |
9 | ||
10 | .PARAMETER ListName | |
11 | [Strin g] The nam e of the l ist to be reported. Defaults t o "Shared Documents" | |
12 | ||
13 | .PARAMETER Url | |
14 | [String] T he URL of the site c ollection. Defaults to "http:/ / DNS . URL /sites/IRB Applicatio ns" | |
15 | ||
16 | .PARAMETER subsiteNa me | |
17 | [Strin g] Name of the subsi te where t he list re sides. Thi s is added to the UR L to deter mine the s ubsite URL . | |
18 | Defaul ts to "" | |
19 | ||
20 | .EXAMPLE | |
21 | #when run from t he powersh ell comman d prompt. | |
22 | #List the siteCo lumn infor mation in the Applic ation List at the Si te Collect ion level | |
23 | .\GetListC olumns.ps1 -ListName "Applicat ion" -Url "https:// DNS . URL /sites/IRB Applicatio n" | |
24 | ||
25 | .EXAMPLE | |
26 | #when run from t he powersh ell comman d prompt. | |
27 | #List the siteCo lumn infor mation in the Commit tee Calend ar List at the Facil ity Subsit e level | |
28 | .\GetListC olumns.ps1 -ListName "Committe e Calendar " -Url "ht tps:// DNS . URL /sites/IRB Applicatio n" -subsit eName "Ash eville" | |
29 | ||
30 | #> | |
31 | [CmdletBin ding()] | |
32 | Param( | |
33 | [Parame ter(Mandat ory=$false )] | |
34 | [string ]$ListName = "Shared Documents ", | |
35 | ||
36 | [Parame ter(Mandat ory=$false )] | |
37 | [string]$U rl = "http :// DNS . URL /sites/IRB Applicatio ns", | |
38 | ||
39 | [Parame ter(Mandat ory=$false )] | |
40 | [string ]$subsiteN ame = "" | |
41 | ) | |
42 | ||
43 | if ((Get-P SSnapin "M icrosoft.S harePoint. PowerShell " -ErrorAc tion Silen tlyContinu e) -eq $nu ll) { | |
44 | Add-PS Snapin "Mi crosoft.Sh arePoint.P owerShell" | |
45 | } | |
46 | $sScriptDi r = Split- Path -pare nt $MyInvo cation.MyC ommand.Pat h | |
47 | if ((get-m odule | Wh ere-Object ({$_.Name -eq 'RAMS_ Module_Uti l'}) ) -eq $null) { | |
48 | Import -Module $s ScriptDir\ ..\module\ RAMS_Modul e_Util.psd 1 | |
49 | } | |
50 | ||
51 | $lookupGui ds = @( | |
52 | ) | |
53 | $listInfo = @( | |
54 | ) | |
55 | $siteUrl = "$Url" | |
56 | if ($subsi teName) { | |
57 | $siteU rl += "/$s ubsiteName " | |
58 | } | |
59 | #$site = G et-SPWeb $ siteURL | |
60 | #$SpSite = Get-SpSit e -Identit y $siteURL | |
61 | #$w = Get- SiteWeb | |
62 | $w = Get-S PWeb $site Url | |
63 | $list = $w .Lists[$Li stName] | |
64 | Write-Host "$($list. Title)" -F oregroundC olor Yello w | |
65 | #$list.fie lds | sele ct Title, InternalNa me, Type, Hidden, Ca nBeDeleted | sort ti tle | ft - AutoSize | |
66 | #$list.fie lds | ?{$_ .Type -eq "Lookup"} | Sort Tit le | selec t Title, I nternalNam e, StaticN ame, Type, LookupLis t, LookupF ield, Hidd en, CanBeD eleted | s ort title | ft -Auto Size | |
67 | $list.fiel ds | Sort InternalNa me, Title | select I nternalNam e, StaticN ame, Title , Required , DefaultV alue, Type , LookupLi st, Lookup Field, Hid den, CanBe Deleted | % { | |
68 | if (($ _.LookupLi st) -and ( $_.LookupL ist -match '{\w{8}-\ w{4}-\w{4} -\w{4}-\w{ 12}}')) { | |
69 | $l ookupGuids += $_.Loo kupList | |
70 | } | |
71 | $_ } | ft -Wrap | |
72 | ||
73 | ||
74 | #Get-SPSit e http:// DNS . URL /sites/IRB Applicatio ns |Get-SP Web -Limit ALL | %{$ _.Lists} | ?{$_.ID - eq "db7be6 af-e7ce-41 4a-81d1-46 34e0199511 "} | ft Ti tle, Paren tWebURL, R ootFolder | |
75 | foreach ($ g in $look upGuids) { | |
76 | $listI nfo += $w. Lists[[GUI D]($g)] | |
77 | } | |
78 | $listInfo | Sort ID | ft Title , ID, Pare ntWebURL, RootFolder | |
79 | ||
80 | ||
81 | #%{$w.List s} | Sort Title | ft Title, ID , ParentWe bURL, Root Folder | |
82 | #if($w.Web s.Count -g t 0) { | |
83 | # forea ch($web in $w.Webs) { | |
84 | # #% {$web.List s} | ?{$_. ID -eq "db 7be6af-e7c e-414a-81d 1-4634e019 9511"} | f t Title, P arentWebUR L, RootFol der | |
85 | # %{ $web.Lists } | Sort T itle | ft Title, ID, ParentWeb URL, RootF older | |
86 | # } | |
87 | #} |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.