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