Grafana is not collecting all metrics from influxdb

Hi

Below is the my telegraf.conf file;

# Configuration for telegraf agent
[agent]
 round_interval = true
  metric_batch_size = 1000
  metric_buffer_limit = 10000

 collection_jitter = "0s"
  flush_interval = "10s"
  flush_jitter = "0s"
  precision = ""

  ## Override default hostname, if empty use os.Hostname()
  hostname = ""
  ## If set to true, do no set the "host" tag in the telegraf agent.
  omit_hostname = false
[[outputs.influxdb_v2]]
  ## The URLs of the InfluxDB cluster nodes.
  ##
  ## Multiple URLs can be specified for a single cluster, only ONE of the
  ## urls will be written to each interval.
  ##   ex: urls = [https://us-west-2-1.aws.cloud2.influxdata.com]
  urls = [http://influxhost:8086]

  ## Token for authentication.
  token = "gtytytyt67****************YnrLmmvHAg=="

  ## Organization is the name of the organization you wish to write to; must exist.
  organization = "MyOrg"

  ## Destination bucket to write into.
  bucket = "VCENTER_BUCKET"

 
## Realtime instance
[[inputs.vsphere]]
## List of vCenter URLs to be monitored. These three lines must be uncommented
## and edited for the plugin to work.
interval = "60s"
  vcenters = [ https://20.10.20.30/sdk ]
  username = svc @mydomain.com
  password = "tytytytyt**"

vm_metric_include = []
host_metric_include = []
cluster_metric_include = []
datastore_metric_exclude = ["*"]

max_query_metrics = 256
timeout = "60s"
insecure_skip_verify = true

## Historical instance
[[inputs.vsphere]]
interval = "300s"
vcenters = [ https://20.10.20.30/sdk ]
  username = svc @mydomain.com
  password = "tytytytyt**"

  datastore_metric_include = [ "disk.capacity.latest", "disk.used.latest", "disk.provisioned.latest" ]
  insecure_skip_verify = true
  force_discover_on_init = true
  host_metric_exclude = ["*"] # Exclude realtime metrics
  vm_metric_exclude = ["*"] # Exclude realtime metrics

  max_query_metrics = 256
  collect_concurrency = 3

Now I start the telegraf service and I can see these metrics in my influxdb console as expected successfully.

Now I successfully integrate this influxdb with our Grafana which is running locally on our computer. But here in Grafana I don’t see these vcenter metrics but I can see other system metrics if I enable CPU, Disk, Memory ect from the local computer where telegraf is running.

Can some one please tell me what I am missing here?

Hello,
I’m not using the query composer but i think you just have a default bucket save in your Influxdb datasource.
you can erase this param in your datasource config to get access to all bucket
or you can compose plain text query i think.

in grafana you can use query inspector to get your plain text query recieved by grafana.
you can try to reach your VCENTER_BUCKET trought plain text query

Are you referring about the influxdb source in Grafana Data Sources?

yes i am,
do you have default bucket in this config ?

Capture
have it like this

maybe query is wrong can you use the right measurement name ?

from(bucket: "VCENTER_BUCKET")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "????????")

what is your version of grafana ?
you should look at this, i believe it’s a config issue
https://localhost:3000/t/error-updating-options-query-error-400-bad-request-after-upgrade-to-8-x/48781
What is the bucket list you have on your first screen ? where are these buckets ?
look like measurement field to me.

Hi Alexander,

i am getting like this, and i use latest version of grafana as yesterday only i downloaded it.

maybe query is wrong can you use the right measurement name ?

from(bucket: "VCENTER_BUCKET")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "????????")

what is your version of grafana ?
you should look at this, i believe it’s a config issue
https://localhost:3000/t/error-updating-options-query-error-400-bad-request-after-upgrade-to-8-x/48781
What is the bucket list you have on your first screen ? where are these buckets ?
look like measurement field to me.

sure, let me go through it.