Report broadcast history

Durgesh Mange shared this question 4 months ago
Answered

Hello Team,

Is there any way to see the history of broadcast ran on Particular report as schedule Management console only show last ran of the report.


I would like to develop a admin report where we can provide the report name, broadcast name or subject and timeframe to fetch the status of the report broadcast(failed, success).


can you please help me with the details which table need to refer and its relationship.


Regards,

Durgesh

Comments (8)

photo
1

Hey Durgesh,

I hope you are well!

You will need the Event Code, Event Type Code and Event Date from the Event Table and then the Name from the Report table..To narrow down the results for broadcasts, you may also want to add Event Code to the Filters section and define the value to Report Broadcast, or to the values of your choosing -

Here is my Example below

ddad37df5dccfe0dacb27037f9766080


3350872767db50ed3f3e2a1ee8824ae3


Let me know if this helped or not! Will be happy to continue looking into this if this did not help!

Best Wishes,

Lesley

photo
1

Hello Lesley,


thank you for the details, However how can we get the broadcast details(like broadcast timestamp and its status). looks like reportbroadcasrresult table holds only latest data?


can you please help.

We have below requirement.

create a report where we can findout broadcast status based on report name. for example report "ABC" is schedule to run every hour so we would like to know status of each and every broadcast since it was created.


Regards,

Durgesh

photo
1

Hi Durgesh,

I believe you will be able to use the ReportBroadcastResult table - My records in my DB show all results from when I set up the broadcast - If you were to set a time filter on the report for the year - this may help narrow down results -

Please see my screenshot below for the ReportBroadcastResult Table -


c420ebe679308a7d44e723815965294c


Let me know if this has helped or not!

Best Wishes,

Lesley

photo
1

Hello Lesley,


yes you are correct. I have created a report with with join of report Header --> Report Broadcast --> Report Broadcast result table.


and data seem like returning correct results. validating data now.


Regards,

Durgesh

photo
1

Oh that is great news, Durgesh! :)

Please let me know if it is all correct once validated?

Best Wishes,

Lesley

photo
1

Hey Durgesh,

I hope you are keeping well and safe!

I just wanted to check in to see if everything was validated and all is returning the correct results? :)

Let me know!

Best Wishes,

Lesley

photo
1

Hello Lesley,


Yes we validated and everything is working fine as expected. we can close this thread.


Regards,

Durgesh

photo
1

Hey Durgesh,

That is wonderful news! Im pleased this helped and worked for you :)

I will mark this ticket as complete now, but if you have any further questions, please let me know! I will be happy to help.

Enjoy your weekend and stay safe!

Best Wishes,

Lesley