I am currently working on a driver that queries and stores a historical log e.g. a log of packet drops incidents. Each incident is stored as a separate instance (PK) and states the source IP and destination IP.
The user would like to be able to trend the packet loss between 2 IPs over time (i.e. y-axis is the packet loss values, x-axis is time).
Is there an elegant method to do this from the existing table?
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 6th February 2024
Thanks Miguel, in the end this method seems to be the best.
It looks like this question has already been answered in the comments. This is a pro forma answer to make it possible to mark the question as resolved.
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 6th February 2024
Hi Joshua,
Normally for this type of integrations we use history sets:
https://docs.dataminer.services/develop/devguide/Connector/MonitoringTrending.html#history-sets
You will need to create a new table that will contain a row per LAN network. In this new table, the packet loss column will be trended