Unable to collect Sub OID from Greater OID

Hey

I am trying to collect Cisco IP SLA Metrics using telegraf. I am however running into a wall. I am using the OIDS from the Cisco CISCO-RTTMON-MIB. I am trying to get the latest IP SLA operations metrics.

I currently have two IP SLA operations running, IP SLA # and IP SLA #5. I want to collect the “average jitter” for these two operations. To do that I need to use the OID .1.3.6.1.4.1.9.9.42.1.5.2.1.46 “rttMonLatestJitterOperAvgJitter”.

I perform an SNMP Walk on this OID and the following output is presented.
SNMPv2-SMI::enterprises.9.9.42.1.5.2.1.46.1 = Gauge32: 6
SNMPv2-SMI::enterprises.9.9.42.1.5.2.1.46.5 = Gauge32: 11

This is great. I can see the values. But this is where the issue starts with telegraf for me.

The following telegraf config works.

[[inputs.snmp.table]]
name = “TV1_SLA”

[[inputs.snmp.table.field]]
name = “Avg_Jit”
oid = “.1.3.6.1.4.1.9.9.42.1.5.2.1.46”

TV1_SLA,agent_host=192.168.1.75,host=tigubustk Avg_Jit=5i 1588603169000000000
TV1_SLA,agent_host=192.168.1.75,host=tigubustk Avg_Jit=2i 1588603169000000000

Now I want to detail it down even further so I can specificy each IP SLA operation. Which would be the OID 1.3.6.1.4.1.9.9.42.1.5.2.1.46 with the operation number added to the end of the OID.
For example. IP SLA 99 operation would be
1.3.6.1.4.1.9.9.42.1.5.2.1.46.99

For example. IP SLA 104 operation would be
1.3.6.1.4.1.9.9.42.1.5.2.1.46.104.

I can SNMPwalk for operation #5 specifically and I obtain an output.
SNMPv2-SMI::enterprises.9.9.42.1.5.2.1.46.5 = Gauge32: 9

But Telegraf is unable to go for the “sub” OID.

[[inputs.snmp.table]]
name = “TV1_SLA”

[[inputs.snmp.table.field]]
name = “Avg_Jit”
oid = “.1.3.6.1.4.1.9.9.42.1.5.2.1.46.5”

How do I, either:
A.) Get Telegraf to work with the sub oid# for each SLA operation. or
B.) Get Telegraf to place each output into a seperate table. Aka, I want all OIDS that are for operation #5 to placed into an influx table of 5.

If I run it on the greater OID and and collect all operations. It just reads the output of each operation and compiles into the same table field. Making the data unusable.

*Caveat, I am by no means an InfluxDB guru. I am just bashing my way around, so the data may be there but I am unable to query correctly for it.

Any help is greatly appreciated.