Skip to main content

work_item_configurations

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

Overview

Namework_item_configurations
TypeResource
Idazure.application_insights.work_item_configurations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
ConfigDisplayNamestringConfiguration friendly name.
ConfigPropertiesstringSerialized JSON object for detailed properties.
ConnectorIdstringConnector identifier where work item is created.
IdstringUnique Id for work item.
IsDefaultbooleanBoolean value indicating whether configuration is default.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_itemselectresource_group_name, resource_name, work_item_config_id, subscription_idGets specified work item configuration for an Application Insights component.
listselectresource_group_name, resource_name, subscription_idGets the list work item configurations that exist for the application.
createinsertresource_group_name, resource_name, subscription_idCreate a work item configuration for an Application Insights component.
deletedeleteresource_group_name, resource_name, work_item_config_id, subscription_idDelete a work item configuration of an Application Insights component.
get_defaultexecresource_group_name, resource_name, subscription_idGets default work item configurations that exist for the application.
update_itemexecresource_group_name, resource_name, work_item_config_id, subscription_idUpdate a work item configuration for 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
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
resource_namestringThe name of the Application Insights component resource. Required.
subscription_idstring
work_item_config_idstringThe unique work item configuration Id. This can be either friendly name of connector as defined in connector configuration. Required.

SELECT examples

Gets specified work item configuration for an Application Insights component.

SELECT
ConfigDisplayName,
ConfigProperties,
ConnectorId,
Id,
IsDefault
FROM azure.application_insights.work_item_configurations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND resource_name = '{{ resource_name }}' -- required
AND work_item_config_id = '{{ work_item_config_id }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a work item configuration for an Application Insights component.

INSERT INTO azure.application_insights.work_item_configurations (
ConnectorId,
ConnectorDataConfiguration,
ValidateOnly,
WorkItemProperties,
resource_group_name,
resource_name,
subscription_id
)
SELECT
'{{ ConnectorId }}',
'{{ ConnectorDataConfiguration }}',
{{ ValidateOnly }},
'{{ WorkItemProperties }}',
'{{ resource_group_name }}',
'{{ resource_name }}',
'{{ subscription_id }}'
RETURNING
ConfigDisplayName,
ConfigProperties,
ConnectorId,
Id,
IsDefault
;

DELETE examples

Delete a work item configuration of an Application Insights component.

DELETE FROM azure.application_insights.work_item_configurations
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND resource_name = '{{ resource_name }}' --required
AND work_item_config_id = '{{ work_item_config_id }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Gets default work item configurations that exist for the application.

EXEC azure.application_insights.work_item_configurations.get_default 
@resource_group_name='{{ resource_group_name }}' --required,
@resource_name='{{ resource_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;