https://community.splunk.com/t5/Splunk-Search/How-to-get-distinct-values-of-one-field-by-another-field/m-p/111209#M29137 <P>the below search will give me distinct count of one field by another field</P> <P>some search | stats dc(field1) by field2</P> <P>but how would I get the distinct values for field1 by field2</P> <P>so i want something like below:</P> <P>some search | stats distinct(field1) by field2</P> Thu, 04 Sep 2014 14:02:04 GMT sridamg 2014-09-04T14:02:04Z https://community.splunk.com/t5/Splunk-Search/How-to-get-distinct-values-of-one-field-by-another-field/m-p/111209#M29137 <P>the below search will give me distinct count of one field by another field</P> <P>some search | stats dc(field1) by field2</P> <P>but how would I get the distinct values for field1 by field2</P> <P>so i want something like below:</P> <P>some search | stats distinct(field1) by field2</P> Thu, 04 Sep 2014 14:02:04 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-distinct-values-of-one-field-by-another-field/m-p/111209#M29137 sridamg 2014-09-04T14:02:04Z https://community.splunk.com/t5/Splunk-Search/How-to-get-distinct-values-of-one-field-by-another-field/m-p/111210#M29138 <P>Hi sridamg,</P> <P>try something like this:</P> <PRE><CODE>some search | stats values(field1) by field2 </CODE></PRE> <P>see the docs for more information <A href="http://docs.splunk.com/Documentation/Splunk/6.1.3/SearchReference/CommonStatsFunctions">http://docs.splunk.com/Documentation/Splunk/6.1.3/SearchReference/CommonStatsFunctions</A></P> <P>cheers, MuS</P> Thu, 04 Sep 2014 14:06:29 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-distinct-values-of-one-field-by-another-field/m-p/111210#M29138 MuS 2014-09-04T14:06:29Z https://community.splunk.com/t5/Splunk-Search/How-to-get-distinct-values-of-one-field-by-another-field/m-p/111211#M29139 <P>Check if this helps..</P> <PRE> ... | dedup field1, field2 | stats list(field1) by field2 </PRE> Thu, 04 Sep 2014 14:08:48 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-distinct-values-of-one-field-by-another-field/m-p/111211#M29139 pradeepkumarg 2014-09-04T14:08:48Z