You can use the Windows and SQL Server Infrastructure report to gain visibility into the infrastructure details for all physical hosts and virtual machines (VMs) that are running Microsoft Windows Server or Microsoft SQL Server across your on-premise and public cloud environments, such as AWS and Microsoft Azure.

The Windows and SQL Server Infrastructure report is available in both the Software Asset Workspace and the Software Asset Management classic application.

To view this report in the Software Asset Workspace, navigate to Workspaces > Software Asset Workspace. From the Software Asset Workspace, navigate to License usage > Reports > Windows and SQL Server Infrastructure.

To view this report in the Software Asset Management classic application, navigate to All > Reports > View/Run. From the list of available reports, search for and select Windows and SQL Server infrastructure details report. When the corresponding Edit report page opens, select Run.

Table 1. Windows and SQL Server infrastructure report
FieldDescription
Deployment type Type of deployment that the physical host or VM is running in. The options are On premise and Cloud.
Cloud provider Cloud provider that Microsoft Windows Server or Microsoft SQL Server is deployed on. The options are AWS and Microsoft Azure.
Note: This field is applicable for cloud deployments only.
vCenter VMware vCenter Server that you are using to manage the physical host or VM in a virtual VMware vSphere environment.
Note: This field is applicable only if you are using VMware virtualization technology.
Cluster Cluster that the physical host or VM resides in.
Host For physical hosts, this field identifies the host that Microsoft Windows Server or Microsoft SQL Server is installed on.

For VMs, this field identifies the physical host that the VM is running on.
Host processor count Number of CPUs that are assigned to the physical host.
Host core count Number of cores within each CPU that is assigned to the physical host.
Virtualization technology Virtualization technology that you are using to deploy and manage your physical hosts and VMs.
Virtual server VM on which you are running Microsoft Windows Server or Microsoft SQL Server.
Note: If a VM resides in an on-premise cluster, it can migrate to any physical host within that cluster. Additionally, if you are using VM-Host affinity rules to specify the physical hosts on which a VM can run, the VM can migrate to any physical host that is specified in those rules. In these scenarios, the same VM can appear on the Windows and SQL Server Infrastructure report multiple times based on the physical hosts to which it can migrate.
Note: This field is applicable for VMs only.
Windows Server installation Microsoft Windows Server version that is installed on the physical host or VM.

If multiple Microsoft Windows Server versions are installed on the same host or VM, this field displays all installed versions using a comma-separated list.
SQL Server installation Microsoft SQL Server version that is installed on the physical host or VM.

If multiple Microsoft SQL Server versions are installed on the same host or VM, this field displays all installed versions using a comma-separated list.
VM processor count Number of virtual CPUs (vCPUs) that are assigned to the VM.
Note: This field is applicable for VMs only.
VM core count Number of virtual cores within each vCPU that is assigned to the VM.
Note: This field is applicable for VMs only.
VM CPU thread count Number of threads that divide each virtual core within the vCPUs that are assigned to the VM.
Note: This field is applicable for VMs only.
Cloud host type Type of cloud host that the VM is running on. The options are Shared and Dedicated.
Note: This field is applicable for cloud deployments only.
Cloud license type - Windows Server Cloud license type of the Microsoft Windows Server installation. The options are BYOL and License Included.
Note: This field is applicable for cloud deployments only.
Cloud license type - SQL Server Cloud license type of the Microsoft SQL Server installation. The options are BYOL and License Included.
Note: This field is applicable for cloud deployments only.