ou_containers

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

Overview

Name	ou_containers
Type	Resource
Id	azure.aad_domain_services.ou_containers

Fields

vw_ou_containers

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
accounts	text	field from the properties object
container_id	text	field from the properties object
deployment_id	text	field from the properties object
distinguished_name	text	field from the properties object
domainServiceName	text	field from the properties object
domain_name	text	field from the properties object
ouContainerName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
service_status	text	field from the properties object
subscriptionId	text	field from the properties object
tenant_id	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

ou_containers

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	Properties of the OuContainer.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	domainServiceName, ouContainerName, resourceGroupName, subscriptionId	Get OuContainer in DomainService instance.
list	SELECT	domainServiceName, resourceGroupName, subscriptionId	The List of OuContainers in DomainService instance.
create	INSERT	domainServiceName, ouContainerName, resourceGroupName, subscriptionId	The Create OuContainer operation creates a new OuContainer under the specified Domain Service instance.
delete	DELETE	domainServiceName, ouContainerName, resourceGroupName, subscriptionId	The Delete OuContainer operation deletes specified OuContainer.
update	UPDATE	domainServiceName, ouContainerName, resourceGroupName, subscriptionId	The Update OuContainer operation can be used to update the existing OuContainers.

SELECT examples

The List of OuContainers in DomainService instance.

vw_ou_containers

SELECT
id,
name,
accounts,
container_id,
deployment_id,
distinguished_name,
domainServiceName,
domain_name,
ouContainerName,
provisioning_state,
resourceGroupName,
service_status,
subscriptionId,
tenant_id,
type
FROM azure.aad_domain_services.vw_ou_containers
WHERE domainServiceName = '{{ domainServiceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

ou_containers

SELECT
id,
name,
properties,
type
FROM azure.aad_domain_services.ou_containers
WHERE domainServiceName = '{{ domainServiceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.aad_domain_services.ou_containers (
domainServiceName,
ouContainerName,
resourceGroupName,
subscriptionId,
accountName,
spn,
password
)
SELECT 
'{{ domainServiceName }}',
'{{ ouContainerName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ accountName }}',
'{{ spn }}',
'{{ password }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: accountName
      value: string
    - name: spn
      value: string
    - name: password
      value: string

UPDATE example

Updates a ou_containers resource.

/*+ update */
UPDATE azure.aad_domain_services.ou_containers
SET 
accountName = '{{ accountName }}',
spn = '{{ spn }}',
password = '{{ password }}'
WHERE 
domainServiceName = '{{ domainServiceName }}'
AND ouContainerName = '{{ ouContainerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified ou_containers resource.

/*+ delete */
DELETE FROM azure.aad_domain_services.ou_containers
WHERE domainServiceName = '{{ domainServiceName }}'
AND ouContainerName = '{{ ouContainerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';