tencentcloud 1.81.189, Apr 30 25

tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.getSqlserverQueryXevent

Explore with Pulumi AI

tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloudstack/terraform-provider-tencentcloud

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";

const example = tencentcloud.getSqlserverQueryXevent({
    endTime: "2023-08-10 00:00:00",
    eventType: "blocked",
    instanceId: "mssql-gyg9xycl",
    startTime: "2023-08-01 00:00:00",
});

import pulumi
import pulumi_tencentcloud as tencentcloud

example = tencentcloud.get_sqlserver_query_xevent(end_time="2023-08-10 00:00:00",
    event_type="blocked",
    instance_id="mssql-gyg9xycl",
    start_time="2023-08-01 00:00:00")

package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := tencentcloud.GetSqlserverQueryXevent(ctx, &tencentcloud.GetSqlserverQueryXeventArgs{
			EndTime:    "2023-08-10 00:00:00",
			EventType:  "blocked",
			InstanceId: "mssql-gyg9xycl",
			StartTime:  "2023-08-01 00:00:00",
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var example = Tencentcloud.GetSqlserverQueryXevent.Invoke(new()
    {
        EndTime = "2023-08-10 00:00:00",
        EventType = "blocked",
        InstanceId = "mssql-gyg9xycl",
        StartTime = "2023-08-01 00:00:00",
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetSqlserverQueryXeventArgs;
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) {
        final var example = TencentcloudFunctions.getSqlserverQueryXevent(GetSqlserverQueryXeventArgs.builder()
            .endTime("2023-08-10 00:00:00")
            .eventType("blocked")
            .instanceId("mssql-gyg9xycl")
            .startTime("2023-08-01 00:00:00")
            .build());

    }
}

variables:
  example:
    fn::invoke:
      function: tencentcloud:getSqlserverQueryXevent
      arguments:
        endTime: 2023-08-10 00:00:00
        eventType: blocked
        instanceId: mssql-gyg9xycl
        startTime: 2023-08-01 00:00:00

Using getSqlserverQueryXevent

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getSqlserverQueryXevent(args: GetSqlserverQueryXeventArgs, opts?: InvokeOptions): Promise<GetSqlserverQueryXeventResult>
function getSqlserverQueryXeventOutput(args: GetSqlserverQueryXeventOutputArgs, opts?: InvokeOptions): Output<GetSqlserverQueryXeventResult>

def get_sqlserver_query_xevent(end_time: Optional[str] = None,
                               event_type: Optional[str] = None,
                               id: Optional[str] = None,
                               instance_id: Optional[str] = None,
                               result_output_file: Optional[str] = None,
                               start_time: Optional[str] = None,
                               opts: Optional[InvokeOptions] = None) -> GetSqlserverQueryXeventResult
def get_sqlserver_query_xevent_output(end_time: Optional[pulumi.Input[str]] = None,
                               event_type: Optional[pulumi.Input[str]] = None,
                               id: Optional[pulumi.Input[str]] = None,
                               instance_id: Optional[pulumi.Input[str]] = None,
                               result_output_file: Optional[pulumi.Input[str]] = None,
                               start_time: Optional[pulumi.Input[str]] = None,
                               opts: Optional[InvokeOptions] = None) -> Output[GetSqlserverQueryXeventResult]

func GetSqlserverQueryXevent(ctx *Context, args *GetSqlserverQueryXeventArgs, opts ...InvokeOption) (*GetSqlserverQueryXeventResult, error)
func GetSqlserverQueryXeventOutput(ctx *Context, args *GetSqlserverQueryXeventOutputArgs, opts ...InvokeOption) GetSqlserverQueryXeventResultOutput

> Note: This function is named GetSqlserverQueryXevent in the Go SDK.

public static class GetSqlserverQueryXevent 
{
    public static Task<GetSqlserverQueryXeventResult> InvokeAsync(GetSqlserverQueryXeventArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlserverQueryXeventResult> Invoke(GetSqlserverQueryXeventInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetSqlserverQueryXeventResult> getSqlserverQueryXevent(GetSqlserverQueryXeventArgs args, InvokeOptions options)
public static Output<GetSqlserverQueryXeventResult> getSqlserverQueryXevent(GetSqlserverQueryXeventArgs args, InvokeOptions options)

fn::invoke:
  function: tencentcloud:index/getSqlserverQueryXevent:getSqlserverQueryXevent
  arguments:
    # arguments dictionary

The following arguments are supported:

EndTime string: Generation end time of an extended file.
EventType string: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
InstanceId string: Instance ID.
StartTime string: Generation start time of an extended file.
Id string: ID.
ResultOutputFile string: Used to save results.

EndTime string: Generation end time of an extended file.
EventType string: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
InstanceId string: Instance ID.
StartTime string: Generation start time of an extended file.
Id string: ID.
ResultOutputFile string: Used to save results.

endTime String: Generation end time of an extended file.
eventType String: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
instanceId String: Instance ID.
startTime String: Generation start time of an extended file.
id String: ID.
resultOutputFile String: Used to save results.

endTime string: Generation end time of an extended file.
eventType string: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
instanceId string: Instance ID.
startTime string: Generation start time of an extended file.
id string: ID.
resultOutputFile string: Used to save results.

end_time str: Generation end time of an extended file.
event_type str: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
instance_id str: Instance ID.
start_time str: Generation start time of an extended file.
id str: ID.
result_output_file str: Used to save results.

endTime String: Generation end time of an extended file.
eventType String: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
instanceId String: Instance ID.
startTime String: Generation start time of an extended file.
id String: ID.
resultOutputFile String: Used to save results.

getSqlserverQueryXevent Result

The following output properties are available:

EndTime string: Generation end time of an extended file.
EventType string: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock (deadlock event).
Events List<GetSqlserverQueryXeventEvent>: List of extended events.
Id string: ID.
InstanceId string
StartTime string: Generation start time of an extended file.
ResultOutputFile string

EndTime string: Generation end time of an extended file.
EventType string: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock (deadlock event).
Events []GetSqlserverQueryXeventEvent: List of extended events.
Id string: ID.
InstanceId string
StartTime string: Generation start time of an extended file.
ResultOutputFile string

endTime String: Generation end time of an extended file.
eventType String: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock (deadlock event).
events List<GetSqlserverQueryXeventEvent>: List of extended events.
id String: ID.
instanceId String
startTime String: Generation start time of an extended file.
resultOutputFile String

endTime string: Generation end time of an extended file.
eventType string: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock (deadlock event).
events GetSqlserverQueryXeventEvent[]: List of extended events.
id string: ID.
instanceId string
startTime string: Generation start time of an extended file.
resultOutputFile string

end_time str: Generation end time of an extended file.
event_type str: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock (deadlock event).
events Sequence[GetSqlserverQueryXeventEvent]: List of extended events.
id str: ID.
instance_id str
start_time str: Generation start time of an extended file.
result_output_file str

endTime String: Generation end time of an extended file.
eventType String: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock (deadlock event).
events List<Property Map>: List of extended events.
id String: ID.
instanceId String
startTime String: Generation start time of an extended file.
resultOutputFile String

Supporting Types

GetSqlserverQueryXeventEvent

EndTime string: Generation end time of an extended file.
EventType string: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
ExternalAddr string: Download address on the public network.
FileName string: File name of an extended event.
Id double: ID.
InternalAddr string: Download address on the private network.
Size double: File size of an extended event.
StartTime string: Generation start time of an extended file.
Status double: Event record status. Valid values: 1 (succeeded), 2 (failed).

EndTime string: Generation end time of an extended file.
EventType string: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
ExternalAddr string: Download address on the public network.
FileName string: File name of an extended event.
Id float64: ID.
InternalAddr string: Download address on the private network.
Size float64: File size of an extended event.
StartTime string: Generation start time of an extended file.
Status float64: Event record status. Valid values: 1 (succeeded), 2 (failed).

endTime String: Generation end time of an extended file.
eventType String: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
externalAddr String: Download address on the public network.
fileName String: File name of an extended event.
id Double: ID.
internalAddr String: Download address on the private network.
size Double: File size of an extended event.
startTime String: Generation start time of an extended file.
status Double: Event record status. Valid values: 1 (succeeded), 2 (failed).

endTime string: Generation end time of an extended file.
eventType string: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
externalAddr string: Download address on the public network.
fileName string: File name of an extended event.
id number: ID.
internalAddr string: Download address on the private network.
size number: File size of an extended event.
startTime string: Generation start time of an extended file.
status number: Event record status. Valid values: 1 (succeeded), 2 (failed).

end_time str: Generation end time of an extended file.
event_type str: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
external_addr str: Download address on the public network.
file_name str: File name of an extended event.
id float: ID.
internal_addr str: Download address on the private network.
size float: File size of an extended event.
start_time str: Generation start time of an extended file.
status float: Event record status. Valid values: 1 (succeeded), 2 (failed).

endTime String: Generation end time of an extended file.
eventType String: Event type. Valid values: slow (Slow SQL event), blocked (blocking event), deadlock` (deadlock event).
externalAddr String: Download address on the public network.
fileName String: File name of an extended event.
id Number: ID.
internalAddr String: Download address on the private network.
size Number: File size of an extended event.
startTime String: Generation start time of an extended file.
status Number: Event record status. Valid values: 1 (succeeded), 2 (failed).

Package Details

Repository: tencentcloud tencentcloudstack/terraform-provider-tencentcloud
License
Notes: This Pulumi package is based on the tencentcloud Terraform Provider.

tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.getSqlserverQueryXevent

On this page

On this page

Example Usage

Using getSqlserverQueryXevent

getSqlserverQueryXevent Result

Supporting Types

GetSqlserverQueryXeventEvent

Package Details

On this page

On this page