Skip to main content

server_vulnerability_assessments

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

Overview

Nameserver_vulnerability_assessments
TypeResource
Idazure.security.server_vulnerability_assessments

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
propertiesobjectdescribes ServerVulnerabilityAssessment properties.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, resourceNamespace, resourceType, resourceName, serverVulnerabilityAssessmentapi-versionGets a server vulnerability assessment onboarding statuses on a given resource.
list_by_extended_resourceselectsubscriptionId, resourceGroupName, resourceNamespace, resourceType, resourceNameapi-versionGets a list of server vulnerability assessment onboarding statuses on a given resource.
create_or_updateinsertsubscriptionId, resourceGroupName, resourceNamespace, resourceType, resourceName, serverVulnerabilityAssessmentapi-versionCreating a server vulnerability assessment on a resource, which will onboard a resource for having a vulnerability assessment on it
deletedeletesubscriptionId, resourceGroupName, resourceNamespace, resourceType, resourceName, serverVulnerabilityAssessmentapi-versionRemoving server vulnerability assessment from a resource.

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.

NameDatatypeDescription
resourceGroupNamestringThe name of the resource group within the user's subscription. The name is case insensitive.
resourceNamestringName of the resource.
resourceNamespacestringThe Namespace of the resource.
resourceTypestringThe type of the resource.
serverVulnerabilityAssessmentstringServerVulnerabilityAssessment status. only a 'default' value is supported.
subscriptionIdstringAzure subscription ID
api-versionstringAPI version for the operation

SELECT examples

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

SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.server_vulnerability_assessments
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND resourceNamespace = '{{ resourceNamespace }}' -- required
AND resourceType = '{{ resourceType }}' -- required
AND resourceName = '{{ resourceName }}' -- required
AND serverVulnerabilityAssessment = '{{ serverVulnerabilityAssessment }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

Creating a server vulnerability assessment on a resource, which will onboard a resource for having a vulnerability assessment on it

INSERT INTO azure.security.server_vulnerability_assessments (
subscriptionId,
resourceGroupName,
resourceNamespace,
resourceType,
resourceName,
serverVulnerabilityAssessment,
api-version
)
SELECT
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ resourceNamespace }}',
'{{ resourceType }}',
'{{ resourceName }}',
'{{ serverVulnerabilityAssessment }}',
'{{ api-version }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Removing server vulnerability assessment from a resource.

DELETE FROM azure.security.server_vulnerability_assessments
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND resourceNamespace = '{{ resourceNamespace }}' --required
AND resourceType = '{{ resourceType }}' --required
AND resourceName = '{{ resourceName }}' --required
AND serverVulnerabilityAssessment = '{{ serverVulnerabilityAssessment }}' --required
AND api-version = '{{ api-version }}'
;