By now you've had a couple of days to play with SP2. Hopefully the install went well. There's some new stuff in it that I want to show you. In this post I'll tell you about the new STSADM operations that are introduced. I did an "STSADM" on a box running SP1 and the Infrastructure Update (build 126.96.36.19918) and on a box running the hot off the presses SP2 (188.8.131.5221). There are six STSADM operations in SP2 that aren't there before. To make it fun, I'm going to list them in order of how excited I am about them.
#6 – variationsfixuptool
This operation alerts you to problems you might have with any variations like orphaned pages. It'll also force a variations timer job to run. You can find out more about it in this article on TechNet. I don't use variations much, so this operation while much needed, doesn't really get my motor running.
#5 – exportipfsadminobjects
Do you use Infopath a lot? Then this operation might be for you. It stands for EXPORT InfoPath Form Server ADMIN OBJECTS. I'm not entirely sure what this does, but it appears to backup forms and configuration that is uploaded to your farm. Unfortunately there isn't an associated IMPORTipfsadminobjects operation, so I'm not sure what to do with it. It sounds cool though. I'm an admin, I like backing stuff up.
#4 and #3 – setqueryprocessoroptions and listqueryprocessoroptions
I couldn't really split these two up, so they share an entry. These two options let you list and set five parameters of your search environment. The following settings are exposed: (blatantly stolen from 'stsadm –help setqueryprocessoroptions)
securitytrimmingcachesize <security trimming cache size>
securitytrimmingmultiplier <security trimming overfetch multiplier>
nearduplicatemultiplier <duplicate removal overfetch multiplier>
joinmultiplier <join discard overfetch multiplier>
sdidjoinmultiplier <missing security descriptor overfetch multiplier>
These settings are per SSP. Use listqueryprocessoroptions to see what your current settings are and use setqueryprocessoroptions to change them. Now that search is heavily integrated in WSS as well as MOSS, this is really handy. Descriptions of the settings can be found on TechNet.
#2 – enumallwebs
This little number is pretty cool. We already have an "enumwebs" operation. Why in the world would we need an "enumALLwebs" function, you might ask? Well, I'll tell you why. Before SP2 came around if we wanted a list of webs for a particular parent all we had was the enumwebs operation. Its major failing was that it didn't recurse. It only showed you the webs directly under the URL you gave it. It would not show you the subwebs of those webs. You only got one level. Enumallwebs gives you ALL the webs a given site collection. Heck, it gives you all the webs in a given database. It also gives you tasty nuggests like SiteIDs and WebIDs, Language and Site Template. I can't count the number of times I've gotten the question "How can I tell what template was used for a site?" Now I can answer with confidence "stsadm –o enumallwebs." You can find out more from TechNet.
Drum roll please…
#1 – preupgradecheck
The one we admins have all been waiting for, preupgradecheck. The one is worth the price of admission alone. Like its predecessor, prescan.exe, this operation walks through your farm and databases and alerts you to any problems you might encounter when it comes time to upgrade to SharePoint 2010. It supports external rule files, so you can tell it about any 3rd party software you've installed. It comes with a default rule file, so all you need to do is run "stsadm –o preupgradecheck" to see what it does. I have been assured that it makes no changes to your databases, so it's completely safe to run. I've run it on several of my systems and haven't found any indication otherwise. The official TechNet article gives a little more information. Hopefully time will permit me to write a whole blog post on it. There's a lot of cool things to see.
That's it. Those are the six new STSADM operations in SharePoint 2007 SP2. I'll be talking a little more in depth about SP2 in 8th weekly netcast. Be sure to check it out.