Report to fetch all the email templates used in IDM

[Olesia]

Hi!

We would like to create a report to fetch all the email templates used in IDM.

I was able to fetch data from rules (hanaruleattribute.OBJECTVALUE), analytics (analyticsconfiges.EMAILTEMPLATE), externalconnection and endpoints (endpoints.TASKEMAILTEMPLATES).

Now I am particularly interested in workflows but I could not find respective tables.

Where else email templates could be used?

Do you have a similar report or maybe know tables which we can use for this report?

[smitg]

Hi @Olesia,

You can fetch all email templates from - ecmemailtemplate table

[Olesia]

Hi,

thanks Smitg,

but I need the usage of the email templates, i.e. where a certain template is used, like this: