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
;