By BradJJ - 6 Nov 2024
I have a log where I have filtered out pairs of log lines.
Firstly the log line where an API request is sent and secondly the log line where the API response is received.
I want to see a timeline bar graph that shows the API responsiveness over a period so I can compare today versus 3 days ago (or another reference) to monitor for performance issues.
I just can't find examples that do this.
Can you please help?
Sample log line pair is below
I have a parser so I have columns for date and time as well as turning on the elapsed column, I just need the query to report on the elapsed values
2024-11-07 06:43:03.956 I/app(722): [activity] [api ] - } to https://url.com/endpoint.svc/endpoint
2024-11-07 06:43:04.345 I/app(722): [activity] [api ] - } from https://url.com/endpoint.svc/endpoint
|
By LogViewPlus Support - 7 Nov 2024
Hi Brad,
LogViewPlus SQL currently does not support WITH or LAG statements. I don't think this scenario will be possible without at least one of these constructs.
It's a good use case and I think it is something that LogViewPlus should be able to do. I will have a think and see if we can come up with a solution in a future release.
In the meantime, the best I can suggest is to export the rows to a CSV file and then using Excel to perform the necessary calculations.
Thanks,
Toby
|
By BradJJ - 8 Nov 2024
Thanks for the response.
Fun fact, I recently discovered the power of AI.
I copied the filtered log lines out of LVP and pasted them into Microsoft CoPilot and asked it to generate a report for me.
It give me python and it worked like a charm. I even got it to tweak the report format.
I was amazed.
|
By LogViewPlus Support - 8 Nov 2024
Awesome Brad - glad to hear you were able to find a solution. Thanks for letting me know!
Toby
|