Approaches to create a dashboard-liked page on a site collection level, that shows items from the site collection' subsites

Question

I have a Team site collection which contain 10 sub-sites, and all these sub sites were created using the same site template. Each sub site have the following 3 lists:-

• Issue tracking list named IssueA.
• Issue tracking list named IssueB.
• A calendar named Calendar.

Now currently end users are facing problems in keeping track of the sub sites' lists. so for example if someone wants to know the pending items assign to him, then he have to go to each subsite , check the related list… which is not very reliable.so I want to know what are the approaches I can follow to create a page on the site collection level that summarize the lists items from all the subsites , for example to have the following :-

• On the site collection home page to view all the items inside IssueA list from all the subsites, that are pending and assign to the login user? So from there the login user can know that there is a pending item assigned to him on subsite ABC ,, without having to check all the subsites’ lists to get this info ?

So can anyone advice how I can do so in sharepoint ?

Answer 1

If each of the lists is based upon their own custom content type (e.g. a custom Issue Tracking Content Type) you can use the Content Query Web Part to roll up your lists.

You can make a Content Type for your Calendars (use the Calendar Item as the parent for this content type) to roll up Calendar lists too.

If they are not based upon a custom content type, you could also use a Content Search Web Part (probably Items Matching a Tag) to look for items where the path contains the Name of your Lists.

You should probably use custom content types in this scenario so you can easily update columns in your lists at the Content Type level, rather than on a list by list basis.