Docs Packages
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDbSystemsUpgradeHistoryEntries
Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi
pulumi/pulumi-oci

oci.Database.getDbSystemsUpgradeHistoryEntries

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.32.0 published on Thursday, Apr 18, 2024 by Pulumi
pulumi/pulumi-oci

    This data source provides the list of Db Systems Upgrade History Entries in Oracle Cloud Infrastructure Database service.

    Gets the history of the upgrade actions performed on the specified DB system.

    Example Usage

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

const testDbSystemsUpgradeHistoryEntries = oci.Database.getDbSystemsUpgradeHistoryEntries({
    dbSystemId: oci_database_db_system.test_db_system.id,
    state: _var.db_systems_upgrade_history_entry_state,
    upgradeAction: _var.db_systems_upgrade_history_entry_upgrade_action,
});

    import pulumi
import pulumi_oci as oci

test_db_systems_upgrade_history_entries = oci.Database.get_db_systems_upgrade_history_entries(db_system_id=oci_database_db_system["test_db_system"]["id"],
    state=var["db_systems_upgrade_history_entry_state"],
    upgrade_action=var["db_systems_upgrade_history_entry_upgrade_action"])

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := Database.GetDbSystemsUpgradeHistoryEntries(ctx, &database.GetDbSystemsUpgradeHistoryEntriesArgs{
			DbSystemId:    oci_database_db_system.Test_db_system.Id,
			State:         pulumi.StringRef(_var.Db_systems_upgrade_history_entry_state),
			UpgradeAction: pulumi.StringRef(_var.Db_systems_upgrade_history_entry_upgrade_action),
		}, 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 testDbSystemsUpgradeHistoryEntries = Oci.Database.GetDbSystemsUpgradeHistoryEntries.Invoke(new()
    {
        DbSystemId = oci_database_db_system.Test_db_system.Id,
        State = @var.Db_systems_upgrade_history_entry_state,
        UpgradeAction = @var.Db_systems_upgrade_history_entry_upgrade_action,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Database.DatabaseFunctions;
import com.pulumi.oci.Database.inputs.GetDbSystemsUpgradeHistoryEntriesArgs;
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 testDbSystemsUpgradeHistoryEntries = DatabaseFunctions.getDbSystemsUpgradeHistoryEntries(GetDbSystemsUpgradeHistoryEntriesArgs.builder()
            .dbSystemId(oci_database_db_system.test_db_system().id())
            .state(var_.db_systems_upgrade_history_entry_state())
            .upgradeAction(var_.db_systems_upgrade_history_entry_upgrade_action())
            .build());

    }
}

    variables:
  testDbSystemsUpgradeHistoryEntries:
    fn::invoke:
      Function: oci:Database:getDbSystemsUpgradeHistoryEntries
      Arguments:
        dbSystemId: ${oci_database_db_system.test_db_system.id}
        state: ${var.db_systems_upgrade_history_entry_state}
        upgradeAction: ${var.db_systems_upgrade_history_entry_upgrade_action}

    Using getDbSystemsUpgradeHistoryEntries

    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 getDbSystemsUpgradeHistoryEntries(args: GetDbSystemsUpgradeHistoryEntriesArgs, opts?: InvokeOptions): Promise<GetDbSystemsUpgradeHistoryEntriesResult>
function getDbSystemsUpgradeHistoryEntriesOutput(args: GetDbSystemsUpgradeHistoryEntriesOutputArgs, opts?: InvokeOptions): Output<GetDbSystemsUpgradeHistoryEntriesResult>
    def get_db_systems_upgrade_history_entries(db_system_id: Optional[str] = None,
                                           filters: Optional[Sequence[_database.GetDbSystemsUpgradeHistoryEntriesFilter]] = None,
                                           state: Optional[str] = None,
                                           upgrade_action: Optional[str] = None,
                                           opts: Optional[InvokeOptions] = None) -> GetDbSystemsUpgradeHistoryEntriesResult
def get_db_systems_upgrade_history_entries_output(db_system_id: Optional[pulumi.Input[str]] = None,
                                           filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetDbSystemsUpgradeHistoryEntriesFilterArgs]]]] = None,
                                           state: Optional[pulumi.Input[str]] = None,
                                           upgrade_action: Optional[pulumi.Input[str]] = None,
                                           opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemsUpgradeHistoryEntriesResult]
    func GetDbSystemsUpgradeHistoryEntries(ctx *Context, args *GetDbSystemsUpgradeHistoryEntriesArgs, opts ...InvokeOption) (*GetDbSystemsUpgradeHistoryEntriesResult, error)
func GetDbSystemsUpgradeHistoryEntriesOutput(ctx *Context, args *GetDbSystemsUpgradeHistoryEntriesOutputArgs, opts ...InvokeOption) GetDbSystemsUpgradeHistoryEntriesResultOutput

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

    public static class GetDbSystemsUpgradeHistoryEntries 
{
    public static Task<GetDbSystemsUpgradeHistoryEntriesResult> InvokeAsync(GetDbSystemsUpgradeHistoryEntriesArgs args, InvokeOptions? opts = null)
    public static Output<GetDbSystemsUpgradeHistoryEntriesResult> Invoke(GetDbSystemsUpgradeHistoryEntriesInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetDbSystemsUpgradeHistoryEntriesResult> getDbSystemsUpgradeHistoryEntries(GetDbSystemsUpgradeHistoryEntriesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

    fn::invoke:
  function: oci:Database/getDbSystemsUpgradeHistoryEntries:getDbSystemsUpgradeHistoryEntries
  arguments:
    # arguments dictionary

    The following arguments are supported:

    DbSystemId string
    The DB system OCID.
    Filters List<GetDbSystemsUpgradeHistoryEntriesFilter>
    State string
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    UpgradeAction string
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    DbSystemId string
    The DB system OCID.
    Filters []GetDbSystemsUpgradeHistoryEntriesFilter
    State string
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    UpgradeAction string
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    dbSystemId String
    The DB system OCID.
    filters List<GetDbSystemsUpgradeHistoryEntriesFilter>
    state String
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    upgradeAction String
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    dbSystemId string
    The DB system OCID.
    filters GetDbSystemsUpgradeHistoryEntriesFilter[]
    state string
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    upgradeAction string
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    db_system_id str
    The DB system OCID.
    filters Sequence[database.GetDbSystemsUpgradeHistoryEntriesFilter]
    state str
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    upgrade_action str
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.
    dbSystemId String
    The DB system OCID.
    filters List<Property Map>
    state String
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    upgradeAction String
    A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.

    getDbSystemsUpgradeHistoryEntries Result

    The following output properties are available:

    DbSystemId string
    DbSystemUpgradeHistoryEntries List<GetDbSystemsUpgradeHistoryEntriesDbSystemUpgradeHistoryEntry>
    The list of db_system_upgrade_history_entries.
    Id string
    The provider-assigned unique ID for this managed resource.
    Filters List<GetDbSystemsUpgradeHistoryEntriesFilter>
    State string
    The current state of the action.
    UpgradeAction string
    DbSystemId string
    DbSystemUpgradeHistoryEntries []GetDbSystemsUpgradeHistoryEntriesDbSystemUpgradeHistoryEntry
    The list of db_system_upgrade_history_entries.
    Id string
    The provider-assigned unique ID for this managed resource.
    Filters []GetDbSystemsUpgradeHistoryEntriesFilter
    State string
    The current state of the action.
    UpgradeAction string
    dbSystemId String
    dbSystemUpgradeHistoryEntries List<GetDbSystemsUpgradeHistoryEntriesDbSystemUpgradeHistoryEntry>
    The list of db_system_upgrade_history_entries.
    id String
    The provider-assigned unique ID for this managed resource.
    filters List<GetDbSystemsUpgradeHistoryEntriesFilter>
    state String
    The current state of the action.
    upgradeAction String
    dbSystemId string
    dbSystemUpgradeHistoryEntries GetDbSystemsUpgradeHistoryEntriesDbSystemUpgradeHistoryEntry[]
    The list of db_system_upgrade_history_entries.
    id string
    The provider-assigned unique ID for this managed resource.
    filters GetDbSystemsUpgradeHistoryEntriesFilter[]
    state string
    The current state of the action.
    upgradeAction string
    db_system_id str
    db_system_upgrade_history_entries Sequence[database.GetDbSystemsUpgradeHistoryEntriesDbSystemUpgradeHistoryEntry]
    The list of db_system_upgrade_history_entries.
    id str
    The provider-assigned unique ID for this managed resource.
    filters Sequence[database.GetDbSystemsUpgradeHistoryEntriesFilter]
    state str
    The current state of the action.
    upgrade_action str
    dbSystemId String
    dbSystemUpgradeHistoryEntries List<Property Map>
    The list of db_system_upgrade_history_entries.
    id String
    The provider-assigned unique ID for this managed resource.
    filters List<Property Map>
    state String
    The current state of the action.
    upgradeAction String

    Supporting Types

    GetDbSystemsUpgradeHistoryEntriesDbSystemUpgradeHistoryEntry

    Action string
    The operating system upgrade action.
    Id string
    The OCID of the upgrade history entry.
    LifecycleDetails string
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    NewGiVersion string
    A valid Oracle Grid Infrastructure (GI) software version.
    NewOsVersion string
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    OldGiVersion string
    A valid Oracle Grid Infrastructure (GI) software version.
    OldOsVersion string
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    SnapshotRetentionPeriodInDays int
    The retention period, in days, for the snapshot that allows you to perform a rollback of the upgrade operation. After this number of days passes, you cannot roll back the upgrade.
    State string
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    TimeEnded string
    The date and time when the upgrade action completed
    TimeStarted string
    The date and time when the upgrade action started.
    Action string
    The operating system upgrade action.
    Id string
    The OCID of the upgrade history entry.
    LifecycleDetails string
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    NewGiVersion string
    A valid Oracle Grid Infrastructure (GI) software version.
    NewOsVersion string
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    OldGiVersion string
    A valid Oracle Grid Infrastructure (GI) software version.
    OldOsVersion string
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    SnapshotRetentionPeriodInDays int
    The retention period, in days, for the snapshot that allows you to perform a rollback of the upgrade operation. After this number of days passes, you cannot roll back the upgrade.
    State string
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    TimeEnded string
    The date and time when the upgrade action completed
    TimeStarted string
    The date and time when the upgrade action started.
    action String
    The operating system upgrade action.
    id String
    The OCID of the upgrade history entry.
    lifecycleDetails String
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    newGiVersion String
    A valid Oracle Grid Infrastructure (GI) software version.
    newOsVersion String
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    oldGiVersion String
    A valid Oracle Grid Infrastructure (GI) software version.
    oldOsVersion String
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    snapshotRetentionPeriodInDays Integer
    The retention period, in days, for the snapshot that allows you to perform a rollback of the upgrade operation. After this number of days passes, you cannot roll back the upgrade.
    state String
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    timeEnded String
    The date and time when the upgrade action completed
    timeStarted String
    The date and time when the upgrade action started.
    action string
    The operating system upgrade action.
    id string
    The OCID of the upgrade history entry.
    lifecycleDetails string
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    newGiVersion string
    A valid Oracle Grid Infrastructure (GI) software version.
    newOsVersion string
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    oldGiVersion string
    A valid Oracle Grid Infrastructure (GI) software version.
    oldOsVersion string
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    snapshotRetentionPeriodInDays number
    The retention period, in days, for the snapshot that allows you to perform a rollback of the upgrade operation. After this number of days passes, you cannot roll back the upgrade.
    state string
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    timeEnded string
    The date and time when the upgrade action completed
    timeStarted string
    The date and time when the upgrade action started.
    action str
    The operating system upgrade action.
    id str
    The OCID of the upgrade history entry.
    lifecycle_details str
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    new_gi_version str
    A valid Oracle Grid Infrastructure (GI) software version.
    new_os_version str
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    old_gi_version str
    A valid Oracle Grid Infrastructure (GI) software version.
    old_os_version str
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    snapshot_retention_period_in_days int
    The retention period, in days, for the snapshot that allows you to perform a rollback of the upgrade operation. After this number of days passes, you cannot roll back the upgrade.
    state str
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    time_ended str
    The date and time when the upgrade action completed
    time_started str
    The date and time when the upgrade action started.
    action String
    The operating system upgrade action.
    id String
    The OCID of the upgrade history entry.
    lifecycleDetails String
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    newGiVersion String
    A valid Oracle Grid Infrastructure (GI) software version.
    newOsVersion String
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    oldGiVersion String
    A valid Oracle Grid Infrastructure (GI) software version.
    oldOsVersion String
    A valid Oracle Software (OS) version eg. Oracle Linux Server release 8
    snapshotRetentionPeriodInDays Number
    The retention period, in days, for the snapshot that allows you to perform a rollback of the upgrade operation. After this number of days passes, you cannot roll back the upgrade.
    state String
    A filter to return only upgrade history entries that match the given lifecycle state exactly.
    timeEnded String
    The date and time when the upgrade action completed
    timeStarted String
    The date and time when the upgrade action started.

    GetDbSystemsUpgradeHistoryEntriesFilter

    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
    pulumi/pulumi-oci