database_sql_vulnerability_assessment_rule_baselines

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

Overview

Name	database_sql_vulnerability_assessment_rule_baselines
Type	Resource
Id	azure.sql.database_sql_vulnerability_assessment_rule_baselines

Fields

vw_database_sql_vulnerability_assessment_rule_baselines

Name	Datatype	Description
baselineName	text	field from the properties object
databaseName	text	field from the properties object
resourceGroupName	text	field from the properties object
results	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
system_data	text	field from the properties object
vulnerabilityAssessmentName	text	field from the properties object

database_sql_vulnerability_assessment_rule_baselines

Name	Datatype	Description
properties	object	Properties of a database Sql Vulnerability Assessment rule baseline.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	baselineName, databaseName, resourceGroupName, ruleId, serverName, subscriptionId, vulnerabilityAssessmentName	Gets a database's sql vulnerability assessment rule baseline.
list_by_baseline	SELECT	baselineName, databaseName, resourceGroupName, serverName, subscriptionId, vulnerabilityAssessmentName	Gets a list of database's sql vulnerability assessment rule baselines.
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 list of database's sql vulnerability assessment rule baselines.

vw_database_sql_vulnerability_assessment_rule_baselines

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

database_sql_vulnerability_assessment_rule_baselines

SELECT
properties,
systemData
FROM azure.sql.database_sql_vulnerability_assessment_rule_baselines
WHERE baselineName = '{{ baselineName }}'
AND databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND vulnerabilityAssessmentName = '{{ vulnerabilityAssessmentName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.database_sql_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: 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: latestScan
          value: boolean
        - name: results
          value:
            - array

DELETE example

Deletes the specified database_sql_vulnerability_assessment_rule_baselines resource.

/*+ delete */
DELETE FROM azure.sql.database_sql_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 }}';