Skip to main content

security_operators

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

Overview

Namesecurity_operators
TypeResource
Idazure.security.security_operators

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.
identityobjectIdentity for the resource.
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
getselectpricing_name, security_operator_name, subscription_idGet a specific security operator for the requested scope.
listselectpricing_name, subscription_idLists Microsoft Defender for Cloud securityOperators in the subscription.
create_or_updateinsertpricing_name, security_operator_name, subscription_idCreates Microsoft Defender for Cloud security operator on the given scope.
create_or_updatereplacepricing_name, security_operator_name, subscription_idCreates Microsoft Defender for Cloud security operator on the given scope.
deletedeletepricing_name, security_operator_name, subscription_idDelete Microsoft Defender for Cloud securityOperator in the subscription.

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
pricing_namestringName of the pricing configuration. Required.
security_operator_namestringName of the security operator. Required.
subscription_idstring

SELECT examples

Get a specific security operator for the requested scope.

SELECT
id,
name,
identity,
systemData,
type
FROM azure.security.security_operators
WHERE pricing_name = '{{ pricing_name }}' -- required
AND security_operator_name = '{{ security_operator_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates Microsoft Defender for Cloud security operator on the given scope.

INSERT INTO azure.security.security_operators (
pricing_name,
security_operator_name,
subscription_id
)
SELECT
'{{ pricing_name }}',
'{{ security_operator_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
identity,
systemData,
type
;

REPLACE examples

Creates Microsoft Defender for Cloud security operator on the given scope.

REPLACE azure.security.security_operators
SET
-- No updatable properties
WHERE
pricing_name = '{{ pricing_name }}' --required
AND security_operator_name = '{{ security_operator_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
identity,
systemData,
type;

DELETE examples

Delete Microsoft Defender for Cloud securityOperator in the subscription.

DELETE FROM azure.security.security_operators
WHERE pricing_name = '{{ pricing_name }}' --required
AND security_operator_name = '{{ security_operator_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;