standards

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

Overview

Name	standards
Type	Resource
Id	azure.security.standards

Fields

vw_standards

Name	Datatype	Description
id	text	Resource Id
name	text	Resource name
description	text	field from the properties object
assessments	text	field from the properties object
cloud_providers	text	field from the properties object
display_name	text	field from the properties object
metadata	text	field from the properties object
policy_set_definition_id	text	field from the properties object
scope	text	field from the properties object
standardId	text	field from the properties object
standard_type	text	field from the properties object
type	text	Resource type

standards

Name	Datatype	Description
id	string	Resource Id
name	string	Resource name
properties	object	Describes properties of a standard.
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	scope, standardId	Get a specific security standard for the requested scope by standardId
list	SELECT	scope	Get a list of all relevant security standards over a scope
create_or_update	INSERT	scope, standardId	Creates or updates a security standard over a given scope
delete	DELETE	scope, standardId	Delete a security standard over a given scope

SELECT examples

Get a list of all relevant security standards over a scope

vw_standards

SELECT
id,
name,
description,
assessments,
cloud_providers,
display_name,
metadata,
policy_set_definition_id,
scope,
standardId,
standard_type,
type
FROM azure.security.vw_standards
WHERE scope = '{{ scope }}';

standards

SELECT
id,
name,
properties,
type
FROM azure.security.standards
WHERE scope = '{{ scope }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.security.standards (
scope,
standardId,
properties
)
SELECT 
'{{ scope }}',
'{{ standardId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: displayName
          value: string
        - name: standardType
          value: string
        - name: description
          value: string
        - name: assessments
          value:
            - - name: assessmentKey
                value: string
        - name: cloudProviders
          value:
            - []
        - name: policySetDefinitionId
          value: string
        - name: metadata
          value:
            - name: createdBy
              value: string
            - name: createdOn
              value: string
            - name: lastUpdatedBy
              value: string
            - name: lastUpdatedOn
              value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

DELETE example

Deletes the specified standards resource.

/*+ delete */
DELETE FROM azure.security.standards
WHERE scope = '{{ scope }}'
AND standardId = '{{ standardId }}';