I would like to find out dashboards which are not optimized and each panel is triggering the independent search and consuming all resources.
Is there a splunk search to identify the dashboard so that I can educate the users to use post process searches and optimize the dashboard and resource consumptions.
See if this helps.
index=_audit savedsearch_name=search*
| rex field=savedsearch_name "search(?<Count>\d+)"
| where Count > 5
| rex field=provenance "Dashboard:(?<dashboard>.*)"
| stats max(Count) by dashboard