SharePoint 2007 Upgrade – Identifying Customizations
During an upgrade from SharePoint 2007 to 2010, knowing where custom webparts and features are deployed can be useful for targeted testing and mitigation. Here's is some TSQL to help identify where those sites are.
First, from SharePoint 2007, execute the PowerShell:
ststadm -o enumallwebs -includewebparts -includefeatures -databasename WSS_Content_YourDBName > sp2007EnumWebsOutput.txt
This command essentially lists every web in your database and the features and webparts it's using. Compare that list with a known list of out-of-box (OOB) features and the deltas will be the customizations. I wrapped that up into a TSQL command the creates a nice pivot table with webs and customizations. To use it, copy the sp2007EnumWebsOut.txt to an instance of SQL Server and execute the attached TSQL (attached). The result with be 3 SQL Results with the source of the features listed (OOB, Fab40 or Custom). Copy and paste those to Excel and you can do whatever filtering and sorting you need to identify the sites.