1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Opsi
  5. getDatabaseInsights
Oracle Cloud Infrastructure v1.31.0 published on Wednesday, Apr 10, 2024 by Pulumi

oci.Opsi.getDatabaseInsights

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.31.0 published on Wednesday, Apr 10, 2024 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

    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,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_database_insights = oci.Opsi.get_database_insights(compartment_id=var["compartment_id"],
        compartment_id_in_subtree=var["database_insight_compartment_id_in_subtree"],
        database_ids=oci_database_database["test_database"]["id"],
        database_types=var["database_insight_database_type"],
        enterprise_manager_bridge_id=oci_opsi_enterprise_manager_bridge["test_enterprise_manager_bridge"]["id"],
        exadata_insight_id=oci_opsi_exadata_insight["test_exadata_insight"]["id"],
        fields=var["database_insight_fields"],
        id=var["database_insight_id"],
        opsi_private_endpoint_id=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
    	})
    }
    
    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 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());
    
        }
    }
    
    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 Sequence[opsi.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 Sequence[opsi.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 Sequence[opsi.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 Sequence[opsi.GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionCredentialDetail]
    User credential details to connect to the database. This is supplied via the External Database Service.
    connection_details Sequence[opsi.GetDatabaseInsightsDatabaseInsightsCollectionItemConnectionDetail]
    Connection details to connect to the database. HostName, protocol, and port should be specified.
    credential_details Sequence[opsi.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.
    WalletSecretId string
    The OCID of the Secret where the database keystore contents are stored.
    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.
    WalletSecretId string
    The OCID of the Secret where the database keystore contents are stored.
    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.
    walletSecretId String
    The OCID of the Secret where the database keystore contents are stored.
    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.
    walletSecretId string
    The OCID of the Secret where the database keystore contents are stored.
    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.
    wallet_secret_id str
    The OCID of the Secret where the database keystore contents are stored.
    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.
    walletSecretId String
    The OCID of the Secret where the database keystore contents are stored.

    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 Sequence[opsi.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.
    WalletSecretId string
    The OCID of the Secret where the database keystore contents are stored.
    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.
    WalletSecretId string
    The OCID of the Secret where the database keystore contents are stored.
    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.
    walletSecretId String
    The OCID of the Secret where the database keystore contents are stored.
    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.
    walletSecretId string
    The OCID of the Secret where the database keystore contents are stored.
    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.
    wallet_secret_id str
    The OCID of the Secret where the database keystore contents are stored.
    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.
    walletSecretId String
    The OCID of the Secret where the database keystore contents are stored.

    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 v1.31.0 published on Wednesday, Apr 10, 2024 by Pulumi