cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

how to exract info regarding report schedulling for users

taral_parekh
Participant

Hi,

 

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?

3 REPLIES 3

adam_piotrowicz
Dynatrace Pro
Dynatrace Pro

Check https://<yourCAS>/EmailSchedule?_callUrl=menu_tools_emailsched URL used for this purpose in 12.X CASes.

taral_parekh
Participant

Thanks Adam.

It worked. Any way to get this info from DB by running query or anyway to exract this info in spreadsheet or document?

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.