came up with the following label_replace(group by (instance) (agent_build_info), "instance", '$1', "instance", '(.+):12345')
On Thursday, August 24, 2023 at 3:37:40 PM UTC-4 Richie wrote: > Brian your suggestions ultimately helped as it introduced me a new > concept. I don't think I conveyed what I wanted properly. Put another > way I was looking for 'a list of unique values for the key "instance". > Still not sure if that's the best way to articulate it. > > Based on your suggestions this is what I came up with > group by (instance) (agent_build_info) > > Ideally the port ':12345' could be stripped, but what is generated from > the above is plenty sufficient. > > Thanks for the help. > > On Thursday, August 24, 2023 at 2:04:26 PM UTC-4 Brian Candler wrote: > >> Aha, I just discovered you can do: >> >> count without (instance, job) (agent_build_info) >> group without (instance, job) (agent_build_info) >> >> That should be what you want :-) >> >> On Thursday, 24 August 2023 at 18:59:24 UTC+1 Brian Candler wrote: >> >>> If you are happy to list all the labels of interest (i.e. everything >>> apart from the 'job' and 'instance' labels and any other labels you've >>> added yourself): >>> >>> count by (goversion,version,branch,revision) (agent_build_info) >>> >>> Or you can use "group by" instead of "count by" to get a value of 1 for >>> everything (although personally I think the counts are useful!) >>> >>> On Thursday, 24 August 2023 at 16:05:17 UTC+1 Richie wrote: >>> >>>> or i suppose i could process the results as they come from the api via >>>> python >>>> >>>> On Thursday, August 24, 2023 at 10:59:18 AM UTC-4 Richie wrote: >>>> >>>>> I would like to pull a line by line list of unique instances from >>>>> agent_build_info and save it to a file for the purpose of cross checking >>>>> via script against a list of known instances that should be monitored >>>>> (reporting purposes). >>>>> >>>>> so in short is it possible to create a query that equivalent of *select >>>>> distinct instance from agent_build_info --(were it a traditional table) * >>>>> ? >>>>> >>>>> -Richie >>>>> >>>>> -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/ba9bc319-701b-4d67-b72a-1a468876b858n%40googlegroups.com.
