Salesforce Email Templates & Attachments

This morning I needed to understand what attachments are included with each Email Template. I looked at answering the problem using the Salesforce GUI -- no luck.  I though about doing via SOQL using https://workbench.developerforce.com but knew that SOQL could not represent the query directly.

In the end I answered the question with a short SQL query against my hot backup of Salesforce in SQL/Server.

SELECT EMAIL.name, FOLDER.name, ATT.name
FROM  EmailTemplate EMAIL JOIN Folder FOLDER ON EMAIL.folderId=FOLDER.id
JOIN Attachment ATT ON EMAIL.id=ATT.parentId
WHERE FOLDER.name = 'License Keys' and isActive=1 and ATT.name LIKE 'Confidential%'

It gave me exactly what I wanted.

Email Template Name	Folder	Attachment Name
Confidential API Float	License Keys	Confidential Float API Activation.pdf
Confidential JMS Float	License Keys	Confidential Float JMS Activation.pdf
Confidential NLME Float	License Keys	Confidential Float Software Activation.pdf
Legacy Confidential Float	License Keys	Confidential Float Software Activation.pdf
etc.

A backup is always a good idea...Especially when it save me time.