vw_users

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

Overview

Name	vw_users
Type	View
Id	azure.lab_services.vw_users

Fields

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

SQL Definition

Sqlite3

SELECT
systemData as system_data,
JSON_EXTRACT(properties, '$.additionalUsageQuota') as "additional_usage_quota",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.resourceOperationError') as "resource_operation_error",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.email') as "email",
JSON_EXTRACT(properties, '$.registrationState') as "registration_state",
JSON_EXTRACT(properties, '$.invitationState') as "invitation_state",
JSON_EXTRACT(properties, '$.invitationSent') as "invitation_sent",
JSON_EXTRACT(properties, '$.totalUsage') as "total_usage",
subscriptionId,
resourceGroupName,
labName,
userName
FROM azure.lab_services.users
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND labName = 'replace-me';

Postgres

SELECT
systemData as system_data,
json_extract_path_text(properties, '$.additionalUsageQuota') as "additional_usage_quota",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.resourceOperationError') as "resource_operation_error",
json_extract_path_text(properties, '$.displayName') as "display_name",
json_extract_path_text(properties, '$.email') as "email",
json_extract_path_text(properties, '$.registrationState') as "registration_state",
json_extract_path_text(properties, '$.invitationState') as "invitation_state",
json_extract_path_text(properties, '$.invitationSent') as "invitation_sent",
json_extract_path_text(properties, '$.totalUsage') as "total_usage",
subscriptionId,
resourceGroupName,
labName,
userName
FROM azure.lab_services.users
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND labName = 'replace-me';