I’m looking for some recommendations on how to deal with historical events such as past maintenance tasks.
My goal is to store all historical services performed on the machines my IoTs are connected to. This information is used to establish a predictive maintenance schedule.
My first idea is to use the Data Tables where I could store the dates as a number. I understand this is not recommended for time series data, hence my interrogation.
My second idea is to use a device attribute, but I would need to manipulate the timestamp of the device state (service history comes from a manual user entry). Also, the values would be lost after 30 days, which doesn’t work for me since I want to keep the entire service history.