All Apps and Add-ons

How to report by time stamp and fields

gancw1
Explorer

Hi, I am new to splunk.
I would like to generate a report that just list all records which certain criteria e.g. status='success' and list the time stamp and 'userid' field.

Time                          Userid
1 7/10/13 12:00:00.000 AM     daveq 
2 7/11/13 12:00:00.000 AM     julesx
3 7/12/13 12:00:00.000 AM     janeo
....
....
Tags (1)
0 Karma

gkanapathy
Splunk Employee
Splunk Employee
status=success | table _time userid
0 Karma

pradeepkumarg
Influencer

index=my_index status=success | stats count by _time, Userid | fields _time, Userid

lukejadamec
Super Champion

If you all events, then don't dedup userID and table it:
index=my_index status=success | table _time,userID

0 Karma

lukejadamec
Super Champion

If you don't want a count, then dedup userID and table it:

index=my_index status=success | dedup userID | table _time,userID

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...