application_security_groups

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

Overview

Name	application_security_groups
Type	Resource
Id	azure.network.application_security_groups

Fields

vw_application_security_groups

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
applicationSecurityGroupName	text	field from the properties object
etag	text	A unique read-only string that changes whenever the resource is updated.
location	text	Resource location.
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_guid	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
type	text	Resource type.

application_security_groups

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
etag	string	A unique read-only string that changes whenever the resource is updated.
location	string	Resource location.
properties	object	Application security group properties.
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	applicationSecurityGroupName, resourceGroupName, subscriptionId	Gets information about the specified application security group.
list	SELECT	resourceGroupName, subscriptionId	Gets all the application security groups in a resource group.
list_all	SELECT	subscriptionId	Gets all application security groups in a subscription.
create_or_update	INSERT	applicationSecurityGroupName, resourceGroupName, subscriptionId	Creates or updates an application security group.
delete	DELETE	applicationSecurityGroupName, resourceGroupName, subscriptionId	Deletes the specified application security group.
update_tags	EXEC	applicationSecurityGroupName, resourceGroupName, subscriptionId	Updates an application security group's tags.

SELECT examples

Gets all application security groups in a subscription.

vw_application_security_groups

SELECT
id,
name,
applicationSecurityGroupName,
etag,
location,
provisioning_state,
resourceGroupName,
resource_guid,
subscriptionId,
tags,
type
FROM azure.network.vw_application_security_groups
WHERE subscriptionId = '{{ subscriptionId }}';

application_security_groups

SELECT
id,
name,
etag,
location,
properties,
tags,
type
FROM azure.network.application_security_groups
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.network.application_security_groups (
applicationSecurityGroupName,
resourceGroupName,
subscriptionId,
properties,
id,
location,
tags
)
SELECT 
'{{ applicationSecurityGroupName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ id }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: resourceGuid
          value: string
        - name: provisioningState
          value: []
    - name: etag
      value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

DELETE example

Deletes the specified application_security_groups resource.

/*+ delete */
DELETE FROM azure.network.application_security_groups
WHERE applicationSecurityGroupName = '{{ applicationSecurityGroupName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';