Report with broadcast schedules

Renee Davis shared this question 4 months ago
Answered

I was asked to generate a list of all the reports being broadcast, with email addresses (staff who are getting the reports) with the schedules. Is there a way to do this without me having to open every report?

Comments (4)

photo
1

Hi Renee,

You can do this via SQL or use the tables/joins and columns below from the Yellowfin Configuration DB to build a View and create a Yellowfin Report as required. This in the mean time, should be able to give you what you need. It is to be run against the Yellowfin Configration table.

select RH.reportname AS "Report Name",

RB.broadcasttypecode AS "Type",

RB.requesttypecode AS "Code",

IPC.emailaddress AS "Email Address"

FROM reportbroadcast RB

INNER JOIN reportbroadcastrecipient RBC on (RB.broadcastid = RBC.broadcastid)

INNER JOIN ipcontact IPC on (RBC.recipientid = IPC.ipid)

INNER JOIN reportheader RH on (RB.reportid = RH.reportid)

WHERE broadcasttypecode = 'EMAIL';

If you need anything else of require further help, please let me know.

Thanks,

Paul

photo
1

This is going to save me a ton of time. Thank you so much.

photo
1

Hi Renee,

No problems. Glad to have helped. Please let me know if you need anything else or happy for this question to be closed off for now.

Thank you,

Paul

photo
1

Hi Renee,

I am going to close off this ticket for now, but if you need anything else, please get back to me.

Thank you,

Paul