SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have OOTB "task lists" in many sites used by the same set of users.

We have a farm with "x" site collections and "x" sites with-in them without any changes to the default content type.

We would like to roll up the pending tasks and show it in a single web part placed in default portal page.

What would be best way to do this task rollup when we have multiple site collections.

Other Details: Security is driven by AD groups placed in SP groups.

share|improve this question
up vote 10 down vote accepted

You should use Search for this task - it's the fastest and most efficient way. Only downside is a slight update delay (until it's incrementally indexed agina).

share|improve this answer
we've had the same requirements and we also preferred search option. although it's relevant to STD or ENT versions - not sure Foundation can support it – Ivan Padabed Apr 11 '11 at 11:24

There are a few products in the market that currently do this, for example Lightning Conductor by Lightning Tools: This tool (I think) can even rollup across web applications too.

share|improve this answer

There are different choices:

  1. Search - not percise
  2. Cycle over site collections with SPSiteDataQuery
  3. Pre-aggregation to root site in each site collection with cycle over site collections

Main problem in query over sitecollection - each site collectiom can be in different Content Database, witch can be on a different server.

share|improve this answer

Im on the search wagon here.

A way of avoiding the the indexing delay, you could build your own custom federated search web part that looks at SharePoint through the API (SPSiteDataQuery)

share|improve this answer

Here is a Good free Option with some configurabiity:

SharePoint User Toolkit: Tasks Lists Roll-up for SharePoint 2010

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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