Ability to generate site report

Recently my manager asked me to create a spreadsheet showing every page on our site so we could do a site eval. As the generated sitemap only shows pages that are indexed, it is an incomplete record of all pages. I would like to be able to generate a site report that lists all pages in the domain, their status as indexed or not indexed, date published and date last edited.