How do I relate 2 objects with no common field?

Elastic Stack Kibana
1

Input Data:

* Operating Systems CSVs
  * Fields: OperatingSystem, general_availability, end_of_life
  * Examples: 
     * OperatingSystem------ general_availability------end_of_life
     * RHEL 7.9-------------------------01/01/2018 --------01/01/2024
     * CentOS 7.9----------------------01/01/2017---------01/01/2024
     * Windows 2016-----------------01/01/2016---------01/01/2020

* Applications CSVs
  * Fields: ApplicationName, general_availability, end_of_life
  * Examples: 
     * ApplicationName-------general_availability------end_of_life
     * Apache 2.4---------------------01/01/2018 --------01/01/2024
     * Docker 6.2------ ---------------01/01/2017---------01/01/2024
     * NetBackup 9.2-  - -------------01/01/2016---------01/01/2020

I would like to define some relationships, for example: (I dont mind creating a 3csv with the relationships)

  • RHEL 7.9 - (apache 2.4, Docker 6.2)
  • CentOS 7.9 - (Apache 2.4)
  • Windows 2016 -(Docker 6.2, NetBackup 9.2)

Lastly If I had a dashboard with 1 filter for OperatingSystems & 2 tables, one with Operating systems and its dates and other one with Applications and its dates. (I know how to build tables and filters), I would like if I select "RHEL 7.9" for the applications table to show Apache 2.4 and Docker 6.2 with both general_availability and end_of_life dates

End Result:

Filter: "RHEL 7.9"

     Table 1:
     OperatingSystem------ general_availability------end_of_life
     RHEL 7.9------------------01/01/2018 -------------01/01/2024
     
     Table 2:
     ApplicationName-------general_availability------end_of_life
     Apache 2.4------------------01/01/2018 -----------01/01/2024
     Docker 6.2------ ------------01/01/2017-----------01/01/2024

All this data(CSVs) is getting ingested by logstash and sent to elasticsearch

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.