How to find missing web part?


To find missing web parts in SharePoint we have many ways. Here I am going to show you 2 ways.

  • With use of STSADM command :
               stsadm.exe -o enumallwebs -includewebparts > c:\bkup\aa.txt  
             This command will send the output in “C:\bkup\aa.txt:” file & where you can find “Status="Missing Type”. Basically this file will contain data in xml format & you will get information about the all sites you have with url & id.

  • With use of SQL statement :
a.       Use [WSS_Content]
b.      SELECT SiteId, AllDocs.DirName as SiteUrl,AllDocs.LeafName as PageUrl, AllDocs.DirName + '/' + AllDocs.LeafName as Url, WebParts.tp_DisplayName as DisplayName FROM [dbo].[AllDocs] INNER JOIN [dbo].[WebParts] ON [AllDocs].Id = [WebParts].[tp_PageUrlID] WHERE [WebParts].[tp_WebPartTypeId] = '8d6034c4-a416-e535-281a-6b714894e1aa'ORDER BY Url
'8d6034c4-a416-e535-281a-6b714894e1aa’ this is missing web part id. Just replace this id with your id


Comments

Popular Posts

SharePoint Interview Questions and Answers

Download Infopath Form Templates

How to get current logged user information using JavaScript ?

Steps to set Form based authentication (FBA) for SharePoint 2010

SharePoint Interview Questions and Answers II

Get List Items - JavaScript

Change Language for current user with JSOM in SharePoint Online

Cross Site List Rollup Web Part for SharePoint 2010

Hide Recently Modified Items

SharePoint 2010 CSS Chart