Identity Manager

How to query for processes that use a particular Mail Template?

 I have set up a bunch of Process Chains that do various things, one of which is sending rich mails. I now need to make a minor adjustment to all processes that reference a particular Mail Template. I could click through each Rich Mail Process step to find them but there are alot of them. I looked in the tables to see where the process step parameters may be held so I can query the database to see which process steps I need to update but I couldn't find a table that stored that information. Are process step parameters stored in a table somewhere? 

No Data
  • Christain is right about the fact that there is often no direct relation between the mail template and the process.

    But you can use the following SQL to identify all MAILID parameters including the content of the value template.

    SELECT jc.Name, j.Name, jrp.UID_JobParameter, jrp.ValueTemplate FROM dbo.JobRunParameter jrp	
    JOIN Job j ON jrp.UID_Job = j.UID_Job
    JOIN dbo.JobChain jc ON j.UID_JobChain = jc.UID_JobChain	
    JOIN dbo.JobTask jt	ON jt.UID_JobTask = j.UID_JobTask   
    WHERE   jt.TaskName	 = 'SendRichMail' and jrp.Name ='MailId'

No Data