security_policies

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

Overview

Name	security_policies
Type	Resource
Id	azure.cdn.security_policies

Fields

vw_security_policies

Name	Datatype	Description
deployment_status	text	field from the properties object
parameters	text	field from the properties object
profileName	text	field from the properties object
profile_name	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
securityPolicyName	text	field from the properties object
subscriptionId	text	field from the properties object

security_policies

Name	Datatype	Description
properties	object	The json object that contains properties required to create a security policy

Methods

Name	Accessible by	Required Params	Description
get	SELECT	profileName, resourceGroupName, securityPolicyName, subscriptionId	Gets an existing security policy within a profile.
list_by_profile	SELECT	profileName, resourceGroupName, subscriptionId	Lists security policies associated with the profile
create	INSERT	profileName, resourceGroupName, securityPolicyName, subscriptionId	Creates a new security policy within the specified profile.
delete	DELETE	profileName, resourceGroupName, securityPolicyName, subscriptionId	Deletes an existing security policy within profile.
patch	UPDATE	profileName, resourceGroupName, securityPolicyName, subscriptionId	Updates an existing security policy within a profile.

SELECT examples

Lists security policies associated with the profile

vw_security_policies

SELECT
deployment_status,
parameters,
profileName,
profile_name,
provisioning_state,
resourceGroupName,
securityPolicyName,
subscriptionId
FROM azure.cdn.vw_security_policies
WHERE profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

security_policies

SELECT
properties
FROM azure.cdn.security_policies
WHERE profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.cdn.security_policies (
profileName,
resourceGroupName,
securityPolicyName,
subscriptionId,
properties
)
SELECT 
'{{ profileName }}',
'{{ resourceGroupName }}',
'{{ securityPolicyName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: deploymentStatus
          value: string
        - name: profileName
          value: string
        - name: parameters
          value:
            - name: type
              value: string

UPDATE example

Updates a security_policies resource.

/*+ update */
UPDATE azure.cdn.security_policies
SET 
properties = '{{ properties }}'
WHERE 
profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND securityPolicyName = '{{ securityPolicyName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified security_policies resource.

/*+ delete */
DELETE FROM azure.cdn.security_policies
WHERE profileName = '{{ profileName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND securityPolicyName = '{{ securityPolicyName }}'
AND subscriptionId = '{{ subscriptionId }}';