Skip to main content

governance_rules

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

Overview

Namegovernance_rules
TypeResource
Idazure.security.governance_rules

Fields

The following fields are returned by SELECT queries:

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 governance rule
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, ruleIdapi-versionGet a specific governance rule for the requested scope by ruleId
listselectscopeapi-versionGet a list of all relevant governance rules over a scope
create_or_updateinsertscope, ruleIdapi-versionCreates or updates a governance rule over a given scope
deletedeletescope, ruleIdapi-versionDelete a Governance rule over a given scope
executeexecscope, ruleIdapi-versionExecute a governance rule
operation_resultsexecscope, ruleId, operationIdapi-versionGet governance rules long run operation result for the requested scope by ruleId and operationId

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
operationIdstringThe governance rule long running operation unique key
ruleIdstringThe governance rule key - unique key for the standard governance rule (GUID)
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})'
api-versionstringAPI version for the operation

SELECT examples

Get a specific governance rule for the requested scope by ruleId

SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.governance_rules
WHERE scope = '{{ scope }}' -- required
AND ruleId = '{{ ruleId }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

Creates or updates a governance rule over a given scope

INSERT INTO azure.security.governance_rules (
data__properties,
scope,
ruleId,
api-version
)
SELECT
'{{ properties }}',
'{{ scope }}',
'{{ ruleId }}',
'{{ api-version }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Delete a Governance rule over a given scope

DELETE FROM azure.security.governance_rules
WHERE scope = '{{ scope }}' --required
AND ruleId = '{{ ruleId }}' --required
AND api-version = '{{ api-version }}'
;

Lifecycle Methods

Execute a governance rule

EXEC azure.security.governance_rules.execute 
@scope='{{ scope }}' --required,
@ruleId='{{ ruleId }}' --required,
@api-version='{{ api-version }}'
@@json=
'{
"override": {{ override }}
}'
;