...
While tuning the ImportAmalgamate the following sql can be used. Please enable the appropriate 7 day condition on creationTime for your database flavour to see what Tasks have been produced over the last week with external historical timeseries. Also the AdminInterface database trend information page can be very useful for this purpose.
...