{"id":61002,"date":"2022-07-26T17:27:12","date_gmt":"2022-07-26T17:27:12","guid":{"rendered":"https:\/\/merikebi.warrenmyers.com\/?p=61002"},"modified":"2022-07-26T17:27:12","modified_gmt":"2022-07-26T17:27:12","slug":"answer-by-warren-for-splunk-search-query","status":"publish","type":"post","link":"https:\/\/merikebi.warrenmyers.com\/?p=61002","title":{"rendered":"Answer by warren for Splunk search query"},"content":{"rendered":"

If you’d like a full<\/em> regex for extracting all of the bracketed fields, this is the most efficient<\/a> one-shot I could make:<\/p>\n

| rex field=_raw "(?<extid>[\\d\\.]+).+D\\[(?<fieldtype>[^\\]]+).+T\\[(?<format>[^\\]]+).+L\\[(?<ll>[^\\]]+).+N\\[(?<len>[^\\]]+).+E\\[(?<type>[^\\]]+).+S\\[(?<charset>[^\\[]+).+A\\[(?<data>[^\\]]+)"\n<\/code><\/pre>\n
Most often I do sequential rex<\/code><\/a> calls, just in case some fields aren’t present in all events, but your sample data shows each of these items present<\/p>\n
Once you’ve extracted every<\/em> field in the data, you can stats<\/code><\/a> or search<\/code><\/a> it any way you may like (I see some of your "FLD<\/code>" (which I’ve named "fieldtype<\/code>") values can have spaces or punctuation, so I’m using the wildcard search<\/code> feature to match anything that looks like "Response Code"):<\/p>\n
index=ndx sourcetype=srctp \n| rex field=_raw "(?<extid>[\\d\\.]+).+D\\[(?<fieldtype>[^\\]]+).+T\\[(?<format>[^\\]]+).+L\\[(?<ll>[^\\]]+).+N\\[(?<len>[^\\]]+).+E\\[(?<type>[^\\]]+).+S\\[(?<charset>[^\\[]+).+A\\[(?<data>[^\\]]+)"\n| search fieldtype="Response*" \n| stats count by extid data fieldtype\n| fields - count\n| where tonumber(data)>5\n<\/code><\/pre>\n
tonumber<\/code><\/a> is quite flexible; I’m using it here in its simplest form<\/p>\n
from User warren – Stack Overflow https:\/\/stackoverflow.com\/questions\/71194954\/splunk-search-query\/73127433#73127433
\nvia IFTTT<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
If you’d like a full regex for extracting all of the bracketed fields, this is the most efficient one-shot I could make: | rex field=_raw "(?<extid>[\\d\\.]+).+D\\[(?<fieldtype>[^\\]]+).+T\\[(?<format>[^\\]]+).+L\\[(?<ll>[^\\]]+).+N\\[(?<len>[^\\]]+).+E\\[(?<type>[^\\]]+).+S\\[(?<charset>[^\\[]+).+A\\[(?<data>[^\\]]+)" Most often I do sequential rex calls, just in case some fields aren’t present in all events, but your sample data shows each of these items present Once you’ve …
Continue reading Answer by warren for Splunk search query<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[991],"keyring_services":[],"class_list":["post-61002","post","type-post","status-publish","format-standard","hentry","category-blih","tag-stackexchange"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/61002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=61002"}],"version-history":[{"count":1,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/61002\/revisions"}],"predecessor-version":[{"id":61003,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/61002\/revisions\/61003"}],"wp:attachment":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=61002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=61002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=61002"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fkeyring_services&post=61002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}