-
1. Re: How to find unnecessary data extracts those are refreshing on server on schedule but not in use on any of the reports / embedded on reports those are not accessed from long time.
Matt Coles
May 2, 2016 8:48 AM
1 of 1 people found this helpfulLuke Brady created a custom SQL query for this:
I built one of my own for this as well, but it's not as precise in that it checks views against a Workbook (which can have multiple extracts), rather than which extract is used in each view.
-
2. Re: How to find unnecessary data extracts those are refreshing on server on schedule but not in use on any of the reports / embedded on reports those are not accessed from long time.
Yep you can use my post Matt Coles linked above provided you have the usage tracking data from http_requests table saved off. I've attached a workbook with one of the Admin Views in it. It doesn't have CPU utilization.