Skip to main content

vw_agents

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

Overview​

Namevw_agents
TypeView
Idazure.storage_mover.vw_agents

Fields​

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

SQL Definition​

SELECT
systemData as system_data,
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.agentVersion') as "agent_version",
JSON_EXTRACT(properties, '$.arcResourceId') as "arc_resource_id",
JSON_EXTRACT(properties, '$.arcVmUuid') as "arc_vm_uuid",
JSON_EXTRACT(properties, '$.agentStatus') as "agent_status",
JSON_EXTRACT(properties, '$.lastStatusUpdate') as "last_status_update",
JSON_EXTRACT(properties, '$.localIPAddress') as "local_ip_address",
JSON_EXTRACT(properties, '$.memoryInMB') as "memory_in_mb",
JSON_EXTRACT(properties, '$.numberOfCores') as "number_of_cores",
JSON_EXTRACT(properties, '$.uptimeInSeconds') as "uptime_in_seconds",
JSON_EXTRACT(properties, '$.timeZone') as "time_zone",
JSON_EXTRACT(properties, '$.uploadLimitSchedule') as "upload_limit_schedule",
JSON_EXTRACT(properties, '$.errorDetails') as "error_details",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
storageMoverName,
agentName
FROM azure.storage_mover.agents
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND storageMoverName = 'replace-me';