Category
Administration
Product Version
8.0
Report broadcast history
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
The same question
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
Let me know if this helped or not! Will be happy to continue looking into this if this did not help!
Best Wishes,
Lesley
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
Let me know if this helped or not! Will be happy to continue looking into this if this did not help!
Best Wishes,
Lesley
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
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
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 -
Let me know if this has helped or not!
Best Wishes,
Lesley
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 -
Let me know if this has helped or not!
Best Wishes,
Lesley
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
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
Oh that is great news, Durgesh! :)
Please let me know if it is all correct once validated?
Best Wishes,
Lesley
Oh that is great news, Durgesh! :)
Please let me know if it is all correct once validated?
Best Wishes,
Lesley
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
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
Hello Lesley,
Yes we validated and everything is working fine as expected. we can close this thread.
Regards,
Durgesh
Hello Lesley,
Yes we validated and everything is working fine as expected. we can close this thread.
Regards,
Durgesh
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
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
Replies have been locked on this page!