Getting unique values of a field.

[splunkpoornima]

Hi all. I have a field called TaskAction that has some 400 values. But, I only want the distinct values of that field.

Plz help me with the query.

[bbialek]

This seems to work when trying to find unique values for a field, like 'host':
* | chart count by host

[Ayn · Accepted solution]

There's dedup, and there's also the stats operator values.

[andrewb_splunk]

The Splunk Enterprise version 5.0 documentation from 2012 is no longer available. Similar information is available in newer versions of the Splunk documentation. Replace "5.0" in the URL with "latest" or a more recent version number to view the topics. 

dedup: https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Dedup 

stats: https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/CommonStatsFunctions 

[slierninja]

stats values(field) is what I used.