Exporting SQL Server 2008 R2 Activity Monitor Log
Well you can (on a dev system of course) run a trace against yourself running activity monitor and then isolate the queries you want to use for monitoring.  Then you could either create custom jobs or use custom collectors with management data warehouse to execute those queries on your desired schedule to log the activity you want to another table.  Then you can just analyze the results there.