interfaces.xml - adding data point / templates graphing port last change

[antram]

Hello everyone, I see that I can poll port status directly ( ifOperStatus ) - I am trying to determine a very unusual outage pattern where a port will drop briefly, then return - but leaving errors on logging systems. I would like to use ( ifLastChange ) which returns system uptime at last change:

.1.3.6.1.2.1.2.2.1.9.1 = Timeticks: (2100) 0:00:21.00
.1.3.6.1.2.1.2.2.1.9.2 = Timeticks: (0) 0:00:00.00
.1.3.6.1.2.1.2.2.1.9.3 = Timeticks: (0) 0:00:00.00
.1.3.6.1.2.1.2.2.1.9.4 = Timeticks: (0) 0:00:00.00
.1.3.6.1.2.1.2.2.1.9.5 = Timeticks: (262013200) 30 days, 7:48:52.00
.1.3.6.1.2.1.2.2.1.9.6 = Timeticks: (0) 0:00:00.00
.1.3.6.1.2.1.2.2.1.9.7 = Timeticks: (615539200) 71 days, 5:49:52.00

I added this to interfaces.xml:

<ifUptime>
<name>Uptime</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.2.1.2.2.1.9</oid>
</ifUptime>

The verbose query shows this field in its results, but so far I'm unable to locate the definitions for it to be creatable with templates in the snmp interface portions of cacti. I'm trying to use generic OID to work around this, but it sure would be nice to batch those creations.

Clearly, I will need to manually review these graphs for changes as they won't reindex like system uptime would, but any change is an issue for us.

Where am I missing ifUptime in the template / graph templates.

[antram]

So I located the various templates, but the poller_items are incorrect...

The interfaces.xml specified .1.3.6.1.2.1.2.2.1.9 (etc )
and in the poller items, I get:
MariaDB [cacti]> select arg1 from poller_item where arg1 like ".1.3.6.1.2.1.2.2.1.8%";
+------------------------+
| arg1 |
+------------------------+
| .1.3.6.1.2.1.2.2.1.8.1 |
| .1.3.6.1.2.1.2.2.1.8.5 |
| .1.3.6.1.2.1.2.2.1.8.7 |
+------------------------+
3 rows in set (0.001 sec)

[antram]

I am now looking inside Data Queries - item is SNMP Interface Statistics - but I'm unable to add a proper element to the table as there is no way to re-import the XML file. Once it is imported, only the requery interfaces function loads the xml. I've tried deleting the definition and associated graph templates, but it doesn't create new items.