Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
OMC HOW-TO: Reporting differences between dates in a log entry — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OMC HOW-TO: Reporting differences between dates in a log entry

Accepted answer
13
Views
10
Comments
edited Sep 27, 2018 7:04PM in Management 10 comments

Summary

Overview of how you can use Log Analytics query language to get the difference between two time/dates stored in a single log entry.

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!