Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/19/2024 06:55 AM
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?
08/19/2024 08:29 AM
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
08/20/2024 12:47 AM
is this will also detect the email template in workflows?
08/20/2024 05:00 AM
No workflow you need to do manually
08/19/2024 10:43 AM
Do you want to find a particular email template say "XYZ" is used anywhere in the system?
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.
08/20/2024 12:48 AM
no I want to check with all email template in the system.. we have around 300+