# Long IP to String convertion in Kibana

**URL:** <https://discuss.elastic.co/t/long-ip-to-string-convertion-in-kibana/81251>\
**Category:** Kibana\
**Created:** [April 5, 2017, 5:19am UTC](https://discuss.elastic.co/t/long-ip-to-string-convertion-in-kibana/81251 "2017-04-05T05:19:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![moni15moni](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/moni15moni/32/42311_2.png) [@moni15moni](https://discuss.elastic.co/u/moni15moni)\
**Post date:** [April 5, 2017, 5:19am UTC](https://discuss.elastic.co/t/long-ip-to-string-convertion-in-kibana/81251/1 "2017-04-05T05:19:44Z")

</div>

Hi Team,

Currently we have stored in IP's are (IPV4)Long Values .we have handled Billion of events for a day(Saving disk space and performance we have used IP as Long). While we are using kibana in Discover or DashBoard module.

For Example If my ip in the long value 154452126 ,i have to show their equivalent string "9.52.192.158" like this .

Is this posible when i am using kibana.

---

<div class="post-metadata">

**Author:** ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)\
**Post date:** [April 5, 2017, 11:05pm UTC](https://discuss.elastic.co/t/long-ip-to-string-convertion-in-kibana/81251/2 "2017-04-05T23:05:36Z")

</div>

You should be able to do this with a scripted field (Management \> Index Patterns \> ? \> Scripted fields), as I have seen folks [go the other direction](http://stackoverflow.com/a/31928177) before. I am not sure what the performance implications of this would be at query time.

Out of curiosity, how much savings were you seeing by storing it as a long? ES stores it as a long under the hood, but will add overhead for the index to aid in searching.

---

<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:** [May 3, 2017, 11:06pm UTC](https://discuss.elastic.co/t/long-ip-to-string-convertion-in-kibana/81251/3 "2017-05-03T23:06:40Z")

</div>

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