Skip to main content

vw_hyperv_machines_controllers

Creates, updates, deletes, gets or lists a vw_hyperv_machines_controllers resource.

Overview​

Namevw_hyperv_machines_controllers
TypeView
Idazure.migrate.vw_hyperv_machines_controllers

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.instanceUuid') as "instance_uuid",
JSON_EXTRACT(properties, '$.hostFqdn') as "host_fqdn",
JSON_EXTRACT(properties, '$.hostId') as "host_id",
JSON_EXTRACT(properties, '$.generation') as "generation",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.highAvailability') as "high_availability",
JSON_EXTRACT(properties, '$.clusterFqdn') as "cluster_fqdn",
JSON_EXTRACT(properties, '$.clusterId') as "cluster_id",
JSON_EXTRACT(properties, '$.maxMemoryMb') as "max_memory_mb",
JSON_EXTRACT(properties, '$.isDynamicMemoryEnabled') as "is_dynamic_memory_enabled",
JSON_EXTRACT(properties, '$.disks') as "disks",
JSON_EXTRACT(properties, '$.networkAdapters') as "network_adapters",
JSON_EXTRACT(properties, '$.managementServerType') as "management_server_type",
JSON_EXTRACT(properties, '$.secureBootTemplateId') as "secure_boot_template_id",
JSON_EXTRACT(properties, '$.secureBootEnabled') as "secure_boot_enabled",
JSON_EXTRACT(properties, '$.secureBootTemplate') as "secure_boot_template",
JSON_EXTRACT(properties, '$.tpmEnabled') as "tpm_enabled",
JSON_EXTRACT(properties, '$.ksdEnabled') as "ksd_enabled",
JSON_EXTRACT(properties, '$.shieldingRequested') as "shielding_requested",
JSON_EXTRACT(properties, '$.dataProtectionRequested') as "data_protection_requested",
JSON_EXTRACT(properties, '$.encryptStateAndVmMigrationTraffic') as "encrypt_state_and_vm_migration_traffic",
JSON_EXTRACT(properties, '$.virtualizationBasedSecurityOptOut') as "virtualization_based_security_opt_out",
JSON_EXTRACT(properties, '$.powerStatus') as "power_status",
JSON_EXTRACT(properties, '$.vmFqdn') as "vm_fqdn",
JSON_EXTRACT(properties, '$.vmConfigurationFileLocation') as "vm_configuration_file_location",
JSON_EXTRACT(properties, '$.firmware') as "firmware",
JSON_EXTRACT(properties, '$.guestOsDetails') as "guest_os_details",
JSON_EXTRACT(properties, '$.numberOfApplications') as "number_of_applications",
JSON_EXTRACT(properties, '$.guestDetailsDiscoveryTimestamp') as "guest_details_discovery_timestamp",
JSON_EXTRACT(properties, '$.isGuestDetailsDiscoveryInProgress') as "is_guest_details_discovery_in_progress",
JSON_EXTRACT(properties, '$.dependencyMapping') as "dependency_mapping",
JSON_EXTRACT(properties, '$.dependencyMappingStartTime') as "dependency_mapping_start_time",
JSON_EXTRACT(properties, '$.dependencyMappingEndTime') as "dependency_mapping_end_time",
JSON_EXTRACT(properties, '$.runAsAccountId') as "run_as_account_id",
JSON_EXTRACT(properties, '$.applianceNames') as "appliance_names",
JSON_EXTRACT(properties, '$.errors') as "errors",
JSON_EXTRACT(properties, '$.applicationDiscovery') as "application_discovery",
JSON_EXTRACT(properties, '$.dependencyMapDiscovery') as "dependency_map_discovery",
JSON_EXTRACT(properties, '$.staticDiscovery') as "static_discovery",
JSON_EXTRACT(properties, '$.sqlDiscovery') as "sql_discovery",
JSON_EXTRACT(properties, '$.webAppDiscovery') as "web_app_discovery",
JSON_EXTRACT(properties, '$.oracleDiscovery') as "oracle_discovery",
JSON_EXTRACT(properties, '$.springBootDiscovery') as "spring_boot_discovery",
JSON_EXTRACT(properties, '$.iisDiscovery') as "iis_discovery",
JSON_EXTRACT(properties, '$.tomcatDiscovery') as "tomcat_discovery",
JSON_EXTRACT(properties, '$.appsAndRoles') as "apps_and_roles",
JSON_EXTRACT(properties, '$.productSupportStatus') as "product_support_status",
JSON_EXTRACT(properties, '$.numberOfProcessorCore') as "number_of_processor_core",
JSON_EXTRACT(properties, '$.allocatedMemoryInMb') as "allocated_memory_in_mb",
JSON_EXTRACT(properties, '$.operatingSystemDetails') as "operating_system_details",
JSON_EXTRACT(properties, '$.biosSerialNumber') as "bios_serial_number",
JSON_EXTRACT(properties, '$.biosGuid') as "bios_guid",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.isDeleted') as "is_deleted",
JSON_EXTRACT(properties, '$.createdTimestamp') as "created_timestamp",
JSON_EXTRACT(properties, '$.tags') as "tags",
JSON_EXTRACT(properties, '$.updatedTimestamp') as "updated_timestamp",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
siteName,
machineName
FROM azure.migrate.hyperv_machines_controllers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = 'replace-me';