Tutorial: Build a business case or assess servers using an imported CSV file

As part of your migration journey to Azure, you discover your on-premises inventory and workloads.

This tutorial shows you how to assess on-premises machines with the Azure Migrate: Discovery and Assessment tool, using an imported comma-separate values (CSV) file.

If you use a CSV file, you don't need to set up the Azure Migrate appliance to discover servers. You can control the data you share in the file, and much of the data is optional. This method is useful if:

• You want to create a quick, initial assessment before you deploy the appliance.
• You can't deploy the Azure Migrate appliance in your organization.
• You can't share credentials that allow access to on-premises servers.
• Security constraints prevent you from gathering and sending data collected by the appliance to Azure.

In this tutorial, you learn how to:

If you don't have an Azure subscription, create a trial subscription before you begin.

Prerequisites

• You can add up to 20,000 servers in a single CSV file, and in an Azure Migrate project.
• Operating system names specified in the CSV file must contain and match supported names.

Prepare an Azure user account

To create an Azure Migrate project, you need an account with:

• Contributor or Owner permissions on an Azure subscription.
• Permissions to register Microsoft Entra apps.

If you just created a trial Azure account, you're the owner of your subscription. If you're not the subscription owner, work with the owner to assign the permissions as follows:

1. In the Azure portal, search for "subscriptions", and under Services, select Subscriptions.

   

2. In the Subscriptions page, select the subscription in which you want to create an Azure Migrate project.

3. Select Access control (IAM).

4. Select Add > Add role assignment to open the Add role assignment page.

5. Assign the following role. For detailed steps, see Assign Azure roles using the Azure portal.

   Setting	Value
   Role	Contributor or Owner
   Assign access to	User
   Members	azmigrateuser

   

6. In the portal, search for users, and under Services, select Users.

7. In User settings, verify that Microsoft Entra users can register applications (set to Yes by default).

   

Set up a project

Set up a new Azure Migrate project if you don't have one.

1. In the Azure portal > All services, search for Azure Migrate.

2. Under Services, select Azure Migrate.

3. In Get started, select Create project.

4. In Create project, select your Azure subscription and resource group. Create a resource group if you don't have one.

5. In Project Details, specify the project name and the geography in which you want to create the project. Review supported geographies for Azure operated by 21Vianet.

   

6. Select Create.

7. Wait a few minutes for the Azure Migrate project to deploy.

The Azure Migrate: Discovery and assessment tool is added by default to the new project.

Prepare the CSV

Download the CSV template and add server information to it.

Download the template

1. In Migration goals > Windows, Linux and SQL Server > Azure Migrate: Discovery and assessment, select Discover.

2. In Discover machines, select Import using CSV.

3. Select Download to download the CSV template. Alternatively, you can download it directly.

   

Add server information

Gather server data and add it to the CSV file.

• To gather data, you can export it from tools you use for on-premises server management, such as VMware vSphere or your configuration-management database (CMDB).
• To review sample data, download our example file.

The following table summarizes the file fields to fill in:

Field name	Mandatory	Details
Server name	Yes	We recommend specifying the fully qualified domain name (FQDN).
IP address	No	Server address.
Cores	Yes	Number of processor cores allocated to the server.
Memory	Yes	Total RAM, in MB, allocated to the server.
OS name	Yes	Server operating system. Operating system names that match or contain the names in this list are recognized by the assessment.
OS version	No	Server operating system version.
OS architecture	No	Server OS architecture Valid values are: x64, x86, amd64, 32-bit or 64-bit
Server type	No	Type of server Valid values are: Virtual, Physical
Hypervisor	No	If server type is Virtual, specify hypervisor name Valid values are: VMware, Hyper-V
Number of disks	No	Not needed if individual disk details are provided.
Storage in use (In GB)	No	You can add how much storage is in use per server. This field will only be used in Azure VMware Solution assessment sizing logic.
Disk 1 size	No	Maximum size of disk, in GB. You can add details for more disks by adding columns in the template. You can add up to twenty disks.
Disk 1 read ops	No	Disk read operations per second.
Disk 1 write ops	No	Disk write operations per second.
Disk 1 read throughput	No	Data read from the disk per second, in MB per second.
Disk 1 write throughput	No	Data written to disk per second, in MB per second.
CPU utilization percentage	No	Percentage of CPU used.
Memory utilization percentage	No	Percentage of RAM used.
Total disks read ops	No	Disk-read operations per second.
Total disks write ops	No	Disk-write operations per second.
Total disks read throughput	No	Data read from the disk, in MB per second.
Total disks write throughput	No	Data written to disk, in MB per second.
Network In throughput	No	Data received by the server, in MB per second.
Network Out throughput	No	Data transmitted by the server, in MB per second.
Firmware type	No	Server firmware. Values can be "BIOS" or "UEFI".
No	Server MAC address.

Add operating systems

Assessment recognizes specific operating system names. Any name you specify must exactly match one of the strings in the supported names list.

Add multiple disks

The template provides default fields for the first disk. You can add similar columns for up to twenty disks.

For example, to specify all fields for a second disk, add these columns:

• Disk 2 size
• Disk 2 read ops
• Disk 2 write ops
• Disk 2 read throughput
• Disk 2 write throughput

Import the server information

After adding information to the CSV template, import the CSV file.

1. In Migration goals > Windows, Linux and SQL Server > Azure Migrate: Discovery and assessment, select Discover.
2. In Discover machines, select Import using CSV
3. Upload the .csv file and select Import.
4. The import status is shown.
   • If warnings appear in the status, you can either fix them or continue without addressing them.
   • To improve assessment accuracy, improve the server information as suggested in warnings.
   • To view and fix warnings, select Download warning details .CSV. This operation downloads the CSV with warnings included. Review the warnings and fix issues as needed.
   • If errors appear in the status so that the import status is Failed, you must fix those errors before you can continue with the import:
     1. Download the CSV, which now includes error details.
     2. Review and address the errors as necessary.
     3. Upload the modified file again.
5. When the import status is Completed, the server information has been imported. Refresh if the import process doesn't seem to be complete.

Update server information

You can update the information for a server by importing the data for the server again with the same Server name. You can't modify the Server name field. Deleting servers is currently not supported.

Verify servers in the portal

To verify that the servers appear in the Azure portal after discovery:

1. Open the Azure Migrate dashboard.
2. On the Azure Migrate - Servers > Azure Migrate: Discovery and assessment page, select the icon that displays the count for Discovered servers.
3. Select the Import based tab.

Supported operating system names

Operating system names provided in the CSV must contain and match. If they don't, you won't be able to assess them.

A-H	I-R	S-T	U-Z
Asianux 3 Asianux 4 Asianux 5 CoreOS Linux Debian GNU/Linux 4 Debian GNU/Linux 5 Debian GNU/Linux 6 Debian GNU/Linux 7 Debian GNU/Linux 8 FreeBSD	IBM OS/2 macOS X 10 MS-DOS Novell NetWare 5 Novell NetWare 6 Oracle Linux Oracle Linux 4/5 Oracle Solaris 10 Oracle Solaris 11 Red Hat Enterprise Linux 2 Red Hat Enterprise Linux 3 Red Hat Enterprise Linux 4 Red Hat Enterprise Linux 5 Red Hat Enterprise Linux 6 Red Hat Enterprise Linux 7 Red Hat Fedora	SCO OpenServer 5 SCO OpenServer 6 SCO UnixWare 7 Serenity Systems eComStation Serenity Systems eComStation 1 Serenity Systems eComStation 2 Sun Microsystems Solaris 8 Sun Microsystems Solaris 9 SUSE Linux Enterprise 10 SUSE Linux Enterprise 11 SUSE Linux Enterprise 12 SUSE Linux Enterprise 8/9 SUSE Linux Enterprise 11 SUSE openSUSE	Ubuntu Linux VMware ESXi 4 VMware ESXi 5 VMware ESXi 6 Windows 10 Windows 2000 Windows 3 Windows 7 Windows 8 Windows 95 Windows 98 Windows NT Windows Server (R) 2008 Windows Server 2003 Windows Server 2008 Windows Server 2008 R2 Windows Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows Server 2019 Windows Server Threshold Windows Vista Windows Web Server 2008 R2 Windows XP Professional

Assessment considerations

• If you import servers by using a CSV file and creating an assessment with sizing criteria as "performance-based":
  • For Azure VM assessment, the performance values you specify (CPU utilization, Memory utilization, Disk IOPS and throughput) are used if you choose performance-based sizing. You will not be able to provide performance history and percentile information.
  • For Azure VMware Solution assessment, the performance values you specify (CPU utilization, Memory utilization, Storage in use(GB)) are used if you choose performance-based sizing. You will not be able to provide performance history and percentile information.
• To get an accurate OS suitability/readiness in Azure VM and Azure VMware Solution assessment, please enter the Operating system version and architecture in the respective columns.

Next steps

In this tutorial, you: