OMC HOW-TO: Reporting differences between dates in a log entry
SummaryOverview of how you can use Log Analytics query language to get the difference between two time/dates stored in a single log entry.
If you have a log entry where you have parsed and store two time/date fields such as Event Start Time and Event End Time, then the query language allows you to do math manipulation on these to display the duration between these two dates. In this example, we have a log entry from Oracle E-Business Suite's FNDWFBG Workflow Background program. This log has a start and end time for a background process that have been stored into the Event Start Time and Event End Time fields respectively.