Skip to main content

vw_security_rules

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

Overview​

Namevw_security_rules
TypeView
Idazure.network.vw_security_rules

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
id as id,
name as name,
etag as etag,
type as type,
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.protocol') as "protocol",
JSON_EXTRACT(properties, '$.sourcePortRange') as "source_port_range",
JSON_EXTRACT(properties, '$.destinationPortRange') as "destination_port_range",
JSON_EXTRACT(properties, '$.sourceAddressPrefix') as "source_address_prefix",
JSON_EXTRACT(properties, '$.sourceAddressPrefixes') as "source_address_prefixes",
JSON_EXTRACT(properties, '$.sourceApplicationSecurityGroups') as "source_application_security_groups",
JSON_EXTRACT(properties, '$.destinationAddressPrefix') as "destination_address_prefix",
JSON_EXTRACT(properties, '$.destinationAddressPrefixes') as "destination_address_prefixes",
JSON_EXTRACT(properties, '$.destinationApplicationSecurityGroups') as "destination_application_security_groups",
JSON_EXTRACT(properties, '$.sourcePortRanges') as "source_port_ranges",
JSON_EXTRACT(properties, '$.destinationPortRanges') as "destination_port_ranges",
JSON_EXTRACT(properties, '$.access') as "access",
JSON_EXTRACT(properties, '$.priority') as "priority",
JSON_EXTRACT(properties, '$.direction') as "direction",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
networkSecurityGroupName,
securityRuleName
FROM azure.network.security_rules
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND networkSecurityGroupName = 'replace-me';