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 accessed by WMI because MAP will use this technology to connect and collect information from servers.

Technet resources: https://technet.microsoft.com/library/bb977556.aspx

Download Microsoft Assessment and Planning Toolkit: https://technet.microsoft.com/en-us/solutionaccelerators/dd537566.aspx

Installation

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

MAP1

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

MAP3

Inventory

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

MAP4

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

MAP5

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

MAP6

MAP7

MAP8

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

MAP9

MAP10

Add IP range if this is selected.

MAP11

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.

MAP13

Put the credentials in the order they should be used.

MAP14

MAP15

Click “Finish” to start the inventory.

MAP16

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.

MAP17

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.

MAP18

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.

MAP19

0

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.

 

0