Skip to main content

vw_session_host_configurations

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

Overview​

Namevw_session_host_configurations
TypeView
Idazure.desktop_virtualization.vw_session_host_configurations

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.friendlyName') as "friendly_name",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.vmTags') as "vm_tags",
JSON_EXTRACT(properties, '$.vmLocation') as "vm_location",
JSON_EXTRACT(properties, '$.vmResourceGroup') as "vm_resource_group",
JSON_EXTRACT(properties, '$.vmNamePrefix') as "vm_name_prefix",
JSON_EXTRACT(properties, '$.availabilityZones') as "availability_zones",
JSON_EXTRACT(properties, '$.networkInfo') as "network_info",
JSON_EXTRACT(properties, '$.vmSizeId') as "vm_size_id",
JSON_EXTRACT(properties, '$.diskInfo') as "disk_info",
JSON_EXTRACT(properties, '$.customConfigurationScriptUrl') as "custom_configuration_script_url",
JSON_EXTRACT(properties, '$.imageInfo') as "image_info",
JSON_EXTRACT(properties, '$.domainInfo') as "domain_info",
JSON_EXTRACT(properties, '$.securityInfo') as "security_info",
JSON_EXTRACT(properties, '$.vmAdminCredentials') as "vm_admin_credentials",
JSON_EXTRACT(properties, '$.bootDiagnosticsInfo') as "boot_diagnostics_info",
subscriptionId,
resourceGroupName,
hostPoolName
FROM azure.desktop_virtualization.session_host_configurations
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND hostPoolName = 'replace-me';