{"id":11571,"date":"2020-04-17T20:49:21","date_gmt":"2020-04-17T20:49:21","guid":{"rendered":"https:\/\/merikebi.warrenmyers.com\/?p=11571"},"modified":"2020-04-17T20:49:21","modified_gmt":"2020-04-17T20:49:21","slug":"new-comment-on-reddit-960","status":"publish","type":"post","link":"https:\/\/merikebi.warrenmyers.com\/?p=11571","title":{"rendered":"New comment on reddit"},"content":{"rendered":"<div class=\"md\">\n<p>Didn&#39;t know these were multivalue fields in the <em>event itself<\/em><\/p>\n<p>In <em>that<\/em> case, do this:<\/p>\n<pre><code>index=ndx sourcetype=srctp SRC_FILE_NM_TXT=* STATUS_TXT=* | eval attach=mvzip(SRC_FILE_NM_TXT,STATUS_TXT,&quot;|&quot;) | mvexpand attach | where match(attach,&quot;\\|.+omplete&quot;) | stats count by attach as &quot;Complete Files&quot; | rex field=attach &quot;(?&lt;file_name&gt;.+)\\|&quot; | fields - attach <\/code><\/pre>\n<p>I end up doing this with multivalue fields from ForeScout all the time<\/p>\n<\/p><\/div>\n<p>April 17, 2020 at 04:42PM<br \/>\nvia reddit https:\/\/www.reddit.com\/r\/Splunk\/comments\/g37d5e\/splunk_command_stats_list_with_eval_condition_how\/fnq1zqq?utm_source=ifttt<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Didn&#39;t know these were multivalue fields in the event itself In that case, do this: index=ndx sourcetype=srctp SRC_FILE_NM_TXT=* STATUS_TXT=* | eval attach=mvzip(SRC_FILE_NM_TXT,STATUS_TXT,&quot;|&quot;) | mvexpand attach | where match(attach,&quot;\\|.+omplete&quot;) | stats count by attach as &quot;Complete Files&quot; | rex field=attach &quot;(?&lt;file_name&gt;.+)\\|&quot; | fields &#8211; attach I end up doing this with multivalue fields from ForeScout all &hellip;<br \/><a href=\"https:\/\/merikebi.warrenmyers.com\/?p=11571\" class=\"more-link pen_button pen_element_default pen_icon_arrow_double\">Continue reading <span class=\"screen-reader-text\">New comment on reddit<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[4],"tags":[972],"keyring_services":[],"class_list":["post-11571","post","type-post","status-publish","format-standard","hentry","category-blih","tag-reddit"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/11571","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=11571"}],"version-history":[{"count":1,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/11571\/revisions"}],"predecessor-version":[{"id":11572,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=\/wp\/v2\/posts\/11571\/revisions\/11572"}],"wp:attachment":[{"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11571"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/merikebi.warrenmyers.com\/index.php?rest_route=%2Fwp%2Fv2%2Fkeyring_services&post=11571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}