Query to find out unknown broadcast scheduler
Answered
Hi Team,
We want to check how many broadcast are present in the system which do not have genuine scheduler and showing as Unknown. Please share DB query which we can run to find the details.
Below is the screenshot for reference.
Hi Sameer,
Report Broadcasts can be found in the reportbroadcast table. The highlighted "unknown" user value would be defined in the reportbroadcast.iplastmodifier field. Not sure how "unknown" user would show here.
It also looks like other fields are missing like time of day, next scheduled run... I would review the broadcast scheduler process in this case, there might be a web service call that needs adjustment.
Thanks,
Eric
Hi Sameer,
Report Broadcasts can be found in the reportbroadcast table. The highlighted "unknown" user value would be defined in the reportbroadcast.iplastmodifier field. Not sure how "unknown" user would show here.
It also looks like other fields are missing like time of day, next scheduled run... I would review the broadcast scheduler process in this case, there might be a web service call that needs adjustment.
Thanks,
Eric
Hi Sameer,
Just wanted to check in to make sure you had what you needed here.
Thanks,
Eric
Hi Sameer,
Just wanted to check in to make sure you had what you needed here.
Thanks,
Eric
Hi Eric,
Thank you for the assistance. Please close this ticket.
Regards,
Sameer
Hi Eric,
Thank you for the assistance. Please close this ticket.
Regards,
Sameer
Replies have been locked on this page!