...
Another way to do so is to provide guidance to users so that as they consider how to upload resources, we steer them towards a particular technological solution that is helpful to us eg. Google spreadsheet with update trigger, document alerts in OneDrive for Business, macro in Excel spreadsheet. I don't know if this is possible, but complete automation would be if they could click something in HDX that creates a resource pointing to a spreadsheet in Google Drive with the trigger set up that opens automatically once they enter their Google credentials.
Approach
a) determine the scope of our problem by calculating how many datasets are locally and externally hosted. Hopefully we can use the HDX to calculate this number.
b) Collect frequency of updates based on interns work
c) Define the age of datasets by calculating: Today's date- last_modified
d) Compare age with frequency and define the logic: how do we define an outdated dataset
Number of Files Locally and Externally Hosted
...