Discover installed software inventory, and SQL Server instances and databases

This article describes how to discover installed software inventory, and SQL Server instances and databases on servers running in your VMware environment, using Azure Migrate: Discovery and assessment tool.

Performing software inventory helps identify and tailor a migration path to Azure for your workloads. Software inventory uses the Azure Migrate appliance to perform discovery, using server credentials. It is completely agentless- no agents are installed on the servers to collect this data.

Before you start

Deploy and configure the Azure Migrate appliance

  1. Review the requirements for deploying the Azure Migrate appliance.
  2. Review the Azure URLs that the appliance will need to access in the public and government clouds.
  3. Review data that the appliance collects during discovery and assessment.
  4. Note port access requirements for the appliance.
  5. Deploy the Azure Migrate appliance to start discovery. To deploy the appliance, you download and import an OVA template into VMware to create a server running in your vCenter Server. After deploying the appliance, you need to register it with the project and configure it to initiate the discovery.
  6. As you configure the appliance, you need to specify the following in the appliance configuration manager:
    • The details of the vCenter Server to which you want to connect.
    • vCenter Server credentials scoped to discover the servers in your VMware environment.
    • Server credentials, which can be domain/ Windows(non-domain)/ Linux(non-domain) credentials. Learn more about how to provide credentials and how we handle them.

Verify permissions

  • You need to create a vCenter Server read-only account for discovery and assessment. The read-only account needs privileges enabled for Virtual Machines > Guest Operations, in order to interact with the servers to perform software inventory.
  • You can add multiple domain and non-domain (Windows/Linux) credentials on the appliance configuration manager for application discovery. You need a guest user account for Windows servers, and a regular/normal user account (non-sudo access) for all Linux servers.Learn more about how to provide credentials and how we handle them.

Add credentials and initiate discovery

  1. Open the appliance configuration manager, complete the prerequisite checks and registration of the appliance.
  2. Navigate to the Manage credentials and discovery sources panel.
  3. In Step 1: Provide vCenter Server credentials, click on Add credentials to provide credentials for the vCenter Server account that the appliance will use to discover servers running on the vCenter Server.
  4. In Step 2: Provide vCenter Server details, click on Add discovery source to select the friendly name for credentials from the drop-down, specify the IP address/FQDN of the vCenter Server instance Panel 3 on appliance configuration manager for vCenter Server details
  5. In Step 3: Provide server credentials to perform software inventory, agentless dependency analysis and discovery of SQL Server instances and databases, click Add credentials to provide multiple server credentials to initiate software inventory.
  6. Click on Start discovery, to kick off vCenter Server discovery.

After the vCenter Server discovery is complete, appliance initiates the discovery of installed applications, roles, and features (software inventory). The duration depends on the number of discovered servers. For 500 servers, it takes approximately one hour for the discovered inventory to appear in the Azure Migrate portal.

Review and export the inventory

After software inventory has completed, you can review and export the inventory in the Azure portal.

  1. In Azure Migrate - Windows, Linux and SQL Servers > Azure Migrate: Discovery and assessment, click the displayed count to open the Discovered servers page.

    Note

    At this stage you can optionally also enable dependency analysis for the discovered servers, so that you can visualize dependencies across servers you want to assess. Learn more about dependency analysis.

  2. In Software inventory column, click the displayed count to review the discovered applications, roles, and features.

  3. To export the inventory, in Discovered Servers, click Export app inventory.

The software inventory is exported and downloaded in Excel format. The Software Inventory sheet displays all the apps discovered across all the servers.

Discover SQL Server instances and databases

  • Software inventory also identifies the SQL Server instances running in your VMware environment.
  • If you have not provided Windows authentication or SQL Server authentication credentials on the appliance configuration manager, then add the credentials so that the appliance can use them to connect to respective SQL Server instances.

Once connected, appliance gathers configuration and performance data of SQL Server instances and databases. The SQL Server configuration data is updated once every 24 hours and the performance data are captured every 30 seconds. Hence any change to the properties of the SQL Server instance and databases such as database status, compatibility level etc. can take up to 24 hours to update on the portal.

Next steps