hi to all.
i import the data from csv to influx 1.8, and i need create an alert when the difference between the 2 timestamps is greater than. Since there are data from multiple services, I need to change the timestamp of the specific service.
this is an example of the data
2023/10/16-10:16:35.113 PC1123 Evento 1 UPS.PowerSummary.PresentStatus.ACPresent 1 Il sistema è alimentato dalle utenze
2023/10/16-10:16:34.023 PC1123 Evento 2 UPS.PowerSummary.PresentStatus.ACPresent 0 Il sistema è alimentato dalla batteria del UPS
2023/10/14-14:48:28.331 PC5544 Evento 1 UPS.PowerSummary.PresentStatus.ACPresent 1 Il sistema è alimentato dalle utenze
2023/10/14-14:44:28.144 PC5544 Evento 2 UPS.PowerSummary.PresentStatus.ACPresent 0 Il sistema è alimentato dalla batteria del UPS
in the first 2 lines the difference between the times of the PC1123 is less than 60 seconds and must not generate an alarm, whereas the difference between the times of the PC5544 is 60 seconds and must generate an alarm. this check should only be done in pairs of 2 based on the times and specific event