I have CAS 11.7/1 with more than 100 users defined along with their email ids, purely for reporting purpose. These users do not log into CAS. They only get monthly reports, staggered throughtout months to avoid load on CAS.
Is there anyway to run a qurery to find out which users has what reports scheduled and what date/time please?
There you go:
select ulogin,name,period, startTime, lastSentTime from emailreports E
join wslastused U on E.userid=U.row_id
join lsentry R on R.row_id=E.requestid
Run it as delta, otherwise prefix all tables with delta.