Thanks for your response.
If I do `ltmPoolMbrStatusAvailState *
on(instance,ltmPoolMbrStatusNodeName,ltmPoolMbrStatusPoolName,ltmPoolMbrStatusPort)
group_right ltmPoolMbrStatusEnabledState` I get:
`{instance="ltm01", job="f5_ltm_test", ltmPoolMbrStatusEnabledState="1",
ltmPoolMbrStatusNodeName="/Common/VPN1",
ltmPoolMbrStatusPoolName="/Common/Pool1", ltmPoolMbrStatusPort="4500",
prometheus="monitoring/k8s", prometheus_replica="prometheus-k8s-0"}`
So this has `ltmPoolMbrStatusEnabledState` but not
`ltmPoolMbrStatusAvailState`. If I swap the metrics round:
`ltmPoolMbrStatusEnabledState *
on(instance,ltmPoolMbrStatusNodeName,ltmPoolMbrStatusPoolName,ltmPoolMbrStatusPort)
group_right ltmPoolMbrStatusAvailState`. I get:
`{instance="ltm01", job="f5_ltm_test", ltmPoolMbrStatusAvailState="1",
ltmPoolMbrStatusNodeName="/Common/VPN1",
ltmPoolMbrStatusPoolName="/Common/Pool1", ltmPoolMbrStatusPort="4500",
prometheus="monitoring/k8s", prometheus_replica="prometheus-k8s-0"}`
This has `ltmPoolMbrStatusAvailState` but not `ltmPoolMbrStatusEnabledState`
So it seems I can get one or the other, not both. Unless im forming my
PromQL wrong?
On Tuesday, 7 March 2023 at 08:31:39 UTC Brian Candler wrote:
> It has to be done in a query - the relabelling phase of a scrape job
> cannot see other metrics.
>
> What you are looking for is one-to-many queries, which can pick up labels
> from the "one" side and apply them to the "many":
>
> https://www.robustperception.io/how-to-have-labels-for-machine-roles
> https://www.robustperception.io/exposing-the-software-version-to-prometheus
>
> https://prometheus.io/docs/prometheus/latest/querying/operators/#many-to-one-and-one-to-many-vector-matches
> https://www.robustperception.io/left-joins-in-promql
>
> > I have tried doing a join but it only seems to bring in one of the
> `ltmPoolMbrStatusEnabledState` and `ltmPoolMbrStatusAvailState` metrics
> depending on if its a left or right join, but I would like both to appear.
>
> Can you show what query you did, the raw metrics which it used, what
> result you got, and what you wanted to get instead?
>
--
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/9e097ded-7211-4b4f-9c4d-1e91a8511bb2n%40googlegroups.com.
