It is a huge problem for us to quickly identify the SubscriptionID
when user forwards an email generated by Subscription (built-in, not DDS).
With your query it becomes a lot easier.
Do you know if it's possible to retrieve SubscriptionID at the time of Subscription execution?
It would be so nice to have let's say an Email Subject like:
"Report: Global Derivatives - Risk Summary; SubsID='267DF775-59C9-40DA-A173-06106AD89110'