Sounds to me like you want to use a result from one query as a label value
to another query's label key.
It seems pretty easy if you use SQL (by using Promscale) for this, like
select * from prom_metric.go_goroutines where labels ? ('ifIndex' ==
(select value from prom_metric.ifName limit 1)::text);
But not sure how to do it in PromQL.
(My previous reply from mail didn't come here, maybe due to some reply
option selection, so repasting the answer. Sorry for that.)
On Tuesday, March 16, 2021 at 7:30:22 PM UTC+5:30 Robert Collier wrote:
> [Moving the list to bcc]
>
> You need to reverse the order - the bracketed expression first:
>
> (ifName * 0) + on(ifIndex,hostname,instance,job) group_left ifOutOctets
>
> I'll follow up separately re the snmp config.
>
>
> On Tue, 16 Mar 2021 at 09:55, Saurabh Jain <[email protected]> wrote:
>
>> It is still not working.
>>
>>
>> [image: image.png]
>>
>> We used the latest configuration of snmp exporter and generator and below
>> is the snapshot of the snmp.yml file which was generated by generator.
>>
>> [image: image.png]
>> Pls suggest if we have to tweak the snmp file to achieve the desired
>> result.
>>
>>
>> On Tue, Mar 16, 2021 at 2:09 PM Robert Collier <[email protected]>
>> wrote:
>>
>>> Ah, reverse it to:
>>>
>>> (ifName * 0) + on(ifIndex,hostname,instance,job) group_left ifOutOctets
>>>
>>> [image: Screen Shot 2021-03-16 at 8.32.10 AM.png]
>>>
>>> *However*, if you are using the regular prometheus snmp_expporter, you
>>> should be aware that configured correctly it will do this step for you, eg,
>>> copying directly from my snmp exporters metrics:
>>>
>>> # HELP ifOutOctets The total number of octets transmitted out of the
>>> interface, including framing characters - 1.3.6.1.2.1.2.2.1.16
>>> # TYPE ifOutOctets counter
>>> ifOutOctets{ifAlias="",ifDescr="apcli0",ifIndex="16",ifName="apcli0"} 0
>>> ifOutOctets{ifAlias="",ifDescr="apclii0",ifIndex="28",ifName="apclii0"} 0
>>> ifOutOctets{ifAlias="",ifDescr="br0",ifIndex="29",ifName="br0"}
>>> 2.7732281e+07
>>> ifOutOctets{ifAlias="",ifDescr="eth0",ifIndex="2",ifName="eth0"}
>>> 2.76292118e+08
>>> ifOutOctets{ifAlias="",ifDescr="lo",ifIndex="1",ifName="lo"} 1.930652e+06
>>> ifOutOctets{ifAlias="",ifDescr="ra0",ifIndex="4",ifName="ra0"}
>>> 5.37888286e+08
>>> ifOutOctets{ifAlias="",ifDescr="ra1",ifIndex="5",ifName="ra1"} 0
>>>
>>> You may have to regenerate the configuration for it to do that though:
>>> https://github.com/prometheus/snmp_exporter/blob/main/README.md#generating-configuration
>>>
>>> It's been a couple of years since I did the setup now and I don't
>>> remember the details.
>>>
>>> - Regards, Rob.
>>>
>>> On Tue, 16 Mar 2021 at 03:53, Saurabh Jain <[email protected]>
>>> wrote:
>>>
>>>> Not working . Pls chk below screenshot.
>>>>
>>>> [image: image.png]
>>>>
>>>>
>>>> On Tue, Mar 16, 2021 at 12:18 AM Robert Collier <[email protected]>
>>>> wrote:
>>>>
>>>>> Something like this maybe?:
>>>>>
>>>>> ifOutOctets + on(ifIndex,hostname,instance,job) group_right (ifName *
>>>>> 0)
>>>>>
>>>>> On Mon, 15 Mar 2021 at 16:17, Saurabh Jain <[email protected]>
>>>>> wrote:
>>>>>
>>>>>> Thanks Harry for the update.
>>>>>>
>>>>>> ifOutOctets metric dont have the label ifName.
>>>>>>
>>>>>> However I am getting below response for the same.
>>>>>>
>>>>>> [image: image.png]
>>>>>> pls advice.
>>>>>>
>>>>>> On Mon, Mar 15, 2021 at 6:00 PM Harry Perks <[email protected]>
>>>>>> wrote:
>>>>>>
>>>>>>> Does ifOutOctets have a label ifName? If not, you'll need to perform
>>>>>>> a vector match operation - it looks like ifIndex can be used:
>>>>>>>
>>>>>>> sum by(ifName) (ifOutOctets * on(ifIndex) group_left(ifName) ifName)
>>>>>>>
>>>>>>> On Monday, March 15, 2021 at 11:38:41 AM UTC [email protected]
>>>>>>> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> I have a certain requirement to implement in Grafana where we need
>>>>>>>> to show interface utilization for switch.
>>>>>>>>
>>>>>>>> I got combination of two queries in order to achieve it
>>>>>>>>
>>>>>>>> 1)
>>>>>>>> ifOutOctets{hostname="XX",ifIndex="103",instance="XX",job="SNMP"}
>>>>>>>>
>>>>>>>> 2)
>>>>>>>> ifName{hostname="XX",ifIndex="103",ifName="Te1/0/1",instance="XX",job="SNMP"}
>>>>>>>>
>>>>>>>> First query -- It gives interface utilization on specific index
>>>>>>>>
>>>>>>>> Second query --- It gives interface name mapped to specific index
>>>>>>>>
>>>>>>>> Now How can I combine both these query in a way that I get
>>>>>>>> interface utilization on interface name not on index.
>>>>>>>>
>>>>>>>> Pls advice.
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>> Saurabh
>>>>>>>
>>>>>>> --
>>>>>>> You received this message because you are subscribed to a topic in
>>>>>>> the Google Groups "Prometheus Developers" group.
>>>>>>> To unsubscribe from this topic, visit
>>>>>>> https://groups.google.com/d/topic/prometheus-developers/PyK8s75e1vE/unsubscribe
>>>>>>> .
>>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>>> [email protected].
>>>>>>> To view this discussion on the web visit
>>>>>>> https://groups.google.com/d/msgid/prometheus-developers/db5825ef-58ba-44f2-b049-ec3050024f9cn%40googlegroups.com
>>>>>>>
>>>>>>> <https://groups.google.com/d/msgid/prometheus-developers/db5825ef-58ba-44f2-b049-ec3050024f9cn%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>>> .
>>>>>>>
>>>>>> --
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "Prometheus Developers" 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-developers/CA%2BTEA9DHhD2%3DKx7%3DnTTzfzepcZQ%2BfXEC06QXywazKYK2oZnzaQ%40mail.gmail.com
>>>>>>
>>>>>> <https://groups.google.com/d/msgid/prometheus-developers/CA%2BTEA9DHhD2%3DKx7%3DnTTzfzepcZQ%2BfXEC06QXywazKYK2oZnzaQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>>>> .
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Robert Collier
>>>>> [email protected]
>>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Prometheus Developers" 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-developers/CA%2BTEA9Cn5a1_Se1nqqgBF5uzgS-cBn_YYAY8ghPTQ%3D3EJ-qR3A%40mail.gmail.com
>>>>
>>>> <https://groups.google.com/d/msgid/prometheus-developers/CA%2BTEA9Cn5a1_Se1nqqgBF5uzgS-cBn_YYAY8ghPTQ%3D3EJ-qR3A%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>>
>>>
>>> --
>>> Robert Collier
>>> [email protected]
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Prometheus Developers" 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-developers/CA%2BTEA9Ca7Cn9dz-OvChKUC%2BoqrUAbRdJuutkXeLfxmiD0AXejA%40mail.gmail.com
>>
>> <https://groups.google.com/d/msgid/prometheus-developers/CA%2BTEA9Ca7Cn9dz-OvChKUC%2BoqrUAbRdJuutkXeLfxmiD0AXejA%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>>
>
>
> --
> Robert Collier
> [email protected]
>
--
You received this message because you are subscribed to the Google Groups
"Prometheus Developers" 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-developers/c12fb859-d26a-4b6a-80e9-4760b7ff0459n%40googlegroups.com.
