# Conflicting Field Elasticsearch host.ip in metrics\*-\* Index Pattern

**URL:** <https://discuss.elastic.co/t/conflicting-field-elasticsearch-host-ip-in-metrics-index-pattern/325539>\
**Category:** Elastic Agent\
**Tags:** metricbeat\
**Created:** [February 15, 2023, 4:54am UTC](https://discuss.elastic.co/t/conflicting-field-elasticsearch-host-ip-in-metrics-index-pattern/325539 "2023-02-15T04:54:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![OmFJ](https://avatars.discourse-cdn.com/v4/letter/o/8e7dd6/32.png) [@OmFJ](https://discuss.elastic.co/u/OmFJ)\
**Post date:** [February 15, 2023, 4:54am UTC](https://discuss.elastic.co/t/conflicting-field-elasticsearch-host-ip-in-metrics-index-pattern/325539/1 "2023-02-15T04:54:22Z")

</div>

Hello Everyone, in this topic, i would like to ask about conflicting field.

From all discussions and forum i visited most of them tell you to re-index your index. but i come across this problem where the conflicting field is occurred within all index with metrics\*-\* index pattern.

When i opened data view for metrics\*-\* and search for the host.ip field, this is what it looks like:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/6/a64a0521c3ff6b405f5c23cbad601020100ff9cd.png)

this is the pop-up when i click the "conflict" warning. i will put the screenshot below:  
1st screenshot  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/b/1b9bf178e0260e61e0cf761ab36c2af3175df8b6.png)

2nd screenshot  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/0/f060e7aab2d78138d422cf481d2a4eadf7a37a95.png)

as you can see from the part of screenshots above, mssql performance and transaction\_log have keyword type for host.ip in it's field.  
the questions would be how can i change the host.ip field from keyword to ip address type? and is this an issue within mssql integration?

Thank you in advance!

---

<div class="post-metadata">

**Author:** ![OmFJ](https://avatars.discourse-cdn.com/v4/letter/o/8e7dd6/32.png) [@OmFJ](https://discuss.elastic.co/u/OmFJ)\
**Post date:** [February 15, 2023, 8:27am UTC](https://discuss.elastic.co/t/conflicting-field-elasticsearch-host-ip-in-metrics-index-pattern/325539/2 "2023-02-15T08:27:32Z")

</div>

i already did some testing and came out with workaround for this.  
we could just create a data view and include the index pattern except for mssql since both are not in the same index.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/4/1411d6699ef1cc2384edcd60296464d396a319ff.png)

it's fine now!

i appreciate any other answer that may help to fix the root cause. Thank you!

---

<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:** [March 15, 2023, 8:27am UTC](https://discuss.elastic.co/t/conflicting-field-elasticsearch-host-ip-in-metrics-index-pattern/325539/3 "2023-03-15T08:27:41Z")

</div>

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