Good question! The following will give you a list of active broadcasts, including the report name, frequency, etc. Please replace the text "youryellowfinDB" with the name of your database.
INNERJOIN reportbroadcast ON taskschedule.scheduleunitid=reportbroadcast.broadcastid
INNER JOIN reportheader ON reportbroadcast.reportid=reportheader.reportid
WHERE ScheduleSubjectCode = 'BROADCAST'
AND ScheduleIsOn = 1
If you need anything else, please let me know.
Hope you are having a good week.
Just touching base to see if the SQL query I sent earlier was able to give you the information you were looking for? Is there anything else I can help with on this?
It worked. thanks.
Glad to hear it. I will mark this as complete, but please let me know if you need anything further on this.
Comments have been locked on this page!