oci.DatabaseTools.getDatabaseToolsSqlReports

Oracle Cloud Infrastructure v4.12.0, May 21 26

Viewing docs for Oracle Cloud Infrastructure v4.12.0
published on Thursday, May 21, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-oci

Viewing docs for Oracle Cloud Infrastructure v4.12.0
published on Thursday, May 21, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-oci

Example Usage

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

const testDatabaseToolsSqlReports = oci.databasetools.getDatabaseToolsSqlReports({
    compartmentId: compartmentId,
    displayName: databaseToolsSqlReportDisplayName,
    state: databaseToolsSqlReportState,
    types: databaseToolsSqlReportType,
});

import pulumi
import pulumi_oci as oci

test_database_tools_sql_reports = oci.databasetools.get_database_tools_sql_reports(compartment_id=compartment_id,
    display_name=database_tools_sql_report_display_name,
    state=database_tools_sql_report_state,
    types=database_tools_sql_report_type)

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasetools.GetDatabaseToolsSqlReports(ctx, &databasetools.GetDatabaseToolsSqlReportsArgs{
			CompartmentId: compartmentId,
			DisplayName:   pulumi.StringRef(databaseToolsSqlReportDisplayName),
			State:         pulumi.StringRef(databaseToolsSqlReportState),
			Types:         pulumi.ToArray(databaseToolsSqlReportType),
		}, 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 testDatabaseToolsSqlReports = Oci.DatabaseTools.GetDatabaseToolsSqlReports.Invoke(new()
    {
        CompartmentId = compartmentId,
        DisplayName = databaseToolsSqlReportDisplayName,
        State = databaseToolsSqlReportState,
        Types = databaseToolsSqlReportType,
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseTools.DatabaseToolsFunctions;
import com.pulumi.oci.DatabaseTools.inputs.GetDatabaseToolsSqlReportsArgs;
import java.util.ArrayList;
import java.util.Arrays;
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 testDatabaseToolsSqlReports = DatabaseToolsFunctions.getDatabaseToolsSqlReports(GetDatabaseToolsSqlReportsArgs.builder()
            .compartmentId(compartmentId)
            .displayName(databaseToolsSqlReportDisplayName)
            .state(databaseToolsSqlReportState)
            .types(databaseToolsSqlReportType)
            .build());

    }
}

variables:
  testDatabaseToolsSqlReports:
    fn::invoke:
      function: oci:DatabaseTools:getDatabaseToolsSqlReports
      arguments:
        compartmentId: ${compartmentId}
        displayName: ${databaseToolsSqlReportDisplayName}
        state: ${databaseToolsSqlReportState}
        types: ${databaseToolsSqlReportType}

Example coming soon!

Using getDatabaseToolsSqlReports

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 getDatabaseToolsSqlReports(args: GetDatabaseToolsSqlReportsArgs, opts?: InvokeOptions): Promise<GetDatabaseToolsSqlReportsResult>
function getDatabaseToolsSqlReportsOutput(args: GetDatabaseToolsSqlReportsOutputArgs, opts?: InvokeOptions): Output<GetDatabaseToolsSqlReportsResult>

def get_database_tools_sql_reports(compartment_id: Optional[str] = None,
                                   display_name: Optional[str] = None,
                                   filters: Optional[Sequence[GetDatabaseToolsSqlReportsFilter]] = None,
                                   state: Optional[str] = None,
                                   types: Optional[Sequence[str]] = None,
                                   opts: Optional[InvokeOptions] = None) -> GetDatabaseToolsSqlReportsResult
def get_database_tools_sql_reports_output(compartment_id: pulumi.Input[Optional[str]] = None,
                                   display_name: pulumi.Input[Optional[str]] = None,
                                   filters: pulumi.Input[Optional[Sequence[pulumi.Input[GetDatabaseToolsSqlReportsFilterArgs]]]] = None,
                                   state: pulumi.Input[Optional[str]] = None,
                                   types: pulumi.Input[Optional[Sequence[pulumi.Input[str]]]] = None,
                                   opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseToolsSqlReportsResult]

func GetDatabaseToolsSqlReports(ctx *Context, args *GetDatabaseToolsSqlReportsArgs, opts ...InvokeOption) (*GetDatabaseToolsSqlReportsResult, error)
func GetDatabaseToolsSqlReportsOutput(ctx *Context, args *GetDatabaseToolsSqlReportsOutputArgs, opts ...InvokeOption) GetDatabaseToolsSqlReportsResultOutput

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

public static class GetDatabaseToolsSqlReports 
{
    public static Task<GetDatabaseToolsSqlReportsResult> InvokeAsync(GetDatabaseToolsSqlReportsArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseToolsSqlReportsResult> Invoke(GetDatabaseToolsSqlReportsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabaseToolsSqlReportsResult> getDatabaseToolsSqlReports(GetDatabaseToolsSqlReportsArgs args, InvokeOptions options)
public static Output<GetDatabaseToolsSqlReportsResult> getDatabaseToolsSqlReports(GetDatabaseToolsSqlReportsArgs args, InvokeOptions options)

fn::invoke:
  function: oci:DatabaseTools/getDatabaseToolsSqlReports:getDatabaseToolsSqlReports
  arguments:
    # arguments dictionary

data "oci_databasetools_getdatabasetoolssqlreports" "name" {
    # arguments
}

The following arguments are supported:

CompartmentId string: The OCID of the compartment in which to list resources.
DisplayName string: A filter to return only resources that match the entire specified display name.
Filters List<GetDatabaseToolsSqlReportsFilter>
State string: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
Types List<string>: A filter to return only resources with one of the specified type values.

CompartmentId string: The OCID of the compartment in which to list resources.
DisplayName string: A filter to return only resources that match the entire specified display name.
Filters []GetDatabaseToolsSqlReportsFilter
State string: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
Types []string: A filter to return only resources with one of the specified type values.

compartment_id string: The OCID of the compartment in which to list resources.
display_name string: A filter to return only resources that match the entire specified display name.
filters list(object)
state string: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
types list(string): A filter to return only resources with one of the specified type values.

compartmentId String: The OCID of the compartment in which to list resources.
displayName String: A filter to return only resources that match the entire specified display name.
filters List<GetSqlReportsFilter>
state String: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
types List<String>: A filter to return only resources with one of the specified type values.

compartmentId string: The OCID of the compartment in which to list resources.
displayName string: A filter to return only resources that match the entire specified display name.
filters GetDatabaseToolsSqlReportsFilter[]
state string: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
types string[]: A filter to return only resources with one of the specified type values.

compartment_id str: The OCID of the compartment in which to list resources.
display_name str: A filter to return only resources that match the entire specified display name.
filters Sequence[GetDatabaseToolsSqlReportsFilter]
state str: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
types Sequence[str]: A filter to return only resources with one of the specified type values.

compartmentId String: The OCID of the compartment in which to list resources.
displayName String: A filter to return only resources that match the entire specified display name.
filters List<Property Map>
state String: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
types List<String>: A filter to return only resources with one of the specified type values.

getDatabaseToolsSqlReports Result

The following output properties are available:

CompartmentId string: The OCID of the compartment containing the Database Tools SQL report.
DatabaseToolsSqlReportCollections List<GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection>: The list of database_tools_sql_report_collection.
Id string: The provider-assigned unique ID for this managed resource.
DisplayName string: A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
Filters List<GetDatabaseToolsSqlReportsFilter>
State string: The current state of the Database Tools SQL report.
Types List<string>: The type of the variable

CompartmentId string: The OCID of the compartment containing the Database Tools SQL report.
DatabaseToolsSqlReportCollections []GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection: The list of database_tools_sql_report_collection.
Id string: The provider-assigned unique ID for this managed resource.
DisplayName string: A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
Filters []GetDatabaseToolsSqlReportsFilter
State string: The current state of the Database Tools SQL report.
Types []string: The type of the variable

compartment_id string: The OCID of the compartment containing the Database Tools SQL report.
database_tools_sql_report_collections list(object): The list of database_tools_sql_report_collection.
id string: The provider-assigned unique ID for this managed resource.
display_name string: A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
filters list(object)
state string: The current state of the Database Tools SQL report.
types list(string): The type of the variable

compartmentId String: The OCID of the compartment containing the Database Tools SQL report.
databaseToolsSqlReportCollections List<GetSqlReportsSqlReportCollection>: The list of database_tools_sql_report_collection.
id String: The provider-assigned unique ID for this managed resource.
displayName String: A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
filters List<GetSqlReportsFilter>
state String: The current state of the Database Tools SQL report.
types List<String>: The type of the variable

compartmentId string: The OCID of the compartment containing the Database Tools SQL report.
databaseToolsSqlReportCollections GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection[]: The list of database_tools_sql_report_collection.
id string: The provider-assigned unique ID for this managed resource.
displayName string: A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
filters GetDatabaseToolsSqlReportsFilter[]
state string: The current state of the Database Tools SQL report.
types string[]: The type of the variable

compartment_id str: The OCID of the compartment containing the Database Tools SQL report.
database_tools_sql_report_collections Sequence[GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection]: The list of database_tools_sql_report_collection.
id str: The provider-assigned unique ID for this managed resource.
display_name str: A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
filters Sequence[GetDatabaseToolsSqlReportsFilter]
state str: The current state of the Database Tools SQL report.
types Sequence[str]: The type of the variable

compartmentId String: The OCID of the compartment containing the Database Tools SQL report.
databaseToolsSqlReportCollections List<Property Map>: The list of database_tools_sql_report_collection.
id String: The provider-assigned unique ID for this managed resource.
displayName String: A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
filters List<Property Map>
state String: The current state of the Database Tools SQL report.
types List<String>: The type of the variable

Supporting Types

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection

Items List<GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItem>

Items []GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItem

items list(object)

items List<GetSqlReportsSqlReportCollectionItem>

items GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItem[]

items Sequence[GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItem]

items List<Property Map>

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItem

Columns List<GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn>: Descriptive information on columns referenced in the Database Tools SQL Report source.
CompartmentId string: The OCID of the compartment in which to list resources.
DefinedTags Dictionary<string, string>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
Description string: The description of the variable
DisplayName string: A filter to return only resources that match the entire specified display name.
FreeformTags Dictionary<string, string>: 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: The OCID of the Database Tools SQL report.
Instructions string: Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
LifecycleDetails string: A message describing the current state in more detail.
Locks List<GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock>: Locks associated with this resource.
Purpose string: Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
Source string: SQL query executed to generate the report.
State string: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
SystemTags Dictionary<string, string>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated string: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
TimeUpdated string: The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
Type string: A filter to return only resources with one of the specified type values.
Variables List<GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable>: Variables referenced in the Database Tools SQL Report source.

Columns []GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn: Descriptive information on columns referenced in the Database Tools SQL Report source.
CompartmentId string: The OCID of the compartment in which to list resources.
DefinedTags map[string]string: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
Description string: The description of the variable
DisplayName string: A filter to return only resources that match the entire specified display name.
FreeformTags map[string]string: 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: The OCID of the Database Tools SQL report.
Instructions string: Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
LifecycleDetails string: A message describing the current state in more detail.
Locks []GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock: Locks associated with this resource.
Purpose string: Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
Source string: SQL query executed to generate the report.
State string: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
SystemTags map[string]string: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
TimeCreated string: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
TimeUpdated string: The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
Type string: A filter to return only resources with one of the specified type values.
Variables []GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable: Variables referenced in the Database Tools SQL Report source.

columns list(object): Descriptive information on columns referenced in the Database Tools SQL Report source.
compartment_id string: The OCID of the compartment in which to list resources.
defined_tags map(string): Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description string: The description of the variable
display_name string: A filter to return only resources that match the entire specified display name.
freeform_tags map(string): 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: The OCID of the Database Tools SQL report.
instructions string: Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
lifecycle_details string: A message describing the current state in more detail.
locks list(object): Locks associated with this resource.
purpose string: Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
source string: SQL query executed to generate the report.
state string: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
system_tags map(string): Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
time_created string: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
time_updated string: The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
type string: A filter to return only resources with one of the specified type values.
variables list(object): Variables referenced in the Database Tools SQL Report source.

columns List<GetSqlReportsSqlReportCollectionItemColumn>: Descriptive information on columns referenced in the Database Tools SQL Report source.
compartmentId String: The OCID of the compartment in which to list resources.
definedTags Map<String,String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description String: The description of the variable
displayName String: A filter to return only resources that match the entire specified display name.
freeformTags Map<String,String>: 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: The OCID of the Database Tools SQL report.
instructions String: Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
lifecycleDetails String: A message describing the current state in more detail.
locks List<GetSqlReportsSqlReportCollectionItemLock>: Locks associated with this resource.
purpose String: Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
source String: SQL query executed to generate the report.
state String: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
systemTags Map<String,String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated String: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
timeUpdated String: The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
type String: A filter to return only resources with one of the specified type values.
variables List<GetSqlReportsSqlReportCollectionItemVariable>: Variables referenced in the Database Tools SQL Report source.

columns GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn[]: Descriptive information on columns referenced in the Database Tools SQL Report source.
compartmentId string: The OCID of the compartment in which to list resources.
definedTags {[key: string]: string}: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description string: The description of the variable
displayName string: A filter to return only resources that match the entire specified display name.
freeformTags {[key: string]: string}: 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: The OCID of the Database Tools SQL report.
instructions string: Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
lifecycleDetails string: A message describing the current state in more detail.
locks GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock[]: Locks associated with this resource.
purpose string: Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
source string: SQL query executed to generate the report.
state string: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
systemTags {[key: string]: string}: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated string: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
timeUpdated string: The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
type string: A filter to return only resources with one of the specified type values.
variables GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable[]: Variables referenced in the Database Tools SQL Report source.

columns Sequence[GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn]: Descriptive information on columns referenced in the Database Tools SQL Report source.
compartment_id str: The OCID of the compartment in which to list resources.
defined_tags Mapping[str, str]: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description str: The description of the variable
display_name str: A filter to return only resources that match the entire specified display name.
freeform_tags Mapping[str, str]: 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: The OCID of the Database Tools SQL report.
instructions str: Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
lifecycle_details str: A message describing the current state in more detail.
locks Sequence[GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock]: Locks associated with this resource.
purpose str: Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
source str: SQL query executed to generate the report.
state str: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
system_tags Mapping[str, str]: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
time_created str: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
time_updated str: The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
type str: A filter to return only resources with one of the specified type values.
variables Sequence[GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable]: Variables referenced in the Database Tools SQL Report source.

columns List<Property Map>: Descriptive information on columns referenced in the Database Tools SQL Report source.
compartmentId String: The OCID of the compartment in which to list resources.
definedTags Map<String>: Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
description String: The description of the variable
displayName String: A filter to return only resources that match the entire specified display name.
freeformTags Map<String>: 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: The OCID of the Database Tools SQL report.
instructions String: Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
lifecycleDetails String: A message describing the current state in more detail.
locks List<Property Map>: Locks associated with this resource.
purpose String: Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
source String: SQL query executed to generate the report.
state String: A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
systemTags Map<String>: Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
timeCreated String: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
timeUpdated String: The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
type String: A filter to return only resources with one of the specified type values.
variables List<Property Map>: Variables referenced in the Database Tools SQL Report source.

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn

Description string: The description of the variable
Name string: The name of the variable
Type string: A filter to return only resources with one of the specified type values.

Description string: The description of the variable
Name string: The name of the variable
Type string: A filter to return only resources with one of the specified type values.

description string: The description of the variable
name string: The name of the variable
type string: A filter to return only resources with one of the specified type values.

description String: The description of the variable
name String: The name of the variable
type String: A filter to return only resources with one of the specified type values.

description string: The description of the variable
name string: The name of the variable
type string: A filter to return only resources with one of the specified type values.

description str: The description of the variable
name str: The name of the variable
type str: A filter to return only resources with one of the specified type values.

description String: The description of the variable
name String: The name of the variable
type String: A filter to return only resources with one of the specified type values.

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock

Message string: A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
RelatedResourceId string: The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
TimeCreated string: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
Type string: A filter to return only resources with one of the specified type values.

Message string: A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
RelatedResourceId string: The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
TimeCreated string: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
Type string: A filter to return only resources with one of the specified type values.

message string: A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
related_resource_id string: The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
time_created string: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
type string: A filter to return only resources with one of the specified type values.

message String: A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
relatedResourceId String: The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
timeCreated String: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
type String: A filter to return only resources with one of the specified type values.

message string: A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
relatedResourceId string: The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
timeCreated string: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
type string: A filter to return only resources with one of the specified type values.

message str: A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
related_resource_id str: The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
time_created str: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
type str: A filter to return only resources with one of the specified type values.

message String: A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
relatedResourceId String: The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
timeCreated String: The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
type String: A filter to return only resources with one of the specified type values.

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable

Description string: The description of the variable
Name string: The name of the variable
Type string: A filter to return only resources with one of the specified type values.

Description string: The description of the variable
Name string: The name of the variable
Type string: A filter to return only resources with one of the specified type values.

description string: The description of the variable
name string: The name of the variable
type string: A filter to return only resources with one of the specified type values.

description String: The description of the variable
name String: The name of the variable
type String: A filter to return only resources with one of the specified type values.

description string: The description of the variable
name string: The name of the variable
type string: A filter to return only resources with one of the specified type values.

description str: The description of the variable
name str: The name of the variable
type str: A filter to return only resources with one of the specified type values.

description String: The description of the variable
name String: The name of the variable
type String: A filter to return only resources with one of the specified type values.

GetDatabaseToolsSqlReportsFilter

Name string: The name of the variable
Values List<string>
Regex bool

Name string: The name of the variable
Values []string
Regex bool

name string: The name of the variable
values list(string)
regex bool

name String: The name of the variable
values List<String>
regex Boolean

name string: The name of the variable
values string[]
regex boolean

name str: The name of the variable
values Sequence[str]
regex bool

name String: The name of the variable
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.

Viewing docs for Oracle Cloud Infrastructure v4.12.0
published on Thursday, May 21, 2026 by Pulumi

Schema (JSON)

pulumi/pulumi-oci

oci.DatabaseTools.getDatabaseToolsSqlReports

On this page

On this page

Example Usage

Using getDatabaseToolsSqlReports

getDatabaseToolsSqlReports Result

Supporting Types

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItem

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable

GetDatabaseToolsSqlReportsFilter

Package Details

On this page

On this page

Try Pulumi Cloud free.
Your team will thank you.

oci.DatabaseTools.getDatabaseToolsSqlReports

On this page

On this page

Example Usage

Using getDatabaseToolsSqlReports

getDatabaseToolsSqlReports Result

Supporting Types

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItem

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock

GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable

GetDatabaseToolsSqlReportsFilter

Package Details

On this page

On this page

Try Pulumi Cloud free.Your team will thank you.

Try Pulumi Cloud free.
Your team will thank you.