1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDbSystemOsPatchHistoryEntries
Viewing docs for Oracle Cloud Infrastructure v4.2.0
published on Friday, Mar 6, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

oci.Database.getDbSystemOsPatchHistoryEntries

oci logo
Viewing docs for Oracle Cloud Infrastructure v4.2.0
published on Friday, Mar 6, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

    This data source provides the list of Db System Os Patch History Entries in Oracle Cloud Infrastructure Database service.

    Gets the history of the OS patch actions performed on the specified DB system.

    Example Usage

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

const testDbSystemOsPatchHistoryEntries = oci.Database.getDbSystemOsPatchHistoryEntries({
    dbSystemId: testDbSystem.id,
    action: dbSystemOsPatchHistoryEntryAction,
    state: dbSystemOsPatchHistoryEntryState,
});

    import pulumi
import pulumi_oci as oci

test_db_system_os_patch_history_entries = oci.Database.get_db_system_os_patch_history_entries(db_system_id=test_db_system["id"],
    action=db_system_os_patch_history_entry_action,
    state=db_system_os_patch_history_entry_state)

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := database.GetDbSystemOsPatchHistoryEntries(ctx, &database.GetDbSystemOsPatchHistoryEntriesArgs{
			DbSystemId: testDbSystem.Id,
			Action:     pulumi.StringRef(dbSystemOsPatchHistoryEntryAction),
			State:      pulumi.StringRef(dbSystemOsPatchHistoryEntryState),
		}, 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 testDbSystemOsPatchHistoryEntries = Oci.Database.GetDbSystemOsPatchHistoryEntries.Invoke(new()
    {
        DbSystemId = testDbSystem.Id,
        Action = dbSystemOsPatchHistoryEntryAction,
        State = dbSystemOsPatchHistoryEntryState,
    });

});

    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.GetDbSystemOsPatchHistoryEntriesArgs;
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 testDbSystemOsPatchHistoryEntries = DatabaseFunctions.getDbSystemOsPatchHistoryEntries(GetDbSystemOsPatchHistoryEntriesArgs.builder()
            .dbSystemId(testDbSystem.id())
            .action(dbSystemOsPatchHistoryEntryAction)
            .state(dbSystemOsPatchHistoryEntryState)
            .build());

    }
}

    variables:
  testDbSystemOsPatchHistoryEntries:
    fn::invoke:
      function: oci:Database:getDbSystemOsPatchHistoryEntries
      arguments:
        dbSystemId: ${testDbSystem.id}
        action: ${dbSystemOsPatchHistoryEntryAction}
        state: ${dbSystemOsPatchHistoryEntryState}

    Using getDbSystemOsPatchHistoryEntries

    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 getDbSystemOsPatchHistoryEntries(args: GetDbSystemOsPatchHistoryEntriesArgs, opts?: InvokeOptions): Promise<GetDbSystemOsPatchHistoryEntriesResult>
function getDbSystemOsPatchHistoryEntriesOutput(args: GetDbSystemOsPatchHistoryEntriesOutputArgs, opts?: InvokeOptions): Output<GetDbSystemOsPatchHistoryEntriesResult>
    def get_db_system_os_patch_history_entries(action: Optional[str] = None,
                                           db_system_id: Optional[str] = None,
                                           filters: Optional[Sequence[GetDbSystemOsPatchHistoryEntriesFilter]] = None,
                                           state: Optional[str] = None,
                                           opts: Optional[InvokeOptions] = None) -> GetDbSystemOsPatchHistoryEntriesResult
def get_db_system_os_patch_history_entries_output(action: Optional[pulumi.Input[str]] = None,
                                           db_system_id: Optional[pulumi.Input[str]] = None,
                                           filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetDbSystemOsPatchHistoryEntriesFilterArgs]]]] = None,
                                           state: Optional[pulumi.Input[str]] = None,
                                           opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemOsPatchHistoryEntriesResult]
    func GetDbSystemOsPatchHistoryEntries(ctx *Context, args *GetDbSystemOsPatchHistoryEntriesArgs, opts ...InvokeOption) (*GetDbSystemOsPatchHistoryEntriesResult, error)
func GetDbSystemOsPatchHistoryEntriesOutput(ctx *Context, args *GetDbSystemOsPatchHistoryEntriesOutputArgs, opts ...InvokeOption) GetDbSystemOsPatchHistoryEntriesResultOutput

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

    public static class GetDbSystemOsPatchHistoryEntries 
{
    public static Task<GetDbSystemOsPatchHistoryEntriesResult> InvokeAsync(GetDbSystemOsPatchHistoryEntriesArgs args, InvokeOptions? opts = null)
    public static Output<GetDbSystemOsPatchHistoryEntriesResult> Invoke(GetDbSystemOsPatchHistoryEntriesInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetDbSystemOsPatchHistoryEntriesResult> getDbSystemOsPatchHistoryEntries(GetDbSystemOsPatchHistoryEntriesArgs args, InvokeOptions options)
public static Output<GetDbSystemOsPatchHistoryEntriesResult> getDbSystemOsPatchHistoryEntries(GetDbSystemOsPatchHistoryEntriesArgs args, InvokeOptions options)

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

    The following arguments are supported:

    DbSystemId string
    The DB system OCID.
    Action string
    A filter to return only OS patch history entries that match the specified OS patch action.
    Filters List<GetDbSystemOsPatchHistoryEntriesFilter>
    State string
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    DbSystemId string
    The DB system OCID.
    Action string
    A filter to return only OS patch history entries that match the specified OS patch action.
    Filters []GetDbSystemOsPatchHistoryEntriesFilter
    State string
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    dbSystemId String
    The DB system OCID.
    action String
    A filter to return only OS patch history entries that match the specified OS patch action.
    filters List<GetDbSystemOsPatchHistoryEntriesFilter>
    state String
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    dbSystemId string
    The DB system OCID.
    action string
    A filter to return only OS patch history entries that match the specified OS patch action.
    filters GetDbSystemOsPatchHistoryEntriesFilter[]
    state string
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    db_system_id str
    The DB system OCID.
    action str
    A filter to return only OS patch history entries that match the specified OS patch action.
    filters Sequence[GetDbSystemOsPatchHistoryEntriesFilter]
    state str
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    dbSystemId String
    The DB system OCID.
    action String
    A filter to return only OS patch history entries that match the specified OS patch action.
    filters List<Property Map>
    state String
    A filter to return only OS patch history entries that match the given lifecycle state exactly.

    getDbSystemOsPatchHistoryEntries Result

    The following output properties are available:

    DbSystemId string
    The OCID of the DB system.
    DbSystemOsPatchHistoryEntryCollections List<GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollection>
    The list of db_system_os_patch_history_entry_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    Action string
    The action being performed or was completed.
    Filters List<GetDbSystemOsPatchHistoryEntriesFilter>
    State string
    The current state of the action.
    DbSystemId string
    The OCID of the DB system.
    DbSystemOsPatchHistoryEntryCollections []GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollection
    The list of db_system_os_patch_history_entry_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    Action string
    The action being performed or was completed.
    Filters []GetDbSystemOsPatchHistoryEntriesFilter
    State string
    The current state of the action.
    dbSystemId String
    The OCID of the DB system.
    dbSystemOsPatchHistoryEntryCollections List<GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollection>
    The list of db_system_os_patch_history_entry_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    action String
    The action being performed or was completed.
    filters List<GetDbSystemOsPatchHistoryEntriesFilter>
    state String
    The current state of the action.
    dbSystemId string
    The OCID of the DB system.
    dbSystemOsPatchHistoryEntryCollections GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollection[]
    The list of db_system_os_patch_history_entry_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    action string
    The action being performed or was completed.
    filters GetDbSystemOsPatchHistoryEntriesFilter[]
    state string
    The current state of the action.
    db_system_id str
    The OCID of the DB system.
    db_system_os_patch_history_entry_collections Sequence[GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollection]
    The list of db_system_os_patch_history_entry_collection.
    id str
    The provider-assigned unique ID for this managed resource.
    action str
    The action being performed or was completed.
    filters Sequence[GetDbSystemOsPatchHistoryEntriesFilter]
    state str
    The current state of the action.
    dbSystemId String
    The OCID of the DB system.
    dbSystemOsPatchHistoryEntryCollections List<Property Map>
    The list of db_system_os_patch_history_entry_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    action String
    The action being performed or was completed.
    filters List<Property Map>
    state String
    The current state of the action.

    Supporting Types

    GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollection

    items List<Property Map>
    Array of OS patch details for a DB System.

    GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollectionItem

    Action string
    A filter to return only OS patch history entries that match the specified OS patch action.
    DbSystemId string
    The DB system OCID.
    Id string
    The OCID of the OS patch history entry.
    LifecycleDetails string
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    OsPatchDetails List<GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollectionItemOsPatchDetail>
    Results of OS patch details for a DB System.
    State string
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    TimeEnded string
    The date and time when the patch action completed
    TimeStarted string
    The date and time when the patch action started.
    Action string
    A filter to return only OS patch history entries that match the specified OS patch action.
    DbSystemId string
    The DB system OCID.
    Id string
    The OCID of the OS patch history entry.
    LifecycleDetails string
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    OsPatchDetails []GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollectionItemOsPatchDetail
    Results of OS patch details for a DB System.
    State string
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    TimeEnded string
    The date and time when the patch action completed
    TimeStarted string
    The date and time when the patch action started.
    action String
    A filter to return only OS patch history entries that match the specified OS patch action.
    dbSystemId String
    The DB system OCID.
    id String
    The OCID of the OS patch history entry.
    lifecycleDetails String
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    osPatchDetails List<GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollectionItemOsPatchDetail>
    Results of OS patch details for a DB System.
    state String
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    timeEnded String
    The date and time when the patch action completed
    timeStarted String
    The date and time when the patch action started.
    action string
    A filter to return only OS patch history entries that match the specified OS patch action.
    dbSystemId string
    The DB system OCID.
    id string
    The OCID of the OS patch history entry.
    lifecycleDetails string
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    osPatchDetails GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollectionItemOsPatchDetail[]
    Results of OS patch details for a DB System.
    state string
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    timeEnded string
    The date and time when the patch action completed
    timeStarted string
    The date and time when the patch action started.
    action str
    A filter to return only OS patch history entries that match the specified OS patch action.
    db_system_id str
    The DB system OCID.
    id str
    The OCID of the OS patch history entry.
    lifecycle_details str
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    os_patch_details Sequence[GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollectionItemOsPatchDetail]
    Results of OS patch details for a DB System.
    state str
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    time_ended str
    The date and time when the patch action completed
    time_started str
    The date and time when the patch action started.
    action String
    A filter to return only OS patch history entries that match the specified OS patch action.
    dbSystemId String
    The DB system OCID.
    id String
    The OCID of the OS patch history entry.
    lifecycleDetails String
    A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
    osPatchDetails List<Property Map>
    Results of OS patch details for a DB System.
    state String
    A filter to return only OS patch history entries that match the given lifecycle state exactly.
    timeEnded String
    The date and time when the patch action completed
    timeStarted String
    The date and time when the patch action started.

    GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollectionItemOsPatchDetail

    items List<Property Map>
    Array of OS patch details for a DB System.

    GetDbSystemOsPatchHistoryEntriesDbSystemOsPatchHistoryEntryCollectionItemOsPatchDetailItem

    DbNodeId string
    The OCID of the DB node targeted for this patch action.
    IsRebootRequired bool
    Indicates whether a reboot is required after applying the patch.
    Rpms List<string>
    List of OS package identifiers (e.g., RPM strings).
    DbNodeId string
    The OCID of the DB node targeted for this patch action.
    IsRebootRequired bool
    Indicates whether a reboot is required after applying the patch.
    Rpms []string
    List of OS package identifiers (e.g., RPM strings).
    dbNodeId String
    The OCID of the DB node targeted for this patch action.
    isRebootRequired Boolean
    Indicates whether a reboot is required after applying the patch.
    rpms List<String>
    List of OS package identifiers (e.g., RPM strings).
    dbNodeId string
    The OCID of the DB node targeted for this patch action.
    isRebootRequired boolean
    Indicates whether a reboot is required after applying the patch.
    rpms string[]
    List of OS package identifiers (e.g., RPM strings).
    db_node_id str
    The OCID of the DB node targeted for this patch action.
    is_reboot_required bool
    Indicates whether a reboot is required after applying the patch.
    rpms Sequence[str]
    List of OS package identifiers (e.g., RPM strings).
    dbNodeId String
    The OCID of the DB node targeted for this patch action.
    isRebootRequired Boolean
    Indicates whether a reboot is required after applying the patch.
    rpms List<String>
    List of OS package identifiers (e.g., RPM strings).

    GetDbSystemOsPatchHistoryEntriesFilter

    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
    Viewing docs for Oracle Cloud Infrastructure v4.2.0
    published on Friday, Mar 6, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-oci
      Try Pulumi Cloud free. Your team will thank you.