1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Opsi
  5. getDatabaseInsights
Oracle Cloud Infrastructure v0.20.1 published on Tuesday, Jun 6, 2023 by Pulumi

oci.Opsi.getDatabaseInsights

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v0.20.1 published on Tuesday, Jun 6, 2023 by Pulumi

    This data source provides the list of Database Insights in Oracle Cloud Infrastructure Opsi service.

    Gets a list of database insights based on the query parameters specified. Either compartmentId or id query parameter must be specified. When both compartmentId and compartmentIdInSubtree are specified, a list of database insights in that compartment and in all sub-compartments will be returned.

    Example Usage

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Oci = Pulumi.Oci;
    
    return await Deployment.RunAsync(() => 
    {
        var testDatabaseInsights = Oci.Opsi.GetDatabaseInsights.Invoke(new()
        {
            CompartmentId = @var.Compartment_id,
            CompartmentIdInSubtree = @var.Database_insight_compartment_id_in_subtree,
            DatabaseIds = oci_database_database.Test_database.Id,
            DatabaseTypes = @var.Database_insight_database_type,
            EnterpriseManagerBridgeId = oci_opsi_enterprise_manager_bridge.Test_enterprise_manager_bridge.Id,
            ExadataInsightId = oci_opsi_exadata_insight.Test_exadata_insight.Id,
            Fields = @var.Database_insight_fields,
            Id = @var.Database_insight_id,
            OpsiPrivateEndpointId = oci_dataflow_private_endpoint.Test_private_endpoint.Id,
            States = @var.Database_insight_state,
            Statuses = @var.Database_insight_status,
        });
    
    });
    
    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.GetDatabaseInsights(ctx, &opsi.GetDatabaseInsightsArgs{
    			CompartmentId:             pulumi.StringRef(_var.Compartment_id),
    			CompartmentIdInSubtree:    pulumi.BoolRef(_var.Database_insight_compartment_id_in_subtree),
    			DatabaseIds:               oci_database_database.Test_database.Id,
    			DatabaseTypes:             _var.Database_insight_database_type,
    			EnterpriseManagerBridgeId: pulumi.StringRef(oci_opsi_enterprise_manager_bridge.Test_enterprise_manager_bridge.Id),
    			ExadataInsightId:          pulumi.StringRef(oci_opsi_exadata_insight.Test_exadata_insight.Id),
    			Fields:                    _var.Database_insight_fields,
    			Id:                        pulumi.StringRef(_var.Database_insight_id),
    			OpsiPrivateEndpointId:     pulumi.StringRef(oci_dataflow_private_endpoint.Test_private_endpoint.Id),
    			States:                    _var.Database_insight_state,
    			Statuses:                  _var.Database_insight_status,
    		}, 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.GetDatabaseInsightsArgs;
    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 testDatabaseInsights = OpsiFunctions.getDatabaseInsights(GetDatabaseInsightsArgs.builder()
                .compartmentId(var_.compartment_id())
                .compartmentIdInSubtree(var_.database_insight_compartment_id_in_subtree())
                .databaseIds(oci_database_database.test_database().id())
                .databaseTypes(var_.database_insight_database_type())
                .enterpriseManagerBridgeId(oci_opsi_enterprise_manager_bridge.test_enterprise_manager_bridge().id())
                .exadataInsightId(oci_opsi_exadata_insight.test_exadata_insight().id())
                .fields(var_.database_insight_fields())
                .id(var_.database_insight_id())
                .opsiPrivateEndpointId(oci_dataflow_private_endpoint.test_private_endpoint().id())
                .states(var_.database_insight_state())
                .statuses(var_.database_insight_status())
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_oci as oci
    
    test_database_insights = oci.Opsi.get_database_insights(compartment_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        compartment_id_in_subtree=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        database_ids=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        database_types=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        enterprise_manager_bridge_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        exadata_insight_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        fields=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        opsi_private_endpoint_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        states=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
        statuses=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    
    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testDatabaseInsights = oci.Opsi.getDatabaseInsights({
        compartmentId: _var.compartment_id,
        compartmentIdInSubtree: _var.database_insight_compartment_id_in_subtree,
        databaseIds: oci_database_database.test_database.id,
        databaseTypes: _var.database_insight_database_type,
        enterpriseManagerBridgeId: oci_opsi_enterprise_manager_bridge.test_enterprise_manager_bridge.id,
        exadataInsightId: oci_opsi_exadata_insight.test_exadata_insight.id,
        fields: _var.database_insight_fields,
        id: _var.database_insight_id,
        opsiPrivateEndpointId: oci_dataflow_private_endpoint.test_private_endpoint.id,
        states: _var.database_insight_state,
        statuses: _var.database_insight_status,
    });
    
    variables:
      testDatabaseInsights:
        fn::invoke:
          Function: oci:Opsi:getDatabaseInsights
          Arguments:
            compartmentId: ${var.compartment_id}
            compartmentIdInSubtree: ${var.database_insight_compartment_id_in_subtree}
            databaseIds: ${oci_database_database.test_database.id}
            databaseTypes: ${var.database_insight_database_type}
            enterpriseManagerBridgeId: ${oci_opsi_enterprise_manager_bridge.test_enterprise_manager_bridge.id}
            exadataInsightId: ${oci_opsi_exadata_insight.test_exadata_insight.id}
            fields: ${var.database_insight_fields}
            id: ${var.database_insight_id}
            opsiPrivateEndpointId: ${oci_dataflow_private_endpoint.test_private_endpoint.id}
            states: ${var.database_insight_state}
            statuses: ${var.database_insight_status}
    

    Using getDatabaseInsights

    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 getDatabaseInsights(args: GetDatabaseInsightsArgs, opts?: InvokeOptions): Promise<GetDatabaseInsightsResult>
    function getDatabaseInsightsOutput(args: GetDatabaseInsightsOutputArgs, opts?: InvokeOptions): Output<GetDatabaseInsightsResult>
    def get_database_insights(compartment_id: Optional[str] = None,
                              compartment_id_in_subtree: Optional[bool] = None,
                              database_ids: Optional[Sequence[str]] = None,
                              database_types: Optional[Sequence[str]] = None,
                              enterprise_manager_bridge_id: Optional[str] = None,
                              exadata_insight_id: Optional[str] = None,
                              fields: Optional[Sequence[str]] = None,
                              filters: Optional[Sequence[_opsi.GetDatabaseInsightsFilter]] = None,
                              id: Optional[str] = None,
                              opsi_private_endpoint_id: Optional[str] = None,
                              states: Optional[Sequence[str]] = None,
                              statuses: Optional[Sequence[str]] = None,
                              opts: Optional[InvokeOptions] = None) -> GetDatabaseInsightsResult
    def get_database_insights_output(compartment_id: Optional[pulumi.Input[str]] = None,
                              compartment_id_in_subtree: Optional[pulumi.Input[bool]] = None,
                              database_ids: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                              database_types: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                              enterprise_manager_bridge_id: Optional[pulumi.Input[str]] = None,
                              exadata_insight_id: Optional[pulumi.Input[str]] = None,
                              fields: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                              filters: Optional[pulumi.Input[Sequence[pulumi.Input[_opsi.GetDatabaseInsightsFilterArgs]]]] = None,
                              id: Optional[pulumi.Input[str]] = None,
                              opsi_private_endpoint_id: Optional[pulumi.Input[str]] = None,
                              states: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                              statuses: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                              opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseInsightsResult]
    func GetDatabaseInsights(ctx *Context, args *GetDatabaseInsightsArgs, opts ...InvokeOption) (*GetDatabaseInsightsResult, error)
    func GetDatabaseInsightsOutput(ctx *Context, args *GetDatabaseInsightsOutputArgs, opts ...InvokeOption) GetDatabaseInsightsResultOutput

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

    public static class GetDatabaseInsights 
    {
        public static Task<GetDatabaseInsightsResult> InvokeAsync(GetDatabaseInsightsArgs args, InvokeOptions? opts = null)
        public static Output<GetDatabaseInsightsResult> Invoke(GetDatabaseInsightsInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetDatabaseInsightsResult> getDatabaseInsights(GetDatabaseInsightsArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:Opsi/getDatabaseInsights:getDatabaseInsights
      arguments:
        # arguments dictionary

    The following arguments are supported:

    CompartmentId string

    The OCID of the compartment.

    CompartmentIdInSubtree bool

    A flag to search all resources within a given compartment and all sub-compartments.

    DatabaseIds List<string>

    Optional list of database OCIDs of the associated DBaaS entity.

    DatabaseTypes List<string>

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    EnterpriseManagerBridgeId string

    Unique Enterprise Manager bridge identifier

    ExadataInsightId string

    OCID of exadata insight resource.

    Fields List<string>

    Specifies the fields to return in a database summary response. By default all fields are returned if omitted.

    Filters List<GetDatabaseInsightsFilter>
    Id string

    Optional list of database insight resource OCIDs.

    OpsiPrivateEndpointId string

    Unique Operations Insights PrivateEndpoint identifier

    States List<string>

    Lifecycle states

    Statuses List<string>

    Resource Status

    CompartmentId string

    The OCID of the compartment.

    CompartmentIdInSubtree bool

    A flag to search all resources within a given compartment and all sub-compartments.

    DatabaseIds []string

    Optional list of database OCIDs of the associated DBaaS entity.

    DatabaseTypes []string

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    EnterpriseManagerBridgeId string

    Unique Enterprise Manager bridge identifier

    ExadataInsightId string

    OCID of exadata insight resource.

    Fields []string

    Specifies the fields to return in a database summary response. By default all fields are returned if omitted.

    Filters []GetDatabaseInsightsFilter
    Id string

    Optional list of database insight resource OCIDs.

    OpsiPrivateEndpointId string

    Unique Operations Insights PrivateEndpoint identifier

    States []string

    Lifecycle states

    Statuses []string

    Resource Status

    compartmentId String

    The OCID of the compartment.

    compartmentIdInSubtree Boolean

    A flag to search all resources within a given compartment and all sub-compartments.

    databaseIds List<String>

    Optional list of database OCIDs of the associated DBaaS entity.

    databaseTypes List<String>

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    enterpriseManagerBridgeId String

    Unique Enterprise Manager bridge identifier

    exadataInsightId String

    OCID of exadata insight resource.

    fields List<String>

    Specifies the fields to return in a database summary response. By default all fields are returned if omitted.

    filters List<GetDatabaseInsightsFilter>
    id String

    Optional list of database insight resource OCIDs.

    opsiPrivateEndpointId String

    Unique Operations Insights PrivateEndpoint identifier

    states List<String>

    Lifecycle states

    statuses List<String>

    Resource Status

    compartmentId string

    The OCID of the compartment.

    compartmentIdInSubtree boolean

    A flag to search all resources within a given compartment and all sub-compartments.

    databaseIds string[]

    Optional list of database OCIDs of the associated DBaaS entity.

    databaseTypes string[]

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    enterpriseManagerBridgeId string

    Unique Enterprise Manager bridge identifier

    exadataInsightId string

    OCID of exadata insight resource.

    fields string[]

    Specifies the fields to return in a database summary response. By default all fields are returned if omitted.

    filters GetDatabaseInsightsFilter[]
    id string

    Optional list of database insight resource OCIDs.

    opsiPrivateEndpointId string

    Unique Operations Insights PrivateEndpoint identifier

    states string[]

    Lifecycle states

    statuses string[]

    Resource Status

    compartment_id str

    The OCID of the compartment.

    compartment_id_in_subtree bool

    A flag to search all resources within a given compartment and all sub-compartments.

    database_ids Sequence[str]

    Optional list of database OCIDs of the associated DBaaS entity.

    database_types Sequence[str]

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    enterprise_manager_bridge_id str

    Unique Enterprise Manager bridge identifier

    exadata_insight_id str

    OCID of exadata insight resource.

    fields Sequence[str]

    Specifies the fields to return in a database summary response. By default all fields are returned if omitted.

    filters GetDatabaseInsightsFilter]
    id str

    Optional list of database insight resource OCIDs.

    opsi_private_endpoint_id str

    Unique Operations Insights PrivateEndpoint identifier

    states Sequence[str]

    Lifecycle states

    statuses Sequence[str]

    Resource Status

    compartmentId String

    The OCID of the compartment.

    compartmentIdInSubtree Boolean

    A flag to search all resources within a given compartment and all sub-compartments.

    databaseIds List<String>

    Optional list of database OCIDs of the associated DBaaS entity.

    databaseTypes List<String>

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    enterpriseManagerBridgeId String

    Unique Enterprise Manager bridge identifier

    exadataInsightId String

    OCID of exadata insight resource.

    fields List<String>

    Specifies the fields to return in a database summary response. By default all fields are returned if omitted.

    filters List<Property Map>
    id String

    Optional list of database insight resource OCIDs.

    opsiPrivateEndpointId String

    Unique Operations Insights PrivateEndpoint identifier

    states List<String>

    Lifecycle states

    statuses List<String>

    Resource Status

    getDatabaseInsights Result

    The following output properties are available:

    DatabaseInsightsCollections List<GetDatabaseInsightsDatabaseInsightsCollection>

    The list of database_insights_collection.

    CompartmentId string

    Compartment identifier of the database

    CompartmentIdInSubtree bool
    DatabaseIds List<string>

    The OCID of the database.

    DatabaseTypes List<string>

    Operations Insights internal representation of the database type.

    EnterpriseManagerBridgeId string

    OPSI Enterprise Manager Bridge OCID

    ExadataInsightId string

    The OCID of the Exadata insight.

    Fields List<string>
    Filters List<GetDatabaseInsightsFilter>
    Id string

    Database insight identifier

    OpsiPrivateEndpointId string

    The OCID of the OPSI private endpoint

    States List<string>

    The current state of the database.

    Statuses List<string>

    Indicates the status of a database insight in Operations Insights

    DatabaseInsightsCollections []GetDatabaseInsightsDatabaseInsightsCollection

    The list of database_insights_collection.

    CompartmentId string

    Compartment identifier of the database

    CompartmentIdInSubtree bool
    DatabaseIds []string

    The OCID of the database.

    DatabaseTypes []string

    Operations Insights internal representation of the database type.

    EnterpriseManagerBridgeId string

    OPSI Enterprise Manager Bridge OCID

    ExadataInsightId string

    The OCID of the Exadata insight.

    Fields []string
    Filters []GetDatabaseInsightsFilter
    Id string

    Database insight identifier

    OpsiPrivateEndpointId string

    The OCID of the OPSI private endpoint

    States []string

    The current state of the database.

    Statuses []string

    Indicates the status of a database insight in Operations Insights

    databaseInsightsCollections List<GetDatabaseInsightsDatabaseInsightsCollection>

    The list of database_insights_collection.

    compartmentId String

    Compartment identifier of the database

    compartmentIdInSubtree Boolean
    databaseIds List<String>

    The OCID of the database.

    databaseTypes List<String>

    Operations Insights internal representation of the database type.

    enterpriseManagerBridgeId String

    OPSI Enterprise Manager Bridge OCID

    exadataInsightId String

    The OCID of the Exadata insight.

    fields List<String>
    filters List<GetDatabaseInsightsFilter>
    id String

    Database insight identifier

    opsiPrivateEndpointId String

    The OCID of the OPSI private endpoint

    states List<String>

    The current state of the database.

    statuses List<String>

    Indicates the status of a database insight in Operations Insights

    databaseInsightsCollections GetDatabaseInsightsDatabaseInsightsCollection[]

    The list of database_insights_collection.

    compartmentId string

    Compartment identifier of the database

    compartmentIdInSubtree boolean
    databaseIds string[]

    The OCID of the database.

    databaseTypes string[]

    Operations Insights internal representation of the database type.

    enterpriseManagerBridgeId string

    OPSI Enterprise Manager Bridge OCID

    exadataInsightId string

    The OCID of the Exadata insight.

    fields string[]
    filters GetDatabaseInsightsFilter[]
    id string

    Database insight identifier

    opsiPrivateEndpointId string

    The OCID of the OPSI private endpoint

    states string[]

    The current state of the database.

    statuses string[]

    Indicates the status of a database insight in Operations Insights

    database_insights_collections GetDatabaseInsightsDatabaseInsightsCollection]

    The list of database_insights_collection.

    compartment_id str

    Compartment identifier of the database

    compartment_id_in_subtree bool
    database_ids Sequence[str]

    The OCID of the database.

    database_types Sequence[str]

    Operations Insights internal representation of the database type.

    enterprise_manager_bridge_id str

    OPSI Enterprise Manager Bridge OCID

    exadata_insight_id str

    The OCID of the Exadata insight.

    fields Sequence[str]
    filters GetDatabaseInsightsFilter]
    id str

    Database insight identifier

    opsi_private_endpoint_id str

    The OCID of the OPSI private endpoint

    states Sequence[str]

    The current state of the database.

    statuses Sequence[str]

    Indicates the status of a database insight in Operations Insights

    databaseInsightsCollections List<Property Map>

    The list of database_insights_collection.

    compartmentId String

    Compartment identifier of the database

    compartmentIdInSubtree Boolean
    databaseIds List<String>

    The OCID of the database.

    databaseTypes List<String>

    Operations Insights internal representation of the database type.

    enterpriseManagerBridgeId String

    OPSI Enterprise Manager Bridge OCID

    exadataInsightId String

    The OCID of the Exadata insight.

    fields List<String>
    filters List<Property Map>
    id String

    Database insight identifier

    opsiPrivateEndpointId String

    The OCID of the OPSI private endpoint

    states List<String>

    The current state of the database.

    statuses List<String>

    Indicates the status of a database insight in Operations Insights

    Supporting Types

    GetDatabaseInsightsDatabaseInsightsCollection

    GetDatabaseInsightsDatabaseInsightsCollectionItem

    CompartmentId string

    The OCID of the compartment.

    ConnectionCredentialDetails List<GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionCredentialDetail>

    User credential details to connect to the database. This is supplied via the External Database Service.

    ConnectionDetails List<GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetail>

    Connection details to connect to the database. HostName, protocol, and port should be specified.

    CredentialDetails List<GetDatabaseInsightsDatabaseInsightsCollectionItemCredentialDetail>

    User credential details to connect to the database. This is supplied via the External Database Service.

    DatabaseConnectionStatusDetails string

    A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

    DatabaseDisplayName string

    Display name of database

    DatabaseId string

    Optional list of database OCIDs of the associated DBaaS entity.

    DatabaseName string

    Name of database

    DatabaseResourceType string

    Oracle Cloud Infrastructure database resource type

    DatabaseType string

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    DatabaseVersion string

    The version of the database.

    DbmPrivateEndpointId string
    DefinedTags Dictionary<string, object>

    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

    DeploymentType string
    EnterpriseManagerBridgeId string

    Unique Enterprise Manager bridge identifier

    EnterpriseManagerEntityDisplayName string

    Enterprise Manager Entity Display Name

    EnterpriseManagerEntityIdentifier string

    Enterprise Manager Entity Unique Identifier

    EnterpriseManagerEntityName string

    Enterprise Manager Entity Name

    EnterpriseManagerEntityType string

    Enterprise Manager Entity Type

    EnterpriseManagerIdentifier string

    Enterprise Manager Unqiue Identifier

    EntitySource string

    Source of the database entity.

    ExadataInsightId string

    OCID of exadata insight resource.

    FreeformTags Dictionary<string, object>

    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    Id string

    Optional list of database insight resource OCIDs.

    LifecycleDetails string

    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.

    OpsiPrivateEndpointId string

    Unique Operations Insights PrivateEndpoint identifier

    ParentId string

    The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.

    ProcessorCount int

    Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

    RootId string

    The OCID of the Exadata Infrastructure.

    ServiceName string

    Database service name used for connection requests.

    State string

    Lifecycle states

    Status string

    Resource Status

    SystemTags Dictionary<string, object>

    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

    TimeCreated string

    The time the the database insight was first enabled. An RFC3339 formatted datetime string

    TimeUpdated string

    The time the database insight was updated. An RFC3339 formatted datetime string

    CompartmentId string

    The OCID of the compartment.

    ConnectionCredentialDetails []GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionCredentialDetail

    User credential details to connect to the database. This is supplied via the External Database Service.

    ConnectionDetails []GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetail

    Connection details to connect to the database. HostName, protocol, and port should be specified.

    CredentialDetails []GetDatabaseInsightsDatabaseInsightsCollectionItemCredentialDetail

    User credential details to connect to the database. This is supplied via the External Database Service.

    DatabaseConnectionStatusDetails string

    A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

    DatabaseDisplayName string

    Display name of database

    DatabaseId string

    Optional list of database OCIDs of the associated DBaaS entity.

    DatabaseName string

    Name of database

    DatabaseResourceType string

    Oracle Cloud Infrastructure database resource type

    DatabaseType string

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    DatabaseVersion string

    The version of the database.

    DbmPrivateEndpointId string
    DefinedTags map[string]interface{}

    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

    DeploymentType string
    EnterpriseManagerBridgeId string

    Unique Enterprise Manager bridge identifier

    EnterpriseManagerEntityDisplayName string

    Enterprise Manager Entity Display Name

    EnterpriseManagerEntityIdentifier string

    Enterprise Manager Entity Unique Identifier

    EnterpriseManagerEntityName string

    Enterprise Manager Entity Name

    EnterpriseManagerEntityType string

    Enterprise Manager Entity Type

    EnterpriseManagerIdentifier string

    Enterprise Manager Unqiue Identifier

    EntitySource string

    Source of the database entity.

    ExadataInsightId string

    OCID of exadata insight resource.

    FreeformTags map[string]interface{}

    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    Id string

    Optional list of database insight resource OCIDs.

    LifecycleDetails string

    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.

    OpsiPrivateEndpointId string

    Unique Operations Insights PrivateEndpoint identifier

    ParentId string

    The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.

    ProcessorCount int

    Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

    RootId string

    The OCID of the Exadata Infrastructure.

    ServiceName string

    Database service name used for connection requests.

    State string

    Lifecycle states

    Status string

    Resource Status

    SystemTags map[string]interface{}

    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

    TimeCreated string

    The time the the database insight was first enabled. An RFC3339 formatted datetime string

    TimeUpdated string

    The time the database insight was updated. An RFC3339 formatted datetime string

    compartmentId String

    The OCID of the compartment.

    connectionCredentialDetails List<GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionCredentialDetail>

    User credential details to connect to the database. This is supplied via the External Database Service.

    connectionDetails List<GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetail>

    Connection details to connect to the database. HostName, protocol, and port should be specified.

    credentialDetails List<GetDatabaseInsightsDatabaseInsightsCollectionItemCredentialDetail>

    User credential details to connect to the database. This is supplied via the External Database Service.

    databaseConnectionStatusDetails String

    A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

    databaseDisplayName String

    Display name of database

    databaseId String

    Optional list of database OCIDs of the associated DBaaS entity.

    databaseName String

    Name of database

    databaseResourceType String

    Oracle Cloud Infrastructure database resource type

    databaseType String

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    databaseVersion String

    The version of the database.

    dbmPrivateEndpointId String
    definedTags Map<String,Object>

    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

    deploymentType String
    enterpriseManagerBridgeId String

    Unique Enterprise Manager bridge identifier

    enterpriseManagerEntityDisplayName String

    Enterprise Manager Entity Display Name

    enterpriseManagerEntityIdentifier String

    Enterprise Manager Entity Unique Identifier

    enterpriseManagerEntityName String

    Enterprise Manager Entity Name

    enterpriseManagerEntityType String

    Enterprise Manager Entity Type

    enterpriseManagerIdentifier String

    Enterprise Manager Unqiue Identifier

    entitySource String

    Source of the database entity.

    exadataInsightId String

    OCID of exadata insight resource.

    freeformTags Map<String,Object>

    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    id String

    Optional list of database insight resource OCIDs.

    lifecycleDetails String

    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.

    opsiPrivateEndpointId String

    Unique Operations Insights PrivateEndpoint identifier

    parentId String

    The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.

    processorCount Integer

    Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

    rootId String

    The OCID of the Exadata Infrastructure.

    serviceName String

    Database service name used for connection requests.

    state String

    Lifecycle states

    status String

    Resource Status

    systemTags Map<String,Object>

    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

    timeCreated String

    The time the the database insight was first enabled. An RFC3339 formatted datetime string

    timeUpdated String

    The time the database insight was updated. An RFC3339 formatted datetime string

    compartmentId string

    The OCID of the compartment.

    connectionCredentialDetails GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionCredentialDetail[]

    User credential details to connect to the database. This is supplied via the External Database Service.

    connectionDetails GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetail[]

    Connection details to connect to the database. HostName, protocol, and port should be specified.

    credentialDetails GetDatabaseInsightsDatabaseInsightsCollectionItemCredentialDetail[]

    User credential details to connect to the database. This is supplied via the External Database Service.

    databaseConnectionStatusDetails string

    A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

    databaseDisplayName string

    Display name of database

    databaseId string

    Optional list of database OCIDs of the associated DBaaS entity.

    databaseName string

    Name of database

    databaseResourceType string

    Oracle Cloud Infrastructure database resource type

    databaseType string

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    databaseVersion string

    The version of the database.

    dbmPrivateEndpointId string
    definedTags {[key: string]: any}

    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

    deploymentType string
    enterpriseManagerBridgeId string

    Unique Enterprise Manager bridge identifier

    enterpriseManagerEntityDisplayName string

    Enterprise Manager Entity Display Name

    enterpriseManagerEntityIdentifier string

    Enterprise Manager Entity Unique Identifier

    enterpriseManagerEntityName string

    Enterprise Manager Entity Name

    enterpriseManagerEntityType string

    Enterprise Manager Entity Type

    enterpriseManagerIdentifier string

    Enterprise Manager Unqiue Identifier

    entitySource string

    Source of the database entity.

    exadataInsightId string

    OCID of exadata insight resource.

    freeformTags {[key: string]: any}

    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    id string

    Optional list of database insight resource OCIDs.

    lifecycleDetails string

    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.

    opsiPrivateEndpointId string

    Unique Operations Insights PrivateEndpoint identifier

    parentId string

    The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.

    processorCount number

    Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

    rootId string

    The OCID of the Exadata Infrastructure.

    serviceName string

    Database service name used for connection requests.

    state string

    Lifecycle states

    status string

    Resource Status

    systemTags {[key: string]: any}

    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

    timeCreated string

    The time the the database insight was first enabled. An RFC3339 formatted datetime string

    timeUpdated string

    The time the database insight was updated. An RFC3339 formatted datetime string

    compartment_id str

    The OCID of the compartment.

    connection_credential_details GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionCredentialDetail]

    User credential details to connect to the database. This is supplied via the External Database Service.

    connection_details GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetail]

    Connection details to connect to the database. HostName, protocol, and port should be specified.

    credential_details GetDatabaseInsightsDatabaseInsightsCollectionItemCredentialDetail]

    User credential details to connect to the database. This is supplied via the External Database Service.

    database_connection_status_details str

    A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

    database_display_name str

    Display name of database

    database_id str

    Optional list of database OCIDs of the associated DBaaS entity.

    database_name str

    Name of database

    database_resource_type str

    Oracle Cloud Infrastructure database resource type

    database_type str

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    database_version str

    The version of the database.

    dbm_private_endpoint_id str
    defined_tags Mapping[str, Any]

    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

    deployment_type str
    enterprise_manager_bridge_id str

    Unique Enterprise Manager bridge identifier

    enterprise_manager_entity_display_name str

    Enterprise Manager Entity Display Name

    enterprise_manager_entity_identifier str

    Enterprise Manager Entity Unique Identifier

    enterprise_manager_entity_name str

    Enterprise Manager Entity Name

    enterprise_manager_entity_type str

    Enterprise Manager Entity Type

    enterprise_manager_identifier str

    Enterprise Manager Unqiue Identifier

    entity_source str

    Source of the database entity.

    exadata_insight_id str

    OCID of exadata insight resource.

    freeform_tags Mapping[str, Any]

    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    id str

    Optional list of database insight resource OCIDs.

    lifecycle_details str

    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.

    opsi_private_endpoint_id str

    Unique Operations Insights PrivateEndpoint identifier

    parent_id str

    The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.

    processor_count int

    Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

    root_id str

    The OCID of the Exadata Infrastructure.

    service_name str

    Database service name used for connection requests.

    state str

    Lifecycle states

    status str

    Resource Status

    system_tags Mapping[str, Any]

    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

    time_created str

    The time the the database insight was first enabled. An RFC3339 formatted datetime string

    time_updated str

    The time the database insight was updated. An RFC3339 formatted datetime string

    compartmentId String

    The OCID of the compartment.

    connectionCredentialDetails List<Property Map>

    User credential details to connect to the database. This is supplied via the External Database Service.

    connectionDetails List<Property Map>

    Connection details to connect to the database. HostName, protocol, and port should be specified.

    credentialDetails List<Property Map>

    User credential details to connect to the database. This is supplied via the External Database Service.

    databaseConnectionStatusDetails String

    A message describing the status of the database connection of this resource. For example, it can be used to provide actionable information about the permission and content validity of the database connection.

    databaseDisplayName String

    Display name of database

    databaseId String

    Optional list of database OCIDs of the associated DBaaS entity.

    databaseName String

    Name of database

    databaseResourceType String

    Oracle Cloud Infrastructure database resource type

    databaseType String

    Filter by one or more database type. Possible values are ADW-S, ATP-S, ADW-D, ATP-D, EXTERNAL-PDB, EXTERNAL-NONCDB.

    databaseVersion String

    The version of the database.

    dbmPrivateEndpointId String
    definedTags Map<Any>

    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}

    deploymentType String
    enterpriseManagerBridgeId String

    Unique Enterprise Manager bridge identifier

    enterpriseManagerEntityDisplayName String

    Enterprise Manager Entity Display Name

    enterpriseManagerEntityIdentifier String

    Enterprise Manager Entity Unique Identifier

    enterpriseManagerEntityName String

    Enterprise Manager Entity Name

    enterpriseManagerEntityType String

    Enterprise Manager Entity Type

    enterpriseManagerIdentifier String

    Enterprise Manager Unqiue Identifier

    entitySource String

    Source of the database entity.

    exadataInsightId String

    OCID of exadata insight resource.

    freeformTags Map<Any>

    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    id String

    Optional list of database insight resource OCIDs.

    lifecycleDetails String

    A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.

    opsiPrivateEndpointId String

    Unique Operations Insights PrivateEndpoint identifier

    parentId String

    The OCID of the VM Cluster or DB System ID, depending on which configuration the resource belongs to.

    processorCount Number

    Processor count. This is the OCPU count for Autonomous Database and CPU core count for other database types.

    rootId String

    The OCID of the Exadata Infrastructure.

    serviceName String

    Database service name used for connection requests.

    state String

    Lifecycle states

    status String

    Resource Status

    systemTags Map<Any>

    System tags for this resource. Each key is predefined and scoped to a namespace. Example: {"orcl-cloud.free-tier-retained": "true"}

    timeCreated String

    The time the the database insight was first enabled. An RFC3339 formatted datetime string

    timeUpdated String

    The time the database insight was updated. An RFC3339 formatted datetime string

    GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionCredentialDetail

    CredentialSourceName string

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    CredentialType string

    Credential type.

    PasswordSecretId string

    The secret OCID mapping to the database credentials.

    Role string

    database user role.

    UserName string

    database user name.

    CredentialSourceName string

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    CredentialType string

    Credential type.

    PasswordSecretId string

    The secret OCID mapping to the database credentials.

    Role string

    database user role.

    UserName string

    database user name.

    credentialSourceName String

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    credentialType String

    Credential type.

    passwordSecretId String

    The secret OCID mapping to the database credentials.

    role String

    database user role.

    userName String

    database user name.

    credentialSourceName string

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    credentialType string

    Credential type.

    passwordSecretId string

    The secret OCID mapping to the database credentials.

    role string

    database user role.

    userName string

    database user name.

    credential_source_name str

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    credential_type str

    Credential type.

    password_secret_id str

    The secret OCID mapping to the database credentials.

    role str

    database user role.

    user_name str

    database user name.

    credentialSourceName String

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    credentialType String

    Credential type.

    passwordSecretId String

    The secret OCID mapping to the database credentials.

    role String

    database user role.

    userName String

    database user name.

    GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetail

    HostName string

    Name of the listener host that will be used to create the connect string to the database.

    Hosts List<GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetailHost>

    List of hosts and port for private endpoint accessed database resource.

    Port int

    Listener port number used for connection requests.

    Protocol string

    Protocol used for connection requests for private endpoint accssed database resource.

    ServiceName string

    Database service name used for connection requests.

    HostName string

    Name of the listener host that will be used to create the connect string to the database.

    Hosts []GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetailHost

    List of hosts and port for private endpoint accessed database resource.

    Port int

    Listener port number used for connection requests.

    Protocol string

    Protocol used for connection requests for private endpoint accssed database resource.

    ServiceName string

    Database service name used for connection requests.

    hostName String

    Name of the listener host that will be used to create the connect string to the database.

    hosts List<GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetailHost>

    List of hosts and port for private endpoint accessed database resource.

    port Integer

    Listener port number used for connection requests.

    protocol String

    Protocol used for connection requests for private endpoint accssed database resource.

    serviceName String

    Database service name used for connection requests.

    hostName string

    Name of the listener host that will be used to create the connect string to the database.

    hosts GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetailHost[]

    List of hosts and port for private endpoint accessed database resource.

    port number

    Listener port number used for connection requests.

    protocol string

    Protocol used for connection requests for private endpoint accssed database resource.

    serviceName string

    Database service name used for connection requests.

    host_name str

    Name of the listener host that will be used to create the connect string to the database.

    hosts GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetailHost]

    List of hosts and port for private endpoint accessed database resource.

    port int

    Listener port number used for connection requests.

    protocol str

    Protocol used for connection requests for private endpoint accssed database resource.

    service_name str

    Database service name used for connection requests.

    hostName String

    Name of the listener host that will be used to create the connect string to the database.

    hosts List<Property Map>

    List of hosts and port for private endpoint accessed database resource.

    port Number

    Listener port number used for connection requests.

    protocol String

    Protocol used for connection requests for private endpoint accssed database resource.

    serviceName String

    Database service name used for connection requests.

    GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetailHost

    HostIp string

    Host IP used for connection requests for Cloud DB resource.

    Port int

    Listener port number used for connection requests.

    HostIp string

    Host IP used for connection requests for Cloud DB resource.

    Port int

    Listener port number used for connection requests.

    hostIp String

    Host IP used for connection requests for Cloud DB resource.

    port Integer

    Listener port number used for connection requests.

    hostIp string

    Host IP used for connection requests for Cloud DB resource.

    port number

    Listener port number used for connection requests.

    host_ip str

    Host IP used for connection requests for Cloud DB resource.

    port int

    Listener port number used for connection requests.

    hostIp String

    Host IP used for connection requests for Cloud DB resource.

    port Number

    Listener port number used for connection requests.

    GetDatabaseInsightsDatabaseInsightsCollectionItemCredentialDetail

    CredentialSourceName string

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    CredentialType string

    Credential type.

    PasswordSecretId string

    The secret OCID mapping to the database credentials.

    Role string

    database user role.

    UserName string

    database user name.

    CredentialSourceName string

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    CredentialType string

    Credential type.

    PasswordSecretId string

    The secret OCID mapping to the database credentials.

    Role string

    database user role.

    UserName string

    database user name.

    credentialSourceName String

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    credentialType String

    Credential type.

    passwordSecretId String

    The secret OCID mapping to the database credentials.

    role String

    database user role.

    userName String

    database user name.

    credentialSourceName string

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    credentialType string

    Credential type.

    passwordSecretId string

    The secret OCID mapping to the database credentials.

    role string

    database user role.

    userName string

    database user name.

    credential_source_name str

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    credential_type str

    Credential type.

    password_secret_id str

    The secret OCID mapping to the database credentials.

    role str

    database user role.

    user_name str

    database user name.

    credentialSourceName String

    Credential source name that had been added in Management Agent wallet. This is supplied in the External Database Service.

    credentialType String

    Credential type.

    passwordSecretId String

    The secret OCID mapping to the database credentials.

    role String

    database user role.

    userName String

    database user name.

    GetDatabaseInsightsFilter

    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 v0.20.1 published on Tuesday, Jun 6, 2023 by Pulumi