Skip to main content

standards

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

Overview

Namestandards
TypeResource
Idazure.security.standards

Fields

The following fields are returned by SELECT queries:

Security standard successfully created

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
propertiesobjectProperties of a security standard
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, standardIdGet a specific security standard for the requested scope by standardId
listselectscopeGet a list of all relevant security standards over a scope
create_or_updateinsertscope, standardIdCreates or updates a security standard over a given scope
deletedeletescope, standardIdDelete 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 scope of the standard assignment. Valid scopes are: management group (format: 'providers/Microsoft.Management/managementGroups/{managementGroup}'), subscription (format: 'subscriptions/{subscriptionId}'), or security connector (format: 'subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Security/securityConnectors/{securityConnectorName})'
standardIdstringThe Security Standard key - unique key for the standard type

SELECT examples

Get a specific security standard for the requested scope by standardId

SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.standards
WHERE scope = '{{ scope }}' -- required
AND standardId = '{{ standardId }}' -- required
;

INSERT examples

Creates or updates a security standard over a given scope

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

DELETE examples

Delete a security standard over a given scope

DELETE FROM azure.security.standards
WHERE scope = '{{ scope }}' --required
AND standardId = '{{ standardId }}' --required
;