Skip to main content

data_exports

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

Overview

Namedata_exports
TypeResource
Idazure.log_analytics.data_exports

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.
createdDatestringThe latest data export rule modification time.
dataExportIdstringThe data export rule ID.
destinationobjectdestination properties.
enablebooleanActive when enabled.
lastModifiedDatestringDate and time when the export was last modified.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tableNamesarrayAn array of tables to export, for example: [“Heartbeat, SecurityEvent”]. Required.
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, data_export_name, subscription_idGets a data export instance.
list_by_workspaceselectresource_group_name, workspace_name, subscription_idLists the data export instances within a workspace.
create_or_updateinsertresource_group_name, workspace_name, data_export_name, subscription_idCreate or update a data export.
create_or_updatereplaceresource_group_name, workspace_name, data_export_name, subscription_idCreate or update a data export.
deletedeleteresource_group_name, workspace_name, data_export_name, subscription_idDeletes the specified data export in a given workspace..

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
data_export_namestringThe data export rule name. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
workspace_namestringThe name of the workspace. Required.

SELECT examples

Gets a data export instance.

SELECT
id,
name,
createdDate,
dataExportId,
destination,
enable,
lastModifiedDate,
systemData,
tableNames,
type
FROM azure.log_analytics.data_exports
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND data_export_name = '{{ data_export_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update a data export.

INSERT INTO azure.log_analytics.data_exports (
properties,
resource_group_name,
workspace_name,
data_export_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ workspace_name }}',
'{{ data_export_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Create or update a data export.

REPLACE azure.log_analytics.data_exports
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND data_export_name = '{{ data_export_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Deletes the specified data export in a given workspace..

DELETE FROM azure.log_analytics.data_exports
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND data_export_name = '{{ data_export_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;