Skip to main content

security_rules

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

Overview

Namesecurity_rules
TypeResource
Idazure.network.security_rules

Fields

The following fields are returned by SELECT queries:

Request successful. The operation returns the resulting SecurityRule resource.

NameDatatypeDescription
idstringResource ID.
namestringThe name of the resource that is unique within a resource group. This name can be used to access the resource.
etagstringA unique read-only string that changes whenever the resource is updated.
propertiesobjectProperties of the security rule.
typestringThe type of the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, networkSecurityGroupName, securityRuleName, subscriptionIdGet the specified network security rule.
listselectresourceGroupName, networkSecurityGroupName, subscriptionIdGets all security rules in a network security group.
create_or_updateinsertresourceGroupName, networkSecurityGroupName, securityRuleName, subscriptionIdCreates or updates a security rule in the specified network security group.
deletedeleteresourceGroupName, networkSecurityGroupName, securityRuleName, subscriptionIdDeletes the specified network security rule.

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
networkSecurityGroupNamestringThe name of the network security group.
resourceGroupNamestringThe name of the resource group.
securityRuleNamestringThe name of the security rule.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get the specified network security rule.

SELECT
id,
name,
etag,
properties,
type
FROM azure.network.security_rules
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND networkSecurityGroupName = '{{ networkSecurityGroupName }}' -- required
AND securityRuleName = '{{ securityRuleName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Creates or updates a security rule in the specified network security group.

INSERT INTO azure.network.security_rules (
data__properties,
data__name,
data__type,
data__id,
resourceGroupName,
networkSecurityGroupName,
securityRuleName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ name }}',
'{{ type }}',
'{{ id }}',
'{{ resourceGroupName }}',
'{{ networkSecurityGroupName }}',
'{{ securityRuleName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
etag,
properties,
type
;

DELETE examples

Deletes the specified network security rule.

DELETE FROM azure.network.security_rules
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND networkSecurityGroupName = '{{ networkSecurityGroupName }}' --required
AND securityRuleName = '{{ securityRuleName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;