jq -r --arg start "<start_timestamp>" --arg end "<end_timestamp>" 'select(.msg | contains("query") and .durationMillis >= 100 and .timestamp >= $start and .timestamp <= $end) | .msg' mongodb.log
jq 'select(.timestamp >= "2023-06-01T00:00:00Z" and .timestamp <= "2023-06-15T23:59:59Z" and .executionTime > 1000)' <mongodb_logs.json jq 'select(.executionTime > 1000)' <mongodb_logs.json. jq 'select((strptime("%Y-%m-%dT%H:%M:%SZ") | mktime) >= strptime("2023-06-01T00:00:00Z") and (strptime("%Y-%m-%dT%H:%M:%SZ") | mktime) <= strptime("2023-06-15T23:59:59Z") and .executionTime > 1000)' mongodb_logs.json
Dear Team,
ReplyDeleteApologies for the missed follow-up.
I would like to connect with you to understand the root cause of this issue and to work on a permanent solution. Kindly arrange a meeting with your expert team at the earliest. I will provide all the necessary details during the discussion.
Please consider this request as high priority, as there is a significant risk of business impact. I appreciate your prompt attention and support on this matter.