I'm looking for a query to display a list of jobs stuck in queue (the past 7 days). Does anyone knows the query?
How about something like this to start with?
index=_internal sourcetype=splunkd log_level=WARN host=sh* component=DispatchManager "QUEUED" | stats count by host