Query to find out unknown broadcast scheduler

Sameer Patil shared this question 3 months ago
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.

/86297bb6ddfbe0c0baee70c53a3bb728

Comments (3)

photo
1

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

photo
1

Hi Sameer,

Just wanted to check in to make sure you had what you needed here.

Thanks,

Eric

photo
1

Hi Eric,

Thank you for the assistance. Please close this ticket.

Regards,

Sameer