# Creating a dashboard using two log files (foreign key in elasticsearch)

**URL:** https://discuss.elastic.co/t/creating-a-dashboard-using-two-log-files-foreign-key-in-elasticsearch/109765
**Category:** Elasticsearch
**Created:** [November 30, 2017, 2:05pm UTC](https://discuss.elastic.co/t/creating-a-dashboard-using-two-log-files-foreign-key-in-elasticsearch/109765 "2017-11-30T14:05:46Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![cilzzz](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@cilzzz](https://discuss.elastic.co/u/cilzzz)
#### Post date: [November 30, 2017, 2:05pm UTC](https://discuss.elastic.co/t/creating-a-dashboard-using-two-log-files-foreign-key-in-elasticsearch/109765/1 "2017-11-30T14:05:46Z")

</div>

![cmdb](https://us1.discourse-cdn.com/elastic/original/3X/3/2/3222d1099980ba17d7dec5b5b21c38b7fe3d5385.PNG)

 ![tsm-server](https://us1.discourse-cdn.com/elastic/original/3X/3/c/3c4660783215ace186adad39e75aba9be230d7c0.PNG)

Hey everyone,

i have two large csv file as showing below on for the database and one for a backup server.  
After filtering the cmdb file i need specify the name of the application (Parent\_Nom) which  
will give me the name of the server where it is installed(Enfant\_Nom). after that i will go to the tsm-server  
file look for the name of the server under (Node) and see its status,volume...

is it possible to visualize this in kibana ?

can lucene or DSL query do that? or should define a method in my logstasg config file?

it is like creating a foreign key to do relations between database tables

all the data are in the same index

thank you

---

<div class="post-metadata">

### Author: ![Julien](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/julien/32/19688_2.png) [@Julien](https://discuss.elastic.co/u/Julien)
#### Post date: [December 8, 2017, 9:34pm UTC](https://discuss.elastic.co/t/creating-a-dashboard-using-two-log-files-foreign-key-in-elasticsearch/109765/2 "2017-12-08T21:34:40Z")

</div>

Hello,

It sounds like the question you have is around data modelling...

In short if you want to create vizualization, you will need to denormalise your data :  
[https://www.elastic.co/guide/en/elasticsearch/guide/current/modeling-your-data.html](https://www.elastic.co/guide/en/elasticsearch/guide/current/modeling-your-data.html)

For the data you presented I see no reason not to denormalise...

If you do not want to denormalize your data; then you will not be able to create visualizations in kibana untill support nested type aggregations is added ([https://github.com/elastic/kibana/issues/1084](https://github.com/elastic/kibana/issues/1084)). You can still run aggregations in elasticsearch of course.

Thanks  
Julien

---

<div class="post-metadata">

### Author: ![cilzzz](https://avatars.discourse-cdn.com/v4/letter/c/c67d28/32.png) [@cilzzz](https://discuss.elastic.co/u/cilzzz)
#### Post date: [December 12, 2017, 1:46pm UTC](https://discuss.elastic.co/t/creating-a-dashboard-using-two-log-files-foreign-key-in-elasticsearch/109765/3 "2017-12-12T13:46:43Z")

</div>

thank you, actually i found this plugin on github

> **[cernops/kibana-relational-filter](https://github.com/cernops/kibana-relational-filter)**
>
> kibana-relational-filter - Kibana Relational Filter

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 9, 2018, 1:46pm UTC](https://discuss.elastic.co/t/creating-a-dashboard-using-two-log-files-foreign-key-in-elasticsearch/109765/4 "2018-01-09T13:46:47Z")

</div>

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