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

Look Back
OMC : How to Display Time Difference Between Start and End Time Using Log Analytics — 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 Display Time Difference Between Start and End Time Using Log Analytics

Received Response
7
Views
4
Comments
edited Oct 22, 2018 7:58AM in Management 4 comments

Summary

I Need to Display the Event/Actions Between Two Different Timing Using Log Analytics

Content

Here I Have my Use case 

From the Below Sample Log I Need to Parse the Start Time and  End Time.  

Once the Parser is created we need to display event/actions between End Time and Start Time

Example: ENDTIME - STARTTIME ( 14/09/2018 16:14:35.779 -  14/09/2018 16:14:35.667 ) 

             Output: Display Value Should be ( 14/09/2018 16:14:35.687 ) 

 

Sample Log: 

Pid: 1834 14/09/2018 16:14:35.667 Received 150 Bytes (Assume This Is Start Time)
30 31 34 36 31 32 30 30 e0 30 81 01 08 00 80 00 01461200.0......
00 00 00 00 04 00 00 20 31 36 39 39 39 39 39 39 ....... 16999999
31 34 32 30 30 30 36 34 32 32 31 33 32 38 32 35 1420006422132825
37 31 36 34 38 33 30 31 31 49 4e 52 33 34 49 4f 716483011INR34IO
42 20 20 20 20 20 20 20 20 31 36 38 38 20 20 20 B        1688
20 31 36 38 38 30 31 30 30 30 30 31 39 36 38 38  168801000019688
30 30 33 49 54 42                               
Pid: 1834 Received At: 14/09/2018 16:14:35.667 MessageId: 1200 Field 002: 9999990000000000 Field 003: 820000 Field 011: 825716483011 Field 
Pid: 1834 Received Message At: 14/09/2018 16:14:35.687

sysDateTime       :20180914161435
userField2        :1536921875.668
traceFlg          :N

Pid: 1834 Sent At: 14/09/2018 16:14:35.779 (Assume This End Time

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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