database_vulnerability_assessment_rule_baselines

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

Overview

Name	database_vulnerability_assessment_rule_baselines
Type	Resource
Id	azure.sql.database_vulnerability_assessment_rule_baselines

Fields

vw_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
resourceGroupName	text	field from the properties object
ruleId	text	field from the properties object
serverName	text	field from the properties object
subscriptionId	text	field from the properties object
vulnerabilityAssessmentName	text	field from the properties object

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, resourceGroupName, ruleId, serverName, subscriptionId, vulnerabilityAssessmentName	Gets a database's vulnerability assessment rule baseline.
create_or_update	INSERT	baselineName, databaseName, resourceGroupName, ruleId, serverName, subscriptionId, vulnerabilityAssessmentName	Creates or updates a database's vulnerability assessment rule baseline.
delete	DELETE	baselineName, databaseName, resourceGroupName, ruleId, serverName, subscriptionId, vulnerabilityAssessmentName	Removes the database's vulnerability assessment rule baseline.

SELECT examples

Gets a database's vulnerability assessment rule baseline.

vw_database_vulnerability_assessment_rule_baselines

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

database_vulnerability_assessment_rule_baselines

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.database_vulnerability_assessment_rule_baselines (
baselineName,
databaseName,
resourceGroupName,
ruleId,
serverName,
subscriptionId,
vulnerabilityAssessmentName,
properties
)
SELECT 
'{{ baselineName }}',
'{{ databaseName }}',
'{{ resourceGroupName }}',
'{{ ruleId }}',
'{{ serverName }}',
'{{ 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 database_vulnerability_assessment_rule_baselines resource.

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