vulnerability_assessments_settings

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

Overview

Name	vulnerability_assessments_settings
Type	Resource
Id	azure.sql.vulnerability_assessments_settings

Fields

vw_vulnerability_assessments_settings

Name	Datatype	Description
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
vulnerabilityAssessmentName	text	field from the properties object

vulnerability_assessments_settings

Name	Datatype	Description
properties	object
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, serverName, subscriptionId, vulnerabilityAssessmentName	Gets SQL Vulnerability Assessment policy.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Lists SQL Vulnerability Assessment policies associated with a server.
create_or_update	INSERT	resourceGroupName, serverName, subscriptionId, vulnerabilityAssessmentName	Creates or updates SQL Vulnerability Assessment policy.

SELECT examples

Lists SQL Vulnerability Assessment policies associated with a server.

vw_vulnerability_assessments_settings

SELECT
resourceGroupName,
serverName,
state,
subscriptionId,
system_data,
vulnerabilityAssessmentName
FROM azure.sql.vw_vulnerability_assessments_settings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

vulnerability_assessments_settings

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.vulnerability_assessments_settings (
resourceGroupName,
serverName,
subscriptionId,
vulnerabilityAssessmentName,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ vulnerabilityAssessmentName }}',
'{{ 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: state
          value: string