Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSqlCollectionLogInsights
Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
pulumi/pulumi-oci

oci.DataSafe.getSqlCollectionLogInsights

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides the list of Sql Collection Log Insights in Oracle Cloud Infrastructure Data Safe service.

    Retrieves a list of the SQL collection log analytics.

    Example Usage

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

const testSqlCollectionLogInsights = oci.DataSafe.getSqlCollectionLogInsights({
    sqlCollectionId: testSqlCollection.id,
    timeEnded: sqlCollectionLogInsightTimeEnded,
    timeStarted: sqlCollectionLogInsightTimeStarted,
    groupBy: sqlCollectionLogInsightGroupBy,
});

    import pulumi
import pulumi_oci as oci

test_sql_collection_log_insights = oci.DataSafe.get_sql_collection_log_insights(sql_collection_id=test_sql_collection["id"],
    time_ended=sql_collection_log_insight_time_ended,
    time_started=sql_collection_log_insight_time_started,
    group_by=sql_collection_log_insight_group_by)

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/datasafe"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := datasafe.GetSqlCollectionLogInsights(ctx, &datasafe.GetSqlCollectionLogInsightsArgs{
			SqlCollectionId: testSqlCollection.Id,
			TimeEnded:       sqlCollectionLogInsightTimeEnded,
			TimeStarted:     sqlCollectionLogInsightTimeStarted,
			GroupBy:         pulumi.StringRef(sqlCollectionLogInsightGroupBy),
		}, 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 testSqlCollectionLogInsights = Oci.DataSafe.GetSqlCollectionLogInsights.Invoke(new()
    {
        SqlCollectionId = testSqlCollection.Id,
        TimeEnded = sqlCollectionLogInsightTimeEnded,
        TimeStarted = sqlCollectionLogInsightTimeStarted,
        GroupBy = sqlCollectionLogInsightGroupBy,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DataSafe.DataSafeFunctions;
import com.pulumi.oci.DataSafe.inputs.GetSqlCollectionLogInsightsArgs;
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 testSqlCollectionLogInsights = DataSafeFunctions.getSqlCollectionLogInsights(GetSqlCollectionLogInsightsArgs.builder()
            .sqlCollectionId(testSqlCollection.id())
            .timeEnded(sqlCollectionLogInsightTimeEnded)
            .timeStarted(sqlCollectionLogInsightTimeStarted)
            .groupBy(sqlCollectionLogInsightGroupBy)
            .build());

    }
}

    variables:
  testSqlCollectionLogInsights:
    fn::invoke:
      function: oci:DataSafe:getSqlCollectionLogInsights
      arguments:
        sqlCollectionId: ${testSqlCollection.id}
        timeEnded: ${sqlCollectionLogInsightTimeEnded}
        timeStarted: ${sqlCollectionLogInsightTimeStarted}
        groupBy: ${sqlCollectionLogInsightGroupBy}

    Using getSqlCollectionLogInsights

    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 getSqlCollectionLogInsights(args: GetSqlCollectionLogInsightsArgs, opts?: InvokeOptions): Promise<GetSqlCollectionLogInsightsResult>
function getSqlCollectionLogInsightsOutput(args: GetSqlCollectionLogInsightsOutputArgs, opts?: InvokeOptions): Output<GetSqlCollectionLogInsightsResult>
    def get_sql_collection_log_insights(filters: Optional[Sequence[_datasafe.GetSqlCollectionLogInsightsFilter]] = None,
                                    group_by: Optional[str] = None,
                                    sql_collection_id: Optional[str] = None,
                                    time_ended: Optional[str] = None,
                                    time_started: Optional[str] = None,
                                    opts: Optional[InvokeOptions] = None) -> GetSqlCollectionLogInsightsResult
def get_sql_collection_log_insights_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_datasafe.GetSqlCollectionLogInsightsFilterArgs]]]] = None,
                                    group_by: Optional[pulumi.Input[str]] = None,
                                    sql_collection_id: Optional[pulumi.Input[str]] = None,
                                    time_ended: Optional[pulumi.Input[str]] = None,
                                    time_started: Optional[pulumi.Input[str]] = None,
                                    opts: Optional[InvokeOptions] = None) -> Output[GetSqlCollectionLogInsightsResult]
    func GetSqlCollectionLogInsights(ctx *Context, args *GetSqlCollectionLogInsightsArgs, opts ...InvokeOption) (*GetSqlCollectionLogInsightsResult, error)
func GetSqlCollectionLogInsightsOutput(ctx *Context, args *GetSqlCollectionLogInsightsOutputArgs, opts ...InvokeOption) GetSqlCollectionLogInsightsResultOutput

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

    public static class GetSqlCollectionLogInsights 
{
    public static Task<GetSqlCollectionLogInsightsResult> InvokeAsync(GetSqlCollectionLogInsightsArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlCollectionLogInsightsResult> Invoke(GetSqlCollectionLogInsightsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetSqlCollectionLogInsightsResult> getSqlCollectionLogInsights(GetSqlCollectionLogInsightsArgs args, InvokeOptions options)
public static Output<GetSqlCollectionLogInsightsResult> getSqlCollectionLogInsights(GetSqlCollectionLogInsightsArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DataSafe/getSqlCollectionLogInsights:getSqlCollectionLogInsights
  arguments:
    # arguments dictionary

    The following arguments are supported:

    SqlCollectionId string
    The OCID of the SQL collection resource.
    TimeEnded string
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    TimeStarted string
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    Filters List<GetSqlCollectionLogInsightsFilter>
    GroupBy string
    The group by parameter to summarize SQL collection log insights aggregation.
    SqlCollectionId string
    The OCID of the SQL collection resource.
    TimeEnded string
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    TimeStarted string
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    Filters []GetSqlCollectionLogInsightsFilter
    GroupBy string
    The group by parameter to summarize SQL collection log insights aggregation.
    sqlCollectionId String
    The OCID of the SQL collection resource.
    timeEnded String
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    timeStarted String
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    filters List<GetSqlCollectionLogInsightsFilter>
    groupBy String
    The group by parameter to summarize SQL collection log insights aggregation.
    sqlCollectionId string
    The OCID of the SQL collection resource.
    timeEnded string
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    timeStarted string
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    filters GetSqlCollectionLogInsightsFilter[]
    groupBy string
    The group by parameter to summarize SQL collection log insights aggregation.
    sql_collection_id str
    The OCID of the SQL collection resource.
    time_ended str
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    time_started str
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    filters Sequence[datasafe.GetSqlCollectionLogInsightsFilter]
    group_by str
    The group by parameter to summarize SQL collection log insights aggregation.
    sqlCollectionId String
    The OCID of the SQL collection resource.
    timeEnded String
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    timeStarted String
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    filters List<Property Map>
    groupBy String
    The group by parameter to summarize SQL collection log insights aggregation.

    getSqlCollectionLogInsights Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    SqlCollectionId string
    SqlCollectionLogInsightsCollections List<GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollection>
    The list of sql_collection_log_insights_collection.
    TimeEnded string
    The time at which the aggregation ended.
    TimeStarted string
    The time at which the aggregation started.
    Filters List<GetSqlCollectionLogInsightsFilter>
    GroupBy string
    Id string
    The provider-assigned unique ID for this managed resource.
    SqlCollectionId string
    SqlCollectionLogInsightsCollections []GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollection
    The list of sql_collection_log_insights_collection.
    TimeEnded string
    The time at which the aggregation ended.
    TimeStarted string
    The time at which the aggregation started.
    Filters []GetSqlCollectionLogInsightsFilter
    GroupBy string
    id String
    The provider-assigned unique ID for this managed resource.
    sqlCollectionId String
    sqlCollectionLogInsightsCollections List<GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollection>
    The list of sql_collection_log_insights_collection.
    timeEnded String
    The time at which the aggregation ended.
    timeStarted String
    The time at which the aggregation started.
    filters List<GetSqlCollectionLogInsightsFilter>
    groupBy String
    id string
    The provider-assigned unique ID for this managed resource.
    sqlCollectionId string
    sqlCollectionLogInsightsCollections GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollection[]
    The list of sql_collection_log_insights_collection.
    timeEnded string
    The time at which the aggregation ended.
    timeStarted string
    The time at which the aggregation started.
    filters GetSqlCollectionLogInsightsFilter[]
    groupBy string
    id str
    The provider-assigned unique ID for this managed resource.
    sql_collection_id str
    sql_collection_log_insights_collections Sequence[datasafe.GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollection]
    The list of sql_collection_log_insights_collection.
    time_ended str
    The time at which the aggregation ended.
    time_started str
    The time at which the aggregation started.
    filters Sequence[datasafe.GetSqlCollectionLogInsightsFilter]
    group_by str
    id String
    The provider-assigned unique ID for this managed resource.
    sqlCollectionId String
    sqlCollectionLogInsightsCollections List<Property Map>
    The list of sql_collection_log_insights_collection.
    timeEnded String
    The time at which the aggregation ended.
    timeStarted String
    The time at which the aggregation started.
    filters List<Property Map>
    groupBy String

    Supporting Types

    GetSqlCollectionLogInsightsFilter

    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

    GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollection

    items List<Property Map>
    The aggregated data point items.

    GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollectionItem

    Dimensions List<GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollectionItemDimension>
    The dimensions available for SQL collection analytics.
    MetricName string
    Name of the aggregation.
    SqlCollectionLogInsightCount string
    Total count of aggregated value.
    TimeEnded string
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    TimeStarted string
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    Dimensions []GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollectionItemDimension
    The dimensions available for SQL collection analytics.
    MetricName string
    Name of the aggregation.
    SqlCollectionLogInsightCount string
    Total count of aggregated value.
    TimeEnded string
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    TimeStarted string
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    dimensions List<GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollectionItemDimension>
    The dimensions available for SQL collection analytics.
    metricName String
    Name of the aggregation.
    sqlCollectionLogInsightCount String
    Total count of aggregated value.
    timeEnded String
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    timeStarted String
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    dimensions GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollectionItemDimension[]
    The dimensions available for SQL collection analytics.
    metricName string
    Name of the aggregation.
    sqlCollectionLogInsightCount string
    Total count of aggregated value.
    timeEnded string
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    timeStarted string
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    dimensions Sequence[datasafe.GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollectionItemDimension]
    The dimensions available for SQL collection analytics.
    metric_name str
    Name of the aggregation.
    sql_collection_log_insight_count str
    Total count of aggregated value.
    time_ended str
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    time_started str
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.
    dimensions List<Property Map>
    The dimensions available for SQL collection analytics.
    metricName String
    Name of the aggregation.
    sqlCollectionLogInsightCount String
    Total count of aggregated value.
    timeEnded String
    An optional filter to return the stats of the SQL collection logs collected before the date-time specified, in the format defined by RFC3339.
    timeStarted String
    An optional filter to return the stats of the SQL collection logs collected after the date-time specified, in the format defined by RFC3339.

    GetSqlCollectionLogInsightsSqlCollectionLogInsightsCollectionItemDimension

    ClientIp string
    The IP addresses for the SQL collection.
    ClientOsUserName string
    The operating system user names for the SQL collection.
    ClientProgram string
    The allowed client programs for the SQL collection.
    ClientIp string
    The IP addresses for the SQL collection.
    ClientOsUserName string
    The operating system user names for the SQL collection.
    ClientProgram string
    The allowed client programs for the SQL collection.
    clientIp String
    The IP addresses for the SQL collection.
    clientOsUserName String
    The operating system user names for the SQL collection.
    clientProgram String
    The allowed client programs for the SQL collection.
    clientIp string
    The IP addresses for the SQL collection.
    clientOsUserName string
    The operating system user names for the SQL collection.
    clientProgram string
    The allowed client programs for the SQL collection.
    client_ip str
    The IP addresses for the SQL collection.
    client_os_user_name str
    The operating system user names for the SQL collection.
    client_program str
    The allowed client programs for the SQL collection.
    clientIp String
    The IP addresses for the SQL collection.
    clientOsUserName String
    The operating system user names for the SQL collection.
    clientProgram String
    The allowed client programs for the SQL collection.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.27.0 published on Thursday, Mar 20, 2025 by Pulumi
    pulumi/pulumi-oci