I'd like to display a list of the most recently modified documents across all document libraries in a site in Sharepoint 2010. It seems that the Content Query webpart might do this for me, but the filter options seem to require me to specify an actual date (or relative date). Unfortunately some sites are more active than others, so for some sites recent might mean "this year" and for others it might mean "this week".
Create a view... Sort it by the Modified Date... Specify the item limit... You can even use filter for further more requirement...
Create new view, and modify the following settings sort : 1st column by modified, 2nd column by Modified by Folders: Show all items without folders Item Limit : reduce it to your requirement
I've used this back in the SP 2003/2007 days: http://smarttools.codeplex.com/wikipage?title=What%27s%20New&referringTitle=Home
I ended up writing my own SP2010 version which is very similar but uses the changelog to get the latest items for lists that are over the listviewthreshhold.