managed_database_vulnerability_assessment_rule_baselines

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

Overview

Name	managed_database_vulnerability_assessment_rule_baselines
Type	Resource
Id	azure.sql.managed_database_vulnerability_assessment_rule_baselines

Fields

vw_managed_database_vulnerability_assessment_rule_baselines

Name	Datatype	Description
baselineName	text	field from the properties object
baseline_results	text	field from the properties object
databaseName	text	field from the properties object
managedInstanceName	text	field from the properties object
resourceGroupName	text	field from the properties object
ruleId	text	field from the properties object
subscriptionId	text	field from the properties object
vulnerabilityAssessmentName	text	field from the properties object

managed_database_vulnerability_assessment_rule_baselines

Name	Datatype	Description
properties	object	Properties of a database Vulnerability Assessment rule baseline.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	baselineName, databaseName, managedInstanceName, resourceGroupName, ruleId, subscriptionId, vulnerabilityAssessmentName	Gets a database's vulnerability assessment rule baseline.
create_or_update	INSERT	baselineName, databaseName, managedInstanceName, resourceGroupName, ruleId, subscriptionId, vulnerabilityAssessmentName	Creates or updates a database's vulnerability assessment rule baseline.
delete	DELETE	baselineName, databaseName, managedInstanceName, resourceGroupName, ruleId, subscriptionId, vulnerabilityAssessmentName	Removes the database's vulnerability assessment rule baseline.

SELECT examples

Gets a database's vulnerability assessment rule baseline.

vw_managed_database_vulnerability_assessment_rule_baselines

SELECT
baselineName,
baseline_results,
databaseName,
managedInstanceName,
resourceGroupName,
ruleId,
subscriptionId,
vulnerabilityAssessmentName
FROM azure.sql.vw_managed_database_vulnerability_assessment_rule_baselines
WHERE baselineName = '{{ baselineName }}'
AND databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND ruleId = '{{ ruleId }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}';

managed_database_vulnerability_assessment_rule_baselines

SELECT
properties
FROM azure.sql.managed_database_vulnerability_assessment_rule_baselines
WHERE baselineName = '{{ baselineName }}'
AND databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND ruleId = '{{ ruleId }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.managed_database_vulnerability_assessment_rule_baselines (
baselineName,
databaseName,
managedInstanceName,
resourceGroupName,
ruleId,
subscriptionId,
vulnerabilityAssessmentName,
properties
)
SELECT 
'{{ baselineName }}',
'{{ databaseName }}',
'{{ managedInstanceName }}',
'{{ resourceGroupName }}',
'{{ ruleId }}',
'{{ subscriptionId }}',
'{{ vulnerabilityAssessmentName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: baselineResults
          value:
            - - name: result
                value:
                  - string

DELETE example

Deletes the specified managed_database_vulnerability_assessment_rule_baselines resource.

/*+ delete */
DELETE FROM azure.sql.managed_database_vulnerability_assessment_rule_baselines
WHERE baselineName = '{{ baselineName }}'
AND databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND ruleId = '{{ ruleId }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}';