network_security_perimeter_configurations

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

Overview

Name	network_security_perimeter_configurations
Type	Resource
Id	azure.sql.network_security_perimeter_configurations

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
networkSecurityPerimeter	object	:vartype network_security_perimeter: ~azure.mgmt.sql.models.NSPConfigPerimeter
profile	object	:vartype profile: ~azure.mgmt.sql.models.NSPConfigProfile
provisioningIssues	array	:vartype provisioning_issues: list[~azure.mgmt.sql.models.NSPProvisioningIssue]
provisioningState	string	:vartype provisioning_state: str
resourceAssociation	object	:vartype resource_association: ~azure.mgmt.sql.models.NSPConfigAssociation
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list_by_server

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
networkSecurityPerimeter	object	:vartype network_security_perimeter: ~azure.mgmt.sql.models.NSPConfigPerimeter
profile	object	:vartype profile: ~azure.mgmt.sql.models.NSPConfigProfile
provisioningIssues	array	:vartype provisioning_issues: list[~azure.mgmt.sql.models.NSPProvisioningIssue]
provisioningState	string	:vartype provisioning_state: str
resourceAssociation	object	:vartype resource_association: ~azure.mgmt.sql.models.NSPConfigAssociation
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, server_name, nsp_config_name, subscription_id		Gets a network security perimeter configuration.
list_by_server	select	resource_group_name, server_name, subscription_id		Gets a list of NSP configurations for a server.
reconcile	exec	resource_group_name, server_name, nsp_config_name, subscription_id		Reconcile network security perimeter configuration for SQL Resource Provider.

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.

Name	Datatype	Description
nsp_config_name	string	Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
server_name	string	The name of the server. Required.
subscription_id	string

SELECT examples

get

Gets a network security perimeter configuration.

SELECT
id,
name,
networkSecurityPerimeter,
profile,
provisioningIssues,
provisioningState,
resourceAssociation,
systemData,
type
FROM azure.sql.network_security_perimeter_configurations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND server_name = '{{ server_name }}' -- required
AND nsp_config_name = '{{ nsp_config_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_server

Gets a list of NSP configurations for a server.

SELECT
id,
name,
networkSecurityPerimeter,
profile,
provisioningIssues,
provisioningState,
resourceAssociation,
systemData,
type
FROM azure.sql.network_security_perimeter_configurations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND server_name = '{{ server_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

Lifecycle Methods

reconcile

Reconcile network security perimeter configuration for SQL Resource Provider.

EXEC azure.sql.network_security_perimeter_configurations.reconcile 
@resource_group_name='{{ resource_group_name }}' --required, 
@server_name='{{ server_name }}' --required, 
@nsp_config_name='{{ nsp_config_name }}' --required, 
@subscription_id='{{ subscription_id }}' --required
;