1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseAddmTask
Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabaseAddmTask

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi

    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

    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,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_managed_database_addm_task = oci.DatabaseManagement.get_managed_database_addm_task(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
        time_end=var["managed_database_addm_task_time_end"],
        time_start=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
    	})
    }
    
    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 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());
    
        }
    }
    
    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 Sequence[databasemanagement.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.
    oci logo
    Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi