# 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).
require 'oci'
require 'date'
# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config
# Initialize service client with default config file
usage_api_client = OCI::UsageApi::UsageapiClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
create_query_response =
usage_api_client.create_query(
OCI::UsageApi::Models::CreateQueryDetails.new(
compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
query_definition:
OCI::UsageApi::Models::QueryDefinition.new(
display_name: 'EXAMPLE-displayName-Value',
report_query:
OCI::UsageApi::Models::ReportQuery.new(
tenant_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-tenantId-Value',
granularity: 'DAILY',
time_usage_started: DateTime.parse('2006-08-27T08:22:30.548Z'),
time_usage_ended: DateTime.parse('2047-11-09T13:22:26.472Z'),
is_aggregate_by_time: true,
forecast:
OCI::UsageApi::Models::Forecast.new(
time_forecast_ended:
DateTime.parse('2049-03-11T09:23:26.888Z'),
forecast_type: 'BASIC',
time_forecast_started:
DateTime.parse('2011-09-27T09:18:59.045Z')
),
query_type: 'EXPIREDCREDIT',
group_by: %w[EXAMPLE--Value],
group_by_tag: [
OCI::UsageApi::Models::Tag.new(
namespace: 'EXAMPLE-namespace-Value',
key: 'EXAMPLE-key-Value',
value: 'EXAMPLE-value-Value'
)
],
compartment_depth: 5.4588947,
filter:
OCI::UsageApi::Models::Filter.new(
operator: 'NOT',
dimensions: [
OCI::UsageApi::Models::Dimension.new(
key: 'EXAMPLE-key-Value', value: 'EXAMPLE-value-Value'
)
],
tags: [
OCI::UsageApi::Models::Tag.new(
namespace: 'EXAMPLE-namespace-Value',
key: 'EXAMPLE-key-Value',
value: 'EXAMPLE-value-Value'
)
]
),
date_range_name: 'LAST_TWO_MONTHS'
),
cost_analysis_ui:
OCI::UsageApi::Models::CostAnalysisUI.new(
graph: 'LINES', is_cumulative_graph: true
),
version: 9851.71
)
)
)
# Get the data from response
puts "#{create_query_response.data}"