Automating and Scripting SharePoint Administration

First off let me thank Todd Klindt, my good buddy who’s shown me the light on the fact that IT Pro geeks really get into STSADM and the fact that you can get good scores showing off the black command line screen for over an hour.
 
I’ve used a few of his slides as inspiration (plus a bit, thanks buddy) for my talk here in Teched South East Asia.  Wish he was here doing this himself.  Maybe next year.
 
Here’s my Teched SEA Automating SharePoint Administration with STSADM deck.  Click "cancel" if you get prompted.
 
For my Scripted Administration talk I divided it up into 3 main sections.  1) Understanding the command line SharePoint Tools and other cmd line tools, 2) Understanding the containment hierarchy and it’s relationship to the stsadm commands 3) Things you can only do in STSADM and STSADM Extensions and Powershell
 
SharePoint Command Line Tools (Scripted Deployment more in previous post.)
  • Setup.exe
    • Install bits
    • Use Answer file to provide needed details to automate.
  • Psconfig.exe
    • Create or Connect to config db
       Start or stop services
       Change server roles
  • STSAdm.exe
    • Create Web Apps
    • Create Site Collections and sites
    • Backup/Restore
    • Import/Export
    • Maintenance and management
Non SharePoint Command Line Tools
 
IISWeb – query/create/delete empty IIS Web Applications (IIS Web Sites)
 
IISApp – List application pools with process id and use to recycle
 
Copy/Xcopy/Robocopy – Copy and Manage files.  There are various ways to connect and bulk upload.  Bamboo solutions has some nice very cheap import tools.  Beyond this there are a ton of third party tools for migrating data into SharePoint from BinaryTree, Tzunami, Quest, AvePoint and on and on.  Don’t forget Excel and Access and interfaces for getting list data into SharePoint.
 
Containment Hierarchy Creation and Management with Cmline tools
 
Farm
      (Setup.exe and Psconfig.exe) Setconfigdb, AddSolution (for farm solutions/features and below)
Servers
      (Setup.exe and Psconfig.exe) setconfigDB, addServer
Web Applications
      extendVS, extendVSinfarm, createAdminVS, createSSP, addcontentDB, AddZoneUrl, Managepolicypermissionlevel
Databases
     createDATABASE, createSSP, setconfigDB,
Site Collections (Site, SPSite)
     CreateSITE, CreateSITEinnewdb, AddUser, AddGroup
 Sites (Web, SubWeb, SPWeb)
     createWEB
Lists
     (automate list creation through list and site templates) (or with STSADM extensions or Access or Excel to add entire custom lists)
Items
    (copy, xcopy, and robocopy can be used to add documents, use Excel and Access to insert or update items.)
Maintenance/Operations
 
Farm
   Quiesefarm, listlogginglevels, setlogginglevel, backuphistory
Servers
   renameServer
Web Applications
   preparetomove, unextendVS, addpath, editSSP
Databases
   DATABASErepair, preparetomove, AddContentDB
Site Collections (Site, SPSite)
   CreateSITE, CreateSITEinnewdb, GetSITElock, enumSITES
Sites (Web, SubWeb, SPWeb)
   createWEB, renameWeb, enumSUBWEBS
Lists
   forcedeleteLIST
Items
   blockedFILElist
 
Advanced Cmdline Admin
 
STSADM Extensions – Gary Lapoint’s STSADM extensions are the most verbose list of extensions anywhere.  Tons of em.  My favorite… Createsiteindb (create site collection in existing database without all that unnecessary jumping around.)
 
Powershell – There are lots of powershell references out there now.  There’s one codeplex community project at http://www.codeplex.com/pssharepoint  and Darrin Bishop (blog) did a session at TechEd called "ehancing automation with SharePoint" that I recommend.  There are quite a few other powershell projects on codeplex.
 
Caution: All those dispose concerns you might have heard about in development applies to anything you’re doing in Powershell.  There can be common mistakes with not properly disposing when walking the site tree.
 
Also check out SP1 and the Infrastructure update and future updates to include additional things… such as MergeContentdbs the most useful STSADM command for managing your databases.  You might not have heard of a SharePoint Admin Toolkit built by Microsoft.  The Move, Lock, and Delete in Batch in a web UI is very nice.
 
Other SharePoint Admin Tools should also be considered if you’re having manageability issues.  There is a lot of good work being done by third parties to make admin easier.
 
Additional References
 

TechNet STSADM Reference and Poster

Minsharp STSADM References (premium content) Mindsharp.com

Todd Klindt MVP blog

Ben Curry’s “SharePoint Admin Companion” (MS Press Book)

Gary Lapoint’s STSADM extensions

Published by

Joel Oleson

I LOVE traveling our little planet. In my quest to visit every country in the world I've got about 35 UN countries left! I'm not just country hopping, but looking for the most immersive cultural experiences and capturing them as photos and videos. Yes, I'm also a geek. I've been recognized as a Microsoft Regional Director, a community leadership award. When not traveling, I'm in paradise in sunny southern California as I'm a Senior IT Manager at Blizzard Entertainment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s