I'm trying to produce a report from the Audit Store of all emails issued by Cognos, the recipients and the report name emailed. IBM has provided some code but it only works correctly when its for an individual report.  It includes reports run from Job steps and then it goes a bit stupid as it doesnt join to the job tables.  I need some correct code (1) for reports/report views executed directly (no jobs) (2) reports run as job steps

Has anyone got anything that would fit the bill and save me reinventing the wheel?

I should have added that this is Cognos Cloud, 12.04