Search to Compare and generate a new table result


In need of finding a way to search to compare and generate a communication-relation table which apparently seem to involve some complex logic.

I have a table with two columns where one lists the servers and the other shows the list of different server that it communicates with.(how it communicates is out of scope of requirement.)

Need to search for different servers that apparently communicate with one another in one or the other way. The sample image added here will explain the source and expected result tables.
alt text

Please let me know if or how this could be achieved in Splunk.

0 Karma