Skip to main content

export_configurations

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

Overview

Nameexport_configurations
TypeResource
Idazure.application_insights.export_configurations

Fields

The following fields are returned by SELECT queries:

The Continuous Export configuration for this export id.

NameDatatypeDescription
ApplicationNamestringThe name of the Application Insights component.
ContainerNamestringThe name of the destination storage container.
DestinationAccountIdstringThe name of destination account.
DestinationStorageLocationIdstringThe destination account location ID.
DestinationStorageSubscriptionIdstringThe destination storage account subscription ID.
DestinationTypestringThe destination type.
ExportIdstringThe unique ID of the export configuration inside an Application Insights component. It is auto generated when the Continuous Export configuration is created.
ExportStatusstringThis indicates current Continuous Export configuration status. The possible values are 'Preparing', 'Success', 'Failure'.
InstrumentationKeystringThe instrumentation key of the Application Insights component.
IsUserEnabledstringThis will be 'true' if the Continuous Export configuration is enabled, otherwise it will be 'false'.
LastGapTimestringThe last time the Continuous Export configuration started failing.
LastSuccessTimestringThe last time data was successfully delivered to the destination storage container for this Continuous Export configuration.
LastUserUpdatestringLast time the Continuous Export configuration was updated.
NotificationQueueEnabledstringDeprecated
PermanentErrorReasonstringThis is the reason the Continuous Export configuration started failing. It can be 'AzureStorageNotFound' or 'AzureStorageAccessDenied'.
RecordTypesstringThis comma separated list of document types that will be exported. The possible values include 'Requests', 'Event', 'Exceptions', 'Metrics', 'PageViews', 'PageViewPerformance', 'Rdd', 'PerformanceCounters', 'Availability', 'Messages'.
ResourceGroupstringThe resource group of the Application Insights component.
StorageNamestringThe name of the destination storage account.
SubscriptionIdstringThe subscription of the Application Insights component.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, subscriptionId, resourceName, exportIdGet the Continuous Export configuration for this export id.
listselectresourceGroupName, subscriptionId, resourceNameGets a list of Continuous Export configuration of an Application Insights component.
createinsertresourceGroupName, subscriptionId, resourceNameCreate a Continuous Export configuration of an Application Insights component.
updatereplaceresourceGroupName, subscriptionId, resourceName, exportIdUpdate the Continuous Export configuration for this export id.
deletedeleteresourceGroupName, subscriptionId, resourceName, exportIdDelete a Continuous Export configuration of an Application Insights component.

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
exportIdstringThe Continuous Export configuration ID. This is unique within a Application Insights component.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
resourceNamestringThe name of the Application Insights component resource.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get the Continuous Export configuration for this export id.

SELECT
ApplicationName,
ContainerName,
DestinationAccountId,
DestinationStorageLocationId,
DestinationStorageSubscriptionId,
DestinationType,
ExportId,
ExportStatus,
InstrumentationKey,
IsUserEnabled,
LastGapTime,
LastSuccessTime,
LastUserUpdate,
NotificationQueueEnabled,
PermanentErrorReason,
RecordTypes,
ResourceGroup,
StorageName,
SubscriptionId
FROM azure.application_insights.export_configurations
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND resourceName = '{{ resourceName }}' -- required
AND exportId = '{{ exportId }}' -- required
;

INSERT examples

Create a Continuous Export configuration of an Application Insights component.

INSERT INTO azure.application_insights.export_configurations (
data__RecordTypes,
data__DestinationType,
data__DestinationAddress,
data__IsEnabled,
data__NotificationQueueEnabled,
data__NotificationQueueUri,
data__DestinationStorageSubscriptionId,
data__DestinationStorageLocationId,
data__DestinationAccountId,
resourceGroupName,
subscriptionId,
resourceName
)
SELECT
'{{ RecordTypes }}',
'{{ DestinationType }}',
'{{ DestinationAddress }}',
'{{ IsEnabled }}',
'{{ NotificationQueueEnabled }}',
'{{ NotificationQueueUri }}',
'{{ DestinationStorageSubscriptionId }}',
'{{ DestinationStorageLocationId }}',
'{{ DestinationAccountId }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ resourceName }}'
RETURNING
ApplicationName,
ContainerName,
DestinationAccountId,
DestinationStorageLocationId,
DestinationStorageSubscriptionId,
DestinationType,
ExportId,
ExportStatus,
InstrumentationKey,
IsUserEnabled,
LastGapTime,
LastSuccessTime,
LastUserUpdate,
NotificationQueueEnabled,
PermanentErrorReason,
RecordTypes,
ResourceGroup,
StorageName,
SubscriptionId
;

REPLACE examples

Update the Continuous Export configuration for this export id.

REPLACE azure.application_insights.export_configurations
SET
data__RecordTypes = '{{ RecordTypes }}',
data__DestinationType = '{{ DestinationType }}',
data__DestinationAddress = '{{ DestinationAddress }}',
data__IsEnabled = '{{ IsEnabled }}',
data__NotificationQueueEnabled = '{{ NotificationQueueEnabled }}',
data__NotificationQueueUri = '{{ NotificationQueueUri }}',
data__DestinationStorageSubscriptionId = '{{ DestinationStorageSubscriptionId }}',
data__DestinationStorageLocationId = '{{ DestinationStorageLocationId }}',
data__DestinationAccountId = '{{ DestinationAccountId }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND resourceName = '{{ resourceName }}' --required
AND exportId = '{{ exportId }}' --required
RETURNING
ApplicationName,
ContainerName,
DestinationAccountId,
DestinationStorageLocationId,
DestinationStorageSubscriptionId,
DestinationType,
ExportId,
ExportStatus,
InstrumentationKey,
IsUserEnabled,
LastGapTime,
LastSuccessTime,
LastUserUpdate,
NotificationQueueEnabled,
PermanentErrorReason,
RecordTypes,
ResourceGroup,
StorageName,
SubscriptionId;

DELETE examples

Delete a Continuous Export configuration of an Application Insights component.

DELETE FROM azure.application_insights.export_configurations
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND resourceName = '{{ resourceName }}' --required
AND exportId = '{{ exportId }}' --required
;