# Logstash does not transform IP

**URL:** <https://discuss.elastic.co/t/logstash-does-not-transform-ip/131567>\
**Category:** Logstash\
**Created:** [May 12, 2018, 11:54am UTC](https://discuss.elastic.co/t/logstash-does-not-transform-ip/131567 "2018-05-12T11:54:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AdamJade](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@AdamJade](https://discuss.elastic.co/u/AdamJade)\
**Post date:** [May 12, 2018, 11:54am UTC](https://discuss.elastic.co/t/logstash-does-not-transform-ip/131567/1 "2018-05-12T11:54:34Z")

</div>

Hi there, i just begin using ELK 6.0.0 and i m very happy with.  
I would like to minitor my webserver and i installed filebeat.  
Logstash receives informations from webserver and kibana displays it.  
Here is kibana display :  
{  
"\_index": "filebeat-2018.05.12",  
"\_type": "doc",  
"\_id": "9JwkVGMBKxo6fAmiLZJC",  
"\_version": 1,  
"\_score": null,  
"\_source": {  
"@timestamp": "2018-05-12T11:37:21.523Z",  
"offset": 37404,  
"@version": "1",  
"beat": {  
"name": "WINDEV",  
"hostname": "WINDEV",  
"version": "6.0.0"  
},  
"host": "WINDEV",  
"source": "c:\inetpub\logs\LogFiles\W3SVC\u\_ex180512.log",  
"message": "2018-05-12 11:36:33 W3SVC1 WINDEV 192.168.1.14 GET /atlas.ui/ - 80 - 90.107.XXX.XXX HTTP/1.1 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/66.0.3359.139+Safari/537.36 - - 90.107.XXX.XXX 200 0 121 0 412 32748",  
"fields": {  
"windev\_environment": "production"  
},  
"tags": [  
"ServeurWeb",  
"beats\_input\_codec\_plain\_applied"  
]  
},  
"fields": {  
"@timestamp": [  
"2018-05-12T11:37:21.523Z"  
]  
},  
"sort": [  
1526125041523  
]  
}  
and here is my logstash filter conf  
if [type] == "iis\_log" {  
if [message] =~ "^#" {  
drop {}  
}

```
    grok {
	    match => [ "message", "%{TIMESTAMP_ISO8601:timestamp} %{NOTSPACE:s-sitename} %{WORD:cs-method} %{URIPATH:cs-uri-stem} %{NOTSPACE:cs-uri-query} %{NUMBER:s-port} %{NOTSPACE:cs-username} %{IPORHOST:c-ip} %{NOTSPACE:cs(User-Agent)} %{NOTSPACE:cs(Cookie)} %{NOTSPACE:cs(Referer)} %{NOTSPACE:cs-host} %{NUMBER:sc-status:int} %{NUMBER:sc-substatus:int} %{NUMBER:sc-win32-status:int} %{NUMBER:sc-bytes:int} %{NUMBER:cs-bytes:int} %{NUMBER:time-taken:int}" ,
                   "message", "%{TIMESTAMP_ISO8601:timestamp} %{IPORHOST:s-sitename} %{WORD:cs-method} %{URIPATH:cs-uri-stem} %{NOTSPACE:cs-uri-query} %{NUMBER:s-port} %{NOTSPACE:cs-username} %{IPORHOST:c-ip} %{NOTSPACE:cs(User-Agent)} %{NOTSPACE:cs(Referer)} %{NUMBER:response:int} %{NUMBER:sc-substatus:int} %{NUMBER:sc-substatus:int} %{NUMBER:time-taken:int}" ,
				   "message", "%{TIMESTAMP_ISO8601:timestamp} %{WORD:cs-method} %{URIPATH:cs-uri-stem} %{NOTSPACE:cs-post-data} %{NUMBER:s-port} %{IPORHOST:c-ip} HTTP/%{NUMBER:c-http-version} %{NOTSPACE:cs(User-Agent)} %{NOTSPACE:cs(Cookie)} %{NOTSPACE:cs(Referer)} %{NOTSPACE:cs-host} %{NUMBER:sc-status:int} %{NUMBER:sc-bytes:int} %{NUMBER:cs-bytes:int} %{NUMBER:time-taken:int}"]
	}
	
	geoip {
	    source => "c-ip"
		target => "geoip"
		add_tag => ["iis-geoip"]
	}
	
	useragent {
	    source => "cs(User-Agent)"
	}
}

```

Kibana does not display IIS fields and logstash does not transform ip in geo-point.  
Can you help????  
Thanks

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [May 14, 2018, 4:48am UTC](https://discuss.elastic.co/t/logstash-does-not-transform-ip/131567/2 "2018-05-14T04:48:13Z")

</div>

> [@AdamJade](#):
>
> if [type] == "iis\_log" {

It doesn't look like this is set in the event, which means this condition may never be true.

---

<div class="post-metadata">

**Author:** ![AdamJade](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@AdamJade](https://discuss.elastic.co/u/AdamJade)\
**Post date:** [May 14, 2018, 12:36pm UTC](https://discuss.elastic.co/t/logstash-does-not-transform-ip/131567/3 "2018-05-14T12:36:51Z")

</div>

Thanks a lot for your reply. Sould i correct my logstash conf condition ?  
I'm new in ELK and i'm trying to make it work with iis log.  
Once again, thanks a lot.

---

<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:** [June 11, 2018, 12:36pm UTC](https://discuss.elastic.co/t/logstash-does-not-transform-ip/131567/4 "2018-06-11T12:36:51Z")

</div>

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