advanced_query.md

copyright	years 2017, 2018
lastupdated	2018-03-29

{:shortdesc: .shortdesc} {:new_window: target="_blank"}

Creating an advanced monitoring query (Beta)

In the {{site.data.keyword.cloud}}, you can use Grafana, an open source analytics and visualization platform, to monitor, search, analyze, and visualize your metrics in a variety of graphs, for example charts and tables. You can use Grafana to perform advanced analytical tasks. {:shortdesc}

If you use Grafana, you can use the dashboard to create graphs using the metric query.

1. Navigate to the Grafana dashboard.
2. Select the domain account and a user account with an IBMid linked to the bare metal device.
3. Use this format to create your queries. ibmcloud.public.iaas-telemetry.region.<DATACENTER_BAREMETAL_LIVES_IN>.<MACHINE_GUID>.<METRIC_TYPE>
4. Here are the available metric types:

Table 1. IBM Cloud Monitoring Service for IaaS Bare Metal Agent

Type	Units
`cpu-pct-` `cpu-pct-avg`	%
`memory-used-bytes`	bytes
`memory-used-percent`	%
`memory-swap-bytes`	bytes
`memory-swap-percent`	%
`disk-total-bytes-` `disk-total-bytes-agg`	bytes
`disk-used-bytes-` `disk-used-bytes-agg`	bytes
`disk-used-percent-`	%
`disk-read-bps-` `disk-read-bps-agg`	bytes/second
`disk-write-bps-` `disk-write-bps-agg`	bytes/second
`disk-read-iops-` `disk-read-iops-agg`	operations/second
`disk-write-iops-` `disk-write-iops-agg`	operations/second
`disk-read-latency-` `disk-read-latency-avg`	latency in milliseconds per operation
`disk-write-latency-` `disk-write-latency-avg`	latency in milliseconds per operation
`net-public-in-bps-` `net-public-in-bps-agg` or `net-private-in-bps- net-private-in-bps-agg`	bytes/second
`net-public-out-bps-` `net-public-out-bps-agg` or `net-private-out-bps- net-private-out-bps-agg`	bytes/second
`net-public-in-packets-` `net-public-in-packets-agg` or `net-private-in-packets- net-private-in-packets-agg`	number
`net-public-out-packets-` `net-public-out-packets-agg` or `net-private-out-packets- net-private-out-packets-agg`	number
`net-public-in-errors-` `net-public-in-errors-agg` or `net-private-in-errors- net-private-in-errors-agg`	number
`net-public-out-errors-` `net-public-out-errors-agg` or `net-private-out-errors- net-private-out-errors-agg`	number
`temperature-celsius-` `temperature-celsius-avg` This metric is not available for all devices.	degrees Celsius

For more information, see Configuring a metric query in Grafana.