oci.DatabaseManagement.getManagedDatabaseAddmTasks
Explore with Pulumi AI
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: testManagedDatabase.id,
    timeEnd: managedDatabaseAddmTaskTimeEnd,
    timeStart: managedDatabaseAddmTaskTimeStart,
});
import pulumi
import pulumi_oci as oci
test_managed_database_addm_tasks = oci.DatabaseManagement.get_managed_database_addm_tasks(managed_database_id=test_managed_database["id"],
    time_end=managed_database_addm_task_time_end,
    time_start=managed_database_addm_task_time_start)
package main
import (
	"github.com/pulumi/pulumi-oci/sdk/v2/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: testManagedDatabase.Id,
			TimeEnd:           managedDatabaseAddmTaskTimeEnd,
			TimeStart:         managedDatabaseAddmTaskTimeStart,
		}, 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 = testManagedDatabase.Id,
        TimeEnd = managedDatabaseAddmTaskTimeEnd,
        TimeStart = managedDatabaseAddmTaskTimeStart,
    });
});
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(testManagedDatabase.id())
            .timeEnd(managedDatabaseAddmTaskTimeEnd)
            .timeStart(managedDatabaseAddmTaskTimeStart)
            .build());
    }
}
variables:
  testManagedDatabaseAddmTasks:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabaseAddmTasks
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        timeEnd: ${managedDatabaseAddmTaskTimeEnd}
        timeStart: ${managedDatabaseAddmTaskTimeStart}
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[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[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)
public static Output<GetManagedDatabaseAddmTasksResult> getManagedDatabaseAddmTasks(GetManagedDatabaseAddmTasksArgs args, InvokeOptions options)
fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabaseAddmTasks:getManagedDatabaseAddmTasks
  arguments:
    # arguments dictionaryThe following arguments are supported:
- ManagedDatabase stringId 
- 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<GetManaged Database Addm Tasks Filter> 
- ManagedDatabase stringId 
- 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
[]GetManaged Database Addm Tasks Filter 
- managedDatabase StringId 
- 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<GetManaged Database Addm Tasks Filter> 
- managedDatabase stringId 
- 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
GetManaged Database Addm Tasks Filter[] 
- managed_database_ strid 
- 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[GetManaged Database Addm Tasks Filter] 
- managedDatabase StringId 
- 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:
- AddmTasks List<GetCollections Managed Database Addm Tasks Addm Tasks Collection> 
- The list of addm_tasks_collection.
- Id string
- The provider-assigned unique ID for this managed resource.
- ManagedDatabase stringId 
- The OCID of the Managed Database.
- TimeEnd string
- TimeStart string
- Filters
List<GetManaged Database Addm Tasks Filter> 
- AddmTasks []GetCollections Managed Database Addm Tasks Addm Tasks Collection 
- The list of addm_tasks_collection.
- Id string
- The provider-assigned unique ID for this managed resource.
- ManagedDatabase stringId 
- The OCID of the Managed Database.
- TimeEnd string
- TimeStart string
- Filters
[]GetManaged Database Addm Tasks Filter 
- addmTasks List<GetCollections Managed Database Addm Tasks Addm Tasks Collection> 
- The list of addm_tasks_collection.
- id String
- The provider-assigned unique ID for this managed resource.
- managedDatabase StringId 
- The OCID of the Managed Database.
- timeEnd String
- timeStart String
- filters
List<GetManaged Database Addm Tasks Filter> 
- addmTasks GetCollections Managed Database Addm Tasks Addm Tasks Collection[] 
- The list of addm_tasks_collection.
- id string
- The provider-assigned unique ID for this managed resource.
- managedDatabase stringId 
- The OCID of the Managed Database.
- timeEnd string
- timeStart string
- filters
GetManaged Database Addm Tasks Filter[] 
- addm_tasks_ Sequence[Getcollections Managed Database Addm Tasks Addm Tasks Collection] 
- The list of addm_tasks_collection.
- id str
- The provider-assigned unique ID for this managed resource.
- managed_database_ strid 
- The OCID of the Managed Database.
- time_end str
- time_start str
- filters
Sequence[GetManaged Database Addm Tasks Filter] 
- addmTasks List<Property Map>Collections 
- The list of addm_tasks_collection.
- id String
- The provider-assigned unique ID for this managed resource.
- managedDatabase StringId 
- The OCID of the Managed Database.
- timeEnd String
- timeStart String
- filters List<Property Map>
Supporting Types
GetManagedDatabaseAddmTasksAddmTasksCollection       
- Items
List<GetManaged Database Addm Tasks Addm Tasks Collection Item> 
- The list of ADDM task metadata.
- Items
[]GetManaged Database Addm Tasks Addm Tasks Collection Item 
- The list of ADDM task metadata.
- items
List<GetManaged Database Addm Tasks Addm Tasks Collection Item> 
- The list of ADDM task metadata.
- items
GetManaged Database Addm Tasks Addm Tasks Collection Item[] 
- The list of ADDM task metadata.
- items
Sequence[GetManaged Database Addm Tasks Addm Tasks Collection Item] 
- The list of ADDM task metadata.
- items List<Property Map>
- The list of ADDM task metadata.
GetManagedDatabaseAddmTasksAddmTasksCollectionItem        
- BeginSnapshot stringId 
- 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.
- EndSnapshot stringId 
- The ID number of the ending AWR snapshot.
- EndSnapshot stringTime 
- 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.
- StartSnapshot stringTime 
- 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.
- BeginSnapshot stringId 
- 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.
- EndSnapshot stringId 
- The ID number of the ending AWR snapshot.
- EndSnapshot stringTime 
- 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.
- StartSnapshot stringTime 
- 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.
- beginSnapshot StringId 
- 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.
- endSnapshot StringId 
- The ID number of the ending AWR snapshot.
- endSnapshot StringTime 
- 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.
- startSnapshot StringTime 
- 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.
- beginSnapshot stringId 
- 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.
- endSnapshot stringId 
- The ID number of the ending AWR snapshot.
- endSnapshot stringTime 
- 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.
- startSnapshot stringTime 
- 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_ strid 
- 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_ strid 
- The ID number of the ending AWR snapshot.
- end_snapshot_ strtime 
- 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_ strtime 
- 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.
- beginSnapshot StringId 
- 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.
- endSnapshot StringId 
- The ID number of the ending AWR snapshot.
- endSnapshot StringTime 
- 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.
- startSnapshot StringTime 
- 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     
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the ociTerraform Provider.