Tuesday, February 19, 2019

PowerShell Toolbox for SharePoint

Most Commonly Requested PowerShell Commands

Many SharePoint Admins ask for a list of most commonly used PowerShell commands so you ask and you receive.

More from PowerShell 101

SharePoint PowerShell
http://powershell101.blogspot.com/2012/09/sharepoint-powershell.html

More from The Cloud Engineer

Cool PowerShell for SharePoint – Start Here
https://thecloudengineer.blogspot.com/2016/10/cool-powershell-for-sharepoint-start.html

Cool PowerShell for SharePoint Online – Start Here
https://thecloudengineer.blogspot.com/2019/04/cool-powershell-for-sharepoint-online.html

General SharePoint PowerShell Page – OLD
http://thecloudengineer.blogspot.com/2011/11/sharepoint-powershell.html

Farm Commands

Reset Farm PassPhrase
Set-SPPassPhrase

ISE

Create PowerShell ISE Enabled for SharePoint
http://thecloudengineer.blogspot.com/2011/10/create-ise-enabled-for-sharepoint.html

Cool PowerShell for SharePoint – Start Here

Central point for PowerShell and SharePoint
R
eference guide of PowerShell on the web

PowerShell 101

Basic
http://powershell101.blogspot.com/2012/09/sharepoint-powershell.html

Add Online Modules
http://sharepoint-tricks.com/install-update-uninstall-cmdlets-for-sharepoint-online

LinkedIn Articles

General Scripts: (Retrieve List and Email) untested
https://www.linkedin.com/in/sachchin-annam-21517031/detail/recent-activity/posts/

Office 365

Exchange PS1
https://blogs.technet.microsoft.com/exchange/2016/10/06/tip-a-few-useful-powershell-scripts-for-exchange-and-office-365-admins/
Using PowerShell to Specify License Plans in Office 365
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=664
Multi Tenant
http://www.luisevalencia.com/2019/02/28/leveraging-office-pnp-core-to-run-multi-tenant-specific-operations

2016

Index of Windows PowerShell cmdlets for SharePoint Server 2016
https://technet.microsoft.com/en-us/library/ff678226(v=office.16).aspx
Download Index of Windows PowerShell cmdlets for SharePoint 2016
https://gallery.technet.microsoft.com/office/SharePoint-2016-Powershell-c7f8814f

DisableLoopBackCheck when routing through a Load Balancer

(PowerShell sample included) NOTE the tick is in the upper left corner of the keyboard, note the single quote used in `r`n for carriage return line feed and use iisreset to complete.

https://blogs.technet.microsoft.com/scottstewart/2014/09/15/disableloopbackcheck-when-routing-through-a-load-balancer-powershell-sample-included/

2013

How-to Enable Protocols on SQL Server with PowerShell https://technet.microsoft.com/en-us/library/dd206997(v=sql.105).aspx

SQL Alias PowerShell script https://blogs.technet.microsoft.com/sqlpfeil/2014/03/31/sql-alias-powershell-script/

Limit SharePoint Site Templates
http://briantjackett.com/2014/03/04/powershell-script-to-limit-sharepoint-site-templates-available/

SharePoint PowerShell Script Series Part 4–Gathering item count for all document libraries in a Site Collection
https://blogs.msdn.microsoft.com/russmax/2012/01/20/sharepoint-powershell-script-series-part-4gathering-item-count-for-all-document-libraries-in-a-site-collection/

Cool site with a ton of scripts
https://github.com/sharepoint

Alternate to Warm Up Scripts

http://thesharepointfarm.com/2012/06/sharepoint-warm-up-scripts-a-thing-of-the-past/

PowerShell Tips
http://secretsofsharepoint.com/cs/
http://powershell101.blogspot.com/search/label/tips

Service Application PowerShell
Search

http://blogs.technet.com/b/praveenh/archive/2013/02/07/create-a-new-search-service-application-in-sharepoint-2013-using-powershell.aspx

Copy lists in PowerShell (thx Todd)
http://www.sharepointdiary.com/2012/12/copy-list-between-sites-powershell.html
http://sharepointpsscripts.codeplex.com/releases/view/21696 Bulk Import

Tools

https://spuploader.codeplex.com/
http://spbulkdocumentimport.codeplex.com/
https://difs.codeplex.com/
http://docuploadmetadata.codeplex.com/
http://get-spscripts.com/2010/10/bulk-upload-files-with-metadata-into.html

2010

Configure a service application by using a Windows PowerShell script (SharePoint Server 2010)
https://technet.microsoft.com/en-us/library/gg983005(v=office.14).aspx

Change Page Layout On Publishing Sites.
https://myspworld.wordpress.com/2012/08/16/powershell-script-to-change-the-page-layout/
Issues
PowerShell 3.0 Issues http://support.microsoft.com/kb/2796733
PowerShell Builder - SharePoint
http://www.microsoft.com/resources/TechNet/en-us/Office/media/WindowsPowerShell/WindowsPowerShellCommandBuilder.html


Untested but look good
Warm-up Scripts
http://gallery.technet.microsoft.com/office/SharePoint-2007-2010-or-d1884b4b
Copy an entire document library from SharePoint to Disk
http://sharepointkunskap.wordpress.com/2012/12/11/powershell-copy-an-entire-document-library-from-sharepoint-2007-to-disk/
Upload File to SharePoint Library using PowerShell
http://www.sharepointdiary.com/2012/07/upload-file-to-sharepoint-library-using.html
http://get-spscripts.com/2010/10/bulk-upload-files-with-metadata-into.html
Move Content Types
http://get-spscripts.com/2011/02/export-and-importcreate-site-content.html
Duplicate Documents
http://blog.pointbeyond.com/2011/08/24/finding-duplicate-documents-in-sharepoint-using-powershell/
https://www.nothingbutsharepoint.com/sites/devwiki/articles/pages/finding-duplicate-documents-in-sharepoint-2010.aspx
Export Reports from SharePoint Reports
http://social.technet.microsoft.com/Forums/sharepoint/en-US/dc719361-50bc-40ba-bd6b-5035c5a876ca/export-report-from-sharepoint-over-powershell