Rae-Jin Shui (1/16/2013)

---

How about...

1. create a table with the columns based on your query.

2. create sql statement so it inserts into the table from your query but include a loop to run the query x number of times

3. set it up as a job to run e.g. every 10 minutes

4. and don't forget to create a data purge on the table

You can then query the table or design a report to pull up any blocks over time.