sql_vulnerability_assessment_baseline_rules

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

Overview

Name	sql_vulnerability_assessment_baseline_rules
Type	Resource
Id	azure.security.sql_vulnerability_assessment_baseline_rules

Fields

vw_sql_vulnerability_assessment_baseline_rules

Name	Datatype	Description
id	text	Resource Id
name	text	Resource name
resourceId	text	field from the properties object
results	text	field from the properties object
ruleId	text	field from the properties object
type	text	Resource type
workspaceId	text	field from the properties object

sql_vulnerability_assessment_baseline_rules

Name	Datatype	Description
id	string	Resource Id
name	string	Resource name
properties	object	Rule results properties.
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceId, ruleId, workspaceId
list	SELECT	resourceId, workspaceId
create_or_update	INSERT	resourceId, ruleId, workspaceId
delete	DELETE	resourceId, ruleId, workspaceId
add	EXEC	resourceId, workspaceId

SELECT examples

vw_sql_vulnerability_assessment_baseline_rules

SELECT
id,
name,
resourceId,
results,
ruleId,
type,
workspaceId
FROM azure.security.vw_sql_vulnerability_assessment_baseline_rules
WHERE resourceId = '{{ resourceId }}'
AND workspaceId = '{{ workspaceId }}';

sql_vulnerability_assessment_baseline_rules

SELECT
id,
name,
properties,
type
FROM azure.security.sql_vulnerability_assessment_baseline_rules
WHERE resourceId = '{{ resourceId }}'
AND workspaceId = '{{ workspaceId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.security.sql_vulnerability_assessment_baseline_rules (
resourceId,
ruleId,
workspaceId,
latestScan,
results
)
SELECT 
'{{ resourceId }}',
'{{ ruleId }}',
'{{ workspaceId }}',
{{ latestScan }},
'{{ results }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: latestScan
      value: boolean
    - name: results
      value:
        - array

DELETE example

Deletes the specified sql_vulnerability_assessment_baseline_rules resource.

/*+ delete */
DELETE FROM azure.security.sql_vulnerability_assessment_baseline_rules
WHERE resourceId = '{{ resourceId }}'
AND ruleId = '{{ ruleId }}'
AND workspaceId = '{{ workspaceId }}';