Export list of scheduled reports and recipients - How to ?

Mpumelelo Tsabedze shared this question 23 days ago
Answered

Good Day,


I would like to export the list of scheduled reports, interval and the recipients as well however not sure how to go about doing that.

Appreciate the help

Thanks

Mpumi

Comments (2)

photo
1

Hi Mpumi,

Thanks for reaching out to support with your question.

This information can be found in the Yellowfin configuration DB.

Here is a query that lists all broadcast task schedules -

select * from TaskSchedule where ScheduleSubjectCode = 'BROADCAST'

You can match broadcastid with scheduleunitid in the taskschedule table to get frequency -

select  scheduleunitid, frequencyunit, frequencytypecode from taskschedule
where schedulesubjectcode = 'BROADCAST'
you can join this to the reportbroadcastrecipient table to get the broadcasts' recipient list.


IPID here can be matched up with users via the ipclass or ipcontact tables.

Hope this helps!

Thanks,

Eric

photo
1

Hi Eric,


Tx for this - really helps a lot !

photo
photo
1

Hi Mpumi,

Thanks for the reply, glad to e of assistance here! I'll go ahead and mark this Question as Answered at this time.

Best,

Eric