PowerShell for SharePoint Developers and Administrators

1. PowerShell for SharePoint Developers and Administrators Michael Blumenthal Magenic Technologies MichaelBl@Magenic.com

2. Who is Michael Blumenthal? • Associate Principal Consultant at Magenic • 17 years in IT Consulting • 9 years working with SharePoint (2003,2007,2010, 2013) • 3x INETA Champ, CSPUG Co-Leader, SP Speaker

3. Why PowerShell?

4. PowerShell puts the SharePoint Engine at your fingertips!

5. Chapter 1 It’s Easy to get Started!

6. Getting Started with PowerShell

8. POSH vs the SP2010 Mgmt Shell

9. V2

10. PowerShell V3 ISE

11. Chapter 2 Learn the PowerShell Syntax!

12. Learn to use PowerShell with SharePoint!

13. Symbols, Keywords, and Syntax! Oh My!

14. Punctuation Pronunciation 1$#|

15. 1 Variables begin with a $

17. Commands are called cmdlets. • 2

19. The Power of Piping! • 3 |

20. Example

21. Making Comparisons • 4

22. Taking Control of the Flow • 5

23. Example

24. Where-Object • 6

25. Using the SharePoint API

26. Highlights from the SharePoint Object Model SPSite

27. Loading SharePoint 2010 Cmdlets C:\...\14\CONFIG\POWERSHELL\ Registration\SharePoint.ps1 [void][System.Reflection.Assembly]:: LoadWithPartialName("Microsoft.SharePoint") Loading SharePoint DLLs

28. Get a Site and Explore it! $site = get-spsite http://server/path THEN $site

30. Create a List Item

31. Practical Uses

32. More Practical Uses

33. A Word About Memory Management Dispose

35. Executing Scripts

36. Chapter 3 Real World Examples

37. Real World Examples • Check the Farm Version • Check Versioning on all document Libraries • Create List Items • Bulk Site Creation • Post Deployment Build Scripts with Audio Alerts

38. What’s your SP2010 Version? PS C:\Users\Administrator> $(get-SPFarm).BuildVersion Major Minor Build Revision ----- ----- ----- -------- 14 0 6109 5002

39. Check Doc Lib Versioning Settings function global:show-all-doclibs ($web) {$web.Lists | where-object {($_.Hidden -ne $true) -and ($_.BaseType -eq "DocumentLibrary")} } function global:show-all-doclib-versettings ($web) {show-all-doclibs ($web) |select-object -property Title, EnableVersioning, MajorVersionLimit, EnableMinorVersions,MajorWithMinorVersionsLimit,forceCheckout} $site = get-spsite “http://server/path” show-all-doclib-versettings $site.RootWeb

42. Bulk Site Creation Site Definitions in V. Studio PowerShell & Excel & UI Well suited for one time “blow in’s” Define the site template in the UI or use standard Save as a template Even pub sites PowerShell has easy loops Data driven from a CSV Changes -> Mod Scripts • Not an answer by themselves • Define site content • Intended for reuse • Mismatch to one time need • CAML and PITA • Harder: Making it data driven • Change Site Def -> Recreate Site

43. The PowerShell Solution • Read the list of sites from CSV • Loop: • Create Site • Configure Site • Turn on Features • Set Master Pages, Welcome Page • Hide Libraries, set versioning • Adjust Navigation • Add Lists, Libraries, Pages, Web parts, etc • Loop again & again if needed – iterative!

44. Audio Alerts • Stick this at the end of your long running script: $Voice = new-object -com SAPI.SpVoice$Voice.Speak(“Deployment is done!")

45. Chapter 3.1 Best Practices

46. Best Practices

48. Chapter 4 More Resources

49. Resources

50. Use a Decompiler to see MSFT’s Code! OR ILSpy.net dotPeek (jetbrains) justDecompile (Telerik) Reflector(RedGate) Others… No Longer Free