New Topic

Yellowfin Support Team

Assigned

Category Broadcast & Report Export

Product Version 8.0

Export list of scheduled reports and recipients - How to ?

Mpumelelo Tsabedze shared this question 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

Replies (2)

Eric Hagfors ●

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

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

Reply URL

Mpumelelo Tsabedze ●

Hi Eric,

Tx for this - really helps a lot !

URL

Eric Hagfors ●

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

Reply URL