Skip to main content

workspace_manager_assignment_jobs

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

Overview

Nameworkspace_manager_assignment_jobs
TypeResource
Idazure.security_insight.workspace_manager_assignment_jobs

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.
endTimestring (date-time)The time the job completed.
errorMessagestringMessage to describe error, if an error exists.
etagstringEtag of the azure resource.
items_arrayList of items published by the job.
provisioningStatestringState of the job. Known values are: "Accepted", "InProgress", "Succeeded", "Failed", and "Canceled". (Accepted, InProgress, Succeeded, Failed, Canceled)
startTimestring (date-time)The time the job started.
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, workspace_name, workspace_manager_assignment_name, job_name, subscription_idGets a job.
listselectresource_group_name, workspace_name, workspace_manager_assignment_name, subscription_id$orderby, $top, $skipTokenGet all jobs for the specified workspace manager assignment.
createinsertresource_group_name, workspace_name, workspace_manager_assignment_name, subscription_idCreate a job for the specified workspace manager assignment.
deletedeleteresource_group_name, workspace_name, workspace_manager_assignment_name, job_name, subscription_idDeletes the specified job from the specified workspace manager assignment.

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
job_namestringThe job name. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
workspace_manager_assignment_namestringThe name of the workspace manager assignment. Required.
workspace_namestringThe name of the workspace. Required.
$orderbystringSorts the results. Optional. Default value is None.
$skipTokenstringSkiptoken is only used if a previous operation returned a partial result. If a previous response contains a nextLink element, the value of the nextLink element will include a skiptoken parameter that specifies a starting point to use for subsequent calls. Optional. Default value is None.
$topintegerReturns only the first n results. Optional. Default value is None.

SELECT examples

Gets a job.

SELECT
id,
name,
endTime,
errorMessage,
etag,
items_,
provisioningState,
startTime,
systemData,
type
FROM azure.security_insight.workspace_manager_assignment_jobs
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND workspace_manager_assignment_name = '{{ workspace_manager_assignment_name }}' -- required
AND job_name = '{{ job_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a job for the specified workspace manager assignment.

INSERT INTO azure.security_insight.workspace_manager_assignment_jobs (
resource_group_name,
workspace_name,
workspace_manager_assignment_name,
subscription_id
)
SELECT
'{{ resource_group_name }}',
'{{ workspace_name }}',
'{{ workspace_manager_assignment_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
properties,
systemData,
type
;

DELETE examples

Deletes the specified job from the specified workspace manager assignment.

DELETE FROM azure.security_insight.workspace_manager_assignment_jobs
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND workspace_manager_assignment_name = '{{ workspace_manager_assignment_name }}' --required
AND job_name = '{{ job_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;