Can I please get a query to see active broadcast report (excluding the reports which are paused)

shahul samad shared this question 4 years ago
Answered

Replies (4)

photo
1

Hi Shahul,


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.


SELECT *

FROM youryellowfinDB.[TaskSchedule]

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.


Cheers,

Neal

photo
1

Hi Shahul,


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?


Cheers,

Neal

photo
1

It worked. thanks.

photo
1

Hi Shahul,


Glad to hear it. I will mark this as complete, but please let me know if you need anything further on this.


Cheers,

Neal

Leave a Comment
 
Attach a file