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

oci.DatabaseManagement.getManagedDatabaseAddmTasks

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 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

    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,
    });
    
    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"])
    
    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
    	})
    }
    
    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 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());
    
        }
    }
    
    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 Sequence[databasemanagement.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[]
    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.32.0 published on Thursday, Apr 18, 2024 by Pulumi