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
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
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