On our portal (Enterprise 2010) there are about 100 subsites (all in a single site collection), and there are form-libraries there where a user can fill out an infopath form and submit the data to a library on that same subsite.
My problem is that now the boss wants a summary of data from all the submitted forms - from one field in particular. I don't need the data to stay in sharepoint - I just need a spreadsheet summary that I can work with.
How can I get that? Powershell? I have admin rights everywhere.