Oracle Cloud Infrastructure v0.12.0, Mar 17 23

oci.Opsi.getAwrHubAwrSnapshots

This data source provides the list of Awr Hub Awr Snapshots in Oracle Cloud Infrastructure Opsi service.

Lists AWR snapshots for the specified source database in the AWR hub. The difference between the timeGreaterThanOrEqualTo and timeLessThanOrEqualTo should not exceed an elapsed range of 1 day. The timeGreaterThanOrEqualTo & timeLessThanOrEqualTo params are optional. If these params are not provided, by default last 1 day snapshots will be returned.

Example Usage

using System.Collections.Generic;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testAwrHubAwrSnapshots = Oci.Opsi.GetAwrHubAwrSnapshots.Invoke(new()
    {
        AwrHubId = oci_opsi_awr_hub.Test_awr_hub.Id,
        AwrSourceDatabaseIdentifier = @var.Awr_hub_awr_snapshot_awr_source_database_identifier,
        TimeGreaterThanOrEqualTo = @var.Awr_hub_awr_snapshot_time_greater_than_or_equal_to,
        TimeLessThanOrEqualTo = @var.Awr_hub_awr_snapshot_time_less_than_or_equal_to,
    });

});

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/go/oci/Opsi"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := Opsi.GetAwrHubAwrSnapshots(ctx, &opsi.GetAwrHubAwrSnapshotsArgs{
			AwrHubId:                    oci_opsi_awr_hub.Test_awr_hub.Id,
			AwrSourceDatabaseIdentifier: _var.Awr_hub_awr_snapshot_awr_source_database_identifier,
			TimeGreaterThanOrEqualTo:    pulumi.StringRef(_var.Awr_hub_awr_snapshot_time_greater_than_or_equal_to),
			TimeLessThanOrEqualTo:       pulumi.StringRef(_var.Awr_hub_awr_snapshot_time_less_than_or_equal_to),
		}, 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.Opsi.OpsiFunctions;
import com.pulumi.oci.Opsi.inputs.GetAwrHubAwrSnapshotsArgs;
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 testAwrHubAwrSnapshots = OpsiFunctions.getAwrHubAwrSnapshots(GetAwrHubAwrSnapshotsArgs.builder()
            .awrHubId(oci_opsi_awr_hub.test_awr_hub().id())
            .awrSourceDatabaseIdentifier(var_.awr_hub_awr_snapshot_awr_source_database_identifier())
            .timeGreaterThanOrEqualTo(var_.awr_hub_awr_snapshot_time_greater_than_or_equal_to())
            .timeLessThanOrEqualTo(var_.awr_hub_awr_snapshot_time_less_than_or_equal_to())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_awr_hub_awr_snapshots = oci.Opsi.get_awr_hub_awr_snapshots(awr_hub_id=oci_opsi_awr_hub["test_awr_hub"]["id"],
    awr_source_database_identifier=var["awr_hub_awr_snapshot_awr_source_database_identifier"],
    time_greater_than_or_equal_to=var["awr_hub_awr_snapshot_time_greater_than_or_equal_to"],
    time_less_than_or_equal_to=var["awr_hub_awr_snapshot_time_less_than_or_equal_to"])

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testAwrHubAwrSnapshots = oci.Opsi.getAwrHubAwrSnapshots({
    awrHubId: oci_opsi_awr_hub.test_awr_hub.id,
    awrSourceDatabaseIdentifier: _var.awr_hub_awr_snapshot_awr_source_database_identifier,
    timeGreaterThanOrEqualTo: _var.awr_hub_awr_snapshot_time_greater_than_or_equal_to,
    timeLessThanOrEqualTo: _var.awr_hub_awr_snapshot_time_less_than_or_equal_to,
});

variables:
  testAwrHubAwrSnapshots:
    fn::invoke:
      Function: oci:Opsi:getAwrHubAwrSnapshots
      Arguments:
        awrHubId: ${oci_opsi_awr_hub.test_awr_hub.id}
        awrSourceDatabaseIdentifier: ${var.awr_hub_awr_snapshot_awr_source_database_identifier}
        timeGreaterThanOrEqualTo: ${var.awr_hub_awr_snapshot_time_greater_than_or_equal_to}
        timeLessThanOrEqualTo: ${var.awr_hub_awr_snapshot_time_less_than_or_equal_to}

Using getAwrHubAwrSnapshots

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 getAwrHubAwrSnapshots(args: GetAwrHubAwrSnapshotsArgs, opts?: InvokeOptions): Promise<GetAwrHubAwrSnapshotsResult>
function getAwrHubAwrSnapshotsOutput(args: GetAwrHubAwrSnapshotsOutputArgs, opts?: InvokeOptions): Output<GetAwrHubAwrSnapshotsResult>

def get_awr_hub_awr_snapshots(awr_hub_id: Optional[str] = None,
                              awr_source_database_identifier: Optional[str] = None,
                              filters: Optional[Sequence[_opsi.GetAwrHubAwrSnapshotsFilter]] = None,
                              time_greater_than_or_equal_to: Optional[str] = None,
                              time_less_than_or_equal_to: Optional[str] = None,
                              opts: Optional[InvokeOptions] = None) -> GetAwrHubAwrSnapshotsResult
def get_awr_hub_awr_snapshots_output(awr_hub_id: Optional[pulumi.Input[str]] = None,
                              awr_source_database_identifier: Optional[pulumi.Input[str]] = None,
                              filters: Optional[pulumi.Input[Sequence[pulumi.Input[_opsi.GetAwrHubAwrSnapshotsFilterArgs]]]] = None,
                              time_greater_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                              time_less_than_or_equal_to: Optional[pulumi.Input[str]] = None,
                              opts: Optional[InvokeOptions] = None) -> Output[GetAwrHubAwrSnapshotsResult]

func GetAwrHubAwrSnapshots(ctx *Context, args *GetAwrHubAwrSnapshotsArgs, opts ...InvokeOption) (*GetAwrHubAwrSnapshotsResult, error)
func GetAwrHubAwrSnapshotsOutput(ctx *Context, args *GetAwrHubAwrSnapshotsOutputArgs, opts ...InvokeOption) GetAwrHubAwrSnapshotsResultOutput

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

public static class GetAwrHubAwrSnapshots 
{
    public static Task<GetAwrHubAwrSnapshotsResult> InvokeAsync(GetAwrHubAwrSnapshotsArgs args, InvokeOptions? opts = null)
    public static Output<GetAwrHubAwrSnapshotsResult> Invoke(GetAwrHubAwrSnapshotsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetAwrHubAwrSnapshotsResult> getAwrHubAwrSnapshots(GetAwrHubAwrSnapshotsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:Opsi/getAwrHubAwrSnapshots:getAwrHubAwrSnapshots
  arguments:
    # arguments dictionary

The following arguments are supported:

AwrHubId string: Unique Awr Hub identifier
AwrSourceDatabaseIdentifier string: AWR source database identifier.
Filters List<GetAwrHubAwrSnapshotsFilter>
TimeGreaterThanOrEqualTo string: The optional greater than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z
TimeLessThanOrEqualTo string: The optional less than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z

AwrHubId string: Unique Awr Hub identifier
AwrSourceDatabaseIdentifier string: AWR source database identifier.
Filters []GetAwrHubAwrSnapshotsFilter
TimeGreaterThanOrEqualTo string: The optional greater than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z
TimeLessThanOrEqualTo string: The optional less than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z

awrHubId String: Unique Awr Hub identifier
awrSourceDatabaseIdentifier String: AWR source database identifier.
filters List<GetAwrHubAwrSnapshotsFilter>
timeGreaterThanOrEqualTo String: The optional greater than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z
timeLessThanOrEqualTo String: The optional less than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z

awrHubId string: Unique Awr Hub identifier
awrSourceDatabaseIdentifier string: AWR source database identifier.
filters GetAwrHubAwrSnapshotsFilter[]
timeGreaterThanOrEqualTo string: The optional greater than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z
timeLessThanOrEqualTo string: The optional less than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z

awr_hub_id str: Unique Awr Hub identifier
awr_source_database_identifier str: AWR source database identifier.
filters GetAwrHubAwrSnapshotsFilter]
time_greater_than_or_equal_to str: The optional greater than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z
time_less_than_or_equal_to str: The optional less than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z

awrHubId String: Unique Awr Hub identifier
awrSourceDatabaseIdentifier String: AWR source database identifier.
filters List<Property Map>
timeGreaterThanOrEqualTo String: The optional greater than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z
timeLessThanOrEqualTo String: The optional less than or equal to query parameter to filter the timestamp. The timestamp format to be followed is: YYYY-MM-DDTHH:MM:SSZ, example 2020-12-03T19:00:53Z

getAwrHubAwrSnapshots Result

The following output properties are available:

AwrHubId string
AwrSnapshotCollections List<GetAwrHubAwrSnapshotsAwrSnapshotCollection>: The list of awr_snapshot_collection.
AwrSourceDatabaseIdentifier string
Id string: The provider-assigned unique ID for this managed resource.
Filters List<GetAwrHubAwrSnapshotsFilter>
TimeGreaterThanOrEqualTo string
TimeLessThanOrEqualTo string

AwrHubId string
AwrSnapshotCollections []GetAwrHubAwrSnapshotsAwrSnapshotCollection: The list of awr_snapshot_collection.
AwrSourceDatabaseIdentifier string
Id string: The provider-assigned unique ID for this managed resource.
Filters []GetAwrHubAwrSnapshotsFilter
TimeGreaterThanOrEqualTo string
TimeLessThanOrEqualTo string

awrHubId String
awrSnapshotCollections List<GetAwrHubAwrSnapshotsAwrSnapshotCollection>: The list of awr_snapshot_collection.
awrSourceDatabaseIdentifier String
id String: The provider-assigned unique ID for this managed resource.
filters List<GetAwrHubAwrSnapshotsFilter>
timeGreaterThanOrEqualTo String
timeLessThanOrEqualTo String

awrHubId string
awrSnapshotCollections GetAwrHubAwrSnapshotsAwrSnapshotCollection[]: The list of awr_snapshot_collection.
awrSourceDatabaseIdentifier string
id string: The provider-assigned unique ID for this managed resource.
filters GetAwrHubAwrSnapshotsFilter[]
timeGreaterThanOrEqualTo string
timeLessThanOrEqualTo string

awr_hub_id str
awr_snapshot_collections GetAwrHubAwrSnapshotsAwrSnapshotCollection]: The list of awr_snapshot_collection.
awr_source_database_identifier str
id str: The provider-assigned unique ID for this managed resource.
filters GetAwrHubAwrSnapshotsFilter]
time_greater_than_or_equal_to str
time_less_than_or_equal_to str

awrHubId String
awrSnapshotCollections List<Property Map>: The list of awr_snapshot_collection.
awrSourceDatabaseIdentifier String
id String: The provider-assigned unique ID for this managed resource.
filters List<Property Map>
timeGreaterThanOrEqualTo String
timeLessThanOrEqualTo String

Supporting Types

GetAwrHubAwrSnapshotsAwrSnapshotCollection

Items List<GetAwrHubAwrSnapshotsAwrSnapshotCollectionItem>: A list of AWR snapshot summary data.

Items []GetAwrHubAwrSnapshotsAwrSnapshotCollectionItem: A list of AWR snapshot summary data.

items List<GetAwrHubAwrSnapshotsAwrSnapshotCollectionItem>: A list of AWR snapshot summary data.

items GetAwrHubAwrSnapshotsAwrSnapshotCollectionItem[]: A list of AWR snapshot summary data.

items GetAwrHubAwrSnapshotsAwrSnapshotCollectionItem]: A list of AWR snapshot summary data.

items List<Property Map>: A list of AWR snapshot summary data.

GetAwrHubAwrSnapshotsAwrSnapshotCollectionItem

Items List<GetAwrHubAwrSnapshotsAwrSnapshotCollectionItemItem>: A list of AWR snapshot summary data.

Items []GetAwrHubAwrSnapshotsAwrSnapshotCollectionItemItem: A list of AWR snapshot summary data.

items List<GetAwrHubAwrSnapshotsAwrSnapshotCollectionItemItem>: A list of AWR snapshot summary data.

items GetAwrHubAwrSnapshotsAwrSnapshotCollectionItemItem[]: A list of AWR snapshot summary data.

items GetAwrHubAwrSnapshotsAwrSnapshotCollectionItemItem]: A list of AWR snapshot summary data.

items List<Property Map>: A list of AWR snapshot summary data.

GetAwrHubAwrSnapshotsAwrSnapshotCollectionItemItem

AwrSourceDatabaseId string: DatabaseId of the Source database for which AWR Data will be uploaded to AWR Hub.
ErrorCount string: The total number of errors.
InstanceNumber int: The database instance number.
SnapshotIdentifier int: The identifier of the snapshot.
TimeDbStartup string: The timestamp of the database startup.
TimeSnapshotBegin string: The start time of the snapshot.
TimeSnapshotEnd string: The end time of the snapshot.

AwrSourceDatabaseId string: DatabaseId of the Source database for which AWR Data will be uploaded to AWR Hub.
ErrorCount string: The total number of errors.
InstanceNumber int: The database instance number.
SnapshotIdentifier int: The identifier of the snapshot.
TimeDbStartup string: The timestamp of the database startup.
TimeSnapshotBegin string: The start time of the snapshot.
TimeSnapshotEnd string: The end time of the snapshot.

awrSourceDatabaseId String: DatabaseId of the Source database for which AWR Data will be uploaded to AWR Hub.
errorCount String: The total number of errors.
instanceNumber Integer: The database instance number.
snapshotIdentifier Integer: The identifier of the snapshot.
timeDbStartup String: The timestamp of the database startup.
timeSnapshotBegin String: The start time of the snapshot.
timeSnapshotEnd String: The end time of the snapshot.

awrSourceDatabaseId string: DatabaseId of the Source database for which AWR Data will be uploaded to AWR Hub.
errorCount string: The total number of errors.
instanceNumber number: The database instance number.
snapshotIdentifier number: The identifier of the snapshot.
timeDbStartup string: The timestamp of the database startup.
timeSnapshotBegin string: The start time of the snapshot.
timeSnapshotEnd string: The end time of the snapshot.

awr_source_database_id str: DatabaseId of the Source database for which AWR Data will be uploaded to AWR Hub.
error_count str: The total number of errors.
instance_number int: The database instance number.
snapshot_identifier int: The identifier of the snapshot.
time_db_startup str: The timestamp of the database startup.
time_snapshot_begin str: The start time of the snapshot.
time_snapshot_end str: The end time of the snapshot.

awrSourceDatabaseId String: DatabaseId of the Source database for which AWR Data will be uploaded to AWR Hub.
errorCount String: The total number of errors.
instanceNumber Number: The database instance number.
snapshotIdentifier Number: The identifier of the snapshot.
timeDbStartup String: The timestamp of the database startup.
timeSnapshotBegin String: The start time of the snapshot.
timeSnapshotEnd String: The end time of the snapshot.

GetAwrHubAwrSnapshotsFilter

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.