Skip to main content

workload_impacts

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

Overview

Nameworkload_impacts
TypeResource
Idazure.impact_reporting.workload_impacts

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.
additionalPropertiesobjectAdditional fields related to impact, applicable fields per resource type are list under /impactCategories API.
armCorrelationIdsarrayThe ARM correlation ids, this is important field for control plane related impacts.
clientIncidentDetailsobjectClient incident details ex: incidentId , incident source.
confidenceLevelstringDegree of confidence on the impact being a platform issue. Known values are: "Low", "Medium", and "High". (Low, Medium, High)
connectivityobjectDetails about connectivity issue. Applicable when root resource causing the issue is not identified. For example, when a VM is impacted due to a network issue, the impacted resource is identified as the VM, but the root cause is the network. In such cases, the connectivity field will have the details about the network issue.
endDateTimestring (date-time)Time at which impact has ended.
errorDetailsobjectARM error code and error message associated with the impact.
impactCategorystringCategory of the impact, details can found from /impactCategories API. Required.
impactDescriptionstringA detailed description of the impact.
impactGroupIdstringUse this field to group impacts.
impactUniqueIdstringUnique ID of the impact (UUID).
impactedResourceIdstringAzure resource id of the impacted resource. Required.
performancearrayDetails about performance issue. Applicable for performance impacts.
provisioningStatestringResource provisioning state. Known values are: "Succeeded", "Failed", and "Canceled". (Succeeded, Failed, Canceled)
reportedTimeUtcstring (date-time)Time at which impact is reported.
startDateTimestring (date-time)Time at which impact was observed. Required.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
workloadobjectInformation about the impacted workload.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectworkload_impact_name, subscription_idGet a WorkloadImpact.
list_by_subscriptionselectsubscription_idList WorkloadImpact resources by subscription ID.
createinsertworkload_impact_name, subscription_idCreate a WorkloadImpact.
deletedeleteworkload_impact_name, subscription_idDelete a WorkloadImpact.

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
subscription_idstring
workload_impact_namestringworkloadImpact resource. Required.

SELECT examples

Get a WorkloadImpact.

SELECT
id,
name,
additionalProperties,
armCorrelationIds,
clientIncidentDetails,
confidenceLevel,
connectivity,
endDateTime,
errorDetails,
impactCategory,
impactDescription,
impactGroupId,
impactUniqueId,
impactedResourceId,
performance,
provisioningState,
reportedTimeUtc,
startDateTime,
systemData,
type,
workload
FROM azure.impact_reporting.workload_impacts
WHERE workload_impact_name = '{{ workload_impact_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a WorkloadImpact.

INSERT INTO azure.impact_reporting.workload_impacts (
properties,
workload_impact_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ workload_impact_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Delete a WorkloadImpact.

DELETE FROM azure.impact_reporting.workload_impacts
WHERE workload_impact_name = '{{ workload_impact_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;