Azure Native v1.103.0, Jun 2 23

azure-native.operationalinsights.Query

Explore with Pulumi AI

A Log Analytics QueryPack-Query definition. API Version: 2019-09-01.

Example Usage

QueryPut

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var query = new AzureNative.OperationalInsights.Query("query", new()
    {
        Body = @"let newExceptionsTimeRange = 1d;
let timeRangeToCheckBefore = 7d;
exceptions
| where timestamp < ago(timeRangeToCheckBefore)
| summarize count() by problemId
| join kind= rightanti (
exceptions
| where timestamp >= ago(newExceptionsTimeRange)
| extend stack = tostring(details[0].rawStack)
| summarize count(), dcount(user_AuthenticatedId), min(timestamp), max(timestamp), any(stack) by problemId  
) on problemId 
| order by  count_ desc
",
        Description = "my description",
        DisplayName = "Exceptions - New in the last 24 hours",
        Id = "a449f8af-8e64-4b3a-9b16-5a7165ff98c4",
        QueryPackName = "my-querypack",
        Related = new AzureNative.OperationalInsights.Inputs.LogAnalyticsQueryPackQueryPropertiesRelatedArgs
        {
            Categories = new[]
            {
                "analytics",
            },
        },
        ResourceGroupName = "my-resource-group",
        Tags = 
        {
            { "my-label", new[]
            {
                "label1",
            } },
            { "my-other-label", new[]
            {
                "label2",
            } },
        },
    });

});

package main

import (
	operationalinsights "github.com/pulumi/pulumi-azure-native-sdk/operationalinsights"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := operationalinsights.NewQuery(ctx, "query", &operationalinsights.QueryArgs{
			Body:          pulumi.String("let newExceptionsTimeRange = 1d;\nlet timeRangeToCheckBefore = 7d;\nexceptions\n| where timestamp < ago(timeRangeToCheckBefore)\n| summarize count() by problemId\n| join kind= rightanti (\nexceptions\n| where timestamp >= ago(newExceptionsTimeRange)\n| extend stack = tostring(details[0].rawStack)\n| summarize count(), dcount(user_AuthenticatedId), min(timestamp), max(timestamp), any(stack) by problemId  \n) on problemId \n| order by  count_ desc\n"),
			Description:   pulumi.String("my description"),
			DisplayName:   pulumi.String("Exceptions - New in the last 24 hours"),
			Id:            pulumi.String("a449f8af-8e64-4b3a-9b16-5a7165ff98c4"),
			QueryPackName: pulumi.String("my-querypack"),
			Related: &operationalinsights.LogAnalyticsQueryPackQueryPropertiesRelatedArgs{
				Categories: pulumi.StringArray{
					pulumi.String("analytics"),
				},
			},
			ResourceGroupName: pulumi.String("my-resource-group"),
			Tags: pulumi.StringArrayMap{
				"my-label": pulumi.StringArray{
					pulumi.String("label1"),
				},
				"my-other-label": pulumi.StringArray{
					pulumi.String("label2"),
				},
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.operationalinsights.Query;
import com.pulumi.azurenative.operationalinsights.QueryArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var query = new Query("query", QueryArgs.builder()        
            .body("""
let newExceptionsTimeRange = 1d;
let timeRangeToCheckBefore = 7d;
exceptions
| where timestamp < ago(timeRangeToCheckBefore)
| summarize count() by problemId
| join kind= rightanti (
exceptions
| where timestamp >= ago(newExceptionsTimeRange)
| extend stack = tostring(details[0].rawStack)
| summarize count(), dcount(user_AuthenticatedId), min(timestamp), max(timestamp), any(stack) by problemId  
) on problemId 
| order by  count_ desc
            """)
            .description("my description")
            .displayName("Exceptions - New in the last 24 hours")
            .id("a449f8af-8e64-4b3a-9b16-5a7165ff98c4")
            .queryPackName("my-querypack")
            .related(Map.of("categories", "analytics"))
            .resourceGroupName("my-resource-group")
            .tags(Map.ofEntries(
                Map.entry("my-label", "label1"),
                Map.entry("my-other-label", "label2")
            ))
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

query = azure_native.operationalinsights.Query("query",
    body="""let newExceptionsTimeRange = 1d;
let timeRangeToCheckBefore = 7d;
exceptions
| where timestamp < ago(timeRangeToCheckBefore)
| summarize count() by problemId
| join kind= rightanti (
exceptions
| where timestamp >= ago(newExceptionsTimeRange)
| extend stack = tostring(details[0].rawStack)
| summarize count(), dcount(user_AuthenticatedId), min(timestamp), max(timestamp), any(stack) by problemId  
) on problemId 
| order by  count_ desc
""",
    description="my description",
    display_name="Exceptions - New in the last 24 hours",
    id="a449f8af-8e64-4b3a-9b16-5a7165ff98c4",
    query_pack_name="my-querypack",
    related=azure_native.operationalinsights.LogAnalyticsQueryPackQueryPropertiesRelatedArgs(
        categories=["analytics"],
    ),
    resource_group_name="my-resource-group",
    tags={
        "my-label": ["label1"],
        "my-other-label": ["label2"],
    })

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const query = new azure_native.operationalinsights.Query("query", {
    body: `let newExceptionsTimeRange = 1d;
let timeRangeToCheckBefore = 7d;
exceptions
| where timestamp < ago(timeRangeToCheckBefore)
| summarize count() by problemId
| join kind= rightanti (
exceptions
| where timestamp >= ago(newExceptionsTimeRange)
| extend stack = tostring(details[0].rawStack)
| summarize count(), dcount(user_AuthenticatedId), min(timestamp), max(timestamp), any(stack) by problemId  
) on problemId 
| order by  count_ desc
`,
    description: "my description",
    displayName: "Exceptions - New in the last 24 hours",
    id: "a449f8af-8e64-4b3a-9b16-5a7165ff98c4",
    queryPackName: "my-querypack",
    related: {
        categories: ["analytics"],
    },
    resourceGroupName: "my-resource-group",
    tags: {
        "my-label": ["label1"],
        "my-other-label": ["label2"],
    },
});

resources:
  query:
    type: azure-native:operationalinsights:Query
    properties:
      body: "let newExceptionsTimeRange = 1d;\nlet timeRangeToCheckBefore = 7d;\nexceptions\n| where timestamp < ago(timeRangeToCheckBefore)\n| summarize count() by problemId\n| join kind= rightanti (\nexceptions\n| where timestamp >= ago(newExceptionsTimeRange)\n| extend stack = tostring(details[0].rawStack)\n| summarize count(), dcount(user_AuthenticatedId), min(timestamp), max(timestamp), any(stack) by problemId  \n) on problemId \n| order by  count_ desc\n"
      description: my description
      displayName: Exceptions - New in the last 24 hours
      id: a449f8af-8e64-4b3a-9b16-5a7165ff98c4
      queryPackName: my-querypack
      related:
        categories:
          - analytics
      resourceGroupName: my-resource-group
      tags:
        my-label:
          - label1
        my-other-label:
          - label2

Create Query Resource

new Query(name: string, args: QueryArgs, opts?: CustomResourceOptions);

@overload
def Query(resource_name: str,
          opts: Optional[ResourceOptions] = None,
          body: Optional[str] = None,
          description: Optional[str] = None,
          display_name: Optional[str] = None,
          id: Optional[str] = None,
          properties: Optional[Any] = None,
          query_pack_name: Optional[str] = None,
          related: Optional[LogAnalyticsQueryPackQueryPropertiesRelatedArgs] = None,
          resource_group_name: Optional[str] = None,
          tags: Optional[Mapping[str, Sequence[str]]] = None)
@overload
def Query(resource_name: str,
          args: QueryArgs,
          opts: Optional[ResourceOptions] = None)

func NewQuery(ctx *Context, name string, args QueryArgs, opts ...ResourceOption) (*Query, error)

public Query(string name, QueryArgs args, CustomResourceOptions? opts = null)

public Query(String name, QueryArgs args)
public Query(String name, QueryArgs args, CustomResourceOptions options)

type: azure-native:operationalinsights:Query
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string: The unique name of the resource.
args QueryArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

resource_name str: The unique name of the resource.
args QueryArgs: The arguments to resource properties.
opts ResourceOptions: Bag of options to control resource's behavior.

ctx Context: Context object for the current deployment.
name string: The unique name of the resource.
args QueryArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args QueryArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args QueryArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

Query Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The Query resource accepts the following input properties:

Body string: Body of the query.
DisplayName string: Unique display name for your query within the Query Pack.
QueryPackName string: The name of the Log Analytics QueryPack resource.
ResourceGroupName string: The name of the resource group. The name is case insensitive.
Description string: Description of the query.
Id string: The id of a specific query defined in the Log Analytics QueryPack
Properties object: Additional properties that can be set for the query.
Related Pulumi.AzureNative.OperationalInsights.Inputs.LogAnalyticsQueryPackQueryPropertiesRelatedArgs: The related metadata items for the function.
Tags Dictionary<string, ImmutableArray<string>>: Tags associated with the query.

Body string: Body of the query.
DisplayName string: Unique display name for your query within the Query Pack.
QueryPackName string: The name of the Log Analytics QueryPack resource.
ResourceGroupName string: The name of the resource group. The name is case insensitive.
Description string: Description of the query.
Id string: The id of a specific query defined in the Log Analytics QueryPack
Properties interface{}: Additional properties that can be set for the query.
Related LogAnalyticsQueryPackQueryPropertiesRelatedArgs: The related metadata items for the function.
Tags map[string][]string: Tags associated with the query.

body String: Body of the query.
displayName String: Unique display name for your query within the Query Pack.
queryPackName String: The name of the Log Analytics QueryPack resource.
resourceGroupName String: The name of the resource group. The name is case insensitive.
description String: Description of the query.
id String: The id of a specific query defined in the Log Analytics QueryPack
properties Object: Additional properties that can be set for the query.
related LogAnalyticsQueryPackQueryPropertiesRelatedArgs: The related metadata items for the function.
tags Map<String,List<String>>: Tags associated with the query.

body string: Body of the query.
displayName string: Unique display name for your query within the Query Pack.
queryPackName string: The name of the Log Analytics QueryPack resource.
resourceGroupName string: The name of the resource group. The name is case insensitive.
description string: Description of the query.
id string: The id of a specific query defined in the Log Analytics QueryPack
properties any: Additional properties that can be set for the query.
related LogAnalyticsQueryPackQueryPropertiesRelatedArgs: The related metadata items for the function.
tags {[key: string]: string[]}: Tags associated with the query.

body str: Body of the query.
display_name str: Unique display name for your query within the Query Pack.
query_pack_name str: The name of the Log Analytics QueryPack resource.
resource_group_name str: The name of the resource group. The name is case insensitive.
description str: Description of the query.
id str: The id of a specific query defined in the Log Analytics QueryPack
properties Any: Additional properties that can be set for the query.
related LogAnalyticsQueryPackQueryPropertiesRelatedArgs: The related metadata items for the function.
tags Mapping[str, Sequence[str]]: Tags associated with the query.

body String: Body of the query.
displayName String: Unique display name for your query within the Query Pack.
queryPackName String: The name of the Log Analytics QueryPack resource.
resourceGroupName String: The name of the resource group. The name is case insensitive.
description String: Description of the query.
id String: The id of a specific query defined in the Log Analytics QueryPack
properties Any: Additional properties that can be set for the query.
related Property Map: The related metadata items for the function.
tags Map<List<String>>: Tags associated with the query.

Outputs

All input properties are implicitly available as output properties. Additionally, the Query resource produces the following output properties:

Author string: Object Id of user creating the query.
Id string: The provider-assigned unique ID for this managed resource.
Name string: Azure resource name
SystemData Pulumi.AzureNative.OperationalInsights.Outputs.SystemDataResponse: Read only system data
TimeCreated string: Creation Date for the Log Analytics Query, in ISO 8601 format.
TimeModified string: Last modified date of the Log Analytics Query, in ISO 8601 format.
Type string: Azure resource type

Author string: Object Id of user creating the query.
Id string: The provider-assigned unique ID for this managed resource.
Name string: Azure resource name
SystemData SystemDataResponse: Read only system data
TimeCreated string: Creation Date for the Log Analytics Query, in ISO 8601 format.
TimeModified string: Last modified date of the Log Analytics Query, in ISO 8601 format.
Type string: Azure resource type

author String: Object Id of user creating the query.
id String: The provider-assigned unique ID for this managed resource.
name String: Azure resource name
systemData SystemDataResponse: Read only system data
timeCreated String: Creation Date for the Log Analytics Query, in ISO 8601 format.
timeModified String: Last modified date of the Log Analytics Query, in ISO 8601 format.
type String: Azure resource type

author string: Object Id of user creating the query.
id string: The provider-assigned unique ID for this managed resource.
name string: Azure resource name
systemData SystemDataResponse: Read only system data
timeCreated string: Creation Date for the Log Analytics Query, in ISO 8601 format.
timeModified string: Last modified date of the Log Analytics Query, in ISO 8601 format.
type string: Azure resource type

author str: Object Id of user creating the query.
id str: The provider-assigned unique ID for this managed resource.
name str: Azure resource name
system_data SystemDataResponse: Read only system data
time_created str: Creation Date for the Log Analytics Query, in ISO 8601 format.
time_modified str: Last modified date of the Log Analytics Query, in ISO 8601 format.
type str: Azure resource type

author String: Object Id of user creating the query.
id String: The provider-assigned unique ID for this managed resource.
name String: Azure resource name
systemData Property Map: Read only system data
timeCreated String: Creation Date for the Log Analytics Query, in ISO 8601 format.
timeModified String: Last modified date of the Log Analytics Query, in ISO 8601 format.
type String: Azure resource type

Supporting Types

LogAnalyticsQueryPackQueryPropertiesRelated

Categories List<string>: The related categories for the function.
ResourceTypes List<string>: The related resource types for the function.
Solutions List<string>: The related Log Analytics solutions for the function.

Categories []string: The related categories for the function.
ResourceTypes []string: The related resource types for the function.
Solutions []string: The related Log Analytics solutions for the function.

categories List<String>: The related categories for the function.
resourceTypes List<String>: The related resource types for the function.
solutions List<String>: The related Log Analytics solutions for the function.

categories string[]: The related categories for the function.
resourceTypes string[]: The related resource types for the function.
solutions string[]: The related Log Analytics solutions for the function.

categories Sequence[str]: The related categories for the function.
resource_types Sequence[str]: The related resource types for the function.
solutions Sequence[str]: The related Log Analytics solutions for the function.

categories List<String>: The related categories for the function.
resourceTypes List<String>: The related resource types for the function.
solutions List<String>: The related Log Analytics solutions for the function.

LogAnalyticsQueryPackQueryPropertiesResponseRelated

Categories List<string>: The related categories for the function.
ResourceTypes List<string>: The related resource types for the function.
Solutions List<string>: The related Log Analytics solutions for the function.

Categories []string: The related categories for the function.
ResourceTypes []string: The related resource types for the function.
Solutions []string: The related Log Analytics solutions for the function.

categories List<String>: The related categories for the function.
resourceTypes List<String>: The related resource types for the function.
solutions List<String>: The related Log Analytics solutions for the function.

categories string[]: The related categories for the function.
resourceTypes string[]: The related resource types for the function.
solutions string[]: The related Log Analytics solutions for the function.

categories Sequence[str]: The related categories for the function.
resource_types Sequence[str]: The related resource types for the function.
solutions Sequence[str]: The related Log Analytics solutions for the function.

categories List<String>: The related categories for the function.
resourceTypes List<String>: The related resource types for the function.
solutions List<String>: The related Log Analytics solutions for the function.

SystemDataResponse

CreatedAt string: The timestamp of resource creation (UTC).
CreatedBy string: The identity that created the resource.
CreatedByType string: The type of identity that created the resource.
LastModifiedAt string: The timestamp of resource last modification (UTC)
LastModifiedBy string: The identity that last modified the resource.
LastModifiedByType string: The type of identity that last modified the resource.

CreatedAt string: The timestamp of resource creation (UTC).
CreatedBy string: The identity that created the resource.
CreatedByType string: The type of identity that created the resource.
LastModifiedAt string: The timestamp of resource last modification (UTC)
LastModifiedBy string: The identity that last modified the resource.
LastModifiedByType string: The type of identity that last modified the resource.

createdAt String: The timestamp of resource creation (UTC).
createdBy String: The identity that created the resource.
createdByType String: The type of identity that created the resource.
lastModifiedAt String: The timestamp of resource last modification (UTC)
lastModifiedBy String: The identity that last modified the resource.
lastModifiedByType String: The type of identity that last modified the resource.

createdAt string: The timestamp of resource creation (UTC).
createdBy string: The identity that created the resource.
createdByType string: The type of identity that created the resource.
lastModifiedAt string: The timestamp of resource last modification (UTC)
lastModifiedBy string: The identity that last modified the resource.
lastModifiedByType string: The type of identity that last modified the resource.

created_at str: The timestamp of resource creation (UTC).
created_by str: The identity that created the resource.
created_by_type str: The type of identity that created the resource.
last_modified_at str: The timestamp of resource last modification (UTC)
last_modified_by str: The identity that last modified the resource.
last_modified_by_type str: The type of identity that last modified the resource.

createdAt String: The timestamp of resource creation (UTC).
createdBy String: The identity that created the resource.
createdByType String: The type of identity that created the resource.
lastModifiedAt String: The timestamp of resource last modification (UTC)
lastModifiedBy String: The identity that last modified the resource.
lastModifiedByType String: The type of identity that last modified the resource.

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:operationalinsights:Query a449f8af-8e64-4b3a-9b16-5a7165ff98c4 /subscriptions/86dc51d3-92ed-4d7e-947a-775ea79b4918/resourceGroups/my-resource-group/providers/microsoft.operationalinsights/queryPacks/my-querypack/queries/a449f8af-8e64-4b3a-9b16-5a7165ff98c4

Package Details

Repository: Azure Native pulumi/pulumi-azure-native
License: Apache-2.0