Let me start with: I am VERY new to Elastic Search and Kabana.
I have multiple indexes imported into ES and one Index Pattern between them all using a wild card so i can grab multiple fields across all indexes to make one report.
the indexes contain server information. One has basic info, another has disk info etc....
When i do a discovery and get all my columns in and then filter on a server name, i get multiple rows with each row containing information from each index.
This is expected as the info is in multiple docs.
Is there a way to combine the info into one row of output instead of multiple?
The data doesn't lend itself to a relational DB hence trying to use Elastic.