Skip to main content

vw_virtual_machine_templates

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

Overview​

Namevw_virtual_machine_templates
TypeView
Idazure.system_center_vm_manager.vw_virtual_machine_templates

Fields​

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

SQL Definition​

SELECT
location as location,
extendedLocation as extended_location,
tags as tags,
JSON_EXTRACT(properties, '$.inventoryItemId') as "inventory_item_id",
JSON_EXTRACT(properties, '$.uuid') as "uuid",
JSON_EXTRACT(properties, '$.vmmServerId') as "vmm_server_id",
JSON_EXTRACT(properties, '$.osType') as "os_type",
JSON_EXTRACT(properties, '$.osName') as "os_name",
JSON_EXTRACT(properties, '$.computerName') as "computer_name",
JSON_EXTRACT(properties, '$.memoryMB') as "memory_mb",
JSON_EXTRACT(properties, '$.cpuCount') as "cpu_count",
JSON_EXTRACT(properties, '$.limitCpuForMigration') as "limit_cpu_for_migration",
JSON_EXTRACT(properties, '$.dynamicMemoryEnabled') as "dynamic_memory_enabled",
JSON_EXTRACT(properties, '$.isCustomizable') as "is_customizable",
JSON_EXTRACT(properties, '$.dynamicMemoryMaxMB') as "dynamic_memory_max_mb",
JSON_EXTRACT(properties, '$.dynamicMemoryMinMB') as "dynamic_memory_min_mb",
JSON_EXTRACT(properties, '$.isHighlyAvailable') as "is_highly_available",
JSON_EXTRACT(properties, '$.generation') as "generation",
JSON_EXTRACT(properties, '$.networkInterfaces') as "network_interfaces",
JSON_EXTRACT(properties, '$.disks') as "disks",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
virtualMachineTemplateName
FROM azure.system_center_vm_manager.virtual_machine_templates
WHERE subscriptionId = 'replace-me';