I’m trying to keep track of switchport status for a large number of switches. These switches use Arista’s streaming telemetry solution, which only pushes updates if the status changes. For switchports in our network, this is very infrequent, state sometimes won’t change for months.
I would like to visualize the port status history in Grafana using a discrete measurements panel. The challenge I have is that quite often, the time period shown in the graph (for example 1 month) does not contain any data points in the database. I can do some tricks by adjusting the query so the time period queried goes back further than the time window shown in the graph, but since port status sometimes won’t change for months, I’d have to go back a long time to be sure I still have measurements.
I checked with Arista if there’s a solution on the data sending side, but unfortunately there isn’t.
So now I was thinking on doing something with Kapacitor, perhaps with StateDurationNode to introduce additional measurements by repeating the previous value. If that would be possible (for example once a day or week) I can use the query with adjusted time periods.
Would this be feasible? Has anyone done something similar? Or is there a better solution I missed?