I would like to have an easy way to get a list of InfoPath forms on SharePoint servers. I know that there is a way to do this with ShareGate’s tool. However, I found a blog posting that described a PowerShell solution: http://sharepointchips.com/2016/05/find-infopath-form-libraries-lists-sharepoint/
I ran the PowerShell script in Windows PowerShell ISE on my SharePoint server as an Administrator. I added the following line at the top of the script:
Add-PSSnapin
Microsoft.SharePoint.Powershell
This command loads the SharePoint Windows PowerShell snap-in.
I ran the script and entered the location of the SharePoint site that I wanted to scan: http://server2012sp/sites/testsites
The script scanned the site and provided the following details in the Console Pane:
Scanning Site Root Team Site @ http://server2012sp
Scanning Site RedirectorTest @ http://server2012sp/sites/Redirector
Scanning Site Search Center @ http://server2012sp/sites/SearchCenter
Scanning Site Social Site @ http://server2012sp/sites/social
Scanning Site FirstWiki @ http://server2012sp/sites/social/16f5ab30-c94a-405b-9cb2-371d6a84ff5d
Scanning Site J Wiki 1 @ http://server2012sp/sites/social/39762677-e5c7-4e9b-adde-82f8efdb1fe8
Scanning Site Blue Test Community @ http://server2012sp/sites/social/507346f5-e0f2-424a-9721-1b240420c7c1
Scanning Site Blue Test Community @ http://server2012sp/sites/social/507346f5-e0f2-424a-9721-1b240420c7c1/507346f5-e0f2-424a-9721-1b240420c7c1
Scanning Site Red Test Community @ http://server2012sp/sites/social/72913b70-1f28-474f-ab3d-f255690d2a60
Scanning Site Test Newburyport Community @ http://server2012sp/sites/social/7fc754f1-8c56-4c7f-a0bb-899be93ed74f
Scanning Site Alpha Community @ http://server2012sp/sites/social/91baf58c-fd59-4170-a838-e2d4ab96fc11
Scanning Site Red Community @ http://server2012sp/sites/social/9cfef5da-2139-4128-9bf8-754953765860
Scanning Site My Help Wiki @ http://server2012sp/sites/social/a123ff96-f62c-4a67-87e1-0c74b7a4d75f
Scanning Site The Red Wiki @ http://server2012sp/sites/social/b22340fe-3782-4f4a-96ee-fc7f932b6dde
Scanning Site The Blue Community @ http://server2012sp/sites/social/b79baa8b-252c-44d5-a596-52aec53074a3
Scanning Site FirstBlog @ http://server2012sp/sites/social/FirstBlog
Scanning Site This is my happy blog @ http://server2012sp/sites/social/Happy
Scanning Site Partner Management Blog @ http://server2012sp/sites/social/PartnerManagement
Scanning Site Test Newburyport Community @ http://server2012sp/sites/social/W7aabe4fef1c8_4247_9189_89caeb8d1aa7
Scanning Site Testing @ http://server2012sp/sites/testing
Scanning Site Test Site @ http://server2012sp/sites/testsites
Scanning Site Migration Test @ http://server2012sp/sites/testsites/MigrationTest
Scanning Site Enterprise Wiki Subsite @ http://server2012sp/sites/testsites/wiki
Report Generated at same path of the powershell script InfoPathLibs.csv
The PowerShell script also saved details to a CSV file. I opened the CSV file in Excel to view the saved details. You can see the details below. You may need to use the scroll bar to see all of the content to the right. Note that empty entries in the Form Template column refer to a custom list. Saved Form Template values are document libraries.
Site Collection | Site | List Name | List Url | Docs Count | Last Modified | Form Template |
Testing | Testing | InfoPathTest | http://server2012sp/sites/testing/InfoPathTest |
28 |
8/9/2017 |
/sites/testing/InfoPathTest/Forms/template.xsn |
Testing | Testing | Nintex Form Test | http://server2012sp/sites/testing/Lists/Nintex Form Test |
1 |
11/10/2015 |
|
Test Site | Test Site | Absence Request | http://server2012sp/sites/testsites/Lists/Absence Request |
5 |
2/18/2018 |
|
Test Site | Test Site | All Fields Test | http://server2012sp/sites/testsites/Lists/All Fields Test |
0 |
3/27/2017 |
|
Test Site | Test Site | Controls with Rules Test | http://server2012sp/sites/testsites/Lists/Controls with Rules Test |
0 |
4/26/2018 |
|
Test Site | Test Site | Generic Custom List for Nintex Form Testing | http://server2012sp/sites/testsites/Lists/Generic Custom List for Nintex Form Testing |
0 |
6/8/2018 |
|
Test Site | Test Site | InfoPath Radio Buttons | http://server2012sp/sites/testsites/Lists/InfoPath Radio Buttons |
0 |
8/12/2017 |
|
Test Site | Test Site | InfoPathTest | http://server2012sp/sites/testsites/InfoPathTest |
20 |
8/9/2017 |
/sites/testsites/InfoPathTest/Forms/template.xml |
Test Site | Test Site | Office Relocation | http://server2012sp/sites/testsites/Lists/Nintex Form Testing |
1 |
5/26/2017 |
|
Test Site | Test Site | Project Management Forms | http://server2012sp/sites/testsites/Project Management Forms |
1 |
5/7/2018 |
/sites/testsites/Project Management Forms/Forms/template.xsn |
Test Site | Test Site | Radio Buttons | http://server2012sp/sites/testsites/Lists/Radio Buttons |
0 |
7/27/2017 |
|
Test Site | Test Site | Test Form with Drop Down Lists | http://server2012sp/sites/testsites/Lists/Test Form with Drop Down Lists |
0 |
2/16/2018 |
|
Test Site | Test Site | Three View InfoPath Form | http://server2012sp/sites/testsites/Lists/Three View InfoPath Form |
0 |
6/9/2017 |
|
Test Site | Test Site | Travel Request Library | http://server2012sp/sites/testsites/Travel Request Library |
2 |
12/20/2017 |
/sites/testsites/Travel Request Library/Forms/template.xsn |
Test Site | Migration Test | InfoPathTest | http://server2012sp/sites/testsites/MigrationTest/Lists/InfoPathTest |
3 |
11/5/2015 |
Now I can see which lists have InfoPath forms! However, I know that some of these lists are using a Nintex form by default. The InfoPath form was not removed when the switch to using an InfoPath form was made.
I’m curious if ShareGate can provide a better report. Perhaps it can tell me which form is being used by default in the list?
Aug. 24, 2018: Unfortunately, ShareGate does not have the capability to report on InfoPath forms. However, we can vote to add InfoPath filters in ShareGate reporting. Click here to vote.