I have a set a events that is like the following:
"1970-01-17 16:31:10" Author="Joe Bob", Author_email="joe.bob@domain.com", 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!
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