Oracle Cloud Infrastructure v0.19.0, May 26 23

oci.DatabaseManagement.getManagedDatabaseAddmTask

Explore with Pulumi AI

This data source provides details about a specific Managed Database Addm Task resource in Oracle Cloud Infrastructure Database Management service.

Lists the metadata for each ADDM task who’s end snapshot time falls within the provided start and end time. Details include the name of the ADDM task, description, user, status and creation date time.

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var testManagedDatabaseAddmTask = Oci.DatabaseManagement.GetManagedDatabaseAddmTask.Invoke(new()
    {
        ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
        TimeEnd = @var.Managed_database_addm_task_time_end,
        TimeStart = @var.Managed_database_addm_task_time_start,
    });

});

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/go/oci/DatabaseManagement"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := DatabaseManagement.GetManagedDatabaseAddmTask(ctx, &databasemanagement.GetManagedDatabaseAddmTaskArgs{
			ManagedDatabaseId: oci_database_management_managed_database.Test_managed_database.Id,
			TimeEnd:           _var.Managed_database_addm_task_time_end,
			TimeStart:         _var.Managed_database_addm_task_time_start,
		}, nil)
		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.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetManagedDatabaseAddmTaskArgs;
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 testManagedDatabaseAddmTask = DatabaseManagementFunctions.getManagedDatabaseAddmTask(GetManagedDatabaseAddmTaskArgs.builder()
            .managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
            .timeEnd(var_.managed_database_addm_task_time_end())
            .timeStart(var_.managed_database_addm_task_time_start())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_managed_database_addm_task = oci.DatabaseManagement.get_managed_database_addm_task(managed_database_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    time_end=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    time_start=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))

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

const testManagedDatabaseAddmTask = oci.DatabaseManagement.getManagedDatabaseAddmTask({
    managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
    timeEnd: _var.managed_database_addm_task_time_end,
    timeStart: _var.managed_database_addm_task_time_start,
});

variables:
  testManagedDatabaseAddmTask:
    fn::invoke:
      Function: oci:DatabaseManagement:getManagedDatabaseAddmTask
      Arguments:
        managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
        timeEnd: ${var.managed_database_addm_task_time_end}
        timeStart: ${var.managed_database_addm_task_time_start}

Using getManagedDatabaseAddmTask

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 getManagedDatabaseAddmTask(args: GetManagedDatabaseAddmTaskArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseAddmTaskResult>
function getManagedDatabaseAddmTaskOutput(args: GetManagedDatabaseAddmTaskOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseAddmTaskResult>

def get_managed_database_addm_task(managed_database_id: Optional[str] = None,
                                   time_end: Optional[str] = None,
                                   time_start: Optional[str] = None,
                                   opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseAddmTaskResult
def get_managed_database_addm_task_output(managed_database_id: Optional[pulumi.Input[str]] = None,
                                   time_end: Optional[pulumi.Input[str]] = None,
                                   time_start: Optional[pulumi.Input[str]] = None,
                                   opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabaseAddmTaskResult]

func GetManagedDatabaseAddmTask(ctx *Context, args *GetManagedDatabaseAddmTaskArgs, opts ...InvokeOption) (*GetManagedDatabaseAddmTaskResult, error)
func GetManagedDatabaseAddmTaskOutput(ctx *Context, args *GetManagedDatabaseAddmTaskOutputArgs, opts ...InvokeOption) GetManagedDatabaseAddmTaskResultOutput

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

public static class GetManagedDatabaseAddmTask 
{
    public static Task<GetManagedDatabaseAddmTaskResult> InvokeAsync(GetManagedDatabaseAddmTaskArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabaseAddmTaskResult> Invoke(GetManagedDatabaseAddmTaskInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetManagedDatabaseAddmTaskResult> getManagedDatabaseAddmTask(GetManagedDatabaseAddmTaskArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseAddmTask:getManagedDatabaseAddmTask
  arguments:
    # arguments dictionary

The following arguments are supported:

ManagedDatabaseId string: The OCID of the Managed Database.
TimeEnd string: The end of the time range to search for ADDM tasks as defined by date-time RFC3339 format.
TimeStart string: The beginning of the time range to search for ADDM tasks as defined by date-time RFC3339 format.

ManagedDatabaseId string: The OCID of the Managed Database.
TimeEnd string: The end of the time range to search for ADDM tasks as defined by date-time RFC3339 format.
TimeStart string: The beginning of the time range to search for ADDM tasks as defined by date-time RFC3339 format.

managedDatabaseId String: The OCID of the Managed Database.
timeEnd String: The end of the time range to search for ADDM tasks as defined by date-time RFC3339 format.
timeStart String: The beginning of the time range to search for ADDM tasks as defined by date-time RFC3339 format.

managedDatabaseId string: The OCID of the Managed Database.
timeEnd string: The end of the time range to search for ADDM tasks as defined by date-time RFC3339 format.
timeStart string: The beginning of the time range to search for ADDM tasks as defined by date-time RFC3339 format.

managed_database_id str: The OCID of the Managed Database.
time_end str: The end of the time range to search for ADDM tasks as defined by date-time RFC3339 format.
time_start str: The beginning of the time range to search for ADDM tasks as defined by date-time RFC3339 format.

managedDatabaseId String: The OCID of the Managed Database.
timeEnd String: The end of the time range to search for ADDM tasks as defined by date-time RFC3339 format.
timeStart String: The beginning of the time range to search for ADDM tasks as defined by date-time RFC3339 format.

getManagedDatabaseAddmTask Result

The following output properties are available:

Id string: The provider-assigned unique ID for this managed resource.
Items List<GetManagedDatabaseAddmTaskItem>: The list of ADDM task metadata.
ManagedDatabaseId string: The OCID of the Managed Database.
TimeEnd string
TimeStart string

Id string: The provider-assigned unique ID for this managed resource.
Items []GetManagedDatabaseAddmTaskItem: The list of ADDM task metadata.
ManagedDatabaseId string: The OCID of the Managed Database.
TimeEnd string
TimeStart string

id String: The provider-assigned unique ID for this managed resource.
items List<GetManagedDatabaseAddmTaskItem>: The list of ADDM task metadata.
managedDatabaseId String: The OCID of the Managed Database.
timeEnd String
timeStart String

id string: The provider-assigned unique ID for this managed resource.
items GetManagedDatabaseAddmTaskItem[]: The list of ADDM task metadata.
managedDatabaseId string: The OCID of the Managed Database.
timeEnd string
timeStart string

id str: The provider-assigned unique ID for this managed resource.
items GetManagedDatabaseAddmTaskItem]: The list of ADDM task metadata.
managed_database_id str: The OCID of the Managed Database.
time_end str
time_start str

id String: The provider-assigned unique ID for this managed resource.
items List<Property Map>: The list of ADDM task metadata.
managedDatabaseId String: The OCID of the Managed Database.
timeEnd String
timeStart String

Supporting Types

GetManagedDatabaseAddmTaskItem

BeginSnapshotId string: The ID number of the beginning AWR snapshot.
DbUser string: The database user who owns the ADDM task.
Description string: The description of the ADDM task.
EndSnapshotId string: The ID number of the ending AWR snapshot.
EndSnapshotTime string: The timestamp of the ending AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
Findings string: The number of ADDM findings.
HowCreated string: A description of how the task was created.
StartSnapshotTime string: The timestamp of the beginning AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
Status string: The status of the ADDM task.
TaskId string: The ID number of the ADDM task.
TaskName string: The name of the ADDM task.
TimeCreated string: The creation date of the ADDM task.

BeginSnapshotId string: The ID number of the beginning AWR snapshot.
DbUser string: The database user who owns the ADDM task.
Description string: The description of the ADDM task.
EndSnapshotId string: The ID number of the ending AWR snapshot.
EndSnapshotTime string: The timestamp of the ending AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
Findings string: The number of ADDM findings.
HowCreated string: A description of how the task was created.
StartSnapshotTime string: The timestamp of the beginning AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
Status string: The status of the ADDM task.
TaskId string: The ID number of the ADDM task.
TaskName string: The name of the ADDM task.
TimeCreated string: The creation date of the ADDM task.

beginSnapshotId String: The ID number of the beginning AWR snapshot.
dbUser String: The database user who owns the ADDM task.
description String: The description of the ADDM task.
endSnapshotId String: The ID number of the ending AWR snapshot.
endSnapshotTime String: The timestamp of the ending AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
findings String: The number of ADDM findings.
howCreated String: A description of how the task was created.
startSnapshotTime String: The timestamp of the beginning AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
status String: The status of the ADDM task.
taskId String: The ID number of the ADDM task.
taskName String: The name of the ADDM task.
timeCreated String: The creation date of the ADDM task.

beginSnapshotId string: The ID number of the beginning AWR snapshot.
dbUser string: The database user who owns the ADDM task.
description string: The description of the ADDM task.
endSnapshotId string: The ID number of the ending AWR snapshot.
endSnapshotTime string: The timestamp of the ending AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
findings string: The number of ADDM findings.
howCreated string: A description of how the task was created.
startSnapshotTime string: The timestamp of the beginning AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
status string: The status of the ADDM task.
taskId string: The ID number of the ADDM task.
taskName string: The name of the ADDM task.
timeCreated string: The creation date of the ADDM task.

begin_snapshot_id str: The ID number of the beginning AWR snapshot.
db_user str: The database user who owns the ADDM task.
description str: The description of the ADDM task.
end_snapshot_id str: The ID number of the ending AWR snapshot.
end_snapshot_time str: The timestamp of the ending AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
findings str: The number of ADDM findings.
how_created str: A description of how the task was created.
start_snapshot_time str: The timestamp of the beginning AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
status str: The status of the ADDM task.
task_id str: The ID number of the ADDM task.
task_name str: The name of the ADDM task.
time_created str: The creation date of the ADDM task.

beginSnapshotId String: The ID number of the beginning AWR snapshot.
dbUser String: The database user who owns the ADDM task.
description String: The description of the ADDM task.
endSnapshotId String: The ID number of the ending AWR snapshot.
endSnapshotTime String: The timestamp of the ending AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
findings String: The number of ADDM findings.
howCreated String: A description of how the task was created.
startSnapshotTime String: The timestamp of the beginning AWR snapshot used in the ADDM task as defined by date-time RFC3339 format.
status String: The status of the ADDM task.
taskId String: The ID number of the ADDM task.
taskName String: The name of the ADDM task.
timeCreated String: The creation date of the ADDM task.

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.