Skip to main content

security_user_rule_collections

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

Overview

Namesecurity_user_rule_collections
TypeResource
Idazure.network.security_user_rule_collections

Fields

NameDatatypeDescription
idtextResource ID.
nametextResource name.
descriptiontextfield from the properties object
applies_to_groupstextfield from the properties object
configurationNametextfield from the properties object
etagtextA unique read-only string that changes whenever the resource is updated.
networkManagerNametextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
resource_guidtextfield from the properties object
ruleCollectionNametextfield from the properties object
subscriptionIdtextfield from the properties object
system_datatextfield from the properties object
typetextResource type.

Methods

NameAccessible byRequired ParamsDescription
getSELECTconfigurationName, networkManagerName, resourceGroupName, ruleCollectionName, subscriptionIdGets a network manager security user configuration rule collection.
listSELECTconfigurationName, networkManagerName, resourceGroupName, subscriptionIdLists all the security user rule collections in a security configuration, in a paginated format.
create_or_updateINSERTconfigurationName, networkManagerName, resourceGroupName, ruleCollectionName, subscriptionIdCreates or updates a security user rule collection.
deleteDELETEconfigurationName, networkManagerName, resourceGroupName, ruleCollectionName, subscriptionIdDeletes a Security User Rule collection.

SELECT examples

Lists all the security user rule collections in a security configuration, in a paginated format.

SELECT
id,
name,
description,
applies_to_groups,
configurationName,
etag,
networkManagerName,
provisioning_state,
resourceGroupName,
resource_guid,
ruleCollectionName,
subscriptionId,
system_data,
type
FROM azure.network.vw_security_user_rule_collections
WHERE configurationName = '{{ configurationName }}'
AND networkManagerName = '{{ networkManagerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

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

DELETE example

Deletes the specified security_user_rule_collections resource.

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