servers_controller_machines

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

Overview

Name	servers_controller_machines
Type	Resource
Id	azure.migrate.servers_controller_machines

Fields

vw_servers_controller_machines

Name	Datatype	Description
allocated_memory_in_mb	text	field from the properties object
appliance_names	text	field from the properties object
application_discovery	text	field from the properties object
apps_and_roles	text	field from the properties object
bios_guid	text	field from the properties object
bios_serial_number	text	field from the properties object
created_timestamp	text	field from the properties object
dependency_map_discovery	text	field from the properties object
dependency_mapping	text	field from the properties object
dependency_mapping_end_time	text	field from the properties object
dependency_mapping_start_time	text	field from the properties object
disks	text	field from the properties object
display_name	text	field from the properties object
errors	text	field from the properties object
firmware	text	field from the properties object
fqdn	text	field from the properties object
guest_details_discovery_timestamp	text	field from the properties object
guest_os_details	text	field from the properties object
hydrated_fqdn	text	field from the properties object
iis_discovery	text	field from the properties object
is_deleted	text	field from the properties object
is_guest_details_discovery_in_progress	text	field from the properties object
machineName	text	field from the properties object
network_adapters	text	field from the properties object
number_of_applications	text	field from the properties object
number_of_processor_core	text	field from the properties object
operating_system_details	text	field from the properties object
oracle_discovery	text	field from the properties object
processor_info	text	field from the properties object
product_support_status	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
run_as_account_id	text	field from the properties object
siteName	text	field from the properties object
spring_boot_discovery	text	field from the properties object
sql_discovery	text	field from the properties object
static_discovery	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	field from the properties object
tomcat_discovery	text	field from the properties object
updated_timestamp	text	field from the properties object
validation_required	text	field from the properties object
web_app_discovery	text	field from the properties object

servers_controller_machines

Name	Datatype	Description
properties	object	Server REST resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	machineName, resourceGroupName, siteName, subscriptionId	Get a Server
delete	DELETE	machineName, resourceGroupName, siteName, subscriptionId	Delete a Server
update	UPDATE	machineName, resourceGroupName, siteName, subscriptionId	Update a Server machine

SELECT examples

Get a Server

vw_servers_controller_machines

SELECT
allocated_memory_in_mb,
appliance_names,
application_discovery,
apps_and_roles,
bios_guid,
bios_serial_number,
created_timestamp,
dependency_map_discovery,
dependency_mapping,
dependency_mapping_end_time,
dependency_mapping_start_time,
disks,
display_name,
errors,
firmware,
fqdn,
guest_details_discovery_timestamp,
guest_os_details,
hydrated_fqdn,
iis_discovery,
is_deleted,
is_guest_details_discovery_in_progress,
machineName,
network_adapters,
number_of_applications,
number_of_processor_core,
operating_system_details,
oracle_discovery,
processor_info,
product_support_status,
provisioning_state,
resourceGroupName,
run_as_account_id,
siteName,
spring_boot_discovery,
sql_discovery,
static_discovery,
subscriptionId,
tags,
tomcat_discovery,
updated_timestamp,
validation_required,
web_app_discovery
FROM azure.migrate.vw_servers_controller_machines
WHERE machineName = '{{ machineName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';

servers_controller_machines

SELECT
properties
FROM azure.migrate.servers_controller_machines
WHERE machineName = '{{ machineName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a servers_controller_machines resource.

/*+ update */
UPDATE azure.migrate.servers_controller_machines
SET 
properties = '{{ properties }}'
WHERE 
machineName = '{{ machineName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified servers_controller_machines resource.

/*+ delete */
DELETE FROM azure.migrate.servers_controller_machines
WHERE machineName = '{{ machineName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';