![]() ![]() Next you will see the mentioned below screen where you can enter the name of Inventory Database and mention a short description about it and click “OK”. So, click on the “Create/Select database” option right in the SQL Server Discovery section. We will now create a Database for collecting Inventory of SQL Server Instances on the local machine. Also it can create a report for Azure VM Readiness. Here you can clearly see that the utility is capable of discovering SQL Server and Oracle Database products on the Desktop Machine or on the Network. Once you click on the left hand side “Database” option, you will see the mentioned below Discovery options available at the right hand side window. So, you can go ahead and create it by Clicking on “Create/Select database” (as shown below) or go directly to “Database” section on the left hand side.Īs we want to focus on the Database section only so I will take you to that screen and will discuss the options accordingly. As the utility has to store data about your environment, it needs an Inventory Database to be created. When you open the MAP for the first time, you will see the Overview window at the center of the screen. And the right hand side are the tools (in general) which will allow us to actually perform assessment, view summary and generate reports. This screen is mostly self-explanatory but just to give an overview, the left hand side has all the platforms for which we may want to get assessment. It’s a simple download like 150 MB file(s) with a pretty simple setup to install.Īfter the install, open then utility and you find the mentioned below screen: You can download the MAP from the link here. So enough said, let get started onto the technical details about the MAP. Windows 10, 8.1 and Server 2012 R2 deployment with software and hardware related readiness capabilities.ĭetailed information about the On-Premise Office 2013 or the cloud based Office 365.Īssess and Plan you upgradation and migration to Microsoft Azure VM.ĭetailed information about Microsoft Volume Licensing and compliance accordingly to your organization’s need. Mentioned below are some of the common utilities for which MAP is used (other than I mentioned above). ![]() MAP is also capable of providing you with data about the Hyper-V technologies and its utilization. ![]() Though this can also assess an organization’s readiness of upgrading to new technologies like Office 365 or Cloud Technologies. I will explain the features and functions of MAP and how we can easily install, configure and collect the inventory information about any domain or workgroup. Though this utility does more than what I mentioned earlier but I will squarely focus on SQL Server related inventory information which this utility collects very easily. MAP is an agentless utility which automates getting the inventory for the Microsoft Platform. This is really handy and does the job really well on getting the inventory information about the infrastructure of Windows Platform. To make our job easy we use a tool known as “Microsoft Assessment and Planning” Toolkit, the MAP. Microsoft is really good at providing tools for the assistance of Database Administrators and Consultants. Though it’s a part of our job but at times it takes hours to get even the basic information about the SQL Server versions, patch level, configuration and small details which even client does not have. To do so, we have to run multiple scripts and tools on almost all the machines at client. Generally speaking, we need to analyze the environment of these clients and get information about the infrastructure. As a Microsoft SQL Server Database Consultant, I have to visit multiple companies with variety of SQL Server versions and patch level. ![]()
0 Comments
Leave a Reply. |