1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabaseAddmTasks
Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi

oci.DatabaseManagement.getManagedDatabaseAddmTasks

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi

    This data source provides the list of Managed Database Addm Tasks 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 testManagedDatabaseAddmTasks = Oci.DatabaseManagement.GetManagedDatabaseAddmTasks.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.GetManagedDatabaseAddmTasks(ctx, &databasemanagement.GetManagedDatabaseAddmTasksArgs{
    			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.GetManagedDatabaseAddmTasksArgs;
    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 testManagedDatabaseAddmTasks = DatabaseManagementFunctions.getManagedDatabaseAddmTasks(GetManagedDatabaseAddmTasksArgs.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_tasks = oci.DatabaseManagement.get_managed_database_addm_tasks(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"])
    
    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testManagedDatabaseAddmTasks = oci.DatabaseManagement.getManagedDatabaseAddmTasks({
        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:
      testManagedDatabaseAddmTasks:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedDatabaseAddmTasks
          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 getManagedDatabaseAddmTasks

    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 getManagedDatabaseAddmTasks(args: GetManagedDatabaseAddmTasksArgs, opts?: InvokeOptions): Promise<GetManagedDatabaseAddmTasksResult>
    function getManagedDatabaseAddmTasksOutput(args: GetManagedDatabaseAddmTasksOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabaseAddmTasksResult>
    def get_managed_database_addm_tasks(filters: Optional[Sequence[_databasemanagement.GetManagedDatabaseAddmTasksFilter]] = None,
                                        managed_database_id: Optional[str] = None,
                                        time_end: Optional[str] = None,
                                        time_start: Optional[str] = None,
                                        opts: Optional[InvokeOptions] = None) -> GetManagedDatabaseAddmTasksResult
    def get_managed_database_addm_tasks_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabaseAddmTasksFilterArgs]]]] = None,
                                        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[GetManagedDatabaseAddmTasksResult]
    func GetManagedDatabaseAddmTasks(ctx *Context, args *GetManagedDatabaseAddmTasksArgs, opts ...InvokeOption) (*GetManagedDatabaseAddmTasksResult, error)
    func GetManagedDatabaseAddmTasksOutput(ctx *Context, args *GetManagedDatabaseAddmTasksOutputArgs, opts ...InvokeOption) GetManagedDatabaseAddmTasksResultOutput

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

    public static class GetManagedDatabaseAddmTasks 
    {
        public static Task<GetManagedDatabaseAddmTasksResult> InvokeAsync(GetManagedDatabaseAddmTasksArgs args, InvokeOptions? opts = null)
        public static Output<GetManagedDatabaseAddmTasksResult> Invoke(GetManagedDatabaseAddmTasksInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetManagedDatabaseAddmTasksResult> getManagedDatabaseAddmTasks(GetManagedDatabaseAddmTasksArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DatabaseManagement/getManagedDatabaseAddmTasks:getManagedDatabaseAddmTasks
      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.

    Filters List<GetManagedDatabaseAddmTasksFilter>
    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.

    Filters []GetManagedDatabaseAddmTasksFilter
    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.

    filters List<GetManagedDatabaseAddmTasksFilter>
    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.

    filters GetManagedDatabaseAddmTasksFilter[]
    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.

    filters GetManagedDatabaseAddmTasksFilter]
    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.

    filters List<Property Map>

    getManagedDatabaseAddmTasks Result

    The following output properties are available:

    AddmTasksCollections List<GetManagedDatabaseAddmTasksAddmTasksCollection>

    The list of addm_tasks_collection.

    Id string

    The provider-assigned unique ID for this managed resource.

    ManagedDatabaseId string

    The OCID of the Managed Database.

    TimeEnd string
    TimeStart string
    Filters List<GetManagedDatabaseAddmTasksFilter>
    AddmTasksCollections []GetManagedDatabaseAddmTasksAddmTasksCollection

    The list of addm_tasks_collection.

    Id string

    The provider-assigned unique ID for this managed resource.

    ManagedDatabaseId string

    The OCID of the Managed Database.

    TimeEnd string
    TimeStart string
    Filters []GetManagedDatabaseAddmTasksFilter
    addmTasksCollections List<GetManagedDatabaseAddmTasksAddmTasksCollection>

    The list of addm_tasks_collection.

    id String

    The provider-assigned unique ID for this managed resource.

    managedDatabaseId String

    The OCID of the Managed Database.

    timeEnd String
    timeStart String
    filters List<GetManagedDatabaseAddmTasksFilter>
    addmTasksCollections GetManagedDatabaseAddmTasksAddmTasksCollection[]

    The list of addm_tasks_collection.

    id string

    The provider-assigned unique ID for this managed resource.

    managedDatabaseId string

    The OCID of the Managed Database.

    timeEnd string
    timeStart string
    filters GetManagedDatabaseAddmTasksFilter[]
    addm_tasks_collections GetManagedDatabaseAddmTasksAddmTasksCollection]

    The list of addm_tasks_collection.

    id str

    The provider-assigned unique ID for this managed resource.

    managed_database_id str

    The OCID of the Managed Database.

    time_end str
    time_start str
    filters GetManagedDatabaseAddmTasksFilter]
    addmTasksCollections List<Property Map>

    The list of addm_tasks_collection.

    id String

    The provider-assigned unique ID for this managed resource.

    managedDatabaseId String

    The OCID of the Managed Database.

    timeEnd String
    timeStart String
    filters List<Property Map>

    Supporting Types

    GetManagedDatabaseAddmTasksAddmTasksCollection

    items List<Property Map>

    The list of ADDM task metadata.

    GetManagedDatabaseAddmTasksAddmTasksCollectionItem

    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.

    GetManagedDatabaseAddmTasksFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    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.16.1 published on Wednesday, Nov 22, 2023 by Pulumi