Oracle Cloud Infrastructure

v0.5.0 published on Monday, Sep 12, 2022 by Pulumi

getManagedDatabaseAddmTasks

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 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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.