How to pull an email analysis which includes the email footer name?

I'd like to build an analysis of which email footers are in use, and potentially by which teams and the amount of use, so i can do some clean up. Has anyone had success in putting together such a report.