// This is an automatically generated code sample.
// To make this code sample work in your Oracle Cloud tenancy,
// please replace the values for any parameters whose current values do not fit
// your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
// boolean, number, and enum parameters with values not fitting your use case).
using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using Oci.LoganalyticsService;
using Oci.Common;
using Oci.Common.Auth;
namespace Oci.Sdk.DotNet.Example.Loganalytics
{
public class QueryExample
{
public static async Task Main()
{
// Create a request and dependent object(s).
var queryDetails = new Oci.LoganalyticsService.Models.QueryDetails
{
CompartmentId = "ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value",
CompartmentIdInSubtree = false,
SavedSearchId = "ocid1.test.oc1..<unique_ID>EXAMPLE-savedSearchId-Value",
QueryString = "EXAMPLE-queryString-Value",
SubSystem = Oci.LoganalyticsService.Models.SubSystemName.Log,
MaxTotalCount = 1383,
TimeFilter = new Oci.LoganalyticsService.Models.TimeRange
{
TimeStart = DateTime.Parse("09/17/2032 19:52:06"),
TimeEnd = DateTime.Parse("07/09/2041 08:56:47"),
TimeZone = "EXAMPLE-timeZone-Value"
},
ScopeFilters = new List<Oci.LoganalyticsService.Models.ScopeFilter>
{
new Oci.LoganalyticsService.Models.ScopeFilter
{
FieldName = "EXAMPLE-fieldName-Value",
Values = new List<Object>
{
"EXAMPLE-values-Value"
}
}
},
QueryTimeoutInSeconds = 86,
ShouldRunAsync = true,
AsyncMode = Oci.LoganalyticsService.Models.JobMode.Foreground,
ShouldIncludeTotalCount = true,
ShouldIncludeColumns = true,
ShouldIncludeFields = true,
ShouldUseAcceleration = true
};
var queryRequest = new Oci.LoganalyticsService.Requests.QueryRequest
{
NamespaceName = "EXAMPLE-namespaceName-Value",
QueryDetails = queryDetails,
Page = "EXAMPLE-page-Value",
OpcRequestId = "B13E5Q8FDSL7D37SISJC<unique_ID>",
Limit = 1573
};
// Create a default authentication provider that uses the DEFAULT
// profile in the configuration file.
// Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.
var provider = new ConfigFileAuthenticationDetailsProvider("DEFAULT");
try
{
// Create a service client and send the request.
using (var client = new LogAnalyticsClient(provider, new ClientConfiguration()))
{
var response = await client.Query(queryRequest);
// Retrieve value from the response.
var totalCountValue = response.QueryAggregation.TotalCount;
}
}
catch (Exception e)
{
Console.WriteLine($"Query Failed with {e.Message}");
throw e;
}
}
}
}