Skip to main content

security_standards

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

Overview

Namesecurity_standards
TypeResource
Idazure.security.security_standards

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
assessmentsarrayList of assessment keys to apply to standard scope.
cloudProvidersarrayList of all standard supported clouds.
descriptionstringDescription of the standard.
displayNamestringDisplay name of the standard, equivalent to the standardId.
metadataobjectThe security standard metadata.
policySetDefinitionIdstringThe policy set definition id associated with the standard.
standardTypestringStandard type (Custom or Default or Compliance only currently). Known values are: "Custom", "Default", and "Compliance". (Custom, Default, Compliance)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectscope, standard_idGet a specific security standard for the requested scope by standardId.
listselectscopeGet a list of all relevant security standards over a scope.
create_or_updateinsertscope, standard_idCreates or updates a security standard over a given scope.
create_or_updatereplacescope, standard_idCreates or updates a security standard over a given scope.
deletedeletescope, standard_idDelete a security standard over a given scope.

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.

NameDatatypeDescription
scopestringThe fully qualified Azure Resource manager identifier of the resource. Required.
standard_idstringThe Security Standard key - unique key for the standard type. Required.

SELECT examples

Get a specific security standard for the requested scope by standardId.

SELECT
id,
name,
assessments,
cloudProviders,
description,
displayName,
metadata,
policySetDefinitionId,
standardType,
systemData,
type
FROM azure.security.security_standards
WHERE scope = '{{ scope }}' -- required
AND standard_id = '{{ standard_id }}' -- required
;

INSERT examples

Creates or updates a security standard over a given scope.

INSERT INTO azure.security.security_standards (
properties,
scope,
standard_id
)
SELECT
'{{ properties }}',
'{{ scope }}',
'{{ standard_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Creates or updates a security standard over a given scope.

REPLACE azure.security.security_standards
SET
properties = '{{ properties }}'
WHERE
scope = '{{ scope }}' --required
AND standard_id = '{{ standard_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Delete a security standard over a given scope.

DELETE FROM azure.security.security_standards
WHERE scope = '{{ scope }}' --required
AND standard_id = '{{ standard_id }}' --required
;