The repository is not documented sorry but it should be possible to get information from the following three views.
The function utils.TicksToDateTime() can be used to filter by date. Using something like this:
- Code: Select all
WHERE utils.TicksToDateTime(data.Cluster_SqlServer_TopQueries_Instances_View.IdCollectionDate) > DATEADD(day, -7, GETDATE())
It might take a bit of experimentation to get this working.