Register
Home   Ask Question Discuss Purchase Submit Events Give Solutions Share News
Automobiles Beauty & Styles Business Computers & Internet Sports Travel Consumer Electronics Education Entertainment & Music Family Society & Culture Food & Drinks Health
Computer Networking
Hardware
Internet
Programming & Design
Security
Software
Other - Computers
How to find missing web part in Sharepoint
-->

Issue: How to find missing web part. Very oftern when you run test-spcontentdatabase command in SharePoint you get Id of missing web part. And you want to know which page that web part is activated/installed.

Solution: Please run the below query on SharePoint database that you tested in test-spcontentdatabase

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] = '55ccbd0e-aaeb-2484-688c-5cd22dacff86'

ORDER BY Url

---------------------------------------------------------------------

Replace the web part if in red above to your web part id that you got in test-spcontentdatabase

--
Bookmark and Share
Related Posts
Comments
Commented By: Gaurav On: 06-09-2014

Here is the solution. Visit this blog & download the utility

http://learn-sharepoint-2013.blogspot.in/2014/09/find-missing-web-part.html

Gaurav Goyal

Add Comment
Name*
Email*
Comment*
Hot Categories: India Women's Health Singles & Dating Tennis Corporations Television Movies Computer Networking
Contact Us About Us Privacy Policy Copyright Sitemap