security_user_rules

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

Overview

Name	security_user_rules
Type	Resource
Id	azure.network.security_user_rules

Fields

vw_security_user_rules

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
description	text	field from the properties object
configurationName	text	field from the properties object
destination_port_ranges	text	field from the properties object
destinations	text	field from the properties object
direction	text	field from the properties object
etag	text	A unique read-only string that changes whenever the resource is updated.
networkManagerName	text	field from the properties object
protocol	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_guid	text	field from the properties object
ruleCollectionName	text	field from the properties object
ruleName	text	field from the properties object
source_port_ranges	text	field from the properties object
sources	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
type	text	Resource type.

security_user_rules

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.
properties	object	Security rule resource.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	configurationName, networkManagerName, resourceGroupName, ruleCollectionName, ruleName, subscriptionId	Gets a security user rule.
list	SELECT	configurationName, networkManagerName, resourceGroupName, ruleCollectionName, subscriptionId	Lists all Security User Rules in a rule collection.
create_or_update	INSERT	configurationName, networkManagerName, resourceGroupName, ruleCollectionName, ruleName, subscriptionId	Creates or updates a security user rule.
delete	DELETE	configurationName, networkManagerName, resourceGroupName, ruleCollectionName, ruleName, subscriptionId	Deletes a security user rule.

SELECT examples

Lists all Security User Rules in a rule collection.

vw_security_user_rules

SELECT
id,
name,
description,
configurationName,
destination_port_ranges,
destinations,
direction,
etag,
networkManagerName,
protocol,
provisioning_state,
resourceGroupName,
resource_guid,
ruleCollectionName,
ruleName,
source_port_ranges,
sources,
subscriptionId,
system_data,
type
FROM azure.network.vw_security_user_rules
WHERE configurationName = '{{ configurationName }}'
AND networkManagerName = '{{ networkManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND ruleCollectionName = '{{ ruleCollectionName }}'
AND subscriptionId = '{{ subscriptionId }}';

security_user_rules

SELECT
id,
name,
etag,
properties,
systemData,
type
FROM azure.network.security_user_rules
WHERE configurationName = '{{ configurationName }}'
AND networkManagerName = '{{ networkManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND ruleCollectionName = '{{ ruleCollectionName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.network.security_user_rules (
configurationName,
networkManagerName,
resourceGroupName,
ruleCollectionName,
ruleName,
subscriptionId,
properties
)
SELECT 
'{{ configurationName }}',
'{{ networkManagerName }}',
'{{ resourceGroupName }}',
'{{ ruleCollectionName }}',
'{{ ruleName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: description
          value: string
        - name: protocol
          value: []
        - name: sources
          value:
            - - name: addressPrefix
                value: string
              - name: addressPrefixType
                value: string
        - name: destinations
          value:
            - - name: addressPrefix
                value: string
              - name: addressPrefixType
                value: string
        - name: sourcePortRanges
          value:
            - string
        - name: destinationPortRanges
          value:
            - string
        - name: direction
          value: []
        - name: provisioningState
          value: []
        - name: resourceGuid
          value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: etag
      value: string

DELETE example

Deletes the specified security_user_rules resource.

/*+ delete */
DELETE FROM azure.network.security_user_rules
WHERE configurationName = '{{ configurationName }}'
AND networkManagerName = '{{ networkManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND ruleCollectionName = '{{ ruleCollectionName }}'
AND ruleName = '{{ ruleName }}'
AND subscriptionId = '{{ subscriptionId }}';