Skip to main content

application_security_groups

Creates, updates, deletes, gets or lists an application_security_groups resource.

Overview

Nameapplication_security_groups
TypeResource
Idazure.network.application_security_groups

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource ID.
namestringResource name.
etagstringA unique read-only string that changes whenever the resource is updated.
locationstringResource location.
provisioningStatestringThe provisioning state of the application security group resource. Known values are: "Failed", "Succeeded", "Canceled", "Creating", "Updating", and "Deleting". (Failed, Succeeded, Canceled, Creating, Updating, Deleting)
resourceGuidstringThe resource GUID property of the application security group resource. It uniquely identifies a resource, even if the user changes its name or migrate the resource across subscriptions or resource groups.
tagsobjectResource tags.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, application_security_group_name, subscription_idGets information about the specified application security group.
listselectresource_group_name, subscription_idGets all the application security groups in a resource group.
list_allselectsubscription_idGets all application security groups in a subscription.
create_or_updateinsertresource_group_name, application_security_group_name, subscription_idCreates or updates an application security group.
update_tagsupdateresource_group_name, application_security_group_name, subscription_idUpdates an application security group's tags.
create_or_updatereplaceresource_group_name, application_security_group_name, subscription_idCreates or updates an application security group.
deletedeleteresource_group_name, application_security_group_name, subscription_idDeletes the specified application security group.

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
application_security_group_namestringThe name of the application security group. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets information about the specified application security group.

SELECT
id,
name,
etag,
location,
provisioningState,
resourceGuid,
tags,
type
FROM azure.network.application_security_groups
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND application_security_group_name = '{{ application_security_group_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates an application security group.

INSERT INTO azure.network.application_security_groups (
id,
location,
tags,
properties,
resource_group_name,
application_security_group_name,
subscription_id
)
SELECT
'{{ id }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ application_security_group_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
location,
properties,
tags,
type
;

UPDATE examples

Updates an application security group's tags.

UPDATE azure.network.application_security_groups
SET
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND application_security_group_name = '{{ application_security_group_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
location,
properties,
tags,
type;

REPLACE examples

Creates or updates an application security group.

REPLACE azure.network.application_security_groups
SET
id = '{{ id }}',
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND application_security_group_name = '{{ application_security_group_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
location,
properties,
tags,
type;

DELETE examples

Deletes the specified application security group.

DELETE FROM azure.network.application_security_groups
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND application_security_group_name = '{{ application_security_group_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;