workspace_managed_sql_server_vulnerability_assessments

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

Overview

Name	workspace_managed_sql_server_vulnerability_assessments
Type	Resource
Id	azure.synapse.workspace_managed_sql_server_vulnerability_assessments

Fields

vw_workspace_managed_sql_server_vulnerability_assessments

Name	Datatype	Description
recurring_scans	text	field from the properties object
resourceGroupName	text	field from the properties object
storage_account_access_key	text	field from the properties object
storage_container_path	text	field from the properties object
storage_container_sas_key	text	field from the properties object
subscriptionId	text	field from the properties object
vulnerabilityAssessmentName	text	field from the properties object
workspaceName	text	field from the properties object

workspace_managed_sql_server_vulnerability_assessments

Name	Datatype	Description
properties	object	Properties of a server Vulnerability Assessment.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, subscriptionId, vulnerabilityAssessmentName, workspaceName	Get workspace managed sql server's vulnerability assessment.
list	SELECT	resourceGroupName, subscriptionId, workspaceName	Lists the vulnerability assessment policies associated with a workspace managed sql server.
create_or_update	INSERT	resourceGroupName, subscriptionId, vulnerabilityAssessmentName, workspaceName	Create or Update workspace managed sql server's vulnerability assessment.
delete	DELETE	resourceGroupName, subscriptionId, vulnerabilityAssessmentName, workspaceName	Remove workspace managed sql server's vulnerability assessment.

SELECT examples

Lists the vulnerability assessment policies associated with a workspace managed sql server.

vw_workspace_managed_sql_server_vulnerability_assessments

SELECT
recurring_scans,
resourceGroupName,
storage_account_access_key,
storage_container_path,
storage_container_sas_key,
subscriptionId,
vulnerabilityAssessmentName,
workspaceName
FROM azure.synapse.vw_workspace_managed_sql_server_vulnerability_assessments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

workspace_managed_sql_server_vulnerability_assessments

SELECT
properties
FROM azure.synapse.workspace_managed_sql_server_vulnerability_assessments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.synapse.workspace_managed_sql_server_vulnerability_assessments (
resourceGroupName,
subscriptionId,
vulnerabilityAssessmentName,
workspaceName,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ vulnerabilityAssessmentName }}',
'{{ workspaceName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: storageContainerPath
          value: string
        - name: storageContainerSasKey
          value: string
        - name: storageAccountAccessKey
          value: string
        - name: recurringScans
          value:
            - name: isEnabled
              value: boolean
            - name: emailSubscriptionAdmins
              value: boolean
            - name: emails
              value:
                - string

DELETE example

Deletes the specified workspace_managed_sql_server_vulnerability_assessments resource.

/*+ delete */
DELETE FROM azure.synapse.workspace_managed_sql_server_vulnerability_assessments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}'
AND workspaceName = '{{ workspaceName }}';