{"id":6277,"date":"2017-05-01T08:37:57","date_gmt":"2017-05-01T13:37:57","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=6277"},"modified":"2017-05-01T08:37:57","modified_gmt":"2017-05-01T13:37:57","slug":"splunk-query-to-group-uri-request-by-first-three-ip-address-octets","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2017\/05\/01\/splunk-query-to-group-uri-request-by-first-three-ip-address-octets\/","title":{"rendered":"Splunk query to group URI request by first three IP address octets"},"content":{"rendered":"<p>We needed this to understand the source of a large influx of requests for a given URI pattern.<\/p>\n<pre>\r\nimport splunklib.client as client\r\nimport splunklib.results as results\r\n\r\nservice = client.connect(host=\"*******\",port=\"8089\",username=\"showard\",password=\"************\")\r\n\r\njob = \"\"\"\t\r\nsearch host=\\\"cmhlpecomweb*\\\" sourcetype=access_combined karlie-kloss | \r\n  eval temp=split(_raw,\\\"\\t\\\") | \r\n  eval tm=mvindex(temp,13) | \r\n  rex field=tm \"(?<ip>\\d+\\.\\d+\\.\\d+)\" | \r\n  stats count by ip | sort - count | head 50\r\n\"\"\"\r\n\r\nrr = results.ResultsReader(service.jobs.oneshot(job,**{\"earliest_time\":\"2017-04-04T11:00:00.000-04:00\",\"latest_time\":\"2017-04-04T18:00:00.000-04:00\",\"count\": 0}))\r\n\r\nfor result in rr:\r\n  print result['ip'],result['count']\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>We needed this to understand the source of a large influx of requests for a given URI pattern. import splunklib.client as client import splunklib.results as results service = client.connect(host=&#8221;*******&#8221;,port=&#8221;8089&#8243;,username=&#8221;showard&#8221;,password=&#8221;************&#8221;) job = &#8220;&#8221;&#8221; search host=\\&#8221;cmhlpecomweb*\\&#8221; sourcetype=access_combined karlie-kloss | eval temp=split(_raw,\\&#8221;\\t\\&#8221;) |&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2017\/05\/01\/splunk-query-to-group-uri-request-by-first-three-ip-address-octets\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[26,81],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/6277"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=6277"}],"version-history":[{"count":1,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/6277\/revisions"}],"predecessor-version":[{"id":6279,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/6277\/revisions\/6279"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=6277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=6277"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=6277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}