Skip to main content

insights

Creates, updates, deletes, gets or lists an insights resource.

Overview

Nameinsights
TypeResource
Idazure.impact_reporting.insights

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.
additionalDetailsobjectadditional details of the insight.
categorystringcategory of the insight. Required.
contentobjectContains title & description for the insight. Required.
eventIdstringIdentifier of the event that has been correlated with this insight. This can be used to aggregate insights for the same event.
eventTimestring (date-time)Time of the event, which has been correlated the impact.
groupIdstringIdentifier that can be used to group similar insights.
impactobjectdetails of of the impact for which insight has been generated. Required.
insightUniqueIdstringunique id of the insight. Required.
provisioningStatestringResource provisioning state. Known values are: "Succeeded", "Failed", and "Canceled". (Succeeded, Failed, Canceled)
statusstringstatus of the insight. example resolved, repaired, other.
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
getselectworkload_impact_name, insight_name, subscription_idGet Insight resources by workloadImpactName and insightName.
list_by_subscriptionselectworkload_impact_name, subscription_idList Insight resources by workloadImpactName.
createinsertworkload_impact_name, insight_name, subscription_idCreate Insight resource, This is Admin only operation.
deletedeleteworkload_impact_name, insight_name, subscription_idDelete Insight resource, This is Admin only operation.

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
insight_namestringName of the insight. Required.
subscription_idstring
workload_impact_namestringworkloadImpact resource. Required.

SELECT examples

Get Insight resources by workloadImpactName and insightName.

SELECT
id,
name,
additionalDetails,
category,
content,
eventId,
eventTime,
groupId,
impact,
insightUniqueId,
provisioningState,
status,
systemData,
type
FROM azure.impact_reporting.insights
WHERE workload_impact_name = '{{ workload_impact_name }}' -- required
AND insight_name = '{{ insight_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create Insight resource, This is Admin only operation.

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

DELETE examples

Delete Insight resource, This is Admin only operation.

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