import * as pulumi from "@pulumi/pulumi"; import * as inputs from "../types/input"; import * as outputs from "../types/output"; /** * This data source provides the list of Managed Database Sql Tuning Advisor Tasks Findings in Oracle Cloud Infrastructure Database Management service. * * Gets an array of the details of the findings that match specific filters. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksFindings = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksFindings({ * managedDatabaseId: testManagedDatabase.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * beginExecId: testBeginExec.id, * endExecId: testEndExec.id, * findingFilter: managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter, * indexHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter, * opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksFindingOpcNamedCredentialId, * searchPeriod: managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod, * statsHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksFindings(args: GetManagedDatabaseSqlTuningAdvisorTasksFindingsArgs, opts?: pulumi.InvokeOptions): Promise; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksFindings. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksFindingsArgs { /** * The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. */ beginExecId?: string; /** * The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. */ endExecId?: string; filters?: inputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter[]; /** * The filter used to display specific findings in the report. */ findingFilter?: string; /** * The hash value of the index table name. */ indexHashFilter?: string; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: string; /** * The OCID of the Named Credential. */ opcNamedCredentialId?: string; /** * The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied. */ searchPeriod?: string; /** * The SQL tuning task identifier. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ sqlTuningAdvisorTaskId: string; /** * The hash value of the object for the statistic finding search. */ statsHashFilter?: string; } /** * A collection of values returned by getManagedDatabaseSqlTuningAdvisorTasksFindings. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksFindingsResult { readonly beginExecId?: string; readonly endExecId?: string; readonly filters?: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingsFilter[]; readonly findingFilter?: string; /** * The provider-assigned unique ID for this managed resource. */ readonly id: string; readonly indexHashFilter?: string; readonly managedDatabaseId: string; readonly opcNamedCredentialId?: string; readonly searchPeriod?: string; /** * The list of sql_tuning_advisor_task_finding_collection. */ readonly sqlTuningAdvisorTaskFindingCollections: outputs.DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasksFindingsSqlTuningAdvisorTaskFindingCollection[]; /** * The unique identifier of the SQL Tuning Advisor task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ readonly sqlTuningAdvisorTaskId: string; readonly statsHashFilter?: string; } /** * This data source provides the list of Managed Database Sql Tuning Advisor Tasks Findings in Oracle Cloud Infrastructure Database Management service. * * Gets an array of the details of the findings that match specific filters. * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as oci from "@pulumi/oci"; * * const testManagedDatabaseSqlTuningAdvisorTasksFindings = oci.databasemanagement.getManagedDatabaseSqlTuningAdvisorTasksFindings({ * managedDatabaseId: testManagedDatabase.id, * sqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.id, * beginExecId: testBeginExec.id, * endExecId: testEndExec.id, * findingFilter: managedDatabaseSqlTuningAdvisorTasksFindingFindingFilter, * indexHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingIndexHashFilter, * opcNamedCredentialId: managedDatabaseSqlTuningAdvisorTasksFindingOpcNamedCredentialId, * searchPeriod: managedDatabaseSqlTuningAdvisorTasksFindingSearchPeriod, * statsHashFilter: managedDatabaseSqlTuningAdvisorTasksFindingStatsHashFilter, * }); * ``` */ export declare function getManagedDatabaseSqlTuningAdvisorTasksFindingsOutput(args: GetManagedDatabaseSqlTuningAdvisorTasksFindingsOutputArgs, opts?: pulumi.InvokeOutputOptions): pulumi.Output; /** * A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksFindings. */ export interface GetManagedDatabaseSqlTuningAdvisorTasksFindingsOutputArgs { /** * The optional greater than or equal to filter on the execution ID related to a specific SQL Tuning Advisor task. */ beginExecId?: pulumi.Input; /** * The optional less than or equal to query parameter to filter on the execution ID related to a specific SQL Tuning Advisor task. */ endExecId?: pulumi.Input; filters?: pulumi.Input[] | undefined>; /** * The filter used to display specific findings in the report. */ findingFilter?: pulumi.Input; /** * The hash value of the index table name. */ indexHashFilter?: pulumi.Input; /** * The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database. */ managedDatabaseId: pulumi.Input; /** * The OCID of the Named Credential. */ opcNamedCredentialId?: pulumi.Input; /** * The search period during which the API will search for begin and end exec id, if not supplied. Unused if beginExecId and endExecId optional query params are both supplied. */ searchPeriod?: pulumi.Input; /** * The SQL tuning task identifier. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm). */ sqlTuningAdvisorTaskId: pulumi.Input; /** * The hash value of the object for the statistic finding search. */ statsHashFilter?: pulumi.Input; } //# sourceMappingURL=getManagedDatabaseSqlTuningAdvisorTasksFindings.d.ts.map