Hi
I am using a table which shows up duplicates. Example shown below.
Is there a way to write a search which removes duplicates from the table?
I am pasting the search here for reference.
*index= source="dbmon-tail://db" Status = "2" Track_Name = "Ab-Initio"|convert timeformat="%Y-%m-%d %H:%M:%S" ctime(_time) AS UpdateDateTime |table UpdateDateTime, Track_Name,Application_Name,Component_Name,Status_Desc,lts_error_description,Comments
This above search returns the two rows below, of which I need only the latest one based on date.
... View more