Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 – Part 2

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:



Pages: 1 2 3 4 5

Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |