Find all locations where a web part has been used?

Shannon Dunn asked on July 29, 2015 19:17

Is there a quick way to find out where a web part is being used in all page templates? I am assuming this something that can be found in SQL but no idea where to start looking. Ideally web parts should have a way to find out like Page Templates usage can be found in the "Documents" tab when looking at a Page Template.

web part

Recent Answers

Roman Hutnyk answered on July 29, 2015 20:32

Search [PageTemplateWebParts] field of [CMS_PageTemplate] table - this will give you the list of templates those include particular web part. Review Documents tab of each template to get all the documents, or select tree nodes those use that template in the database.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on July 29, 2015 22:11

There is no way of doing this within the UI. What Roman suggests is probably the best place to start. You will have to do some fun SQL work but you can get it with that.

0 votesVote for this answer Mark as a Correct answer