About JiachengWei

JiachengWei · ‎06-23-2021

@aasabatini Thanks for sharing. But the dedup will only delete the duplicate log. I believe it will show as below: _time _raw 2021-5-26 00:00:00 A 2021-5-26 00:05:00 C 2021-5-26 00:10:05 D What I'd like to see: _time downtime 2021-5-26 00:05:00 C 2021-5-26 00:10:05 D Do you have any other ideas? Thanks

JiachengWei · ‎06-23-2021

Hi Guys, I'd like to exclude the logs with same time for the search results _time _raw 2021-5-26 00:00:00 A 2021-5-26 00:00:00 B 2021-5-26 00:05:00 C 2021-5-26 00:10:05 D What I'd like to see: _time downtime 2021-5-26 00:05:00 C 2021-5-26 00:10:05 D Would you please share how I can do this? Thanks!

JiachengWei · ‎05-25-2021

I have tried that previously. Not working...

JiachengWei · ‎05-25-2021

Excellent! Appreciate! Just a more quick question: How to fill startswith and endswith for below sample: time raw 2021-5-26T00:00:00 port is not operational 2021-5-26T00:02:20 port is operational 2021-5-26T00:05:00 port is not operational 2021-5-26T00:10:05 port is operational

JiachengWei · ‎05-25-2021

Hi Guys, I'd like to calculate the time delta. Here is the sample: _time _raw 2021-5-26 00:00:00 port is down 2021-5-26 00:02:20 port is up 2021-5-26 00:05:00 port is down 2021-5-26 00:10:05 port is up May I know how to calculate each downtime and sort by '_time' ? Thanks. What I'd like to see: _time downtime 2021-5-26 00:00:00 02:20 2021-5-26 00:05:00 05:05

Posts	5
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎05-25-2021

Online Status	Offline
Date Last Visited	‎12-08-2021 05:26 AM

Exclude the logs with the same time for search res...

Calculate time delta

Re: Exclude the logs with the same time for search...

Exclude the logs with the same time for search res...

Re: Calculate time delta

Re: Calculate time delta

Calculate time delta