Skip to main content

file_workspaces

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

Overview

Namefile_workspaces
TypeResource
Idazure.support.file_workspaces

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}". # pylint: disable=line-too-long
namestringThe name of the resource.
createdOnstring (date-time)Time in UTC (ISO 8601 format) when file workspace was created.
expirationTimestring (date-time)Time in UTC (ISO 8601 format) when file workspace is going to expire.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectfile_workspace_name, subscription_idGets details for a specific file workspace in an Azure subscription.
createinsertfile_workspace_name, subscription_idCreates a new file workspace for the specified subscription.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
file_workspace_namestringFile workspace name. Required.
subscription_idstring

SELECT examples

Gets details for a specific file workspace in an Azure subscription.

SELECT
id,
name,
createdOn,
expirationTime,
systemData,
type
FROM azure.support.file_workspaces
WHERE file_workspace_name = '{{ file_workspace_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates a new file workspace for the specified subscription.

INSERT INTO azure.support.file_workspaces (
file_workspace_name,
subscription_id
)
SELECT
'{{ file_workspace_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;