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? • Sr. Consultant @ Magenic (MSFT Gold Partner) • 16+ years in IT Consulting • 9 years working with SharePoint • MCITP: SharePoint 2010; MCTS: WSS Dev • MCTS: MOSS Config & MCTS: WSS Config • MCAD, MCSE, MCDBA, CAPM, INETA Champ

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

10. Chapter 2 Learn the PowerShell Syntax!

11. Learn to use PowerShell with SharePoint!

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

13. Punctuation Pronunciation Is “$#|” a “one dollar hash pipe”?

14. 1 Variables begin with a $

16. Commands are called cmdlets. • 2

18. The Power of Piping! • 3 |

19. Example

20. Making Comparisons • 4

21. Taking Control of the Flow • 5

22. Example

23. Where-Object • 6

24. Using the SharePoint API

25. Highlights from the SharePoint Object Model SPSite

26. Loading SharePoint DLLs [void][System.Reflection.Assembly]:: LoadWithPartialName("Microsoft.SharePoint")

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

29. Create a List Item

30. Practical Uses

31. More Practical Uses

32. A Word About Memory Management Dispose

34. Executing Scripts

35. Chapter 3 Real World Examples

36. Real World Examples • Check the Farm Version • Check Versioning on all document Libraries • Create List Items • Export Web App Properties to a file • Bulk Site Creation

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

38. 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

40. Clear a List • Make a mess: • Clean it up!

43. 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

44. 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!

45. Chapter 4 More Resources

46. Resources

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