← All packages

Oracle Cloud Infrastructure

Pulumi Official

Package maintained by Pulumi

v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

Source code

getQueries

This data source provides the list of Queries in Oracle Cloud Infrastructure Metering Computation service.

Returns the saved query list.

Example Usage

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testQueries = Output.Create(Oci.MeteringComputation.GetQueries.InvokeAsync(new Oci.MeteringComputation.GetQueriesArgs
        {
            CompartmentId = @var.Compartment_id,
        }));
    }

}

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := MeteringComputation.GetQueries(ctx, &meteringcomputation.GetQueriesArgs{
			CompartmentId: _var.Compartment_id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

Coming soon!

import pulumi
import pulumi_oci as oci

test_queries = oci.MeteringComputation.get_queries(compartment_id=var["compartment_id"])

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

const testQueries = oci.MeteringComputation.getQueries({
    compartmentId: _var.compartment_id,
});

Coming soon!

Using getQueries

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 getQueries(args: GetQueriesArgs, opts?: InvokeOptions): Promise<GetQueriesResult>
function getQueriesOutput(args: GetQueriesOutputArgs, opts?: InvokeOptions): Output<GetQueriesResult>

def get_queries(compartment_id: Optional[str] = None,
                filters: Optional[Sequence[_meteringcomputation.GetQueriesFilter]] = None,
                opts: Optional[InvokeOptions] = None) -> GetQueriesResult
def get_queries_output(compartment_id: Optional[pulumi.Input[str]] = None,
                filters: Optional[pulumi.Input[Sequence[pulumi.Input[_meteringcomputation.GetQueriesFilterArgs]]]] = None,
                opts: Optional[InvokeOptions] = None) -> Output[GetQueriesResult]

func GetQueries(ctx *Context, args *GetQueriesArgs, opts ...InvokeOption) (*GetQueriesResult, error)
func GetQueriesOutput(ctx *Context, args *GetQueriesOutputArgs, opts ...InvokeOption) GetQueriesResultOutput

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

public static class GetQueries 
{
    public static Task<GetQueriesResult> InvokeAsync(GetQueriesArgs args, InvokeOptions? opts = null)
    public static Output<GetQueriesResult> Invoke(GetQueriesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetQueriesResult> getQueries(GetQueriesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

Fn::Invoke:
  Function: oci:MeteringComputation/getQueries:getQueries
  Arguments:
    # Arguments dictionary

The following arguments are supported:

CompartmentId string: The compartment ID in which to list resources.
Filters List<GetQueriesFilter>

CompartmentId string: The compartment ID in which to list resources.
Filters []GetQueriesFilter

compartmentId String: The compartment ID in which to list resources.
filters List<GetQueriesFilter>

compartmentId string: The compartment ID in which to list resources.
filters GetQueriesFilter[]

compartment_id str: The compartment ID in which to list resources.
filters GetQueriesFilter]

compartmentId String: The compartment ID in which to list resources.
filters List<Property Map>

getQueries Result

The following output properties are available:

CompartmentId string: The compartment OCID.
Id string: The provider-assigned unique ID for this managed resource.
QueryCollections List<GetQueriesQueryCollection>: The list of query_collection.
Filters List<GetQueriesFilter>

CompartmentId string: The compartment OCID.
Id string: The provider-assigned unique ID for this managed resource.
QueryCollections []GetQueriesQueryCollection: The list of query_collection.
Filters []GetQueriesFilter

compartmentId String: The compartment OCID.
id String: The provider-assigned unique ID for this managed resource.
queryCollections List<GetQueriesQueryCollection>: The list of query_collection.
filters List<GetQueriesFilter>

compartmentId string: The compartment OCID.
id string: The provider-assigned unique ID for this managed resource.
queryCollections GetQueriesQueryCollection[]: The list of query_collection.
filters GetQueriesFilter[]

compartment_id str: The compartment OCID.
id str: The provider-assigned unique ID for this managed resource.
query_collections GetQueriesQueryCollection]: The list of query_collection.
filters GetQueriesFilter]

compartmentId String: The compartment OCID.
id String: The provider-assigned unique ID for this managed resource.
queryCollections List<Property Map>: The list of query_collection.
filters List<Property Map>

Supporting Types

GetQueriesFilter

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

GetQueriesQueryCollection

Items List<GetQueriesQueryCollectionItem>

Items []GetQueriesQueryCollectionItem

items List<GetQueriesQueryCollectionItem>

items GetQueriesQueryCollectionItem[]

items GetQueriesQueryCollectionItem]

items List<Property Map>

GetQueriesQueryCollectionItem

CompartmentId string: The compartment ID in which to list resources.
Id string: The query OCID.
QueryDefinitions List<GetQueriesQueryCollectionItemQueryDefinition>: The common fields for queries.

CompartmentId string: The compartment ID in which to list resources.
Id string: The query OCID.
QueryDefinitions []GetQueriesQueryCollectionItemQueryDefinition: The common fields for queries.

compartmentId String: The compartment ID in which to list resources.
id String: The query OCID.
queryDefinitions List<GetQueriesQueryCollectionItemQueryDefinition>: The common fields for queries.

compartmentId string: The compartment ID in which to list resources.
id string: The query OCID.
queryDefinitions GetQueriesQueryCollectionItemQueryDefinition[]: The common fields for queries.

compartment_id str: The compartment ID in which to list resources.
id str: The query OCID.
query_definitions GetQueriesQueryCollectionItemQueryDefinition]: The common fields for queries.

compartmentId String: The compartment ID in which to list resources.
id String: The query OCID.
queryDefinitions List<Property Map>: The common fields for queries.

GetQueriesQueryCollectionItemQueryDefinition

CostAnalysisUis List<GetQueriesQueryCollectionItemQueryDefinitionCostAnalysisUi>: The common fields for Cost Analysis UI rendering.
DisplayName string: The query display name. Avoid entering confidential information.
ReportQueries List<GetQueriesQueryCollectionItemQueryDefinitionReportQuery>: The request of the generated Cost Analysis report.
Version double: The saved query version.

CostAnalysisUis []GetQueriesQueryCollectionItemQueryDefinitionCostAnalysisUi: The common fields for Cost Analysis UI rendering.
DisplayName string: The query display name. Avoid entering confidential information.
ReportQueries []GetQueriesQueryCollectionItemQueryDefinitionReportQuery: The request of the generated Cost Analysis report.
Version float64: The saved query version.

costAnalysisUis List<GetQueriesQueryCollectionItemQueryDefinitionCostAnalysisUi>: The common fields for Cost Analysis UI rendering.
displayName String: The query display name. Avoid entering confidential information.
reportQueries List<GetQueriesQueryCollectionItemQueryDefinitionReportQuery>: The request of the generated Cost Analysis report.
version Double: The saved query version.

costAnalysisUis GetQueriesQueryCollectionItemQueryDefinitionCostAnalysisUi[]: The common fields for Cost Analysis UI rendering.
displayName string: The query display name. Avoid entering confidential information.
reportQueries GetQueriesQueryCollectionItemQueryDefinitionReportQuery[]: The request of the generated Cost Analysis report.
version number: The saved query version.

cost_analysis_uis GetQueriesQueryCollectionItemQueryDefinitionCostAnalysisUi]: The common fields for Cost Analysis UI rendering.
display_name str: The query display name. Avoid entering confidential information.
report_queries GetQueriesQueryCollectionItemQueryDefinitionReportQuery]: The request of the generated Cost Analysis report.
version float: The saved query version.

costAnalysisUis List<Property Map>: The common fields for Cost Analysis UI rendering.
displayName String: The query display name. Avoid entering confidential information.
reportQueries List<Property Map>: The request of the generated Cost Analysis report.
version Number: The saved query version.

GetQueriesQueryCollectionItemQueryDefinitionCostAnalysisUi

Graph string: The graph type.
IsCumulativeGraph bool: A cumulative graph.

Graph string: The graph type.
IsCumulativeGraph bool: A cumulative graph.

graph String: The graph type.
isCumulativeGraph Boolean: A cumulative graph.

graph string: The graph type.
isCumulativeGraph boolean: A cumulative graph.

graph str: The graph type.
is_cumulative_graph bool: A cumulative graph.

graph String: The graph type.
isCumulativeGraph Boolean: A cumulative graph.

GetQueriesQueryCollectionItemQueryDefinitionReportQuery

CompartmentDepth double: The compartment depth level.
DateRangeName string: The UI date range, for example, LAST_THREE_MONTHS. Conflicts with timeUsageStarted and timeUsageEnded.
Filter string
Forecasts List<GetQueriesQueryCollectionItemQueryDefinitionReportQueryForecast>: Forecast configuration of usage/cost.
Granularity string: The usage granularity. HOURLY - Hourly data aggregation. DAILY - Daily data aggregation. MONTHLY - Monthly data aggregation. TOTAL - Not yet supported.
GroupBies List<string>: Aggregate the result by. example: ["tagNamespace", "tagKey", "tagValue", "service", "skuName", "skuPartNumber", "unit", "compartmentName", "compartmentPath", "compartmentId", "platform", "region", "logicalAd", "resourceId", "tenantId", "tenantName"]
GroupByTags List<GetQueriesQueryCollectionItemQueryDefinitionReportQueryGroupByTag>: GroupBy a specific tagKey. Provide the tagNamespace and tagKey in the tag object. Only supports one tag in the list. For example: [{"namespace":"oracle", "key":"createdBy"]
IsAggregateByTime bool: Whether aggregated by time. If isAggregateByTime is true, all usage/cost over the query time period will be added up.
QueryType string: The query usage type. COST by default if it is missing. Usage - Query the usage data. Cost - Query the cost/billing data. Credit - Query the credit adjustments data. ExpiredCredit - Query the expired credits data AllCredit - Query the credit adjustments and expired credit
TenantId string: Tenant ID.
TimeUsageEnded string: The usage end time.
TimeUsageStarted string: The usage start time.

CompartmentDepth float64: The compartment depth level.
DateRangeName string: The UI date range, for example, LAST_THREE_MONTHS. Conflicts with timeUsageStarted and timeUsageEnded.
Filter string
Forecasts []GetQueriesQueryCollectionItemQueryDefinitionReportQueryForecast: Forecast configuration of usage/cost.
Granularity string: The usage granularity. HOURLY - Hourly data aggregation. DAILY - Daily data aggregation. MONTHLY - Monthly data aggregation. TOTAL - Not yet supported.
GroupBies []string: Aggregate the result by. example: ["tagNamespace", "tagKey", "tagValue", "service", "skuName", "skuPartNumber", "unit", "compartmentName", "compartmentPath", "compartmentId", "platform", "region", "logicalAd", "resourceId", "tenantId", "tenantName"]
GroupByTags []GetQueriesQueryCollectionItemQueryDefinitionReportQueryGroupByTag: GroupBy a specific tagKey. Provide the tagNamespace and tagKey in the tag object. Only supports one tag in the list. For example: [{"namespace":"oracle", "key":"createdBy"]
IsAggregateByTime bool: Whether aggregated by time. If isAggregateByTime is true, all usage/cost over the query time period will be added up.
QueryType string: The query usage type. COST by default if it is missing. Usage - Query the usage data. Cost - Query the cost/billing data. Credit - Query the credit adjustments data. ExpiredCredit - Query the expired credits data AllCredit - Query the credit adjustments and expired credit
TenantId string: Tenant ID.
TimeUsageEnded string: The usage end time.
TimeUsageStarted string: The usage start time.

compartmentDepth Double: The compartment depth level.
dateRangeName String: The UI date range, for example, LAST_THREE_MONTHS. Conflicts with timeUsageStarted and timeUsageEnded.
filter String
forecasts List<GetQueriesQueryCollectionItemQueryDefinitionReportQueryForecast>: Forecast configuration of usage/cost.
granularity String: The usage granularity. HOURLY - Hourly data aggregation. DAILY - Daily data aggregation. MONTHLY - Monthly data aggregation. TOTAL - Not yet supported.
groupBies List<String>: Aggregate the result by. example: ["tagNamespace", "tagKey", "tagValue", "service", "skuName", "skuPartNumber", "unit", "compartmentName", "compartmentPath", "compartmentId", "platform", "region", "logicalAd", "resourceId", "tenantId", "tenantName"]
groupByTags List<GetQueriesQueryCollectionItemQueryDefinitionReportQueryGroupByTag>: GroupBy a specific tagKey. Provide the tagNamespace and tagKey in the tag object. Only supports one tag in the list. For example: [{"namespace":"oracle", "key":"createdBy"]
isAggregateByTime Boolean: Whether aggregated by time. If isAggregateByTime is true, all usage/cost over the query time period will be added up.
queryType String: The query usage type. COST by default if it is missing. Usage - Query the usage data. Cost - Query the cost/billing data. Credit - Query the credit adjustments data. ExpiredCredit - Query the expired credits data AllCredit - Query the credit adjustments and expired credit
tenantId String: Tenant ID.
timeUsageEnded String: The usage end time.
timeUsageStarted String: The usage start time.

compartmentDepth number: The compartment depth level.
dateRangeName string: The UI date range, for example, LAST_THREE_MONTHS. Conflicts with timeUsageStarted and timeUsageEnded.
filter string
forecasts GetQueriesQueryCollectionItemQueryDefinitionReportQueryForecast[]: Forecast configuration of usage/cost.
granularity string: The usage granularity. HOURLY - Hourly data aggregation. DAILY - Daily data aggregation. MONTHLY - Monthly data aggregation. TOTAL - Not yet supported.
groupBies string[]: Aggregate the result by. example: ["tagNamespace", "tagKey", "tagValue", "service", "skuName", "skuPartNumber", "unit", "compartmentName", "compartmentPath", "compartmentId", "platform", "region", "logicalAd", "resourceId", "tenantId", "tenantName"]
groupByTags GetQueriesQueryCollectionItemQueryDefinitionReportQueryGroupByTag[]: GroupBy a specific tagKey. Provide the tagNamespace and tagKey in the tag object. Only supports one tag in the list. For example: [{"namespace":"oracle", "key":"createdBy"]
isAggregateByTime boolean: Whether aggregated by time. If isAggregateByTime is true, all usage/cost over the query time period will be added up.
queryType string: The query usage type. COST by default if it is missing. Usage - Query the usage data. Cost - Query the cost/billing data. Credit - Query the credit adjustments data. ExpiredCredit - Query the expired credits data AllCredit - Query the credit adjustments and expired credit
tenantId string: Tenant ID.
timeUsageEnded string: The usage end time.
timeUsageStarted string: The usage start time.

compartment_depth float: The compartment depth level.
date_range_name str: The UI date range, for example, LAST_THREE_MONTHS. Conflicts with timeUsageStarted and timeUsageEnded.
filter str
forecasts GetQueriesQueryCollectionItemQueryDefinitionReportQueryForecast]: Forecast configuration of usage/cost.
granularity str: The usage granularity. HOURLY - Hourly data aggregation. DAILY - Daily data aggregation. MONTHLY - Monthly data aggregation. TOTAL - Not yet supported.
group_bies Sequence[str]: Aggregate the result by. example: ["tagNamespace", "tagKey", "tagValue", "service", "skuName", "skuPartNumber", "unit", "compartmentName", "compartmentPath", "compartmentId", "platform", "region", "logicalAd", "resourceId", "tenantId", "tenantName"]
group_by_tags GetQueriesQueryCollectionItemQueryDefinitionReportQueryGroupByTag]: GroupBy a specific tagKey. Provide the tagNamespace and tagKey in the tag object. Only supports one tag in the list. For example: [{"namespace":"oracle", "key":"createdBy"]
is_aggregate_by_time bool: Whether aggregated by time. If isAggregateByTime is true, all usage/cost over the query time period will be added up.
query_type str: The query usage type. COST by default if it is missing. Usage - Query the usage data. Cost - Query the cost/billing data. Credit - Query the credit adjustments data. ExpiredCredit - Query the expired credits data AllCredit - Query the credit adjustments and expired credit
tenant_id str: Tenant ID.
time_usage_ended str: The usage end time.
time_usage_started str: The usage start time.

compartmentDepth Number: The compartment depth level.
dateRangeName String: The UI date range, for example, LAST_THREE_MONTHS. Conflicts with timeUsageStarted and timeUsageEnded.
filter String
forecasts List<Property Map>: Forecast configuration of usage/cost.
granularity String: The usage granularity. HOURLY - Hourly data aggregation. DAILY - Daily data aggregation. MONTHLY - Monthly data aggregation. TOTAL - Not yet supported.
groupBies List<String>: Aggregate the result by. example: ["tagNamespace", "tagKey", "tagValue", "service", "skuName", "skuPartNumber", "unit", "compartmentName", "compartmentPath", "compartmentId", "platform", "region", "logicalAd", "resourceId", "tenantId", "tenantName"]
groupByTags List<Property Map>: GroupBy a specific tagKey. Provide the tagNamespace and tagKey in the tag object. Only supports one tag in the list. For example: [{"namespace":"oracle", "key":"createdBy"]
isAggregateByTime Boolean: Whether aggregated by time. If isAggregateByTime is true, all usage/cost over the query time period will be added up.
queryType String: The query usage type. COST by default if it is missing. Usage - Query the usage data. Cost - Query the cost/billing data. Credit - Query the credit adjustments data. ExpiredCredit - Query the expired credits data AllCredit - Query the credit adjustments and expired credit
tenantId String: Tenant ID.
timeUsageEnded String: The usage end time.
timeUsageStarted String: The usage start time.

GetQueriesQueryCollectionItemQueryDefinitionReportQueryForecast

ForecastType string: BASIC uses the exponential smoothing (ETS) model to project future usage/costs based on history data. The basis for projections is a periodic set of equivalent historical days for which the projection is being made.
TimeForecastEnded string: The forecast end time.
TimeForecastStarted string: The forecast start time. Defaults to UTC-1 if not specified.

ForecastType string: BASIC uses the exponential smoothing (ETS) model to project future usage/costs based on history data. The basis for projections is a periodic set of equivalent historical days for which the projection is being made.
TimeForecastEnded string: The forecast end time.
TimeForecastStarted string: The forecast start time. Defaults to UTC-1 if not specified.

forecastType String: BASIC uses the exponential smoothing (ETS) model to project future usage/costs based on history data. The basis for projections is a periodic set of equivalent historical days for which the projection is being made.
timeForecastEnded String: The forecast end time.
timeForecastStarted String: The forecast start time. Defaults to UTC-1 if not specified.

forecastType string: BASIC uses the exponential smoothing (ETS) model to project future usage/costs based on history data. The basis for projections is a periodic set of equivalent historical days for which the projection is being made.
timeForecastEnded string: The forecast end time.
timeForecastStarted string: The forecast start time. Defaults to UTC-1 if not specified.

forecast_type str: BASIC uses the exponential smoothing (ETS) model to project future usage/costs based on history data. The basis for projections is a periodic set of equivalent historical days for which the projection is being made.
time_forecast_ended str: The forecast end time.
time_forecast_started str: The forecast start time. Defaults to UTC-1 if not specified.

forecastType String: BASIC uses the exponential smoothing (ETS) model to project future usage/costs based on history data. The basis for projections is a periodic set of equivalent historical days for which the projection is being made.
timeForecastEnded String: The forecast end time.
timeForecastStarted String: The forecast start time. Defaults to UTC-1 if not specified.

GetQueriesQueryCollectionItemQueryDefinitionReportQueryGroupByTag

Key string: The tag key.
Namespace string: The tag namespace.
Value string: The tag value.

Key string: The tag key.
Namespace string: The tag namespace.
Value string: The tag value.

key String: The tag key.
namespace String: The tag namespace.
value String: The tag value.

key string: The tag key.
namespace string: The tag namespace.
value string: The tag value.

key str: The tag key.
namespace str: The tag namespace.
value str: The tag value.

key String: The tag key.
namespace String: The tag namespace.
value String: The tag value.

Package Details

Repository: https://github.com/pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.