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

The following fields are returned by SELECT queries:

get

Successfully got the vulnerability assessment rule baseline.

Name	Datatype	Description
id	string (arm-id)	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties	object	Rule results properties.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

list

Successfully removed the database vulnerability assessment rule baseline.

Name	Datatype	Description
id	string (arm-id)	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties	object	Rule results properties.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	ruleId, workspaceId	api-version, resourceId
list	select	workspaceId	api-version, resourceId
create_or_update	insert	ruleId, workspaceId	api-version, resourceId
delete	delete	ruleId, workspaceId	api-version, resourceId
add	exec	workspaceId	api-version, resourceId

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
ruleId	string	The rule Id.
workspaceId	string	The workspace Id.
api-version	string	The api version.
resourceId	string	Optional filter for listing the assignments of a specific resource.

SELECT examples

get

Successfully got the vulnerability assessment rule baseline.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.sql_vulnerability_assessment_baseline_rules
WHERE ruleId = '{{ ruleId }}' -- required
AND workspaceId = '{{ workspaceId }}' -- required
AND api-version = '{{ api-version }}'
AND resourceId = '{{ resourceId }}'
;

list

Successfully removed the database vulnerability assessment rule baseline.

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

INSERT examples

create_or_update

No description available.

INSERT INTO azure.security.sql_vulnerability_assessment_baseline_rules (
data__latestScan,
data__results,
ruleId,
workspaceId,
api-version,
resourceId
)
SELECT 
{{ latestScan }},
'{{ results }}',
'{{ ruleId }}',
'{{ workspaceId }}',
'{{ api-version }}',
'{{ resourceId }}'
RETURNING
id,
name,
properties,
systemData,
type
;

Manifest

# Description fields are for documentation purposes
- name: sql_vulnerability_assessment_baseline_rules
  props:
    - name: ruleId
      value: string
      description: Required parameter for the sql_vulnerability_assessment_baseline_rules resource.
    - name: workspaceId
      value: string
      description: Required parameter for the sql_vulnerability_assessment_baseline_rules resource.
    - name: latestScan
      value: boolean
      description: |
        Take results from latest scan.
    - name: results
      value: array
      description: |
        Expected results to be inserted into the baseline.
        Leave this field empty it LatestScan == true.
    - name: api-version
      value: string
      description: The api version.
    - name: resourceId
      value: string
      description: Optional filter for listing the assignments of a specific resource.

DELETE examples

delete

No description available.

DELETE FROM azure.security.sql_vulnerability_assessment_baseline_rules
WHERE ruleId = '{{ ruleId }}' --required
AND workspaceId = '{{ workspaceId }}' --required
AND api-version = '{{ api-version }}'
AND resourceId = '{{ resourceId }}'
;

Lifecycle Methods

add

Successfully removed the database vulnerability assessment rule baseline.

EXEC azure.security.sql_vulnerability_assessment_baseline_rules.add 
@workspaceId='{{ workspaceId }}' --required, 
@api-version='{{ api-version }}', 
@resourceId='{{ resourceId }}' 
@@json=
'{
"latestScan": {{ latestScan }}, 
"results": "{{ results }}"
}'
;