Telegraf and csv data

Telegraf
1

Hi to all, i have one problem, i would import data from csv file and use the time from field csv.

this an example data

"Data","Nodo","Tipo","Livello","Oggetto","Valore","Messaggio"
"2023/10/16-11:55:34.659","PC2864","Evento","1","System.CommunicationLost","0","Connessione fra dispositivi ristabilita"
"2023/10/16-11:44:09.540","PC2740-DO","Evento","1","System.CommunicationLost","0","Connessione fra dispositivi ristabilita"
"2023/10/16-11:44:07.453","PC2740-DO","Evento","1","System.CommunicationLost","0","Connessione fra dispositivi ristabilita"
"2023/10/16-11:25:04.962","PC5480","Evento","1","System.PresentStatus.CommunicationError","0","Comunicazione ristabilita"
"2023/10/16-11:23:04.895","PC5480","Evento","2","System.PresentStatus.CommunicationError","1","Comunicazione fallita"
"2023/10/16-11:22:21.223","PC1398","Evento","1","System.PresentStatus.CommunicationError","0","Comunicazione ristabilita"

I need to see all the events and perhaps do some checks on event 2 of the machine x how much time has passed for the change of state.

example

how much time has passed on this event change

"2023/10/16-11:25:04.962","PC5480","Evento","1","System.PresentStatus.CommunicationError","0","Comunicazione ristabilita"
"2023/10/16-11:23:04.895","PC5480","Evento","2","System.PresentStatus.CommunicationError","1","Comunicazione fallita"
2

Hello @manustar,
I can recommend the following resource for creating alert tasks:

Also these functions:

I’m not sure how you would find when a state change has occurred though and subtract the time between the two.

Honestly I recommend using a client library instead of Flux. Querying for your data, doing this logic in python, creating an alert, and then writing any relevant data back to influx.