Hmm, not sure what documentation is in the code, perhaps I was looking at the wrong files.
It would appear however that the ifLastChange field is only changed whenever that particular record gets ‘updated’. The MySQL column has 'on update CURRENT_TIMESTAMP’ as it’s attribute.
I’m thinking of removing that and creating a separate script to update this column with the interface change time as reported by the device.
Thanks
Jake Turner
Sent from my Mac
On 19 Apr 2014, at 03:18, Adam Armstrong <adama@memetic.orgmailto:adama@memetic.org> wrote:
You can easily ascertain this by looking at the code.
It's actually quite well documented in the code, and is not a reliable value, really.
adam.
On 2014-04-18 19:34, Jake Turner wrote: Hi Does anybody know where the ‘ifLastChange’ field in the DB gets set? I’m trying to add in a script that will pull the last change time using SNMP from Cisco devices (I already know how to do this) and then add this into the db instead of wherever it get’s set by default. The reason I want to do this is because the alerts at present can be slightly misleading. When I ignore a down interface (say it’s been down a week) and then remove the ignore flag, the interface shows as being down since the time the ignore flag was removed. This could lead to chasing tails trying to figure out why an interface has gone down when in fact it hasn’t been up for a week. Happy Easter to all too :) Jake Turner On 13 Apr 2014, at 06:28, Jake Turner <Jake.Turner@turnerhouse.org.ukmailto:Jake.Turner@turnerhouse.org.uk> wrote: Hi all, I can't seem to see this feature on the port details page or the 'all ports' list but forgive me if it is visible somewhere. It would be useful to have a 'last changed' time (30 mins ago) etc... on the port details page. This info can be gained from SNMP and from what I can see is already in the DB so it would just be a case of adding it to the page code. Thanks Jake _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium