Thursday, March 26, 2015

Running MAP Toolkit for SQL and Exchange Server related reporting.

 

MAP toolkit is pretty impressive tool set from Microsoft and it is free. You can perform real simple application related queries ( SQL,Exchange Server ,Oracle ,Desktop,Virtualization etc.) and produce powerful and useful information for the given environment. The MAP toolkit helps increase the agility and cost effectiveness of deploying the latest Microsoft technologies and it provides pretty comprehensive reports. It is worth it to have MAP toolkit  in the environment and it can be pretty valuable tool.

image

Installation MAP is pretty straight forward , I will list the steps and some of the tweaks to save some time.

  • Install MAP tool
  • Create repository database by clicking on file and selecting Create/Select Database

clip_image001

  • Provide name to your database and click on the bottom

clip_image002

  • Verify the database has been created

clip_image003

  • Click Database and under SQL Server Discovery , we will run our fist query

clip_image004

  • Click Collect Data

clip_image005

  • Select SQL servers ( the information pane is very useful it provides detailed information about what has been selected)

clip_image001[4]

  • We will first run SQL server query and come back to run SQL server with Database Details query

clip_image002[4]

  • We will use pre defines text file to import the servers we would like to use for the scan m click next, the text file will have SQL server names in a simple fashion.

clip_image003[4]

  • Click next

clip_image004[4]

  • Click Save and next

image 

  • Click next again, on the import files click "Create"

clip_image001[6]

  • Click "Add"

clip_image002[6]

  • Locate the text file
  • Select "Use All Computers credentials list"

clip_image002[8]

  • And click save

image

  • Click next on the summary page my sure you have captured all you need to run the query

clip_image004[6]

  • Now the query will run against the server provide by the list

clip_image005[4]

  • You will see the numbers will go up as the MAP toolkit discovers and adds the SQL server into inventory

clip_image006[4]

  • You can click on details to see more information

clip_image007

  • Once it is complete , click close
  • Now click on SQL discovery and under options you will have reports you need

clip_image008

image

clip_image010

  • Now export the SQL data by clicking on it

clip_image011

image

  • You can copy and paste these reports onto your workstation.

clip_image013

If you open exported Excel spreadsheet you will find very useful and comprehensive data  for your environment.

 

Location of Local MAP inventory databases

  • C:\Users\UserName \Documents\MAP\Database Backups
  • You can export and import the databases to be used and shared among administrators.

Diagnostic Logging for MAP (Troubleshooting)

  • Location of Map Toolkit.log file C:\Users\UserName\AppData\Local\Microsoft\MAP
  • Each time the MAP tool runs it creates section similar below, this will help for troubleshooting issues to see what is going on.

clip_image001[10]

Firewall Ports for MAP to run properly

  • Will need to open ports 135 and 1024-65535, ( source to destination) the reason for this has to do with the way RPC works. WMI uses DCOM to communicate with remote machines, and DCOM uses RPC extensively.
  • Use Port scanner to determine the ports on the destination and ask assistance firewall team

Resources:

Oz Casey, Dedeal  ( MVP North America)
MCITP (EMA), MCITP (SA)
MCSE 2003, M+, S+, MCDST
Security+, Project +, Server +
http://smtp25.blogspot.com/ (Blog)
http://telnet25.wordpress.com/ (Blog)

Twitter @Message_Talk

 

No comments: