Oracle Cloud Infrastructure

v0.5.0 published on Monday, Sep 12, 2022 by Pulumi

getDatabaseInsights

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 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=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"])
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

ProcessorCount int

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

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

ProcessorCount int

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

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

processorCount Integer

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

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

processorCount number

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

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

processor_count int

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

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

processorCount Number

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

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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.