Location pages with a specific custom control, in the databa

Hello all.

I am currently in the process of migration to the latest version of Sitefinity and I believe I have a number of controls that are now redundant in my project. So for example, I have a control named "Deceased", using my SQL database, how would I find out how many pages reference this particular control?

e.g.

SELECT COUNT(DISTINCT Page) FROM tblPage
WHERE ControlName = "Deceased"

EDIT: Migrating from 3.7 (I've just noticed the databases are considerably different from 3.7 to 5 :) )

Any help or suggestions greatly appreciated.

Kind regards

If you don't have loads and loads of pages, then you could rename the control for a few seconds and see which pages go wrong. otherwise use full-text search on teh database to find where the control is stored, get its ID and then full-text search again through the entire database which will show you in which other tables it appears. from there you can then work it out. so there are two very down and dirty ways of doing it. Hope it helps.
Andrei