Posts

Showing posts with the label Missing Web Parts

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