InfluxDB query and filter values

Question

cant seem to find if similar post. I am using Grafana / InfluxDB I am trying to create a variable in Grafana, to create this variable I need to query values which I can do easily with this piece:

SHOW TAG VALUES WITH KEY = "name"

However, I need to filter the values that I get, in example, I would like only to see values that have specific url maybe just https://google.com.

I tried something like this

SHOW TAG VALUES WITH KEY = "name" WHERE "name" = 'https://google.com'

And I get only on instance of this URL, perhaps there is a way to find all the URL's which contain https://google.com

Jan Garaj · Accepted Answer · 2022-08-09 14:41:23Z

1

Try regular expressions, probably:

SHOW TAG VALUES WITH KEY = "name" 
WHERE "name" =~ /.https:\/\/google\.com./

answered Aug 9, 2022 at 14:41

Jan Garaj

29k3 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

InfluxDB query and filter values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related