Using my sample data, how do I write a search to return a list Authors with the Authors they worked with on other projects?

[jkokko]

I have a set a events that is like the following:

"1970-01-17 16:31:10" Author="Joe Bob", Author_email="[email protected]", Author_id="jbob", Key="195", author_localtime="1463470690", author_tz="-0500", commit="480f780f1eb3a3eabfabaec5fcff9ff20c5516a8", filetypes="test.txt,script.pl,nm.sh", Week_yr="21", Proj="ProjectX", Cost_center="9909", U_id="195"

The dataset contains multiple Authors and multiple projects. I'm trying to retrieve a list of Authors with a list of Authors they have worked with on other projects. stats values(Proj) BY Author will give me Authors and a project list. How do I search to find related Authors?

Thanks!

[woodcock]

Like this:

... | multireport
    [ stats values(Proj) BY Author ]
    [ stats values(Author) BY Proj ]

Or like this:

... | eventstats values(Author) AS Authors BY Proj | nomv Authors | dedup Author Proj Authors | stats list(Proj) list(Authors) BY Author