server_vulnerability_assessments

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

Overview

Name	server_vulnerability_assessments
Type	Resource
Id	azure.security.server_vulnerability_assessments

Fields

vw_server_vulnerability_assessments

Name	Datatype	Description
id	text	Resource Id
name	text	Resource name
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
resourceName	text	field from the properties object
resourceNamespace	text	field from the properties object
resourceType	text	field from the properties object
serverVulnerabilityAssessment	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Resource type

server_vulnerability_assessments

Name	Datatype	Description
id	string	Resource Id
name	string	Resource name
properties	object	describes ServerVulnerabilityAssessment properties.
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourceName, resourceNamespace, resourceType, serverVulnerabilityAssessment, subscriptionId	Gets a server vulnerability assessment onboarding statuses on a given resource.
list_by_extended_resource	SELECT	resourceGroupName, resourceName, resourceNamespace, resourceType, subscriptionId	Gets a list of server vulnerability assessment onboarding statuses on a given resource.
create_or_update	INSERT	resourceGroupName, resourceName, resourceNamespace, resourceType, serverVulnerabilityAssessment, subscriptionId	Creating a server vulnerability assessment on a resource, which will onboard a resource for having a vulnerability assessment on it
delete	DELETE	resourceGroupName, resourceName, resourceNamespace, resourceType, serverVulnerabilityAssessment, subscriptionId	Removing server vulnerability assessment from a resource.

SELECT examples

Gets a list of server vulnerability assessment onboarding statuses on a given resource.

vw_server_vulnerability_assessments

SELECT
id,
name,
provisioning_state,
resourceGroupName,
resourceName,
resourceNamespace,
resourceType,
serverVulnerabilityAssessment,
subscriptionId,
type
FROM azure.security.vw_server_vulnerability_assessments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND resourceNamespace = '{{ resourceNamespace }}'
AND resourceType = '{{ resourceType }}'
AND subscriptionId = '{{ subscriptionId }}';

server_vulnerability_assessments

SELECT
id,
name,
properties,
type
FROM azure.security.server_vulnerability_assessments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND resourceNamespace = '{{ resourceNamespace }}'
AND resourceType = '{{ resourceType }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.security.server_vulnerability_assessments (
resourceGroupName,
resourceName,
resourceNamespace,
resourceType,
serverVulnerabilityAssessment,
subscriptionId
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ resourceNamespace }}',
'{{ resourceType }}',
'{{ serverVulnerabilityAssessment }}',
'{{ subscriptionId }}'
;

Manifest

- name: your_resource_model_name
  props: []

DELETE example

Deletes the specified server_vulnerability_assessments resource.

/*+ delete */
DELETE FROM azure.security.server_vulnerability_assessments
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND resourceNamespace = '{{ resourceNamespace }}'
AND resourceType = '{{ resourceType }}'
AND serverVulnerabilityAssessment = '{{ serverVulnerabilityAssessment }}'
AND subscriptionId = '{{ subscriptionId }}';