VERIFIED SOLUTION i

Listing templates with associated delivery options, delivery channels and devices imported in EngageOne Server

Following DB query executed on EngageOne repository, lists all the templates together with their delivery options, delivery channels and devices imported in EngageOne Server:
 
select a.FR_Name as templateName, d.DELIVERY_OPTION_NAME, e.DELIVERY_CHANNEL_NAME, f.DEVICE_NAME, f.Device_Identifier, f.TYPE
from Doc_Resources a, OCM_TEMPLATE b, OCM_TEMPLATE_DELIVERY_OPTION c, OCM_DELIVERY_OPTION d, OCM_DELIVERY_CHANNEL e, OCM_DEVICE f
where a.Doc_Resource_ID = b.RESOURCE_ID
and b.RESOURCE_ID = c.TEMPLATE_ID
and c.DELIVERY_OPTION_ID = d.DELIVERY_OPTION_ID
and d.DELIVERY_CHANNEL_ID = e.DELIVERY_CHANNEL_ID
and e.DEVICE_ID = f.DEVICE_ID
and a.Domain_ID = (select Domain_ID from System_Domain where Domain_Name = '<your_domain_name>')
and a.Template_Flag = 1


Note:- Replace <your_domain_name> with the proper domain name before the query is executed.
UPDATED:  September 19, 2018