Automate Reports or Work Item Queries
Accepted answer
You can run queries in automation e.g. use the JBE for it. See https://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/
You can also run scheduled tasks on the server see: http://jorgediazblog.wordpress.com/2013/06/28/rtc-custom-scheduled-async-task-example-explained/
On the server there is the mailer service that you can use to send mails.
You can also run scheduled tasks on the server see: http://jorgediazblog.wordpress.com/2013/06/28/rtc-custom-scheduled-async-task-example-explained/
On the server there is the mailer service that you can use to send mails.
One other answer
We do this using the Java APIs on a scheduled task on a separate Windows-based server (since running them on the RTC server itself is problematic for us since we have our CLM hosted by another team). In some cases, it sends email (using just javamail and an smtp server) and others generate HTML reports that can then be viewed by others.