Skip to main content

vw_session_hosts

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

Overview​

Namevw_session_hosts
TypeView
Idazure.desktop_virtualization.vw_session_hosts

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, '$.objectId') as "object_id",
JSON_EXTRACT(properties, '$.lastHeartBeat') as "last_heart_beat",
JSON_EXTRACT(properties, '$.sessions') as "sessions",
JSON_EXTRACT(properties, '$.agentVersion') as "agent_version",
JSON_EXTRACT(properties, '$.allowNewSession') as "allow_new_session",
JSON_EXTRACT(properties, '$.virtualMachineId') as "virtual_machine_id",
JSON_EXTRACT(properties, '$.resourceId') as "resource_id",
JSON_EXTRACT(properties, '$.assignedUser') as "assigned_user",
JSON_EXTRACT(properties, '$.friendlyName') as "friendly_name",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.statusTimestamp') as "status_timestamp",
JSON_EXTRACT(properties, '$.osVersion') as "os_version",
JSON_EXTRACT(properties, '$.sxSStackVersion') as "sx_s_stack_version",
JSON_EXTRACT(properties, '$.updateState') as "update_state",
JSON_EXTRACT(properties, '$.lastUpdateTime') as "last_update_time",
JSON_EXTRACT(properties, '$.updateErrorMessage') as "update_error_message",
JSON_EXTRACT(properties, '$.lastSessionHostUpdateTime') as "last_session_host_update_time",
JSON_EXTRACT(properties, '$.sessionHostConfiguration') as "session_host_configuration",
JSON_EXTRACT(properties, '$.sessionHostHealthCheckResults') as "session_host_health_check_results",
subscriptionId,
resourceGroupName,
hostPoolName,
sessionHostName
FROM azure.desktop_virtualization.session_hosts
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND hostPoolName = 'replace-me';