Skip to main content

vw_servers_controller_machines

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

Overview​

Namevw_servers_controller_machines
TypeView
Idazure.migrate.vw_servers_controller_machines

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.fqdn') as "fqdn",
JSON_EXTRACT(properties, '$.networkAdapters') as "network_adapters",
JSON_EXTRACT(properties, '$.hydratedFqdn') as "hydrated_fqdn",
JSON_EXTRACT(properties, '$.disks') as "disks",
JSON_EXTRACT(properties, '$.validationRequired') as "validation_required",
JSON_EXTRACT(properties, '$.processorInfo') as "processor_info",
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, '$.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.servers_controller_machines
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = 'replace-me' AND machineName = 'replace-me';