List Modified System Workflow Msg Templates

list-custom-msg-tpl.sql

SELECT 
        og.name,
        ov.id, ov.name, ov.label
FROM
        civicrm_msg_template tpl
INNER JOIN
        civicrm_msg_template r -- reserved tpls
    ON         r.is_reserved = 1 AND r.is_default = 0 
        AND tpl.is_default = 1 AND tpl.is_reserved = 0 
    AND r.workflow_id = tpl.workflow_id
                LEFT JOIN
    civicrm_option_value ov ON tpl.workflow_id = ov.id
        LEFT JOIN
    civicrm_option_group og ON ov.option_group_id = og.id
WHERE
        tpl.is_active = 1
    AND ( tpl.msg_text != r.msg_text OR tpl.msg_html != r.msg_html OR tpl.msg_subject != r.msg_subject)
ORDER BY og.name, ov.id
;