I'd like to ask if the following requirement is possible:
Basically I monitor the state of my database every 30 mins and sends details of database locks to ELK and stores it in a database-lock index. So every 30 mins I need to refresh the Kibana visualization and identify the status of old database locks that was previously captured and new ones that recently arrived in ELK. In my index I have a date field which indicates the date and time when the lock occurred.
What I need to know is how long has it been locked from this moment by comparing the lock occurrence date field to the current system date. I'm having a hard time searching for a way to compare my date field to the systems current date.
Hoping for your response. Thank you.