accounts

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

Overview

Name	accounts
Type	Resource
Id	azure_extras.visual_studio.accounts

Fields

Name	Datatype	Description
id	string	Unique identifier of the resource.
name	string	Resource name.
location	string	Resource location.
properties	object	Resource properties.
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourceName, subscriptionId	Gets the Visual Studio Team Services account resource details.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all Visual Studio Team Services account resources under the resource group linked to the specified Azure subscription.
create_or_update	INSERT	resourceGroupName, resourceName, subscriptionId	Creates or updates a Visual Studio Team Services account resource.
delete	DELETE	resourceGroupName, resourceName, subscriptionId	Deletes a Visual Studio Team Services account resource.
update	UPDATE	resourceGroupName, resourceName, subscriptionId	Updates tags for Visual Studio Team Services account resource.
check_name_availability	EXEC	subscriptionId	Checks if the specified Visual Studio Team Services account name is available. Resource name can be either an account name or an account name and PUID.

SELECT examples

Gets all Visual Studio Team Services account resources under the resource group linked to the specified Azure subscription.

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure_extras.visual_studio.accounts
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new accounts resource.

All Properties

/*+ create */
INSERT INTO azure_extras.visual_studio.accounts (
resourceGroupName,
resourceName,
subscriptionId,
accountName,
location,
operationType,
properties,
tags
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ accountName }}',
'{{ location }}',
'{{ operationType }}',
'{{ properties }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: accountName
      value: string
    - name: location
      value: string
    - name: operationType
      value: string
    - name: properties
      value: object
    - name: tags
      value: object

UPDATE example

Updates a accounts resource.

/*+ update */
UPDATE azure_extras.visual_studio.accounts
SET 
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified accounts resource.

/*+ delete */
DELETE FROM azure_extras.visual_studio.accounts
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';