Trending from log data

Solved468 viewstrending
1
2 Comments

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
Miguel Obregon [SLC] [DevOps Catalyst] commented

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
Joshua Lee [SLC] [DevOps Advocate] commented

Thanks Miguel, in the end this method seems to be the best.

1 Answer

0
4.66K 0 Comments

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