Is it possible to list all the content that was added to a site in a date range? E.g. show me all content added yesterday.

This is for MOSS 2007.


You can use Content Query Web Part to display eg. all documents in entire site collection based on custom filter/query.

To use time span as filter take a look at this links (both links for 2010 but it's same as in 2007):

You will encounter some issues if your goal is to combine different content types (eg. mix list items with documents). Also customization is sometimes tricky but there are tons of examples out there eg. Customizing the Content Query Web Part and Custom Item Styles


Some extra links regarding Today issue in 2007:

| improve this answer | |
  • Im happy customising CQWP and DVWP, and had considered this. I Wasnt sure how much of a negative impact it would have if it was looking at every single item that exists on the site. – dmce Oct 3 '11 at 12:10
  • You need to be careful when running queries against whole site collection (performance issue). IMO using it for aggregation of just one content type and with time span filter should be ok. However it really depends on your specific requirements and amount of data you are querying. There is no other or better solution - even if you develop custom web part you will again face same problems with speed, performance... If you have 'tons of items' you can use one CQWP per site (or some other kind of grouping like for several sub sites) and not just one CQWP for entire site collection. – Vedran Rasol Oct 3 '11 at 12:55
  • Your links are specific to 2010 Verdan. The problem with the CQWP in 2007 is that (as far as im aware) you cannot filter by [Today]-1 for example. I cannot create calculated columns on every list/library. – dmce Oct 5 '11 at 8:56
  • Sorry, since I didn't do any serious work on 2007 for year or even more and I forgot most of it :) I have included some more info in my answer - hope it helps. Btw if someone presented me this request I would instantly start developing custom web part with SPSiteDataQuery – Vedran Rasol Oct 5 '11 at 9:19

I create web part page, and make a dashboard out of it. I set each list to display with anything that's been modified in the last 7 days.

| improve this answer | |
  • This sounds like you are using dashboard webparts to query specific lists. This wont work for me as the business are unable to specify which lists they want to look at, so it need to be everything. – dmce Oct 5 '11 at 8:54
  • There is also a "What's New" web part that does something similar. that should be "out of the box", but once again you need to know the lists. – Bryan Smith Oct 5 '11 at 11:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.