Skip to main content

users

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

Overview

Nameusers
TypeResource
Idazure.dev_test_labs.users

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe identifier of the resource.
namestringThe name of the resource.
createdDatestring (date-time)The creation date of the user profile.
identityobjectThe identity of the user.
locationstringThe location of the resource.
provisioningStatestringThe provisioning status of the resource.
secretStoreobjectThe secret store of the user.
tagsobjectThe tags of the resource.
typestringThe type of the resource.
uniqueIdentifierstringThe unique immutable identifier of a resource (Guid).

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, lab_name, name, subscription_id$expandGet user profile.
listselectresource_group_name, lab_name, subscription_id$expand, $filter, $top, $orderbyList user profiles in a given lab.
create_or_updateinsertresource_group_name, lab_name, name, subscription_idCreate or replace an existing user profile. This operation can take a while to complete.
updateupdateresource_group_name, lab_name, name, subscription_idAllows modifying tags of user profiles. All other properties will be ignored.
create_or_updatereplaceresource_group_name, lab_name, name, subscription_idCreate or replace an existing user profile. This operation can take a while to complete.
deletedeleteresource_group_name, lab_name, name, subscription_idDelete user profile. This operation can take a while to complete.

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
lab_namestringThe name of the lab. Required.
namestringThe name of the user profile. Required.
resource_group_namestringThe name of the resource group. Required.
subscription_idstring
$expandstringSpecify the $expand query. Example: 'properties($select=identity)'. Default value is None.
$filterstringThe filter to apply to the operation. Example: '$filter=contains(name,'myName'). Default value is None.
$orderbystringThe ordering expression for the results, using OData notation. Example: '$orderby=name desc'. Default value is None.
$topintegerThe maximum number of resources to return from the operation. Example: '$top=10'. Default value is None.

SELECT examples

Get user profile.

SELECT
id,
name,
createdDate,
identity,
location,
provisioningState,
secretStore,
tags,
type,
uniqueIdentifier
FROM azure.dev_test_labs.users
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND lab_name = '{{ lab_name }}' -- required
AND name = '{{ name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND $expand = '{{ $expand }}'
;

INSERT examples

Create or replace an existing user profile. This operation can take a while to complete.

INSERT INTO azure.dev_test_labs.users (
location,
tags,
properties,
resource_group_name,
lab_name,
name,
subscription_id
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ lab_name }}',
'{{ name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
tags,
type
;

UPDATE examples

Allows modifying tags of user profiles. All other properties will be ignored.

UPDATE azure.dev_test_labs.users
SET
-- No updatable properties
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND lab_name = '{{ lab_name }}' --required
AND name = '{{ name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
tags,
type;

REPLACE examples

Create or replace an existing user profile. This operation can take a while to complete.

REPLACE azure.dev_test_labs.users
SET
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND lab_name = '{{ lab_name }}' --required
AND name = '{{ name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
tags,
type;

DELETE examples

Delete user profile. This operation can take a while to complete.

DELETE FROM azure.dev_test_labs.users
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND lab_name = '{{ lab_name }}' --required
AND name = '{{ name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;