Log analyzer with the ability to dril down by ID?

Question

open source

Required - a tool for collecting and grouping logs from different systems / files with display in the web interface.
Background:
There are 3 systems, each of which writes logs. A common field for all 3 logs is a certain string identifier.
What you want:
So that you can configure the web interface to search by time and view logs from different systems by this identifier.
For example:
I am looking for events in a time interval, I find the right one - in the search results there is a list of identifiers for a given period in the form of a link. I click on the link - there is a transition to viewing (spoiler spread) logs from all systems by events in the logs with the given identifiers.
For example, you can see how similar functionality is implemented in Homer .

Answer 1

a crutch of course - but can solve at the level of a DB? combine a record from 3 systems into 1 by field. Is the ID unique in each system? not a spoiler of course, but something close to the task.