MAP - Application To Machine Correlation Report

This quick blogpost covers using Microsoft Excel to present data from a Microsoft Assessment And Planning Toolkit (MAP) database in a way that allows you to show which computers have what software installed.

If you do not have MAP installed/ inventory gathered you can follow my previous post here if you wish.

This is a really quick and simple thing to do if you have Office installed on the same host as MAP, and as I have MAP on my local machine and just import the databases I collect this is great for me :)

Firstly open an elevated instance of Excel then click Data->From Other Sources->From Data Connection Wizard

Select Microsoft SQL Server in the box that appears then press Next

In the server name box enter LOCALHOST\SQLEXPRESS

Once the list of views are displayed scroll down and select InstalledProducts_View, press Next and then Finish

The next box that appears allows you to add a pivot table if you wish, once done press OK

Voila! your data to manipulate as you wish

Cheers

EDIT: For MAP 8 you will need to connect to (localdb)\Maptoolkit