We are currently designing a where there are many sites, each site contains a list.
The list in each of these sites has the same fields.
We would like to create a report based on the information in these lists.
Is there a built in way to extract this information? Or do we just have to loop through each site and pull it out?