How I can check if email template is used or not? from analytic or other way

[Dalalsaleh888]

How I can check if email template is used or not? from analytic or other way.

I want to clean up our email templates, is there a way we can perform this efficiently?  

[rushikeshvartak]

Use below query 

select 'Analytics v2' category,analyticsname as name, emailtemplate from analyticsconfiges where length(emailtemplate) !=0 and status =1
union
select 'Analytics v1' category, analyticsname as name, emailtemplate from analyticsconfig where length(emailtemplate) !=0 and status =1
union
select 'Endpoint' category,ENDPOINTNAME as name, TASKEMAILTEMPLATES as emailtemplate from endpoints where length(TASKEMAILTEMPLATES ) !=0 and status =1

[Dalalsaleh888]

is this will also detect the email template in workflows?

[rushikeshvartak]

No workflow you need to do manually 

[dgandhi]

Do you want to find a particular email template say "XYZ" is used anywhere in the system?

[Dalalsaleh888]

no I want to check with all email template in the system.. we have around 300+