Another one… Use this for daily SSRS subscriptions because I’m too lazy to log into the server to check. Plus there’s no aggregation available on the product..
SELECT convert(date,CreatedOn, 1), CM_NAME as 'Triggered Email Name', COUNT(cm_triggeredemailid) as 'Total Triggered'
WHERE CreatedOn >= getDate() - 1
group by CM_NAME, convert(date,CreatedOn, 1)
order by 1 desc