Creating a Query for a Custom Metric

• Console
• CLI
• API

• These steps show how to create a query in Basic mode on the Metrics Explorer page. To create a query in Advanced mode (MQL), see Editing the MQL Expression for a Query.

  1. Create a basic query on the Metrics Explorer page.
  2. In the navigation bar, select the region that contains the metric data that you want.
     For more information about regions, see Understand Regions and Working Across Regions.
  3. In the query under the chart, select the compartment that contains the custom metric that you want.
  4. Select the metric namespace that contains the custom metric that you want.
     Example: mymetricsnamespace
  5. (Optional) Select the resource group that you want.
     Example: divisionX
  6. Select the name of the custom metric.
     Example: productOrder
  7. (Optional) Update the interval or statistic.
     Example: Select 1 minute for Interval, and select Sum for Statistic.
  8. To view and update the MQL expression, select Advanced mode.

     The MQL expression is in the Query code editor box. Example:

     productOrder[1m].sum()
  9. Select Update Chart.
     The chart shows data points for the custom metric, in a graph view. Example:
  10. (Optional) To switch to a table view, select Show Data Table.
      The chart shows data points for the custom metric, in a table view.

• Use the oci monitoring metric-data summarize-metrics-data command and required parameters to query metric data.

  Command

  CopyTry It

  oci monitoring metric-data summarize-metrics-data --compartment-id <compartment_OCID> --namespace <metric_namespace> --query-text <mql_expression>

  The following example uses the --from-json parameter to retrieve custom metric information from a JSON file.

  Command

  CopyTry It

  oci monitoring metric-data summarize-metrics-data --from-json file://./get-metrics.json [...]

  For a complete list of parameters and values for CLI commands, see the Command Line Reference for Monitoring.

  Example JSON file for request

  Example response

• Run the SummarizeMetricsData operation to query metric data.