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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/dd94cc65-7fde-4ea1-ab46-02a25aa34078n%40googlegroups.com.
