Active Document Composition Templates

[Mike_Kroner1]

Hello,

How can I go about to find which document composition templates are being used in workflows.  I am looking for a SQL query which would show me this information. 

Workflow Action: Compose Document

Use specified template: XXXXXXXX

The underlined part is really what I am looking for.   Bonus If I can get the lifecycle, queue, and template that would be the cherry on top.

Thanks in advance,

Mike

Stay safe

[Larissa_Armand]

Larissa, Is there a way to find out the counts of documents that went through that queue between a date range? we are trying to get a high level view on volume count on each action type. Thanks for your help, Mike

You could combine aspects of @Dean Johnson 's query from WFLOG with the date range. You could also query from workflow transaction history if you have "log execution" enabled on the actions that are composing documents.