Splunk Search

Removing duplicates

12onetwo
New Member

HI , i am new to splunk i need to create a report that has rest calls which has mulitple path parameters , so it was showing the multiple uris to make a status count on that
for example:
/t1/email/ksjdf@gmail.com
/t1/email/ksjdf@gmail.com/f1/12345
/t1/email/ytft@gmail.com
/t1/email/ytft@gmail.com/f1/123456

result should be like this :
/t1/email/
/t1/email/XXXX/f1/XXXX

how to remove the duplicates herer , i am not which command to use?..

Tags (1)
0 Karma

MuS
Legend

Hi 12onetwo,

given you have a field called path or uri you can use dedup on this field

base search goes here | dedup uri | stats count by uri

see the doce for more details http://docs.splunk.com/Documentation/Splunk/6.3.0/SearchReference/Dedup

Hope this helps ...

cheers, MuS

0 Karma
Get Updates on the Splunk Community!

Developer Spotlight with William Searle

The Splunk Guy: A Developer’s Path from Web to Cloud William is a Splunk Professional Services Consultant with ...

Major Splunk Upgrade – Prepare your Environment for Splunk 10 Now!

Attention App Developers: Test Your Apps with the Splunk 10.0 Beta and Ensure Compatibility Before the ...

Stay Connected: Your Guide to June Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...