This custom query will return historical wait time data for the specified timeframe, and y default it shows data for the last 90 days while summarizing to a daily level. This is similar data to the chart in the upper left on the Home screen, but will allow you to see more than 10 days of information.
To run the query, login to the DPA repository with your favorite query tool like SSMS and execute it. To visualize it you can use Excel charts, PowerBI, SSRS or other charting tools.
The top 2 lines of this script can be modified to change how the data is displayed:
- @HistoryDays - the amount of history to show. Since the query uses hourly summary data, this can be set up to 90 days
- @HistoryType - how you want the data summarized, D=Daily, H=Hourly
Here is sample output of the query for daily data:
