I have a logfile which has multiple lines of logs with each logline having nearly 700+ lines. I am trying to extract only following from each line and would like to create a chart or a graph based on these results.
Lines I am trying to extract are always at the start of the log file and below is the sample extract. Rest of the log file has all the other data.
====================================
01/29/2018 23:10:40
Monitors:
Monitor Data:
Monitor System Tasks:
Status: OK , severity: Terrible , Last Update Time: 01/29/2018 23:10:40
Jobs Types:
Name: Log Sync, Status: OK , severity: Good , Last Update Time: 01/29/2018 15:45:15
Log Sync , ignore = 507830 , jobs execution count = 6529 , jobs exection average = 6.26 sec
Name: Collection, Status: N/A , severity: N/A , Last Update Time: 01/29/2018 15:45:15
Collection , ignore = 0 , jobs execution count = 0 , jobs exection average = 0 ms
Long Jobs Times:
Name: server1-sample-binarylogs server1b, Status: N/A , severity: Terrible , Last Update Time: 01/27/2018 07:34:00
fxccspricing-bubble-binlogs server1b , type = nog Sync , ignore = 0 , job execution count = 7 , job exection average = 11.96 min
Name: server4-sample-core server1e, Status: N/A , severity: Terrible , Last Update Time: 01/27/2018 09:34:00
server4-sample-core server1e , type = nog Sync , ignore = 0 , job execution count = 4 , job exection average = 3.67 min
Name: server5-sample-binarylogs server1f, Status: N/A , severity: Poor , Last Update Time: 01/27/2018 10:34:00
server5-sample-binarylogs server1f , type = nog Sync , ignore = 0 , job execution count = 4 , job exection average = 7.27 min
====================================
For below log line -
Name: server5-sample-binarylogs server1f, Status: N/A , severity: Poor , Last Update Time: 01/27/2018 10:34:00
server5-sample-binarylogs server1f , type = nog Sync , ignore = 0 , job execution count = 4 , job execution average = 7.27 min
When I do -
index=abc source=/data/logs/abc/xyz/* "job execution average =" | rex "job execution average =(?[^ ]*)"
I do get the results, however, the massive logfile still remains and I can't extract ONLY the meainingful lines out of it.
How can I only extract three below values and make a chart out of them -
Value 1 - Name: server4-sample-core
Value 2 - server1f
Value 3 - job execution average = 7.27 min (these mins value would change)
Can someone please help me on this, thanks!
... View more