Downloaded 14 times
![45 Loading SharePoint DLLs Works in MOSS 2007 too! [void][System.Reflection.Assembly]:: LoadWithPartialName("Microsoft.SharePoint")](https://image.slidesharecdn.com/introductiontopowershell-beapowershellhero-spfest2014workshop-141219113107-conversion-gate02/75/Introduction-to-PowerShell-for-SharePoint-SharePointFest-2014-workshop-45-2048.jpg)
![66 Email Alerts Send-MailMessage [-To] <string[]> [- Subject] <string> [[-Body] <string>] [[- SmtpServer] <string>] -From <string> [- Attachments <string[]>] [-Bcc <string[]>] [-BodyAsHtml] [-Encoding <Encoding>] [-Cc <string[]>] [- DeliveryNotificationOption <DeliveryNotificationOptions>] [- Priority <MailPriority>] [-Credential <pscredential>] [-UseSsl] [-Port <int>] [<CommonParameters>]](https://image.slidesharecdn.com/introductiontopowershell-beapowershellhero-spfest2014workshop-141219113107-conversion-gate02/75/Introduction-to-PowerShell-for-SharePoint-SharePointFest-2014-workshop-66-2048.jpg)
Uploaded byMichael Blumenthal (Microsoft MVP)
Introduction to PowerShell for SharePoint - SharePointFest 2014 workshop
This document serves as an advanced introduction to PowerShell for SharePoint developers and administrators, authored by experts Michael Blumenthal and Jack Fruh. It covers fundamental concepts, best practices, and practical uses of PowerShell in managing SharePoint environments, including command syntax, flow control, and object model interactions. The document also emphasizes hands-on learning, with a focus on real-world applications and community involvement.
Introduction to PowerShell for SharePoint - SharePointFest 2014 workshop
- 1. An Advanced Introductionto PowerShell for SharePoint Developers and Administrators Michael Blumenthal & Jack Fruh
- 2. 2 Who is MichaelBlumenthal? Sr. Solution Architect at PSC Group CSPUG Co-Leader 19 years in IT Consulting 11 years working with SharePoint 7 years with PowerShell
- 3. 3 Who is JackFruh? SharePoint Administrator Fortune 500 Company Big on community SPS Chicago Suburbs Co- Leader SharePointJack.com SPYam CloudSaturday.com
- 4. 4 This is aboutyou Version of SharePoint? Admin, Developer, Both, Other? PowerShell experience? SharePoint experience?
- 5.
- 6. 6 PowerShell puts theSharePoint Engine at your fingertips! • It’s Easy to Get Started!1 • Learn the PowerShell Syntax2 • Best Practices3 • Practical Uses4 • Scripting Q&A, Raffle5
- 7.
- 8. 8 Getting Started withPowerShell 2003 2008, R2, 2012, R27, 8, 8.1, 10…
- 9.
- 10.
- 11.
- 12.
- 13. 13 PowerShell v3 &v4 ISE
- 14. 14 POSH vs theSharePoint Mgmt Shell
- 15. 15 Managing On Premvs Online http://bit.ly/POSH4SPO
- 16.
- 17. Learn to usePowerShell with SharePoint! Fundamentals Using the SharePoint API
- 18. 18 Symbols, Keywords, andSyntax! Oh My! • Variables1 • Commands2 • Piping3 • Comparisons4 • Flow Control5 • Filtering6 • Scripts7 • Debugging8
- 19. 19 Reading Symbols inCode (tal Guidance Moe, Larry, and } The universe started with the Big ! !Important A # of Bacon and # Browns
- 20. 20 Variables begin witha $ • Case Insensitive, Dynamic typing $something $true, $false, $profile, $null $MyMessage = “Hello, World” 1
- 21.
- 22. 22 Commands are calledcmdlets. Verb-Noun Built-in, Extensible Get-Help & Help Get-Member Get-Command 2
- 23.
- 24.
- 25.
- 26.
- 27. 27 Find custom commandsthis way Refresh the command list Actions you can take once you fill in parameters
- 28. 28 The Power ofPiping! Output Of Command 1 Input of Command 2 3
- 29.
- 30. Making Comparisons4 Operator MeaningOperator Meaning -eq Equals -le Less Than or Equal To -ne Not Equals -like Wildcard Match -gt Greater Than -notlike Not (Wildcard Match) -ge Greater Than or Equal To -match Reg. Exp. Match -lt Less Than -notmatch Not (Reg. Exp. Match)
- 31.
- 32. 32 Taking Control ofthe Flow5 • For (Init;Test;Repeat) {Commands} • for($i=1; $i -le 10; $i++) {Write-Host $i}For • Foreach (Item in Collection) {Commands} • Foreach ($web in $site.AllWebs) {$web.Title}ForEach • If (Test) {Commands} • if ($web.Title –ne “”) {Write-Host $web.Title}If • While (Condition){Commands} • while($val -ne 3){$val++; Write-Host $val}While
- 33.
- 34. 34 Where-Object6 •Where {<Test>}Syntax • V1&2:Dir| Where {$_.Name –like “B*”} • V3:Dir | where Name –like B* Example
- 36.
- 38. 38 Creating a function Functionglobal:Do-Something ($param, …){ # put cmdlets here… }
- 39.
- 40.
- 41. 41 In Review • Variables1 •Commands2 • Piping3 • Comparisons4 • Flow Control5 • Filtering6 • Scripts7 • Debugging8
- 42. 42 Using the SharePointAPI • Understand the OM1 • Load Cmdlets2 • Use ’em!3
- 43. 43 Highlights from theSharePoint Object Model SPField SPListItem SPList SPWeb SPSite SPWebApplication SPFarm Word Page Book Classroom Department School District
- 44. 44 Loading SharePoint Cmdlets C:...14or 15CONFIGPOWERSHELL RegistrationSharePoint.ps1: Add-PsSnapin Microsoft.SharePoint.PowerShell
- 45. 45 Loading SharePoint DLLs Worksin MOSS 2007 too! [void][System.Reflection.Assembly]:: LoadWithPartialName("Microsoft.SharePoint")
- 46. 46 Get a Siteand Explore it! $site = get-spsite http://server/path THEN $site
- 47.
- 48.
- 49.
- 50. 50 Best Practices • Followthe Verb-Noun pattern1 • Comment Your Functions2 • Write your scripts as functions that announce themselves •Make accidentals runs harmless 3 • Use Source Control4
- 51. 51 Verb-Noun = Action-Thing Add Backup Clear Connect Convert Copy Disable Disconnect Dismount Enable Etc… SPAppDeniedEndpoint SPClaimTypeMapping SPDiagnosticsPerformanceCo unter SPDistributedCacheServiceIns tance SPEduClassMember SPEduUser SPInfoPathUserAgent SPPluggableSecurityTrimmer SPProfileLeader SPProfileSyncConnection Etc… 42verbs combined with 347 nouns to give us 799 cmdlets
- 52. 52 Comment your functions <# .SYNOPSIS–a brief explanation of what the script or function does. .DESCRIPTION – a more detailed explanation of what the script or function does. .PARAMETER name – an explanation of a specific parameter. Replace name with the parameter name. You can have one of these sections for each parameter the script or function uses. .EXAMPLE – an example of how to use the script or function. You can have multiple .EXAMPLE sections if you want to provide more than one example. .NOTES – any miscellaneous notes on using the script or function. .LINK – a cross-reference to another help topic; you can have more than one of these. If you include a URL beginning with http:// or https://, the shell will open that URL when the Help command’s –online parameter is used. #>
- 53.
- 54. 54 Find custom commandsthis way Refresh the command list
- 55.
- 56. 56 More Good Ideas Alwaysread scripts before running them Make it safe for others to not read them first Write scripts as functions most of the time Check for valid parameter values Do error handling
- 57. 57 A Word AboutMemory Management SPWeb SPSite Inline In Script
- 58.
- 59.
- 60. 60 Practical Uses • BulkCreate Sites1 • List Item CRUD2 •Create data for test cases3 • Associate Workflows with a List4
- 61. 61 More Practical Uses •Work across site collections5 • Deployment Scripting6 • Identify files that won’t upload7 • Sync Wep App Properties8
- 62. 62 More Practical Uses •Install SharePoint9 • Repeatably Manage Content10 • Update Field Definitions11 • Check the Farm Version12
- 63. 63 More Practical Uses •Custom Reports on Permissions13 • Document Versioning Settings14 • Managing Azure and SPO15 • SSL Cert Expiry Alerts16
- 64. 64 What’s your SharePointVersion? PS C:UsersAdministrator> $(get- SPFarm).BuildVersion Major Minor Build Revision ----- ----- ----- -------- 14 0 6109 5002
- 65. 65 Audio Alerts Stick thisat the end of your long running script: $Voice = new-object -com SAPI.SpVoice $Voice.Speak(“Deployment is done!")
- 66. 66 Email Alerts Send-MailMessage [-To]<string[]> [- Subject] <string> [[-Body] <string>] [[- SmtpServer] <string>] -From <string> [- Attachments <string[]>] [-Bcc <string[]>] [-BodyAsHtml] [-Encoding <Encoding>] [-Cc <string[]>] [- DeliveryNotificationOption <DeliveryNotificationOptions>] [- Priority <MailPriority>] [-Credential <pscredential>] [-UseSsl] [-Port <int>] [<CommonParameters>]
- 67. 67 Review • It’s onyour machine!1 • Know the PowerShell Syntax2 • Use Best Practices3 • Practical Uses4 • Do it now!5
- 68.
- 69.
- 70. Book Raffle Put yourcard in the box
- 71. 73 Tonight only! CSPUG’s SPFestSpeaker Panel Discussion 6-7:30pm http://bit.ly/201412CSPUGReg
- 72.
- 73. 75 Questions & ThankYou • Michael Blumenthal SharePoint Architect PSC Group, LLC • MBlumenthal@psclistens.com • www.psclistens.com • MichaelBlumenthal.me • @MichaelBL • LinkedIn • SPYam • Jack Fruh SharePoint Admin • Jack@SharepointJack.com • SPSChicagoSuburbs.com • SharePointJack.com • @SharePointJack • LinkedIn • SPYam Thank you for your time today.
Editor's Notes
- #3 PSC is a title sponsor
- #5 Anyone here not done SharePoint development? What kind of development have you done? Who has worked with PowerShell already? Used for what? Your name? Who has worked with other scripting languages?
- #6 Command line control of SharePoint at your fingertips? Every SharePoint Developer & admin needs this! Fast and Flexible Great for LastMile Problems. New MSFT std for command line & remote admin. No Visual Studio.
- #7 Who would like another tool in their toolbox, one that will help them with SharePoint, but also with many other things? How about the swiss army knife of tools? It will make you a better developer!
- #9 Who here already has installed and PowerShell? Win 2003: http://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx Win 2008 – It’s an OS Feature – “servermanagercmd –install PowerShell” Win2008R2 – it’s already installed
- #15 One is SharePoint aware, the other isn’t!
- #16 Download SPO Cmdlets here: http://www.microsoft.com/en-us/download/details.aspx?id=35588
- #21 Name that Language… Similar to @variables in SQL, apparently also Ruby, PHP. Arrays start at 0
- #23 Mention Aliases
- #24 Like a UNIX Manpage!
- #25 Get-Member examples
- #26 Get Command Examples
- #27 Intellisense!
- #30 Ask if anyone has unix scripting experience, and what they think of this. Can you imagine trying to do this in unix or vbscript?
- #33 Get-Help about_flow_control Mention that collections start at 0
- #34 Ask if anyone has unix scripting experience, and what they think of this. Can you imagine trying to do this in unix or vbscript?
- #44 If you are familiar with these objects, raise your hand.
- #48 Now that you know all the fundamentals, Jack will show you how to apply them
- #51 http://technet.microsoft.com/en-us/magazine/ff458353.aspx
- #52 Try to use an existing verb. You can make your own Noun Prefix if you want.
- #54 about_comment_based_help
- #58 Your mother doesn’t work here! You must clean up after yourself.
- #59 http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?PageType=4&ListId={72C1C85B-1D2D-4A4A-90DE-CA74A7808184}&pID=524 http://msdn.microsoft.com/en-us/library/ee557362.aspx See Assignment collections - http://technet.microsoft.com/en-us/library/ff607664.aspx
- #68 Who would like another tool in their toolbox, one that will help them with SharePoint, but also with many other things? How about the swiss army knife of tools? It will make you a better developer!
- #70 Michael
- #71 Once used a choice column’s values instead of a CSV
- #72 Thanks for the VM, Cloudshare!