server_dev_ops_audit_settings

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

Overview

Name	server_dev_ops_audit_settings
Type	Resource
Id	azure.sql.server_dev_ops_audit_settings

Fields

vw_server_dev_ops_audit_settings

Name	Datatype	Description
devOpsAuditingSettingsName	text	field from the properties object
is_azure_monitor_target_enabled	text	field from the properties object
is_managed_identity_in_use	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
state	text	field from the properties object
storage_account_access_key	text	field from the properties object
storage_account_subscription_id	text	field from the properties object
storage_endpoint	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object

server_dev_ops_audit_settings

Name	Datatype	Description
properties	object	Properties of a server DevOps audit settings.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	devOpsAuditingSettingsName, resourceGroupName, serverName, subscriptionId	Gets a server's DevOps audit settings.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Lists DevOps audit settings of a server.
create_or_update	INSERT	devOpsAuditingSettingsName, resourceGroupName, serverName, subscriptionId	Creates or updates a server's DevOps audit settings.

SELECT examples

Lists DevOps audit settings of a server.

vw_server_dev_ops_audit_settings

SELECT
devOpsAuditingSettingsName,
is_azure_monitor_target_enabled,
is_managed_identity_in_use,
resourceGroupName,
serverName,
state,
storage_account_access_key,
storage_account_subscription_id,
storage_endpoint,
subscriptionId,
system_data
FROM azure.sql.vw_server_dev_ops_audit_settings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

server_dev_ops_audit_settings

SELECT
properties,
systemData
FROM azure.sql.server_dev_ops_audit_settings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new server_dev_ops_audit_settings resource.

All Properties

/*+ create */
INSERT INTO azure.sql.server_dev_ops_audit_settings (
devOpsAuditingSettingsName,
resourceGroupName,
serverName,
subscriptionId,
properties
)
SELECT 
'{{ devOpsAuditingSettingsName }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: isAzureMonitorTargetEnabled
          value: boolean
        - name: isManagedIdentityInUse
          value: boolean
        - name: state
          value: string
        - name: storageEndpoint
          value: string
        - name: storageAccountAccessKey
          value: string
        - name: storageAccountSubscriptionId
          value: string