We are using SP2016 on-premise. We have a site collection with over 50 subsites under it. All the subsites are created with same Site template. Therefore all of them have a list called "ContactInfo".(https://sharepoint.com/sites/ABC/project1/Lists/ContactInfo) All the ContactInfo have same fields but they do not have specific content type.
I need to create a report using Report builder 2016 and SSRS (native mode) to list all the contact information across all the subsites. Could you advise is it possible achieved by CAML? If so could you provide some reference? Thanks.