Archive | Application

Use Microsoft Assessment and Planning Toolkit to do inventory of the Windows servers

In this post I will show how to do inventory of servers with the tool Microsoft Assessment and Planning Toolkit (MAP). To be able to do this the servers needs to be accessible by WMI because MAP will use this technology to connect and collect information from servers.

Technet resources:

Download Microsoft Assessment and Planning Toolkit:


The installation is very strait forward and can be ran directly on a server. Just run the installation executable and follow the wizard.


When the installation is done, create a database to store the data that is going to be collected.



To start doing inventory on the servers, click Server on the left side of the application.


Then click “Collect inventory data”. This will bring up a wizard. To do inventory of Windows computers checkbox “Windows computers” and click next.


Choose how you want to discover the servers to get the inventory from.




To do inventory with “Windows Networking Protocols” one need to have started “Computer Browser” service. This service is disabled by default.



Add IP range if this is selected.


At the ”All Computers Credentials” hit enter if the dialog below don’t show up. Add the accounts needed. For example different accounts that have access to enter different servers.


Put the credentials in the order they should be used.



Click “Finish” to start the inventory.


When the inventory is done the status is published in the dashboard. To get a report click on the dashboard, in my example I clicked “Windows Server 2012 R2” and then “Generate Windows Server 2012 R2 Report” to get an Excel report.



In the Excel report there are a lot of information regarding the servers. The information is divided in different Sheets in Excel. Below is a summary of what is covered in the report.

  • Windows Server 2012 R2 Assessment Summary
  • System Requirements Used in the Assessment
  • Assessment Results for Servers
  • Server Role Assessment Summary for Windows Server 2012 R2
  • Discovered Applications
  • Device Summary
  • Device Details
  • Inventory Results for All Windows Servers

Inventory Results in the Excel Sheet “Inventory Results for All Windows Servers”

Below is a screenshot of inventory results regarding the servers that is inventoried.


More information that are included in the report.

  • Computer Name
  • WMI Status
  • Machine Type
  • Current Windows Server 2012 R2 Readiness
  • Installed Roles
  • Computer Model
  • Current Operating System
  • Service Pack Level
  • Active Network Adapter
  • IP Address
  • MAC Address
  • DNS Server
  • Subnet Mask
  • WINS Server
  • Registered User Name
  • Domain/Workgroup
  • Number of Processors
  • Number of Cores
  • Number of Logical Processors
  • CPU
  • System Memory (MB)
  • Video Card
  • Video Card Memory (MB)
  • Sound Card
  • Disk Drive
  • Disk Drive Size (GB)
  • Optical Drive
  • BIOS
  • BIOS Serial Number
  • BIOS Manufacturer
  • BIOS Release Date

Inventory Results in the Excel Sheet “Discovered Applications”

Below is a screenshot of the inventoried applications.



Execute MSI with PowerShell and return the MSI exit code

I had the need to execute a MSI and get the script to return the exit code for a MSI installation. This is the script that I came up with.