Michael Schau

My SharePoint Blog

PreUpgradeCheck: Missing webparts

Some of the issues in a Pre-Upgrade Check Report are straight forward to fix, but what do you do about this one? “Issue : Missing server file or server configuration issues


In a site collection with thousands of sites, it is not an option to manually track down these obsolete webparts. So I wrote a SQL statement to identify the sites/pages. This statement is for the webpart with the Id ‘34febc2f-1526-47d8-d72a-7b992ac65a7d’.

SELECT [AllDocs].*
FROM [WSS_Content].[dbo].[AllDocs] INNER JOIN [WSS_Content].[dbo].[WebParts]
ON [AllDocs].Id = [WebParts].[tp_PageUrlID]
WHERE [WebParts].[tp_WebPartTypeId] = '34febc2f-1526-47d8-d72a-7b992ac65a7d'

Now you have a nice list of the pages where you need to remove the webpart.


Go to the Web Part Page Maintenance (<url>?contents=1) and delete the webpart.


Comments (1) -

  • Bharathesh Murthy

    2/14/2012 6:48:30 PM | Reply

    thanks your Query helped us a lot

    Regards - Bharathesh