Are you a member of the Splunk Community?
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- How to track number of requests by time made by us...
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I need to find user's all request times
User Time Count
testuser1 16:01:32 3
testuser1 16:01:33
testuser1 16:01:35
testuser2 16:01:31 2
testuser2 16:01:37
testuser3 16:02:21 4
testuser3 16:02:22
testuser3 16:02:24
testuser3 16:02:26
Basically try to get a user's time spent on the site over multiple requests or clicks or hits.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you have User and Time in separate fields, you could simply search for
your base search | stats count values(Time) by User
If you have to use the event time as parsed by Splunk, you'll use _time instead of Time. Though you'll want to alter how _time is presented...
your base search | eval Time = strftime(_time,"%Y-%m-%d %H:%M:%S") | stats count values(Time) by User
/k
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you have User and Time in separate fields, you could simply search for
your base search | stats count values(Time) by User
If you have to use the event time as parsed by Splunk, you'll use _time instead of Time. Though you'll want to alter how _time is presented...
your base search | eval Time = strftime(_time,"%Y-%m-%d %H:%M:%S") | stats count values(Time) by User
/k
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks
that did work!
Community Content Calendar, September edition
Splunkbase Unveils New App Listing Management Public Preview
Leveraging Automated Threat Analysis Across the Splunk Ecosystem
