The Audit Reports
The information captured by the discovery and assessment process is not limited to the fancy lists and pie charts in the detail pane. In fact a more extensive reporting is available in Excel file format. If you choose the Prepare New Reports and Proposals option from the File menu, you will be presented with the dialogue box below:
I am only interested about the database servers at this moment, so all options were cleared except Microsoft SQL Server Discovery. The next screen only gives us the option to finish. Once the Finish button is clicked, a progress bar shows the status of the report generation.
Once the report generation completes, you can click on the Close button on the status screen and choose Saved Reports and Proposals option under the View menu. This opens a Windows Explorer window. By default the files are saved under the My DocumentsMAP<database name> folder for your user profile. There will be one MS Word Proposal document and two MS Excel report documents. Each file will have a date time stamp in its name.
From an auditing point of view, the Excel files will be of interest to you. If you open the SQL Server Assessment Excel file, you will notice that it consists of three worksheets. The first worksheet gives a summarised picture, as shown below: