Query regarding Email Templates

[n1khil]

Hi Folks,

We have lots of email templates in our environment, is there any way to determine what email template is being used in what analytics/endpoints?

We wanted to do a cleanup for these, if we can utilize any table to achieve it then please let me know,

Thanks!

[Saathvik]

@n1khil : It's not that easy to track back. Especially when used in Workflows where you cannot simply query a table to get the data as this information is stored in xml format.

But giving few queries wherever it is possible 

For V2 Analytics: 

select analyticsname, emailtemplate from analyticsconfiges where emailtemplate is not null

For V1 Analytics:

select analyticsname, emailtemplate from analyticsconfig where emailtemplate is not null

For Endpoint Task Emails:

select ENDPOINTNAME, TASKEMAILTEMPLATES from endpoints where TASKEMAILTEMPLATES is not null -- Here data is in JSON format where you may have to do some manual work.

[rushikeshvartak]

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