So in theory this seems like a simple ordeal milliseconds output / 60000 = minutes I have 2 datetime fields start_time and end_time, I have to subtract 1 from the other to = session_time, which I have working great - the output is in milliseconds. Now I want to convert milliseconds to minutes - no …

This post might get you a little closer to what you want to do: [image] Convert seconds to something readable Pipeline Rules Our VPN reported total connect time in seconds but we needed something understandable for reporting purposes. @shoothub handily put it together fo…

thanks for the suggestion, I had tried that exact thing this morning with no success. The problem is the value for to_long(session_time) = 0 so it doesn’t process the rule. if I leave the > 0 part off, I see hours minutes seconds for duration, but no numbers I even tried rule "VPN sessiontime to …

I just tried doing the above except I used to_string instead of to_long… now I get an output of PT142S - not sure what that means but it’s something!

so for some reason it converted it to a duration… I used a grok pattern to extract the number of seconds from the to_string value. Then did some math to turn it into hours minutes seconds

Hello @d2freak82 If I’m correct this was from Discord? [image] d2freak82: I used a grok pattern to extract the number of seconds from the to_string value. Then did some math to turn it into hours minutes seconds Could you show how this was done?

sure - first since I was seeing PT140s (or some variation of that) displaying for session_time I realized that it was a duration it was showing. To do that, I just did a basic output of what to_string(session_time) was. Then I created a grok pattern to extract that, which could be done in the pipel…

Awesome, thanks for posting it @d2freak82

Datetime milliseconds to minutes

Graylog Central (peer support)

tmacgbay (Tmacgbay) July 25, 2022, 7:10pm 2

This post might get you a little closer to what you want to do:

Topic		Replies	Views
Convert Milliseconds to Minutes Pipeline Rules	0	494	July 26, 2022
Pipeline rule to convert microsec to millisec Graylog Central (peer support) pipeline-rules , debuggingpl	9	1097	April 20, 2020
Pipeline Rule: convert seconds to something readable Graylog Central (peer support) pipeline-rules	1	1333	November 28, 2019
Convert seconds to something readable Pipeline Rules pipeline-rules	0	636	July 30, 2021
Rounding in Pipelines Graylog Central (peer support) pipeline-rules	5	1281	July 28, 2020

Datetime milliseconds to minutes

Related topics