Skip to main content

server_vulnerability_assessment

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

Overview

Nameserver_vulnerability_assessment
TypeResource
Idazure.security.server_vulnerability_assessment

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
provisioningStatestringThe provisioningState of the vulnerability assessment capability on the VM. Known values are: "Succeeded", "Failed", "Canceled", "Provisioning", and "Deprovisioning". (Succeeded, Failed, Canceled, Provisioning, Deprovisioning)
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
getselectresource_group_name, resource_namespace, resource_type, resource_name, subscription_idGets a server vulnerability assessment onboarding statuses on a given resource.
create_or_updateinsertresource_group_name, resource_namespace, resource_type, resource_name, subscription_idCreating a server vulnerability assessment on a resource, which will onboard a resource for having a vulnerability assessment on it.
create_or_updatereplaceresource_group_name, resource_namespace, resource_type, resource_name, subscription_idCreating a server vulnerability assessment on a resource, which will onboard a resource for having a vulnerability assessment on it.
deletedeleteresource_group_name, resource_namespace, resource_type, resource_name, subscription_idRemoving server vulnerability assessment from a resource.
list_by_extended_resourceexecresource_group_name, resource_namespace, resource_type, resource_name, subscription_idGets a list of server vulnerability assessment onboarding statuses on a given 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
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
resource_namestringThe name of the resource. Required.
resource_namespacestringThe parent resource provider namespace. Required.
resource_typestringThe type of the resource. Required.
subscription_idstring

SELECT examples

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

SELECT
id,
name,
provisioningState,
systemData,
type
FROM azure.security.server_vulnerability_assessment
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND resource_namespace = '{{ resource_namespace }}' -- required
AND resource_type = '{{ resource_type }}' -- required
AND resource_name = '{{ resource_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

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_assessment (
resource_group_name,
resource_namespace,
resource_type,
resource_name,
subscription_id
)
SELECT
'{{ resource_group_name }}',
'{{ resource_namespace }}',
'{{ resource_type }}',
'{{ resource_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

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

REPLACE azure.security.server_vulnerability_assessment
SET
-- No updatable properties
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND resource_namespace = '{{ resource_namespace }}' --required
AND resource_type = '{{ resource_type }}' --required
AND resource_name = '{{ resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Removing server vulnerability assessment from a resource.

DELETE FROM azure.security.server_vulnerability_assessment
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND resource_namespace = '{{ resource_namespace }}' --required
AND resource_type = '{{ resource_type }}' --required
AND resource_name = '{{ resource_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

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

EXEC azure.security.server_vulnerability_assessment.list_by_extended_resource 
@resource_group_name='{{ resource_group_name }}' --required,
@resource_namespace='{{ resource_namespace }}' --required,
@resource_type='{{ resource_type }}' --required,
@resource_name='{{ resource_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;