Hyper-V Hypervisor host and virtual machine data can be import via the Sam360 Web Portal ‘Import Data‘ page. To import Hyper-V data…
- Log in to the Sam360 web portal
- Click the ‘Settings’ button on the top right of the screen
- Click on the ‘Import Data’ menu option on the left menu bar
- Select ‘Hyper-V’ from the ‘Data Import Type’ dropdown menu
- Click the ‘Choose file’ button to browse for the file to be imported. Select the file and click ‘Open’ Note: Only one file can be imported at a time, the content and format of this file are explained below
- Click the ‘Upload’ button
- The Hyper-V data will now be imported and queued for processing. Data is generally processed within a minute of importing, although this can be longer if the platform is busy
Import File Format
Hyper-V data can be imported in a single CSV file or as a zipped archive (.zip file) containing multiple CSV files. The CSV file format for uploading Hyper-V is described below. A free to use Sam360 SAM Gold Toolkit PowerShell script which extracts virtual machine and host data from a Hyper-V Hypervisor in the correct CSV file format can be downloaded from here.
The Hyper-V import CSV file (comma delimited) should contain the following columns.
| Column Title | Description | Sample Value |
|---|---|---|
| FQDN | The virtual machines (VMs) fully qualified domain name | machine1.testdomain.local |
| OSName | The VMs operating system | Windows 7 Professional |
| HyperV_Name | The VMs Hyper-V name (MANDATORY) | Machine1 |
| EnabledState | The VMs state (Enabled/Disabled) | Enabled |
| Host | The host hypervisor name | Host-01 |
| GUID | The VMs unique identifier (MANDATORY) | 65232B00-B0FB-47FD-B1C3-C54EE1751F43 |
| Description | A description for the VM | Microsoft Virtual Machine |
| EnabledStateID | 2 | |
| InstallDate | The VMs install date | 20160419175017.449143-000 |
| OnTimeInMilliseconds | The amount of time the VM has been running | 5000000 |
| TimeOfLastStateChange | The time when the VMs state last changed | 20160713134744.831756-000 |
| OSVersion | The VMs operating system version | 6.3.9431 |
| CSDVersion | The VMs current service pack | Service Pack 1 |
| ProductType | 1 | |
| NetworkAddressIPv4 | The VMs IP address | 125.125.125.1 |
| NetworkAddressIPv6 | The VMs IPv6 address | fe80::9658:11b8:3d25:2610%6 |
| OSEditionId | 48 | |
| ProcessorArchitecture | 9 | |
| SuiteMask | 256 |
A sample Hyper-V import file can be downloaded here.
Leave A Comment