Skip to main content

scope_assignments

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

Overview

Namescope_assignments
TypeResource
Idazure.managed_network.scope_assignments

Fields

The following fields are returned by SELECT queries:

OK - Returns information about the scope assignment.

NameDatatypeDescription
propertiesobjectThe Scope Assignment properties

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectscope, scopeAssignmentNameGet the specified scope assignment.
listselectscopeGet the specified scope assignment.
create_or_updateinsertscope, scopeAssignmentNameCreates a scope assignment.
deletedeletescope, scopeAssignmentNameDeletes a scope assignment.

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
scopestringThe scope of the scope assignment to delete.
scopeAssignmentNamestringThe name of the scope assignment to delete.

SELECT examples

Get the specified scope assignment.

SELECT
properties
FROM azure.managed_network.scope_assignments
WHERE scope = '{{ scope }}' -- required
AND scopeAssignmentName = '{{ scopeAssignmentName }}' -- required
;

INSERT examples

Creates a scope assignment.

INSERT INTO azure.managed_network.scope_assignments (
data__properties,
scope,
scopeAssignmentName
)
SELECT
'{{ properties }}',
'{{ scope }}',
'{{ scopeAssignmentName }}'
RETURNING
properties
;

DELETE examples

Deletes a scope assignment.

DELETE FROM azure.managed_network.scope_assignments
WHERE scope = '{{ scope }}' --required
AND scopeAssignmentName = '{{ scopeAssignmentName }}' --required
;